Re: shared memory not initialized
Posted in 2007
Topics: Installation, Setup & Upgrades, Storage & Space Management, Stored Procedures & SPL, Server Administration, Security, Permissions & Auditing, Logging & Checkpoints, Networking & sqlhosts Configuration, Licensing & Editions
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...@de.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...@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
Looks like your environment is a real challenge for installing IDS;-)
I would propose you should try a new install:
1. reboot your machine
2. move your old installation away
3. follow the instructions for installing and configuring an example
instance of IDS at
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0603breitfeld/#N10196
4. if 'oninit -iv' fails with the same error, then change onconfig
parameter SHMBASE to 0x10000000L , reboot your machine and run 'oninit
-iv'
5. if this fails again, reboot your machine and run oninit with strace
command as root (with set environment ids.env from the example above):
strace -o /tmp/oninit.strace -f oninit -ivy
6. Please 'gzip /tmp/oninit.strace' and send /tmp/oninit.strace.gz to my
Email address.
7. Please add output of following command:
cat /procs/$$/maps
Andreas
On Friday 10 August 2007 06:34, tom.priore@gmail.com wrote:
> 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...@de.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...@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
> > > > >
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@gmail.com" <tom.priore@gmail.com>
>To: informix-list@iiug.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...@de.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...@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
> >
> > > > >