shared memory not initialized

comp.databases.informix comp.databases.informix

Page 3 of 3

Thread Tools

Search this Thread

Display Modes

#21

Keith Simmons

Posts: n/a

Re: shared memory not initialized - 08-13-2007 , 10:05 AM

Tom

I may have missed this in the variety of posts ! but do i understand
this is a new installation and has never run? If so have you actually
initialised the engine (oninit -i) at any time?

Keith

On 13/08/07, Ogiwara Tsutomu <tsutomu_ogiwara (AT) hotmail (DOT) com> wrote:

Quote:

Hi Tom.

Just a thought.
Is your machine available iptables (firewall) ?

Here is my result.
No rules is setting.

# /sbin/iptables -L
Chain INPUT (policy ACCEPT)
target prot opt source destination

Chain FORWARD (policy ACCEPT)
target prot opt source destination

Chain OUTPUT (policy ACCEPT)
target prot opt source destination

If you can see any rules in your machine,
you need configure iptables entry using GUI or iptable command.

Regards.
--
Tsutomu Ogiwara from Tokyo Japan.

From: "tom.priore (AT) gmail (DOT) com" <tom.priore (AT) gmail (DOT) com
To: informix-list (AT) iiug (DOT) org
Subject: Re: shared memory not initialized
Date: Fri, 10 Aug 2007 04:34:29 -0000

Thanks Andreas,

The system is resolving the host name fine.
uname -n reports informix.
when i ping informix, i get a reply from the correct IP, 192.168.26.66

Still no luck

Tom

On Aug 9, 4:55 am, Andreas Breitfeld <abrei... (AT) de (DOT) ibm.com> wrote:
Maybe my hint regarding the 'setarch' command is not the solution of
your problem. We assume the error you see is caused by a failed
resolution of hostname to IP address. Please check with command:
ping informix

is pinging the IP address (inet addr

configured on your machine:
/sbin/ifconfig

This should be the address 192.168.26.66 as you configured
in /etc/hosts .

Also check the hostname is really 'informix' by command:
hostname

and the hosts are resolved first by local /etc/hosts file:
grep hosts /etc/nsswitch.conf

should print:
hosts: files dns

Andreas

On Wednesday 08 August 2007 19:10, tom.pri... (AT) gmail (DOT) com wrote:

Thank you for your help.

I have executed "setarch i686 -R sh"
It puts me in the "sh" shell.
I then run oninit, and it still stops and puts my back to the shell.
Here are the onstat -m results:

[root@informix informix]# setarch i686 -R sh
sh-3.00# oninit
Your evaluation license will expire on 2007-10-30 00:00:00
sh-3.00# onstat -m
Your evaluation license will expire on 2007-10-30 00:00:00
shared memory not initialized for INFORMIXSERVER 'informixserver'

Message Log File: /opt/informix/online.log
08:06:22 DR: DRAUTO is 0 (Off)
08:06:22 Dynamically allocated new virtual shared memory segment
(size 8192KB)
08:06:22 Memory sizes:resident:11664 KB, virtual:16384 KB, no
SHMTOTAL limit
08:06:22 Dynamically allocated new message shared memory segment
(size 528KB)
08:06:22 Memory sizes:resident:11664 KB, virtual:16912 KB, no
SHMTOTAL limit
08:06:22 Event notification facility epoll enabled.
08:06:22 IBM Informix Dynamic Server Version 10.00.UC6TL Software
Serial Number AAA#B000000
08:06:22 Your evaluation license will expire on 2007-10-30 00:00:00

08:06:22 listener-thread: err = -930: oserr = 0: errstr = informix:
Cannot connect to database server (informix).

08:06:22 sql_listener: ASF_LISTEN failed

08:06:22 Attempting to bring listener thread down.

08:06:22 Server stopped.

08:06:22 IBM Informix Dynamic Server Stopped.

08:06:22 mt_shm_remove: WARNING: may not have removed all/correct
segments

On Aug 8, 4:11 am, Andreas Breitfeld <abrei... (AT) de (DOT) ibm.com> wrote:
Please try disable randomization of the virtual address space.

On CentOS and RedHat 5 this can be done for a new shell:
setarch i686 -R sh

or
setarch i686 -R -L sh

from which IDS can be started.

On some CentOS and RHEL5 systems users reported shared libraries
are loaded near to default SHMBASE 0x44000000L .

Andreas

On Wednesday 08 August 2007 08:54, you wrote:
I have just installed Informix 10 on a CentOS 4.5 system.

When I run oninit -v to start the dbserver, I get the following,
and then it dumps me back to bash:

[root@informix informix]# oninit -v
Your evaluation license will expire on 2007-10-30 00:00:00
Checking group membership to determine server run
mode...succeeded Reading configuration file
'/opt/informix/etc/onconfig'...succeeded Creating
/INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/opt/informix/
etc/.infos.informixserver"...succeeded
Linking conf file
"/opt/informix/etc/.conf.informixserver"...succeeded Writing to
infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 1402 kbytes...succeeded
Allocating 10016 kbytes for buffer pool of 2K page
size...succeeded Initializing rhead structure...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Onlining 0 additional cpu vps...succeeded
Onlining 2 IO vps...succeeded
Initialization of Encryption...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 1 flushers...succeeded

When I run onstat -m I get:
21:48:34 Booting Language <builtin> from module
21:48:34 Loading Module <BUILTINNULL
21:48:39 DR: DRAUTO is 0 (Off)
21:48:39 Event notification facility epoll enabled.
21:48:39 Dynamically allocated new virtual shared memory segment
(size 8192KB)
21:48:39 Memory sizes:resident:11664 KB, virtual:16384 KB, no
SHMTOTAL limit
21:48:39 IBM Informix Dynamic Server Version 10.00.UC6TL
Software Serial Number AAA#B000000
21:48:39 Your evaluation license will expire on 2007-10-30
00:00:00

21:48:39 listener-thread: err = -930: oserr = 0: errstr =
informix: Cannot connect to database server (informix).

21:48:39 sql_listener: ASF_LISTEN failed

21:48:39 Attempting to bring listener thread down.

21:48:39 Server stopped.

21:48:39 IBM Informix Dynamic Server Stopped.

21:48:39 mt_shm_remove: WARNING: may not have removed
all/correct segments

my sqlhosts has the following line:
informixserver onsoctcp informix sqlexec

my /etc/services has:
sqlexec 1526/tcp informixserver

my onconfig looks like this:
# Root Dbspace Configuration

ROOTNAME rootdbs # Root dbspace name
ROOTPATH /opt/informix/dbs/rootdbs # Path for device
containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into
device (Kbytes)
ROOTSIZE 30000 # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR 0 # Mirroring flag (Yes = 1, No =
0) MIRRORPATH # Path for device containing
mirrored root
MIRROROFFSET 0 # Offset into mirrored device
(Kbytes)

# Physical Log Configuration

PHYSDBS rootdbs # Location (dbspace) of physical
log PHYSFILE 2000 # Physical log file size
(Kbytes)

# Logical Log Configuration

LOGFILES 6 # Number of logical log files
LOGSIZE 2000 # Logical log size (Kbytes)

# Tablespace Tablespace Configuration in Root Dbspace

TBLTBLFIRST 0 # First extent size (Kbytes) (0 =
default)
TBLTBLNEXT 0 # Next extent size (Kbytes) (0 =
default)
.......

# System Configuration

SERVERNUM 0 # Unique id corresponding to a
OnLine instance
DBSERVERNAME informixserver # Name of default
database server
DBSERVERALIASES informixserver # List of alternate
dbservernames
NETTYPE onsoctcp # Configure poll
thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in
distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1,
No = 0)

MULTIPROCESSOR 0 # 0 for single-processor, 1 for
multi- processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of
cpu vps to one

NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors

# Shared Memory Parameters

LOCKS 2000 # Maximum number of locks
NUMAIOVPS # Number of IO vps
PHYSBUFF 32 # Physical log buffer size
(Kbytes) LOGBUFF 32 # Logical log buffer
size (Kbytes) CLEANERS 1 # Number of buffer
cleaner processes SHMBASE 0x44000000L # Shared memory
base address SHMVIRTSIZE 8192 # initial virtual
shared memory segment size
SHMADD 8192 # Size of new shared memory
segments (Kbytes)
EXTSHMADD 8192 # Size of new extension shared
memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes).
0=>unlimited
SHMVIRT_ALLOCSEG 0 # Values between 0 and .99 are %,
values > 1 are
# KB - when this much virtual
memory is used we
# try to get a new segment. 0
means "off". 2nd
# parameter is alarm level
CKPTINTVL 300 # Check point interval (in sec)
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)

......

_______________________________________________
Informix-list mailing list
Informix-l... (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

--
Andreas Breitfeld; Informix Development Munich
IBM Deutschland GmbH; Vorsitzender des Aufsichtsrats: Hans Ulrich
Maerki; Gesch$BgG(Btsf$B!&(Brung: Martin Jetter (Vorsitzender), Rudolf
Bauer, Christian Diedrich, Christoph Grandpierre, Matthias
Hartmann, Thomas Fell, Michael Diemer; Sitz der Gesellschaft:
Stuttgart;
Registergericht: Amtsgericht Stuttgart, HRB 14562 WEEE-Reg.-Nr. DE
99369940

--
Andreas Breitfeld; Informix Development Munich
IBM Deutschland GmbH; Vorsitzender des Aufsichtsrats: Hans Ulrich
Maerki; Gesch$BgG(Btsf$B!&(Brung: Martin Jetter (Vorsitzender), Rudolf Bauer,
Christian Diedrich, Christoph Grandpierre, Matthias ...

read more $B%5(B

_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

__________________________________________________ _______________
Hotmail$B%j%K%e!<%"%k5-G0!*%W%8%g!<$N%K%e!<%b%G%k!V%W%8%g!<(B 207 Cielo$B!W$,Ev$?(B
$B$k(B http://clk.atdmt.com/GBL/go/msnjpqjl...gbl/direct/01/

_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

Page 3 of 3

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off