Error starting IDS v10
IDS 10.00.FC5 on AIX 5.3 failed to start with "listener-thread: err = -25572 ... Network driver cannot bind a name to the port" / ASF_LISTEN failed. Diagnosis showed sqlhosts contained three entries for the same dbservername mol_dev, two of them on the same host; Art Kagel advised giving each TCP interface a distinct name and listing the extra one in DBSERVERALIASES. After fixing that, startup got further but then failed on the root chunk (errno 2, later "chunk failed sanity check", chunk taken offline) and ontape -r restore also failed, pointing to a disk/LV problem at the DR site; chunk device permissions were also advised to be 660 rather than 666. No resolution of the chunk/disk problem is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello,
When trying to start the IDS 10, this message appear from onstat -m
14:37:13 Event alarms enabled. ALARMPROG = '/usr/informix/etc/alarmprogram.sh'
14:37:13 Booting Language <c> from module <>
14:37:13 Loading Module <CNULL>
14:37:13 Booting Language <builtin> from module <>
14:37:13 Loading Module <BUILTINNULL>
14:37:18 DR: DRAUTO is 0 (Off)
14:37:18 AIX MP latch code enabled
14:37:18 IBM Informix Dynamic Server Version 10.00.FC5 Software Serial Numb
er AAA#B000000
14:37:18 listener-thread: err = -25572: oserr = 68: errstr = : Network driver c
annot bind a name to the port.
System error = 68.
14:37:18 sql_listener: ASF_LISTEN failed
14:37:18 Attempting to bring listener thread down.
14:37:18 Server stopped.
14:37:18 IBM Informix Dynamic Server Stopped.
What could be the problem?
Hazim
Full version and OS versions would be useful. How did the engine stop, was
it a clean shut down or a crash of some sort ?
This error usually indicates some files need tidying up or an application still
has a connection into the network port.
what does ls -al /INFORMIXTMP show ?
Keith
On 14 October 2010 08:01, AZRAN HAZIM <azran@matrade.gov.my> wrote:
> Hello,
> When trying to start the IDS 10, this message appear from onstat -m
>
> 14:37:13 Event alarms enabled. ALARMPROG =
'/usr/informix/etc/alarmprogram.sh'
> 14:37:13 Booting Language <c> from module <>
> 14:37:13 Loading Module <CNULL>
> 14:37:13 Booting Language <builtin> from module <>
> 14:37:13 Loading Module <BUILTINNULL>
> 14:37:18 DR: DRAUTO is 0 (Off)
> 14:37:18 AIX MP latch code enabled
> 14:37:18 IBM Informix Dynamic Server Version 10.00.FC5 Software Serial Numb
> er AAA#B000000
> 14:37:18 listener-thread: err = -25572: oserr = 68: errstr = : Network driver
> c
> annot bind a name to the port.
> System error = 68.
> 14:37:18 sql_listener: ASF_LISTEN failed
>
> 14:37:18 Attempting to bring listener thread down.
>
> 14:37:18 Server stopped.
>
> 14:37:18 IBM Informix Dynamic Server Stopped.
>
> What could be the problem?
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
hi,
IDS v10.00 FC5, AIX 5.3
I've sent oninit -v command and from onstat -m, display the error
ls -l /INFORMIXTMP
mol_dev : /usr/informix/etc> ls -al /INFORMIXTMP
total 112
drwxrwxr-t 2 informix informix 4096 Oct 14 14:37 .
drwxr-xr-x 32 root system 4096 Oct 14 12:00 ..
-rw-rw---- 1 informix informix 292 Feb 28 2008 .demo_on.alarm
-rw-rw---- 1 informix informix 136 Apr 24 12:18 .dss_prod.alarm
-rw-rw---- 1 informix informix 78 Jan 22 2007 .eis.alarm
-rw-rw---- 1 informix informix 81 Apr 24 16:18 .eis_prod.alarm
-r--r--r-- 1 root informix 60 Apr 17 2008 .inf.on_servername
-rw-rw-r-- 1 root informix 45 Feb 28 2008 .infxdirs
-rw-rw---- 1 informix informix 90 Oct 14 10:24 .mol_dev.alarm
-rw-rw---- 1 informix informix 520 Jul 11 2008 .moldev.alarm
-rw-rw---- 1 informix informix 526 Jul 31 2008 .molstag.alarm
-rw-rw---- 1 informix informix 81 Oct 6 13:16 .mtx2informix_prod.alar
m
-rw-rw---- 1 informix informix 59 Sep 23 15:15 .stat_prod.alarm
-rw-rw---- 1 informix informix 154 Dec 12 2007 .trade_prod.alarm
appreciate it
Azran, You can't send attachments to the forums, we never get to see them.
Post the oninit -v output inline in your posting.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, Oct 14, 2010 at 4:08 AM, AZRAN HAZIM <azran@matrade.gov.my> wrote:
> hi,
>
> IDS v10.00 FC5, AIX 5.3
>
> I've sent oninit -v command and from onstat -m, display the error
>
> ls -l /INFORMIXTMP
>
> mol_dev : /usr/informix/etc> ls -al /INFORMIXTMP
> total 112
> drwxrwxr-t 2 informix informix 4096 Oct 14 14:37 .
> drwxr-xr-x 32 root system 4096 Oct 14 12:00 ..
> -rw-rw---- 1 informix informix 292 Feb 28 2008 .demo_on.alarm
> -rw-rw---- 1 informix informix 136 Apr 24 12:18 .dss_prod.alarm
> -rw-rw---- 1 informix informix 78 Jan 22 2007 .eis.alarm
> -rw-rw---- 1 informix informix 81 Apr 24 16:18 .eis_prod.alarm
> -r--r--r-- 1 root informix 60 Apr 17 2008 .inf.on_servername
> -rw-rw-r-- 1 root informix 45 Feb 28 2008 .infxdirs
> -rw-rw---- 1 informix informix 90 Oct 14 10:24 .mol_dev.alarm
> -rw-rw---- 1 informix informix 520 Jul 11 2008 .moldev.alarm
> -rw-rw---- 1 informix informix 526 Jul 31 2008 .molstag.alarm
> -rw-rw---- 1 informix informix 81 Oct 6 13:16 .mtx2informix_prod.alar
> m
> -rw-rw---- 1 informix informix 59 Sep 23 15:15 .stat_prod.alarm
> -rw-rw---- 1 informix informix 154 Dec 12 2007 .trade_prod.alarm
>
> appreciate it
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016361643a9a81d910492940a13
i didn't, the oninit -v error message at 1st post. here's another
22:11:12 Event alarms enabled. ALARMPROG = '/usr/informix/etc/alarmprogram.sh'
22:11:12 Booting Language <c> from module <>
22:11:12 Loading Module <CNULL>
22:11:12 Booting Language <builtin> from module <>
22:11:12 Loading Module <BUILTINNULL>
22:11:17 DR: DRAUTO is 0 (Off)
22:11:17 AIX MP latch code enabled
22:11:17 Dynamically allocated new message shared memory segment (size 1072KB)
22:11:18 Dynamically allocated new message shared memory segment (size 1072KB)
22:11:18 Dynamically allocated new message shared memory segment (size 1072KB)
22:11:18 Dynamically allocated new message shared memory segment (size 1072KB)
22:11:18 listener-thread: err = -25572: oserr = 68: errstr = : Network driver c
annot bind a name to the port.
System error = 68.
22:11:18 sql_listener: ASF_LISTEN failed
22:11:18 Attempting to bring listener thread down.
22:11:18 Server stopped.
No, that's the contents of the message log (onstat -m) at the time of the
startup failure. I want to see what you saw on the command line output when
you ran the oninit -v. This is telling us that you had a problem opening
the network interface. There could be many reasons for that and the oninit
-v output may provide another clue. Also post: the exact IDS version
including the patch levels, your OS version, your sqlhosts file, and the
SERVERNAME, SERVERNUM, and DBSERVERALIASES lines from the ONCONFIG file.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, Oct 14, 2010 at 10:17 AM, AZRAN HAZIM <azran@matrade.gov.my> wrote:
> i didn't, the oninit -v error message at 1st post. here's another
>
> 22:11:12 Event alarms enabled. ALARMPROG =
> '/usr/informix/etc/alarmprogram.sh'
> 22:11:12 Booting Language <c> from module <>
> 22:11:12 Loading Module <CNULL>
> 22:11:12 Booting Language <builtin> from module <>
> 22:11:12 Loading Module <BUILTINNULL>
> 22:11:17 DR: DRAUTO is 0 (Off)
> 22:11:17 AIX MP latch code enabled
> 22:11:17 Dynamically allocated new message shared memory segment (size
> 1072KB)
> 22:11:18 Dynamically allocated new message shared memory segment (size
> 1072KB)
> 22:11:18 Dynamically allocated new message shared memory segment (size
> 1072KB)
> 22:11:18 Dynamically allocated new message shared memory segment (size
> 1072KB)
> 22:11:18 listener-thread: err = -25572: oserr = 68: errstr = : Network
> driver
> c
> annot bind a name to the port.
> System error = 68.
> 22:11:18 sql_listener: ASF_LISTEN failed
>
> 22:11:18 Attempting to bring listener thread down.
>
> 22:11:18 Server stopped.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0cd32da8dbe1d8049294865a
I had the same issue yesterday and determined that I had two shared
memory DBSERV* connection and I can only have one. I also review all
ports that I am allocating. I want to use ports not being used by the
OS and ones that are not being used by another TCP/IP connection name in
the sqlhosts file.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings - BU: I & T Group
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry: 2244650553@messaging.sprintpcs.com
Page via Skytel: 2244650553@sprint.skytel.com
Informix or MySQL Primary: 9110210@skytel.com
Informix or MySQL Secondary: 7276872@skytel.com
" Yes we can make a Change! "
" It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS!
"
" Lets not forget - GO Pistons and Red Wings! "
GSU
*******************************************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Art Kagel
Sent: Thursday, October 14, 2010 10:29 AM
To: ids@iiug.org
Subject: Re: Error starting IDS v10 [21690]
No, that's the contents of the message log (onstat -m) at the time of
the
startup failure. I want to see what you saw on the command line output
when
you ran the oninit -v. This is telling us that you had a problem opening
the network interface. There could be many reasons for that and the
oninit-v output may provide another clue. Also post: the exact IDS version
including the patch levels, your OS version, your sqlhosts file, and the
SERVERNAME, SERVERNUM, and DBSERVERALIASES lines from the ONCONFIG file.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions
and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other
organization with which I am associated either explicitly, implicitly,
or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, Oct 14, 2010 at 10:17 AM, AZRAN HAZIM <azran@matrade.gov.my>
wrote:
> i didn't, the oninit -v error message at 1st post. here's another
>
> 22:11:12 Event alarms enabled. ALARMPROG =
> '/usr/informix/etc/alarmprogram.sh'
> 22:11:12 Booting Language <c> from module <>
> 22:11:12 Loading Module <CNULL>
> 22:11:12 Booting Language <builtin> from module <>
> 22:11:12 Loading Module <BUILTINNULL>
> 22:11:17 DR: DRAUTO is 0 (Off)
> 22:11:17 AIX MP latch code enabled
> 22:11:17 Dynamically allocated new message shared memory segment (size
> 1072KB)
> 22:11:18 Dynamically allocated new message shared memory segment (size
> 1072KB)
> 22:11:18 Dynamically allocated new message shared memory segment (size
> 1072KB)
> 22:11:18 Dynamically allocated new message shared memory segment (size
> 1072KB)
> 22:11:18 listener-thread: err = -25572: oserr = 68: errstr = : Network
> driver
> c
> annot bind a name to the port.
> System error = 68.
> 22:11:18 sql_listener: ASF_LISTEN failed
>
> 22:11:18 Attempting to bring listener thread down.
>
> 22:11:18 Server stopped.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0cd32da8dbe1d8049294865a
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Azran,
Provide below info:
env|grep INFORMIXSERVER
grep "^$INFORMIXSERVER" $INFORMIXDIR/etc/sqlhosts
grep "^$INFORMIXSERVER" $INFORMIXDIR/etc/sqlhosts | grep `awk '{print $4}'`
/etc/services
grep "^DBSER" $INFORMIXDIR/etc/$ONCONFIG
uname -a
Regards,
On Thu, Oct 14, 2010 at 3:01 PM, AZRAN HAZIM <azran@matrade.gov.my> wrote:
> Hello,
> When trying to start the IDS 10, this message appear from onstat -m
>
> 14:37:13 Event alarms enabled. ALARMPROG =
> '/usr/informix/etc/alarmprogram.sh'
> 14:37:13 Booting Language <c> from module <>
> 14:37:13 Loading Module <CNULL>
> 14:37:13 Booting Language <builtin> from module <>
> 14:37:13 Loading Module <BUILTINNULL>
> 14:37:18 DR: DRAUTO is 0 (Off)
> 14:37:18 AIX MP latch code enabled
> 14:37:18 IBM Informix Dynamic Server Version 10.00.FC5 Software Serial Numb
> er AAA#B000000
> 14:37:18 listener-thread: err = -25572: oserr = 68: errstr = : Network
> driver
> c
> annot bind a name to the port.
> System error = 68.
> 14:37:18 sql_listener: ASF_LISTEN failed
>
> 14:37:18 Attempting to bring listener thread down.
>
> 14:37:18 Server stopped.
>
> 14:37:18 IBM Informix Dynamic Server Stopped.
>
> What could be the problem?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016364ec874e06aac04929d2426
mol_dev : /home/informix> env|grep INFORMIXSERVER
PS1=$INFORMIXSERVER : $PWD>
INFORMIXSERVER=mol_dev
mol_dev : /home/informix> grep "^$INFORMIXSERVER" $INFORMIXDIR/etc/sqlhosts
mol_dev onsoctcp mtx2informix inf-dev
mol_dev onsoctcp saga inf-portal
mol_dev onsoctcp mtx2informix inf-ekpmatrade
mol_dev : /home/informix> NFORMIXDIR/etc/sqlhosts | grep `awk '{print $4}'`
grep: can't open inf-portal
grep: can't open inf-ekpmatrade
/etc/services
inf-stat 50010/tcp
inf-prod 50001/tcp
inf-dss 50003/tcp
inf-dev 50004/tcp
mol_dev : /home/informix> grep "^DBSER" $INFORMIXDIR/etc/$ONCONFIG
DBSERVERALIASES # List of alternate dbservernames
DBSERVERNAME mol_dev
mol_dev : /home/informix> uname -a
AIX mtx2informix 3 5 00C9E10D4C00
OK your problem is that you have three definitions for the same SERVERNAME
in your sqlhosts file and two of them are for the mtx2informix server
machine which would appear to be the one you are trying to start up. You
can only have one, you MAY be able to have the server on saga have the same
name as the one on mtx2informix, but I'm not sure. If you really do want
two soctcp interfaces to the server on mtx2informix they have to have
different servernames. One of these would be listed in the DBSERVERALIASES
entry in the ONCONFIG file.
So you would change the sqlhosts file, for the local server's entries, to
something like:
mol_dev onsoctcp mtx2informix inf-dev
mol_dev_ekp onsoctcp mtx2informix inf-ekpmatrade
Then in the ONCONFIG file:
DBSERVERALIASES mol_dev_ekp # List of alternate dbservernames
DBSERVERNAME mol_dev
And that should do it.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Fri, Oct 15, 2010 at 4:33 AM, AZRAN HAZIM <azran@matrade.gov.my> wrote:
> mol_dev : /home/informix> env|grep INFORMIXSERVER
> PS1=$INFORMIXSERVER : $PWD>
> INFORMIXSERVER=mol_dev>
> mol_dev : /home/informix> grep "^$INFORMIXSERVER" $INFORMIXDIR/etc/sqlhosts
> mol_dev onsoctcp mtx2informix inf-dev
> mol_dev onsoctcp saga inf-portal
> mol_dev onsoctcp mtx2informix inf-ekpmatrade>
> mol_dev : /home/informix> NFORMIXDIR/etc/sqlhosts | grep `awk '{print $4}'`
> grep: can't open inf-portal
> grep: can't open inf-ekpmatrade
>
> /etc/services
> inf-stat 50010/tcp
> inf-prod 50001/tcp
> inf-dss 50003/tcp
> inf-dev 50004/tcp
>
> mol_dev : /home/informix> grep "^DBSER" $INFORMIXDIR/etc/$ONCONFIG
> DBSERVERALIASES # List of alternate dbservernames
> DBSERVERNAME mol_dev>
> mol_dev : /home/informix> uname -a
> AIX mtx2informix 3 5 00C9E10D4C00
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016364187812339f00492a56dff
Hi Azran,
Please refer Art Kagel's advise in other email
To add on one more possible root cause, please check is there any other db
instance or other services using port 50004 as well
Just "grep 50004 /etc/services" to find out.
Regards,
On Fri, Oct 15, 2010 at 4:33 PM, AZRAN HAZIM <azran@matrade.gov.my> wrote:
> mol_dev : /home/informix> env|grep INFORMIXSERVER
> PS1=$INFORMIXSERVER : $PWD>
> INFORMIXSERVER=mol_dev>
> mol_dev : /home/informix> grep "^$INFORMIXSERVER" $INFORMIXDIR/etc/sqlhosts
> mol_dev onsoctcp mtx2informix inf-dev
> mol_dev onsoctcp saga inf-portal
> mol_dev onsoctcp mtx2informix inf-ekpmatrade>
>
> mol_dev : /home/informix> NFORMIXDIR/etc/sqlhosts | grep `awk '{print $4}'`
> grep: can't open inf-portal
> grep: can't open inf-ekpmatrade
>
> /etc/services
> inf-stat 50010/tcp
> inf-prod 50001/tcp
> inf-dss 50003/tcp
> inf-dev 50004/tcp
>
> mol_dev : /home/informix> grep "^DBSER" $INFORMIXDIR/etc/$ONCONFIG
> DBSERVERALIASES # List of alternate dbservernames
> DBSERVERNAME mol_dev>
> mol_dev : /home/informix> uname -a
> AIX mtx2informix 3 5 00C9E10D4C00
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0cd241004036990492b4bad2
I've already commented the inf-ekpmatrade
mol_dev : /usr/informix/etc> cat sqlhosts
mtx2informix_prod onsoctcp mtx2informix inf-prod
prod_shm onipcshm mtx2informix inf-prod
#eis_prod onsoctcp mtx2informix inf-eis
stat_prod onsoctcp mtx2informix inf-stat
dss_prod onsoctcp mtx2informix inf-dss
mol_dev onsoctcp mtx2informix inf-dev
#mtx2informix_prod onsoctcp saga inf-portal
mol_dev onsoctcp saga inf-portal
#mol_dev onsoctcp mtx2informix inf-ekpmatrade/19/10/2010
#mol_dev onsoctcp saga inf-dev
#matrade onipcshm 172.25.96.180 service_matrade
ol_matradetcp onsoctcp 172.25.96.179 service_matrade
and 'grep 50004 /etc/services'
inf-dev 50004/tcp # Informix instance for development
if I try to do oninit -v
mol_dev : /usr/informix/etc> oninit -v
Checking group membership to determine server run mode...succeeded
Reading configuration file '/usr/informix/etc/onconfig.mol_dev'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/usr/informix/etc/.infos.mol_dev"...succeeded
Linking conf file "/usr/informix/etc/.conf.mol_dev"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 6232 kbytes...succeeded
Allocating 80016 kbytes for buffer pool of 4K 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 2 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
SENDER IS NULL NO MAIL WILL BE SENT
oninit: Cannot open chunk '/informixdata/data/moldev/devrootdbslv'. errno = 2
oninit: Fatal error in shared memory initialization
ontape -r ( to do restoration)
Physical restore failed - function read archive backup failed code -1 errno 5
Hi Azran,
Either the Disk of the Chunk is not available or failed.
ls -l /informixdata/data/moldev/devrootdbslv
On Tue, Oct 19, 2010 at 12:21 PM, AZRAN HAZIM <azran@matrade.gov.my> wrote:
> I've already commented the inf-ekpmatrade
>
> mol_dev : /usr/informix/etc> cat sqlhosts
> mtx2informix_prod onsoctcp mtx2informix inf-prod
> prod_shm onipcshm mtx2informix inf-prod
> #eis_prod onsoctcp mtx2informix inf-eis
> stat_prod onsoctcp mtx2informix inf-stat
> dss_prod onsoctcp mtx2informix inf-dss
> mol_dev onsoctcp mtx2informix inf-dev
> #mtx2informix_prod onsoctcp saga inf-portal
> mol_dev onsoctcp saga inf-portal
> #mol_dev onsoctcp mtx2informix inf-ekpmatrade/19/10/2010
> #mol_dev onsoctcp saga inf-dev
> #matrade onipcshm 172.25.96.180 service_matrade
> ol_matradetcp onsoctcp 172.25.96.179 service_matrade>
> and 'grep 50004 /etc/services'
> inf-dev 50004/tcp # Informix instance for development
>
> if I try to do oninit -v
>
> mol_dev : /usr/informix/etc> oninit -v
> Checking group membership to determine server run mode...succeeded
> Reading configuration file '/usr/informix/etc/onconfig.mol_dev'...succeeded
> Creating /INFORMIXTMP/.infxdirs...succeeded
> Creating infos file "/usr/informix/etc/.infos.mol_dev"...succeeded
> Linking conf file "/usr/informix/etc/.conf.mol_dev"...succeeded
> Writing to infos file...succeeded
> Checking config parameters...succeeded
> Allocating and attaching to shared memory...succeeded
> Creating resident pool 6232 kbytes...succeeded
> Allocating 80016 kbytes for buffer pool of 4K 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 2 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
> SENDER IS NULL NO MAIL WILL BE SENT
> oninit: Cannot open chunk '/informixdata/data/moldev/devrootdbslv'. errno =
> 2
> oninit: Fatal error in shared memory initialization
>
> ontape -r ( to do restoration)>
> Physical restore failed - function read archive backup failed code -1 errno
> 5
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016364175ad7ddebf0492f12109
it's available mol_dev : /usr/informix/etc> ls -l /informixdata/data/moldev/devrootdbslv lrwxrwxrwx 1 informix informix 18 Oct 19 10:54 /informixdata/data/mold ev/devrootdbslv -> /dev/rdevrootdbslv
What about ls -l /dev/rdevrootdbslv ? From: "AZRAN HAZIM" <azran@matrade.gov.my> To: ids@iiug.org Date: 19/10/2010 10:35 AM Subject: Re: Error starting IDS v10 [21743] it's available mol_dev : /usr/informix/etc> ls -l /informixdata/data/moldev/devrootdbslv lrwxrwxrwx 1 informix informix 18 Oct 19 10:54 /informixdata/data/mold ev/devrootdbslv -> /dev/rdevrootdbslv ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
how about /dev/rdevrootdbslv? if yes, then you may need to verify this disk is in good condition or not On Tue, Oct 19, 2010 at 1:06 PM, AZRAN HAZIM <azran@matrade.gov.my> wrote: > it's available > > mol_dev : /usr/informix/etc> ls -l /informixdata/data/moldev/devrootdbslv > lrwxrwxrwx 1 informix informix 18 Oct 19 10:54 /informixdata/data/mold > ev/devrootdbslv -> /dev/rdevrootdbslv > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016364d30b1fa4cb90492f14b04
mol_dev : /usr/informix/etc> ls -l /dev/rdevrootdbslv crw-rw-rw- 1 informix informix 39, 38 Oct 7 12:16 /dev/rdevrootdbslv
change the /dev/rdevrootdbslv(and any other chunks file as well) permission mode to 660 and restore from the tapes On Tue, Oct 19, 2010 at 1:24 PM, AZRAN HAZIM <azran@matrade.gov.my> wrote: > mol_dev : /usr/informix/etc> ls -l /dev/rdevrootdbslv > crw-rw-rw- 1 informix informix 39, 38 Oct 7 12:16 /dev/rdevrootdbslv > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd2da52d191990492f2e4ca
ontape -r
Physical restore failed - function read archive backup failed code -1 errno 5
onstat -m
Message Log File: /informixdata/log/mol_dev.log
15:19:31 Loading Module <BUILTINNULL>
15:19:36 DR: DRAUTO is 0 (Off)
15:19:36 AIX MP latch code enabled
15:19:36 IBM Informix Dynamic Server Version 10.00.FC5 Software Serial Numb
er AAA#B000000
15:19:37 Assert Warning: chunk failed sanity check
15:19:37 IBM Informix Dynamic Server Version 10.00.FC5
15:19:37 Who: Session(1, informix@mtx2informix, 0, 700000020341028)
Thread(7, main_loop(), 700000020307028, 3)
File: rspartn.c Line: 8673
15:19:37 Results: Chunk 1 is being taken OFFLINE.
15:19:37 Action: Restore chunk from archive.
15:19:37 stack trace for pid 106718 written to /usr/informix/tmp/af.3ef4689
15:19:37 See Also: /usr/informix/tmp/af.3ef4689
15:19:37 chunk failed sanity check
15:19:38 I/O error, Primary Chunk '/informixdata/data/moldev/devrootdbslv' -- O
ffline (sanity)
15:19:38 IBM Informix Dynamic Server Stopped.
15:19:38 mt_shm_remove: WARNING: may not have removed all/correct segments
You need to diagnose hard disk.
On Tue, Oct 19, 2010 at 3:18 PM, AZRAN HAZIM <azran@matrade.gov.my> wrote:
> ontape -r>
> Physical restore failed - function read archive backup failed code -1 errno
> 5
>
> onstat -m>
> Message Log File: /informixdata/log/mol_dev.log
> 15:19:31 Loading Module <BUILTINNULL>
> 15:19:36 DR: DRAUTO is 0 (Off)
> 15:19:36 AIX MP latch code enabled
> 15:19:36 IBM Informix Dynamic Server Version 10.00.FC5 Software Serial Numb
> er AAA#B000000
> 15:19:37 Assert Warning: chunk failed sanity check
>
> 15:19:37 IBM Informix Dynamic Server Version 10.00.FC5
> 15:19:37 Who: Session(1, informix@mtx2informix, 0, 700000020341028)
>
> Thread(7, main_loop(), 700000020307028, 3)
>
> File: rspartn.c Line: 8673
> 15:19:37 Results: Chunk 1 is being taken OFFLINE.
> 15:19:37 Action: Restore chunk from archive.
> 15:19:37 stack trace for pid 106718 written to /usr/informix/tmp/af.3ef4689
> 15:19:37 See Also: /usr/informix/tmp/af.3ef4689
> 15:19:37 chunk failed sanity check
>
> 15:19:38 I/O error, Primary Chunk '/informixdata/data/moldev/devrootdbslv'
> --
> O
> ffline (sanity)
> 15:19:38 IBM Informix Dynamic Server Stopped.
>
> 15:19:38 mt_shm_remove: WARNING: may not have removed all/correct segments
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0cd1724c33ca9a0492f3314f
in the production site, for instance, on of the LV is on hdisk1 and mirrored hdisk3 but here at the DR site, only hdisk1. would that be an issue?
Please confirm this /dev/rdevrootdbslv attached to which hdisk lslv -m rdevrootdbslv On Tue, Oct 19, 2010 at 6:33 PM, AZRAN HAZIM <azran@matrade.gov.my> wrote: > in the production site, for instance, on of the LV is on hdisk1 and > mirrored > hdisk3 but here at the DR site, only hdisk1. would that be an issue? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00163630f66dd6bce50492f6ba58
On Mon, Oct 18, 2010 at 22:24, AZRAN HAZIM <azran@matrade.gov.my> wrote: > mol_dev : /usr/informix/etc> ls -l /dev/rdevrootdbslv > crw-rw-rw- 1 informix informix 39, 38 Oct 7 12:16 /dev/rdevrootdbslv > > > You really, really, really do not want anyone to write to or read from your chunks. Reset the permissions to 660 (please). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. --20cf30564191681c5a0493261686