shared memory not initialized
A new Informix 10 install on CentOS 4.5 started with oninit but immediately stopped, logging 'listener-thread: err = -930 ... Cannot connect to database server (informix)' and 'shared memory not initialized'. Suggestions: disable address-space randomization (setarch i686 -R sh) because of SHMBASE conflicts, and avoid using the same name for DBSERVERNAME and DBSERVERALIASES with proper onipcshm/onsoctcp entries in sqlhosts. Art Kagel spotted the real cause: INFORMIXSERVER was set to 'informix' instead of 'informixserver'. After fixing that, the poster hit a new error ('Cannot open chunk /opt/informix/dbs/rootdbs', errno 2) and was asked about the chunk file's existence, ownership and permissions; the thread ends there with no recorded resolution of that second problem.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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, noSHMTOTAL limit21:48:39 IBM Informix Dynamic Server Version 10.00.UC6TL SoftwareSerial 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/correctsegments
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 nameROOTPATH /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 mirroredroot
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 OnLineinstance
DBSERVERNAME informixserver # Name of default databaseserver
DBSERVERALIASES informixserver # List of alternatedbservernames
NETTYPE onsoctcp # Configure poll thread(s) fornettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed 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 vpsto 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 memorysegment 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)
......
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-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
--
Andreas Breitfeld; Informix Development Munich
IBM Deutschland GmbH; Vorsitzender des Aufsichtsrats: Hans Ulrich
Maerki; Geschäftsführung: 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
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]On Behalf Of tom.priore@gmail.com
Sent: Wednesday, August 08, 2007 2:55 AM
To: informix-list@iiug.org
Subject: shared memory not initialized
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:
DBSERVERNAME informixserver # Name of default databaseserver
DBSERVERALIASES informixserver # List of alternatedbservernames
You don't want these to be the same name. And both names must be in
sqlhosts. Typically DBSERVERNAME is a shared memory connection (onipcshm)
while the DBSERVERALIASES is a tcp connection (onsoctcp). I would suggest:
$ONCONFIG
DBSERVERNAME informixserver # Name of default databaseserver
DBSERVERALIASES informixserver_tcp # List of alternatedbservernames
sqlhosts:
informixserver onipcshm informix dummy
informixserver_tcp onsoctcp informix sqlexec
/etc/services:
sqlexec 1526/tcp # informixserver
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# oninitYour evaluation license will expire on 2007-10-30 00:00:00
sh-3.00# onstat -mYour 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, noSHMTOTAL limit08:06:22 Dynamically allocated new message shared memory segment
(size 528KB)
08:06:22 Memory sizes:resident:11664 KB, virtual:16912 KB, noSHMTOTAL limit08:06:22 Event notification facility epoll enabled.
08:06:22 IBM Informix Dynamic Server Version 10.00.UC6TL SoftwareSerial 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/correctsegments
On Aug 8, 4:11 am, Andreas Breitfeld <abrei...@de.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
Thanks for you help.
I have made those changes, oninit still fails and drops me to the
shell. Should I have to change NETTYPE in the onconfig?
here is the output of onstat -m
[root@informix informix]# setarch i686 -R sh
sh-3.00# oninitYour evaluation license will expire on 2007-10-30 00:00:00
sh-3.00# onstat -mYour 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, noSHMTOTAL limit08:06:22 Dynamically allocated new message shared memory segment
(size 528KB)
08:06:22 Memory sizes:resident:11664 KB, virtual:16912 KB, noSHMTOTAL limit08:06:22 Event notification facility epoll enabled.
08:06:22 IBM Informix Dynamic Server Version 10.00.UC6TL SoftwareSerial 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/correctsegments
On Aug 8, 8:25 am, "Jack Parker" <jack.park...@verizon.net> wrote:
> -----Original Message-----
> From: informix-list-boun...@iiug.org
>
> [mailto:informix-list-boun...@iiug.org]On Behalf Of tom.pri...@gmail.com
> Sent: Wednesday, August 08, 2007 2:55 AM
> To: informix-l...@iiug.org
> Subject: shared memory not initialized
>
> 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:
>
> DBSERVERNAME informixserver # Name of default database> server
> DBSERVERALIASES informixserver # List of alternate> dbservernames
>
> You don't want these to be the same name. And both names must be in
> sqlhosts. Typically DBSERVERNAME is a shared memory connection (onipcshm)
> while the DBSERVERALIASES is a tcp connection (onsoctcp). I would suggest:
>
> $ONCONFIG
> DBSERVERNAME informixserver # Name of default database> server
> DBSERVERALIASES informixserver_tcp # List of alternate> dbservernames
>
> sqlhosts:
> informixserver onipcshm informix dummy
> informixserver_tcp onsoctcp informix sqlexec>
> /etc/services:
> sqlexec 1526/tcp # informixserver
On Aug 8, 1:13 pm, "tom.pri...@gmail.com" <tom.pri...@gmail.com>
wrote:
> Thanks for you help.
> I have made those changes, oninit still fails and drops me to the
> shell. Should I have to change NETTYPE in the onconfig?
>
> here is the output of onstat -m
<SNIP>
> 08:06:22 listener-thread: err = -930: oserr = 0: errstr = informix:> Cannot connect to database server (informix).
<SNIP>
> > sqlhosts:
> > informixserver onipcshm informix dummy
> > informixserver_tcp onsoctcp informix sqlexec>
> > /etc/services:
> > sqlexec 1526/tcp # informixserver
OK, the sqlhosts file says your server is named 'informixserver' and
is running on a machine whose name is 'informix' and the connection
uses service 'sqlexec' (port 1526). So far so good, though I question
your choice of machine and server names (what will you name things
when you bring up the second server for Informix?). However, the
failure message in the online log indicates that you have
INFORMIXSERVER set to 'informix' when it should be set to
'informixserver'. Try fixing that.
Art S. Kagel
I missed that entirely. >Sigh< the joys of going blind.
Tom - are you good to go?
j.
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]On Behalf Of Art S. Kagel
Sent: Wednesday, August 08, 2007 2:01 PM
To: informix-list@iiug.org
Subject: Re: shared memory not initialized
On Aug 8, 1:13 pm, "tom.pri...@gmail.com" <tom.pri...@gmail.com>
wrote:
> Thanks for you help.
> I have made those changes, oninit still fails and drops me to the
> shell. Should I have to change NETTYPE in the onconfig?
>
> here is the output of onstat -m
<SNIP>
> 08:06:22 listener-thread: err = -930: oserr = 0: errstr = informix:> Cannot connect to database server (informix).
<SNIP>
> > sqlhosts:
> > informixserver onipcshm informix dummy
> > informixserver_tcp onsoctcp informix sqlexec>
> > /etc/services:
> > sqlexec 1526/tcp # informixserver
OK, the sqlhosts file says your server is named 'informixserver' and
is running on a machine whose name is 'informix' and the connection
uses service 'sqlexec' (port 1526). So far so good, though I question
your choice of machine and server names (what will you name things
when you bring up the second server for Informix?). However, the
failure message in the online log indicates that you have
INFORMIXSERVER set to 'informix' when it should be set to
'informixserver'. Try fixing that.
Art S. Kagel
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
No not yet.
Here is what im getting now:
[root@informix ~]# oninit
Your evaluation license will expire on 2007-10-30 00:00:00
oninit: Cannot open chunk '/opt/informix/dbs/rootdbs'. errno = 2
oninit: Fatal error in shared memory initialization
[root@informix ~]# 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
Wed Aug 8 12:07:15 2007
12:07:15 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh'
12:07:15 Booting Language <c> from module <>
12:07:15 Loading Module <CNULL>
12:07:15 Booting Language <builtin> from module <>
12:07:15 Loading Module <BUILTINNULL>
12:07:20 DR: DRAUTO is 0 (Off)
12:07:20 Dynamically allocated new virtual shared memory segment
(size 8192KB)
12:07:20 Memory sizes:resident:11664 KB, virtual:16384 KB, noSHMTOTAL limit12:07:20 Dynamically allocated new message shared memory segment
(size 528KB)
12:07:20 Memory sizes:resident:11664 KB, virtual:16912 KB, noSHMTOTAL limit12:07:20 IBM Informix Dynamic Server Version 10.00.UC6TL SoftwareSerial Number AAA#B000000
12:07:20 Your evaluation license will expire on 2007-10-30 00:00:00
12:07:20 Cannot Open Primary Chunk '/opt/informix/dbs/rootdbs', errno
= 2
12:07:20 IBM Informix Dynamic Server Stopped.
12:07:20 mt_shm_remove: WARNING: may not have removed all/correctsegments
On Aug 8, 9:12 pm, "Jack Parker" <jack.park...@verizon.net> wrote:
> I missed that entirely. >Sigh< the joys of going blind.
>
> Tom - are you good to go?
>
> j.
>
> -----Original Message-----
> From: informix-list-boun...@iiug.org
>
> [mailto:informix-list-boun...@iiug.org]On Behalf Of Art S. Kagel
> Sent: Wednesday, August 08, 2007 2:01 PM
> To: informix-l...@iiug.org
> Subject: Re: shared memory not initialized
>
> On Aug 8, 1:13 pm, "tom.pri...@gmail.com" <tom.pri...@gmail.com>
> wrote:
> > Thanks for you help.
> > I have made those changes, oninit still fails and drops me to the
> > shell. Should I have to change NETTYPE in the onconfig?
>
> > here is the output of onstat -m
> <SNIP>
> > 08:06:22 listener-thread: err = -930: oserr = 0: errstr = informix:> > Cannot connect to database server (informix).
> <SNIP>
> > > sqlhosts:
> > > informixserver onipcshm informix dummy
> > > informixserver_tcp onsoctcp informix sqlexec>
> > > /etc/services:
> > > sqlexec 1526/tcp # informixserver
>
> OK, the sqlhosts file says your server is named 'informixserver' and
> is running on a machine whose name is 'informix' and the connection
> uses service 'sqlexec' (port 1526). So far so good, though I question
> your choice of machine and server names (what will you name things
> when you bring up the second server for Informix?). However, the
> failure message in the online log indicates that you have
> INFORMIXSERVER set to 'informix' when it should be set to
> 'informixserver'. Try fixing that.
>
> Art S. Kagel
>
> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list
Here is my (non-working config):
sqlhosts:
informixserver onipcshm informix sqlexec
/etc/hosts:
127.0.0.1 localhost.localdomain localhost
192.168.26.66 informix
/etc/services:
sqlexec 9088/tcp
onconfig
ROOTNAME rootdbs # Root dbspace nameROOTPATH /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)
SERVERNUM 0 # Unique id corresponding to a OnLineinstance
DBSERVERNAME informixserver # Name of default databaseserver
#DBSERVERALIASES informixserver_tcp # List of
alternate dbservernames
NETTYPE # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed 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 vpsto 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 memorysegment 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)
On Aug 8, 9:12 pm, "Jack Parker" <jack.park...@verizon.net> wrote:
> I missed that entirely. >Sigh< the joys of going blind.
>
> Tom - are you good to go?
>
> j.
>
> -----Original Message-----
> From: informix-list-boun...@iiug.org
>
> [mailto:informix-list-boun...@iiug.org]On Behalf Of Art S. Kagel
> Sent: Wednesday, August 08, 2007 2:01 PM
> To: informix-l...@iiug.org
> Subject: Re: shared memory not initialized
>
> On Aug 8, 1:13 pm, "tom.pri...@gmail.com" <tom.pri...@gmail.com>
> wrote:
> > Thanks for you help.
> > I have made those changes, oninit still fails and drops me to the
> > shell. Should I have to change NETTYPE in the onconfig?
>
> > here is the output of onstat -m
> <SNIP>
> > 08:06:22 listener-thread: err = -930: oserr = 0: errstr = informix:> > Cannot connect to database server (informix).
> <SNIP>
> > > sqlhosts:
> > > informixserver onipcshm informix dummy
> > > informixserver_tcp onsoctcp informix sqlexec>
> > > /etc/services:
> > > sqlexec 1526/tcp # informixserver
>
> OK, the sqlhosts file says your server is named 'informixserver' and
> is running on a machine whose name is 'informix' and the connection
> uses service 'sqlexec' (port 1526). So far so good, though I question
> your choice of machine and server names (what will you name things
> when you bring up the second server for Informix?). However, the
> failure message in the online log indicates that you have
> INFORMIXSERVER set to 'informix' when it should be set to
> 'informixserver'. Try fixing that.
>
> Art S. Kagel
>
> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list
tom.priore@gmail.com wrote:
> No not yet.
> Here is what im getting now:
> [root@informix ~]# oninit
> Your evaluation license will expire on 2007-10-30 00:00:00
> oninit: Cannot open chunk '/opt/informix/dbs/rootdbs'. errno = 2
> oninit: Fatal error in shared memory initialization
Does this file (/opt/informix/dbs/rootdbs) exist?
What are the permissions / owner?
I'm also presuming that this instance has been fully up before . . .
JWC
Does /opt/informix/dbs/rootdbs exist?
It also needs to have permissions of 660 and be owned by informix:informix
Also, when you oninit, use oninit -v - that will print more detailed status
messages to the screen while it boots. Of course if you are iniitlizing,
that would become oninit -ivy.
j.
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]On Behalf Of tom.priore@gmail.com
Sent: Wednesday, August 08, 2007 10:09 PM
To: informix-list@iiug.org
Subject: Re: shared memory not initialized
No not yet.
Here is what im getting now:
[root@informix ~]# oninit
Your evaluation license will expire on 2007-10-30 00:00:00
oninit: Cannot open chunk '/opt/informix/dbs/rootdbs'. errno = 2
oninit: Fatal error in shared memory initialization
[root@informix ~]# 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
Wed Aug 8 12:07:15 2007
12:07:15 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh'
12:07:15 Booting Language <c> from module <>
12:07:15 Loading Module <CNULL>
12:07:15 Booting Language <builtin> from module <>
12:07:15 Loading Module <BUILTINNULL>
12:07:20 DR: DRAUTO is 0 (Off)
12:07:20 Dynamically allocated new virtual shared memory segment
(size 8192KB)
12:07:20 Memory sizes:resident:11664 KB, virtual:16384 KB, noSHMTOTAL limit12:07:20 Dynamically allocated new message shared memory segment
(size 528KB)
12:07:20 Memory sizes:resident:11664 KB, virtual:16912 KB, noSHMTOTAL limit12:07:20 IBM Informix Dynamic Server Version 10.00.UC6TL SoftwareSerial Number AAA#B000000
12:07:20 Your evaluation license will expire on 2007-10-30 00:00:00
12:07:20 Cannot Open Primary Chunk '/opt/informix/dbs/rootdbs', errno
= 2
12:07:20 IBM Informix Dynamic Server Stopped.
12:07:20 mt_shm_remove: WARNING: may not have removed all/correctsegments
On Aug 8, 9:12 pm, "Jack Parker" <jack.park...@verizon.net> wrote:
> I missed that entirely. >Sigh< the joys of going blind.
>
> Tom - are you good to go?
>
> j.
>
> -----Original Message-----
> From: informix-list-boun...@iiug.org
>
> [mailto:informix-list-boun...@iiug.org]On Behalf Of Art S. Kagel
> Sent: Wednesday, August 08, 2007 2:01 PM
> To: informix-l...@iiug.org
> Subject: Re: shared memory not initialized
>
> On Aug 8, 1:13 pm, "tom.pri...@gmail.com" <tom.pri...@gmail.com>
> wrote:
> > Thanks for you help.
> > I have made those changes, oninit still fails and drops me to the
> > shell. Should I have to change NETTYPE in the onconfig?
>
> > here is the output of onstat -m
> <SNIP>
> > 08:06:22 listener-thread: err = -930: oserr = 0: errstr = informix:> > Cannot connect to database server (informix).
> <SNIP>
> > > sqlhosts:
> > > informixserver onipcshm informix dummy
> > > informixserver_tcp onsoctcp informix sqlexec>
> > > /etc/services:
> > > sqlexec 1526/tcp # informixserver
>
> OK, the sqlhosts file says your server is named 'informixserver' and
> is running on a machine whose name is 'informix' and the connection
> uses service 'sqlexec' (port 1526). So far so good, though I question
> your choice of machine and server names (what will you name things
> when you bring up the second server for Informix?). However, the
> failure message in the online log indicates that you have
> INFORMIXSERVER set to 'informix' when it should be set to
> 'informixserver'. Try fixing that.
>
> Art S. Kagel
>
> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
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.priore@gmail.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...@de.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 inf