Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

shared memory not initialized

2,482 views
Skip to first unread message

tom.p...@gmail.com

unread,
Aug 8, 2007, 2:54:41 AM8/8/07
to
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)

......

Andreas Breitfeld

unread,
Aug 8, 2007, 4:11:34 AM8/8/07
to inform...@iiug.org
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

> _______________________________________________
> Informix-list mailing list
> Inform...@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

Jack Parker

unread,
Aug 8, 2007, 8:25:36 AM8/8/07
to tom.p...@gmail.com, inform...@iiug.org

-----Original Message-----
From: informix-l...@iiug.org
[mailto:informix-l...@iiug.org]On Behalf Of tom.p...@gmail.com
Sent: Wednesday, August 08, 2007 2:55 AM
To: inform...@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

tom.p...@gmail.com

unread,
Aug 8, 2007, 1:10:25 PM8/8/07
to
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

> > Informix-l...@iiug.org

tom.p...@gmail.com

unread,
Aug 8, 2007, 1:13:03 PM8/8/07
to
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# 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, 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

Art S. Kagel

unread,
Aug 8, 2007, 2:00:32 PM8/8/07
to
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

Jack Parker

unread,
Aug 8, 2007, 9:12:55 PM8/8/07
to Art S. Kagel, inform...@iiug.org
I missed that entirely. >Sigh< the joys of going blind.

Tom - are you good to go?

j.

Art S. Kagel

_______________________________________________

tom.p...@gmail.com

unread,
Aug 8, 2007, 10:08:49 PM8/8/07
to
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, no
SHMTOTAL limit
12:07:20 Dynamically allocated new message shared memory segment
(size 528KB)
12:07:20 Memory sizes:resident:11664 KB, virtual:16912 KB, no
SHMTOTAL limit
12:07:20 IBM Informix Dynamic Server Version 10.00.UC6TL Software
Serial 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/correct
segments

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

> Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list


tom.p...@gmail.com

unread,
Aug 8, 2007, 10:13:53 PM8/8/07
to
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 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)

SERVERNUM 0 # Unique id corresponding to a OnLine
instance


DBSERVERNAME informixserver # Name of default database
server

#DBSERVERALIASES informixserver_tcp # List of
alternate dbservernames
NETTYPE # Configure poll thread(s) for nettype

# Shared Memory Parameters

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

> Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list


Jack Parker

unread,
Aug 8, 2007, 10:28:38 PM8/8/07
to tom.p...@gmail.com, inform...@iiug.org
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.

Message Log File: /opt/informix/online.log

John Carlson

unread,
Aug 8, 2007, 10:25:13 PM8/8/07
to
tom.p...@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

Jack Parker

unread,
Aug 8, 2007, 10:33:44 PM8/8/07
to tom.p...@gmail.com, Informix-List@Iiug. Org
The holy trinity is ONCONFIG, sqlhosts and /etc/services. Your entries look
ok at this point - sounds like your rootdbs either does not exist or has
wrong ownership/permissions (previous note).

You also need environment variables:
INFORMIXSERVER=informixserver (in your case)
ONCONFIG=whatever (no path - just filename)

There are others, but these two should be enough to start.

DBSERVERNAME must match $INFORMIXSERVER and needs an entry in sqlhosts.

I was wrong to earlier critique your sqlhosts and indicate that an onipcshm
was required, there are folks who run only with a network connection.
(Hence why I used the word 'typically')

an /etc/service entry must exist for all network connections (onsoctcp for
example). I do not believe that it is required for shared memory
connections.

j.

-----Original Message-----
From: tom.p...@gmail.com [mailto:tom.p...@gmail.com]
Sent: Wednesday, August 08, 2007 10:14 PM
To: Jack Parker
Subject: Re: shared memory not initialized

/etc/services:
sqlexec 9088/tcp

# Shared Memory Parameters

Andreas Breitfeld

unread,
Aug 9, 2007, 4:55:18 AM8/9/07
to inform...@iiug.org
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

Jack Parker

unread,
Aug 9, 2007, 8:59:08 AM8/9/07
to Tom Priore, inform...@iiug.org
You didn't need to run oninit -v the second time, the first time (oninit -ivy) was enough.  The second time around it tries to pop memory back in the same place as the last one.  Check if the first one is still running:
 
onstat -
 
It probably is.
 
If not, then you may have corrupted memory with the second oninit -v (I don't see anything in the error to suggest that) and may want to reboot rather than attempt to clean up memory. 
 
Now that you have done the oninit -i - you do not need to do it again (think format c:), from now on you can startup with oninit, or oninit -v if debugging.  Shutdown with onmode -yuk.
 
If you want just tcp connectivity, then change the sqlhosts entry:
 
sqlhosts:
informixserver  onsoctcp        informix        sqlexec


/etc/services:
sqlexec         1526/tcp      #  informixserver
j.
 
-----Original Message-----
From: Tom Priore [mailto:tom.p...@gmail.com]
Sent: Wednesday, August 08, 2007 10:38 PM
To: Jack Parker
Cc: inform...@iiug.org
Subject: Re: shared memory not initialized

rootdbs did not exist.. I thought oninit -i would create it.
I touched it and chown/chgrp/chmoded it.
I double checked the enviornment vars, they look good.
I then ran oninit -ivy and got:

[root@informix informix]# oninit -ivy
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 'ipcshm' listener threads...succeeded

Starting tracing...succeeded
Initializing 1 flushers...succeeded
Initializing log/checkpoint information...succeeded
Opening primary chunks...succeeded
Opening mirror chunks...succeeded
Initializing dbspaces...succeeded
Validating chunks...succeeded
Creating database partition...succeeded
Initialize Async Log Flusher...succeeded
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list...succeeded
Checking database partition index...succeeded
Checking location of physical log...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Forking onmode_mon thread...succeeded
Verbose output complete: mode = 5

Which i guess looks good.

Then i run:

[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...FAILED
oninit: Fatal error in shared memory creation

which looks bad.

Now, you said that some people run with out shared memory. since generally i will be connecting from another system via tcp, would i be a canidate to be one of those other people?

If i were to give up on shared memory, and go at it via network, how would i change the configs?




On 8/8/07, Jack Parker < jack.p...@verizon.net> wrote:
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-l...@iiug.org
[mailto:informix-l...@iiug.org]On Behalf Of tom.p...@gmail.com
Sent: Wednesday, August 08, 2007 10:09 PM
To: inform...@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, no
SHMTOTAL limit
12:07:20  Dynamically allocated new message shared memory segment
(size 528KB)
12:07:20  Memory sizes:resident:11664 KB, virtual:16912 KB, no
SHMTOTAL limit
12:07:20  IBM Informix Dynamic Server Version 10.00.UC6TL Software
Serial 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/correct
segments

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.p...@gmail.com

unread,
Aug 10, 2007, 12:34:29 AM8/10/07
to
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
>

> Christian Diedrich, Christoph Grandpierre, Matthias ...
>
> read more »

Andreas Breitfeld

unread,
Aug 10, 2007, 5:46:13 AM8/10/07
to inform...@iiug.org
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

Ogiwara Tsutomu

unread,
Aug 12, 2007, 9:01:13 PM8/12/07
to tom.p...@gmail.com, inform...@iiug.org
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.p...@gmail.com" <tom.p...@gmail.com>
>To: inform...@iiug.org
>Subject: Re: shared memory not initialized

> > > > Maerki; Gesch臟tsf・rung: 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臟tsf・rung: Martin Jetter (Vorsitzender), Rudolf Bauer,


> > Christian Diedrich, Christoph Grandpierre, Matthias ...
> >

> > read more サ
>


>_______________________________________________
>Informix-list mailing list
>Inform...@iiug.org
>http://www.iiug.org/mailman/listinfo/informix-list

_________________________________________________________________
Hotmailリニューアル記念!プジョーのニューモデル「プジョー 207 Cielo」が当た
http://clk.atdmt.com/GBL/go/msnjpqjl0060000010gbl/direct/01/

Keith Simmons

unread,
Aug 13, 2007, 10:05:51 AM8/13/07
to tom.p...@gmail.com, inform...@iiug.org
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...@hotmail.com> wrote:
> 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.p...@gmail.com" <tom.p...@gmail.com>
> >To: inform...@iiug.org
> >Subject: Re: shared memory not initialized
> >Date: Fri, 10 Aug 2007 04:34:29 -0000
> >

> > > > > Maerki; Gesch臟tsf・rung: 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臟tsf・rung: Martin Jetter (Vorsitzender), Rudolf Bauer,


> > > Christian Diedrich, Christoph Grandpierre, Matthias ...
> > >

0 new messages