shared memory not initialized for INFORMIXSERVER
A user on IDS 7.31.UD6 (HP-UX 11.11) couldn't connect with dbaccess (error 25588) and onstat -d reported shared memory not initialized for server 'onlinedev'. Advice was to start the instance with oninit -v as user informix and check online.log/onstat -m. The server then came up, but only sysmaster and sysutils existed — the six application databases were gone. Respondents said this indicates the instance was re-initialized (oninit -i, shown by 'database built successfully' messages in online.log) or the databases were dropped, and the only recovery is a restore from a level 0 archive (ontape -s -L 0); the user's ontape -a logical-log tape is not a level 0. The thread ends without confirming whether a usable level 0 backup existed, so no final outcome is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mode=5
If not, you must look the Informix message file. Execute onstat -m to
view your online log.
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 13:50
Para: ids@iiug.org
Assunto: shared memory not initialized for INFORMIXSERVER [17092]
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Thanks, Alberto. I got to the line "Verbose output complete mode=5", but I
only have the sysmaster@onlinedev and sysutils@onlinedev. I should see six
other databases, how can I bring back the missing databases.
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 9:54 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17093]
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mode=5
If not, you must look the Informix message file. Execute onstat -m to
view your online log.
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 13:50
Para: ids@iiug.org
Assunto: shared memory not initialized for INFORMIXSERVER [17092]
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Did you perform by accicdent oninit -i??? If you did that, you
initialized a new instance (without database application). To restore
you application database, you must perform a restore from your last
level 0 backup.
Otherwise, somebody who has sufficient privileges dropped your database
application... and to recover, you also must perform a restore from your
last level 0 backup.
You can look your online.log and find for a message, such as "Database
(database_name) dropped".
I hope that you have a valid level 0 backup...
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:04
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17094]
Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
I
only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
six
other databases, how can I bring back the missing databases.
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 9:54 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17093]
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mode=5
If not, you must look the Informix message file. Execute onstat -m to
view your online log.
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 13:50
Para: ids@iiug.org
Assunto: shared memory not initialized for INFORMIXSERVER [17092]
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Thanks a lot, Alberto. I am going to look for it and will be back for more
questions. I hope you don't mind.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:12 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17095]
Did you perform by accicdent oninit -i??? If you did that, you
initialized a new instance (without database application). To restore
you application database, you must perform a restore from your last
level 0 backup.
Otherwise, somebody who has sufficient privileges dropped your database
application... and to recover, you also must perform a restore from your
last level 0 backup.
You can look your online.log and find for a message, such as "Database
(database_name) dropped".
I hope that you have a valid level 0 backup...
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:04
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17094]
Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
I
only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
six
other databases, how can I bring back the missing databases.
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 9:54 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17093]
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mode=5
If not, you must look the Informix message file. Execute onstat -m to
view your online log.
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 13:50
Para: ids@iiug.org
Assunto: shared memory not initialized for INFORMIXSERVER [17092]
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
I don't think that anyone would run the oninit -i. How do I find out that
one did that?
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:12 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17095]
Did you perform by accicdent oninit -i??? If you did that, you
initialized a new instance (without database application). To restore
you application database, you must perform a restore from your last
level 0 backup.
Otherwise, somebody who has sufficient privileges dropped your database
application... and to recover, you also must perform a restore from your
last level 0 backup.
You can look your online.log and find for a message, such as "Database
(database_name) dropped".
I hope that you have a valid level 0 backup...
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:04
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17094]
Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
I
only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
six
other databases, how can I bring back the missing databases.
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 9:54 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17093]
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mode=5
If not, you must look the Informix message file. Execute onstat -m to
view your online log.
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 13:50
Para: ids@iiug.org
Assunto: shared memory not initialized for INFORMIXSERVER [17092]
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
You must look for some evidence, such as "building sysmaster
database"... If you found that phrase, brow... you're in a bad
situation and prove that somebody created a new instance overwriting
your old instance.
To fix that, only restoring your databases performing a level 0
backup, as I mentioned before.
Look you online.log as I mentioned, and let me know...
Regards,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:27
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17097]
I don't think that anyone would run the oninit -i. How do I find out
that
one did that?
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:12 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17095]
Did you perform by accicdent oninit -i??? If you did that, you
initialized a new instance (without database application). To restore
you application database, you must perform a restore from your last
level 0 backup.
Otherwise, somebody who has sufficient privileges dropped your database
application... and to recover, you also must perform a restore from your
last level 0 backup.
You can look your online.log and find for a message, such as "Database
(database_name) dropped".
I hope that you have a valid level 0 backup...
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:04
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17094]
Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
I
only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
six
other databases, how can I bring back the missing databases.
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 9:54 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17093]
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mode=5
If not, you must look the Informix message file. Execute onstat -m to
view your online log.
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 13:50
Para: ids@iiug.org
Assunto: shared memory not initialized for INFORMIXSERVER [17092]
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
** Look in the online.log for catalog built messages and their date.
This will tell you if you need to restore from back, due to the instance
being re-initialized by someone having the Informix password. Security
is needed.
17:08:57 Maximum server connections 1
17:08:57 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
blocked 0, Plog used 72, Llog used 1123
17:08:58 'sysmaster' database built successfully.
17:08:58 'sysutils' database built successfully.
17:08:58 'sysuser' database built successfully.
17:09:04 Building 'sysadmin' database ...
17:09:07 Loading Module <SPLNULL>
17:09:10 'sysadmin' database built successfully.
17:09:10 SCHAPI: Started dbScheduler thread.
17:09:10 SCHAPI: Started 2 dbWorker threads.
** Otherwise someone deleted the databases and you will have to restore
from level 0 backup.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
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
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 12:50 PM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17098]
You must look for some evidence, such as "building sysmaster
database"... If you found that phrase, brow... you're in a bad
situation and prove that somebody created a new instance overwriting
your old instance.
To fix that, only restoring your databases performing a level 0
backup, as I mentioned before.
Look you online.log as I mentioned, and let me know...
Regards,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:27
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17097]
I don't think that anyone would run the oninit -i. How do I find out
that
one did that?
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:12 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17095]
Did you perform by accicdent oninit -i??? If you did that, you
initialized a new instance (without database application). To restore
you application database, you must perform a restore from your last
level 0 backup.
Otherwise, somebody who has sufficient privileges dropped your database
application... and to recover, you also must perform a restore from your
last level 0 backup.
You can look your online.log and find for a message, such as "Database
(database_name) dropped".
I hope that you have a valid level 0 backup...
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:04
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17094]
Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
I
only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
six
other databases, how can I bring back the missing databases.
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 9:54 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17093]
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mode=5
If not, you must look the Informix message file. Execute onstat -m to
view your online log.
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 13:50
Para: ids@iiug.org
Assunto: shared memory not initialized for INFORMIXSERVER [17092]
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
I found one logical log backup using "ontape -a" in production server.
"Starting ontape -a Sat Sep 5 03:00:00 PDT 2009
Performing automatic backup of logical logs.
Please mount tape 1 on /backups/informix_lg and press Return to continue ...
Do you want to back up the current logical log? (y/n) Please label this tape
as number 1 in the log tape sequence.
This tape contains the following logical logs:
588 - 596
Program over.
Ontape -a complete Sat Sep 5 03:00:28 PDT 2009 Done..."
Is this my level 0 backup?
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:50 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17098]
You must look for some evidence, such as "building sysmaster
database"... If you found that phrase, brow... you're in a bad
situation and prove that somebody created a new instance overwriting
your old instance.
To fix that, only restoring your databases performing a level 0
backup, as I mentioned before.
Look you online.log as I mentioned, and let me know...
Regards,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:27
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17097]
I don't think that anyone would run the oninit -i. How do I find out
that
one did that?
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:12 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17095]
Did you perform by accicdent oninit -i??? If you did that, you
initialized a new instance (without database application). To restore
you application database, you must perform a restore from your last
level 0 backup.
Otherwise, somebody who has sufficient privileges dropped your database
application... and to recover, you also must perform a restore from your
last level 0 backup.
You can look your online.log and find for a message, such as "Database
(database_name) dropped".
I hope that you have a valid level 0 backup...
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:04
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17094]
Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
I
only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
six
other databases, how can I bring back the missing databases.
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 9:54 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17093]
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mode=5
If not, you must look the Informix message file. Execute onstat -m to
view your online log.
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 13:50
Para: ids@iiug.org
Assunto: shared memory not initialized for INFORMIXSERVER [17092]
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
No, you need ontape -s -L 0 something similar to this.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
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
Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 1:36 PM
To: ids@iiug.org
Subject: RE: shared memory not initialized for INFORMI.... [17100]
I found one logical log backup using "ontape -a" in production server.
"Starting ontape -a Sat Sep 5 03:00:00 PDT 2009
Performing automatic backup of logical logs.
Please mount tape 1 on /backups/informix_lg and press Return to continue
...
Do you want to back up the current logical log? (y/n) Please label this
tape
as number 1 in the log tape sequence.
This tape contains the following logical logs:
588 - 596
Program over.
Ontape -a complete Sat Sep 5 03:00:28 PDT 2009 Done..."
Is this my level 0 backup?
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:50 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17098]
You must look for some evidence, such as "building sysmaster
database"... If you found that phrase, brow... you're in a bad
situation and prove that somebody created a new instance overwriting
your old instance.
To fix that, only restoring your databases performing a level 0
backup, as I mentioned before.
Look you online.log as I mentioned, and let me know...
Regards,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:27
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17097]
I don't think that anyone would run the oninit -i. How do I find out
that
one did that?
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:12 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17095]
Did you perform by accicdent oninit -i??? If you did that, you
initialized a new instance (without database application). To restore
you application database, you must perform a restore from your last
level 0 backup.
Otherwise, somebody who has sufficient privileges dropped your database
application... and to recover, you also must perform a restore from your
last level 0 backup.
You can look your online.log and find for a message, such as "Database
(database_name) dropped".
I hope that you have a valid level 0 backup...
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:04
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17094]
Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
I
only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
six
other databases, how can I bring back the missing databases.
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 9:54 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17093]
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mode=5
If not, you must look the Informix message file. Execute onstat -m to
view your online log.
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 13:50
Para: ids@iiug.org
Assunto: shared memory not initialized for INFORMIXSERVER [17092]
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Wally, are you the DBA that setup this instance? If not, you should be
working with that person to determine what is going on with the
instance.
If you are, then we need to know what you have done to this point
towards building, running, and securing the instance for usage and
recovery.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
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: Knox, Ernest
Sent: Friday, September 18, 2009 1:39 PM
To: 'ids@iiug.org'
Subject: RE: shared memory not initialized for INFORMI.... [17100]
No, you need ontape -s -L 0 something similar to this.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
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
Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 1:36 PM
To: ids@iiug.org
Subject: RE: shared memory not initialized for INFORMI.... [17100]
I found one logical log backup using "ontape -a" in production server.
"Starting ontape -a Sat Sep 5 03:00:00 PDT 2009
Performing automatic backup of logical logs.
Please mount tape 1 on /backups/informix_lg and press Return to continue
...
Do you want to back up the current logical log? (y/n) Please label this
tape
as number 1 in the log tape sequence.
This tape contains the following logical logs:
588 - 596
Program over.
Ontape -a complete Sat Sep 5 03:00:28 PDT 2009 Done..."
Is this my level 0 backup?
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:50 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17098]
You must look for some evidence, such as "building sysmaster
database"... If you found that phrase, brow... you're in a bad
situation and prove that somebody created a new instance overwriting
your old instance.
To fix that, only restoring your databases performing a level 0
backup, as I mentioned before.
Look you online.log as I mentioned, and let me know...
Regards,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:27
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17097]
I don't think that anyone would run the oninit -i. How do I find out
that
one did that?
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:12 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17095]
Did you perform by accicdent oninit -i??? If you did that, you
initialized a new instance (without database application). To restore
you application database, you must perform a restore from your last
level 0 backup.
Otherwise, somebody who has sufficient privileges dropped your database
application... and to recover, you also must perform a restore from your
last level 0 backup.
You can look your online.log and find for a message, such as "Database
(database_name) dropped".
I hope that you have a valid level 0 backup...
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:04
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17094]
Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
I
only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
six
other databases, how can I bring back the missing databases.
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 9:54 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17093]
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mode=5
If not, you must look the Informix message file. Execute onstat -m to
view your online log.
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 13:50
Para: ids@iiug.org
Assunto: shared memory not initialized for INFORMIXSERVER [17092]
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****@@N
If I performed ontape -s -L 0?? On my production server and restore to
development server. Will it work?
Wally Tang
DOD-Defense Media Center - IT
Lockheed Martin - IT
23755 Z Street
Riverside, CA 92518-2017
951-413-2246
E-mail: wally.tang.ctr@dma.mil
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Knox,
Ernest
Sent: Friday, September 18, 2009 11:39 AM
To: ids@iiug.org
Subject: RE: shared memory not initialized for INFORMI.... [17101]
No, you need ontape -s -L 0 something similar to this.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
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
Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 1:36 PM
To: ids@iiug.org
Subject: RE: shared memory not initialized for INFORMI.... [17100]
I found one logical log backup using "ontape -a" in production server.
"Starting ontape -a Sat Sep 5 03:00:00 PDT 2009
Performing automatic backup of logical logs.
Please mount tape 1 on /backups/informix_lg and press Return to continue
....
Do you want to back up the current logical log? (y/n) Please label this
tape
as number 1 in the log tape sequence.
This tape contains the following logical logs:
588 - 596
Program over.
Ontape -a complete Sat Sep 5 03:00:28 PDT 2009 Done..."
Is this my level 0 backup?
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:50 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17098]
You must look for some evidence, such as "building sysmaster
database"... If you found that phrase, brow... you're in a bad
situation and prove that somebody created a new instance overwriting
your old instance.
To fix that, only restoring your databases performing a level 0
backup, as I mentioned before.
Look you online.log as I mentioned, and let me know...
Regards,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:27
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17097]
I don't think that anyone would run the oninit -i. How do I find out
that
one did that?
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:12 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17095]
Did you perform by accicdent oninit -i??? If you did that, you
initialized a new instance (without database application). To restore
you application database, you must perform a restore from your last
level 0 backup.
Otherwise, somebody who has sufficient privileges dropped your database
application... and to recover, you also must perform a restore from your
last level 0 backup.
You can look your online.log and find for a message, such as "Database
(database_name) dropped".
I hope that you have a valid level 0 backup...
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:04
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17094]
Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
I
only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
six
other databases, how can I bring back the missing databases.
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 9:54 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17093]
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mode=5
If not, you must look the Informix message file. Execute onstat -m to
view your online log.
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 13:50
Para: ids@iiug.org
Assunto: shared memory not initialized for INFORMIXSERVER [17092]
________________________________
From: Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 9:28 AM
To: 'ids@iiug.org'
Subject: shared memory not initialized for INFORMIXSERVER
Hi,
On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
executed
dbaccess dbname, we got error message "25588: The appl process connot
connect to Dynamic server". When I onstat -d, I got "shared memory no
initialized for INFORMIXSERVER 'onlinedev'".
What should I do?
Thanks in advance.
Wally Tang
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****@
Archive Information
Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc.
Initialization Time 04/10/2003 10:10:35
System Page Size 2048
Version 6
Archive CheckPoint Time 09/18/2009 03:00:03
Dbspaces
number flags fchunk nchunks flags owner name
1 1 1 1 N informix rootdbs
2 1 2 2 N informix tasa
3 2001 3 1 N T informix tasatemp
4 1 4 1 N informix tasalog
5 11 5 1 N B informix tasablob
Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 26000 2913 PO- /dev/ifx/rootdbs
2 2 0 1000000 57 PO- /dev/ifx/tasa
3 3 0 1000000 999897 PO- /dev/ifx/tasatemp
4 4 0 1000000 999947 PO- /dev/ifx/tasalog
5 5 0 1000000 1000000 POB /dev/ifx/tasablob
6 2 0 1000000 854084 PO- /dev/ifx/tasa1
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n
oninit: Fatal error in shared memory creation
Wally Tang
DOD-Defense Media Center - IT
Lockheed Martin - IT
23755 Z Street
Riverside, CA 92518-2017
951-413-2246
E-mail: wally.tang.ctr@dma.mil
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Knox,
Ernest
Sent: Friday, September 18, 2009 11:42 AM
To: ids@iiug.org
Subject: RE: shared memory not initialized for INFORMI.... [17102]
Wally, are you the DBA that setup this instance? If not, you should be
working with that person to determine what is going on with the
instance.
If you are, then we need to know what you have done to this point
towards building, running, and securing the instance for usage and
recovery.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
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: Knox, Ernest
Sent: Friday, September 18, 2009 1:39 PM
To: 'ids@iiug.org'
Subject: RE: shared memory not initialized for INFORMI.... [17100]
No, you need ontape -s -L 0 something similar to this.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
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
Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 1:36 PM
To: ids@iiug.org
Subject: RE: shared memory not initialized for INFORMI.... [17100]
I found one logical log backup using "ontape -a" in production server.
"Starting ontape -a Sat Sep 5 03:00:00 PDT 2009
Performing automatic backup of logical logs.
Please mount tape 1 on /backups/informix_lg and press Return to continue
....
Do you want to back up the current logical log? (y/n) Please label this
tape
as number 1 in the log tape sequence.
This tape contains the following logical logs:
588 - 596
Program over.
Ontape -a complete Sat Sep 5 03:00:28 PDT 2009 Done..."
Is this my level 0 backup?
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:50 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17098]
You must look for some evidence, such as "building sysmaster
database"... If you found that phrase, brow... you're in a bad
situation and prove that somebody created a new instance overwriting
your old instance.
To fix that, only restoring your databases performing a level 0
backup, as I mentioned before.
Look you online.log as I mentioned, and let me know...
Regards,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:27
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17097]
I don't think that anyone would run the oninit -i. How do I find out
that
one did that?
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 10:12 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17095]
Did you perform by accicdent oninit -i??? If you did that, you
initialized a new instance (without database application). To restore
you application database, you must perform a restore from your last
level 0 backup.
Otherwise, somebody who has sufficient privileges dropped your database
application... and to recover, you also must perform a restore from your
last level 0 backup.
You can look your online.log and find for a message, such as "Database
(database_name) dropped".
I hope that you have a valid level 0 backup...
Good Luck,
Alberto Pessonio
Orizon Brasil
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
Wally, CTR, DMA-Riv/IT
Enviada em: sexta-feira, 18 de setembro de 2009 14:04
Para: ids@iiug.org
Assunto: RE: shared memory not initialized for INFORMI.... [17094]
Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
I
only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
six
other databases, how can I bring back the missing databases.
Thanks.
Wally Tang
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alberto Romeu Pessonio Filho
Sent: Friday, September 18, 2009 9:54 AM
To: ids@iiug.org
Subject: RES: shared memory not initialized for INFORMI.... [17093]
To up your informix server database, execute oninit -v command using
Informix user.
If everything r working properly, the last line must be:
Verbose output complete mod
$ tail -100 online.log
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 PANIC: Attempting to bring system down
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
12:10:46 semctl: errno = 22
Fri Sep 18 09:58:00 2009
09:58:00 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh'
09:58:06 DR: DRAUTO is 0 (Off)
09:58:06 Requested shared memory segment size rounded from 588KB to 592KB
09:58:06 Informix Dynamic Server Version 7.31.UD5 Software Serial
Number A2
09:58:07 Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:58:07 Dynamically allocated new virtual shared memory segment (size
8192KB)
09:58:07 Physical Recovery Started.
09:58:07 Physical Recovery Complete: 0 Pages Restored.
09:58:07 Logical Recovery Started.
09:58:10 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
09:58:11 Dataskip is now OFF for all dbspaces
09:58:12 On-Line Mode
09:58:12 Affinitied VP 1 to phys proc 0
09:58:12 Checkpoint Completed: duration was 0 seconds.
09:58:12 Checkpoint loguniq 592, logpos 0x128018
10:03:13 Checkpoint Completed: duration was 0 seconds.
10:03:13 Checkpoint loguniq 592, logpos 0x129018
10:13:19 Checkpoint Completed: duration was 0 seconds.
10:13:19 Checkpoint loguniq 592, logpos 0x12a018
11:54:39 Informix Dynamic Server Stopped.
11:56:06 shmget: [EEXIST][17]: key 52574801: shared memory already exists
11:56:06 Could not create single shared memory segment with resident and
non-rr
titions. Proceeding to create 2 shared memory segments instead.
11:56:06 shmget: [EEXIST][17]: key 52574801: shared memory already exists
11:56:06 mt_shm_init: can't create resident segment
Wally Tang
DOD-Defense Media Center - IT
Lockheed Martin - IT
23755 Z Street
Riverside, CA 92518-2017
951-413-2246
E-mail: wally.tang.ctr@dma.mil
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Tang,
Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 11:57 AM
To: ids@iiug.org
Subject: RE: shared memory not initialized for INFORMI.... [17104]
Archive Information
Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc.
Initialization Time 04/10/2003 10:10:35
System Page Size 2048
Version 6
Archive CheckPoint Time 09/18/2009 03:00:03
Dbspaces
number flags fchunk nchunks flags owner name
1 1 1 1 N informix rootdbs
2 1 2 2 N informix tasa
3 2001 3 1 N T informix tasatemp
4 1 4 1 N informix tasalog
5 11 5 1 N B informix tasablob
Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 26000 2913 PO- /dev/ifx/rootdbs
2 2 0 1000000 57 PO- /dev/ifx/tasa
3 3 0 1000000 999897 PO- /dev/ifx/tasatemp
4 4 0 1000000 999947 PO- /dev/ifx/tasalog
5 5 0 1000000 1000000 POB /dev/ifx/tasablob
6 2 0 1000000 854084 PO- /dev/ifx/tasa1
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n
oninit: Fatal error in shared memory creation
Wally Tang
DOD-Defense Media Center - IT
Lockheed Martin - IT
23755 Z Street
Riverside, CA 92518-2017
951-413-2246
E-mail: wally.tang.ctr@dma.mil
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Knox,
Ernest
Sent: Friday, September 18, 2009 11:42 AM
To: ids@iiug.org
Subject: RE: shared memory not initialized for INFORMI.... [17102]
Wally, are you the DBA that setup this instance? If not, you should be
working with that person to determine what is going on with the
instance.
If you are, then we need to know what you have done to this point
towards building, running, and securing the instance for usage and
recovery.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
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: Knox, Ernest
Sent: Friday, September 18, 2009 1:39 PM
To: 'ids@iiug.org'
Subject: RE: shared memory not initialized for INFORMI.... [17100]
No, you need ontape -s -L 0 something similar to this.
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
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
Tang, Wally, CTR, DMA-Riv/IT
Sent: Friday, September 18, 2009 1:36 PM
To: ids@iiug.org
Subject: RE: shared memory not initialized for INFORMI.... [17100]
I found one logical log backup using "ontape -a" in production server.
"Starting ontape -a Sat Sep 5 03:00:00 PDT 2009
Performing automatic backup of logical logs.
Please mount tape 1 on /backups/informix_lg and press Return to continue
.....
Do you want to back up the current logical log? (y/n) Please label this
tape
as number 1 in the log tape sequence.
This tape contains the following logical logs:
588 - 596
Program over.
Ontape -a
You must shutdown first...
onmode -k
Tang, Wally, CTR, DMA-Riv/IT escreveu:
> Archive Information
>
> Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc.
> Initialization Time 04/10/2003 10:10:35
> System Page Size 2048
> Version 6
> Archive CheckPoint Time 09/18/2009 03:00:03
>
> Dbspaces
> number flags fchunk nchunks flags owner name
> 1 1 1 1 N informix rootdbs
> 2 1 2 2 N informix tasa
> 3 2001 3 1 N T informix tasatemp
> 4 1 4 1 N informix tasalog
> 5 11 5 1 N B informix tasablob
>
> Chunks
> chk/dbs offset size free bpages flags pathname
> 1 1 0 26000 2913 PO- /dev/ifx/rootdbs
> 2 2 0 1000000 57 PO- /dev/ifx/tasa
> 3 3 0 1000000 999897 PO- /dev/ifx/tasatemp
> 4 4 0 1000000 999947 PO- /dev/ifx/tasalog
> 5 5 0 1000000 1000000 POB /dev/ifx/tasablob
> 6 2 0 1000000 854084 PO- /dev/ifx/tasa1
>
> Continue restore? (y/n)y
> Do you want to back up the logs? (y/n)n
> oninit: Fatal error in shared memory creation
>
> Wally Tang
> DOD-Defense Media Center - IT
> Lockheed Martin - IT
> 23755 Z Street
> Riverside, CA 92518-2017
> 951-413-2246
> E-mail: wally.tang.ctr@dma.mil
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Knox,
> Ernest
> Sent: Friday, September 18, 2009 11:42 AM
> To: ids@iiug.org
> Subject: RE: shared memory not initialized for INFORMI.... [17102]
>
> Wally, are you the DBA that setup this instance? If not, you should be
> working with that person to determine what is going on with the
> instance.
>
> If you are, then we need to know what you have done to this point
> towards building, running, and securing the instance for usage and
> recovery.
>
> Thanks,
> *******************************************************************
> Ernie Knox
> IT Database Administrator Specialist
> Sears Holdings
> 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: Knox, Ernest
> Sent: Friday, September 18, 2009 1:39 PM
> To: 'ids@iiug.org'
> Subject: RE: shared memory not initialized for INFORMI.... [17100]
>
> No, you need ontape -s -L 0 something similar to this.
>
> Thanks,
> *******************************************************************
> Ernie Knox
> IT Database Administrator Specialist
> Sears Holdings
> 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
> Tang, Wally, CTR, DMA-Riv/IT
> Sent: Friday, September 18, 2009 1:36 PM
> To: ids@iiug.org
> Subject: RE: shared memory not initialized for INFORMI.... [17100]
>
> I found one logical log backup using "ontape -a" in production server.
>
> "Starting ontape -a Sat Sep 5 03:00:00 PDT 2009
>
> Performing automatic backup of logical logs.
>
> Please mount tape 1 on /backups/informix_lg and press Return to continue
> .....
>
> Do you want to back up the current logical log? (y/n) Please label this
> tape
> as number 1 in the log tape sequence.
>
> This tape contains the following logical logs:
>
> 588 - 596
>
> Program over.
> Ontape -a complete Sat Sep 5 03:00:28 PDT 2009 Done..."
>
> Is this my level 0 backup?
>
> Thanks.
>
> Wally Tang
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Alberto Romeu Pessonio Filho
> Sent: Friday, September 18, 2009 10:50 AM
> To: ids@iiug.org
> Subject: RES: shared memory not initialized for INFORMI.... [17098]
>
> You must look for some evidence, such as "building sysmaster
> database"... If you found that phrase, brow... you're in a bad
> situation and prove that somebody created a new instance overwriting
> your old instance.
>
> To fix that, only restoring your databases performing a level 0
> backup, as I mentioned before.
>
> Look you online.log as I mentioned, and let me know...
>
> Regards,
> Alberto Pessonio
> Orizon Brasil
> www.orizonbrasil.com.br
>
> -----Mensagem original-----
> De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
> Wally, CTR, DMA-Riv/IT
> Enviada em: sexta-feira, 18 de setembro de 2009 14:27
> Para: ids@iiug.org
> Assunto: RE: shared memory not initialized for INFORMI.... [17097]
>
> I don't think that anyone would run the oninit -i. How do I find out
> that
> one did that?
>
> Wally Tang
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Alberto Romeu Pessonio Filho
> Sent: Friday, September 18, 2009 10:12 AM
> To: ids@iiug.org
> Subject: RES: shared memory not initialized for INFORMI.... [17095]
>
> Did you perform by accicdent oninit -i??? If you did that, you
> initialized a new instance (without database application). To restore
> you application database, you must perform a restore from your last
> level 0 backup.
>
> Otherwise, somebody who has sufficient privileges dropped your database
> application... and to recover, you also must perform a restore from your
>
> last level 0 backup.
>
> You can look your online.log and find for a message, such as "Database
> (database_name) dropped".
>
> I hope that you have a valid level 0 backup...
>
> Good Luck,
> Alberto Pessonio
> Orizon Brasil
> www.orizonbrasil.com.br
>
> -----Mensagem original-----
> De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
> Wally, CTR, DMA-Riv/IT
> Enviada em: sexta-feira, 18 de setembro de 2009 14:04
> Para: ids@iiug.org
> Assunto: RE: shared memory not initialized for INFORMI.... [17094]
>
> Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
>
> I
> only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
> six
> other databases, how can I bring back the missing databases.
>
> Thanks.
>
> Wally Tang
>@@
On Fri, Sep 18, 2009 at 10:23, Tang, Wally, CTR, DMA-Riv/IT <
Wally.Tang.CTR@dma.mil> wrote:
> Thanks a lot, Alberto. I am going to look for it and will be back for more
> questions. I hope you don't mind.
>
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Alberto Romeu Pessonio Filho
> Sent: Friday, September 18, 2009 10:12 AM
> To: ids@iiug.org
> Subject: RES: shared memory not initialized for INFORMI.... [17095]
>
> Did you perform by accicdent oninit -i???
One of the emails in the thread did show 'oninit -iv' after the attempt to
change port number.
Dear Willy,
Don't use the '-i' option on working systems.
Do use your backup to restore as suggested.
If you don't have a backup, contact IBM Informix Tech Support before you do
any more damage.
> If you did that, you
> initialized a new instance (without database application). To restore
> you application database, you must perform a restore from your last
> level 0 backup.
>
> Otherwise, somebody who has sufficient privileges dropped your database
> application... and to recover, you also must perform a restore from your
> last level 0 backup.
>
> You can look your online.log and find for a message, such as "Database
> (database_name) dropped".
>
> I hope that you have a valid level 0 backup...
>
> Good Luck,
> Alberto Pessonio
> Orizon Brasil
> www.orizonbrasil.com.br
>
> -----Mensagem original-----
> De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
> Wally, CTR, DMA-Riv/IT
> Enviada em: sexta-feira, 18 de setembro de 2009 14:04
> Para: ids@iiug.org
> Assunto: RE: shared memory not initialized for INFORMI.... [17094]
>
> Thanks, Alberto. I got to the line "Verbose output complete mode=5", but
> I
> only have the sysmaster@onlinedev and sysutils@onlinedev. I should see
> six
> other databases, how can I bring back the missing databases.
>
> Thanks.
>
> Wally Tang
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Alberto Romeu Pessonio Filho
> Sent: Friday, September 18, 2009 9:54 AM
> To: ids@iiug.org
> Subject: RES: shared memory not initialized for INFORMI.... [17093]
>
> To up your informix server database, execute oninit -v command using
> Informix user.
>
> If everything r working properly, the last line must be:
>
> Verbose output complete mode=5
>
> If not, you must look the Informix message file. Execute onstat -m to
> view your online log.
>
> Good Luck,
> Alberto Pessonio
> Orizon Brasil
> www.orizonbrasil.com.br
>
> -----Mensagem original-----
> De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Tang,
> Wally, CTR, DMA-Riv/IT
> Enviada em: sexta-feira, 18 de setembro de 2009 13:50
> Para: ids@iiug.org
> Assunto: shared memory not initialized for INFORMIXSERVER [17092]
>
> ________________________________
>
> From: Tang, Wally, CTR, DMA-Riv/IT
> Sent: Friday, September 18, 2009 9:28 AM
> To: 'ids@iiug.org'
> Subject: shared memory not initialized for INFORMIXSERVER
>
> Hi,
>
> On our development server (IDS 7.31.UD6 on HPUX B.11.11), when we
> executed
> dbaccess dbname, we got error message "25588: The appl process connot
> connect to Dynamic server". When I onstat -d, I got "shared memory no
> initialized for INFORMIXSERVER 'onlinedev'".
>
> What should I do?
>
> Thanks in advance.
>
> Wally Tang
>
> ************************************************************************
>
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
> ****
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
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.
Stephen
Leacock<http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html>;
- "I detest life-insurance agents: they always argue that I shall some
day
die, which is not so."
--000feaefb8c45cf6c20473e073a7
onmode -kyto shutdown the instance that maybe exist
ipcs
to see wheather user informix is using shm
2009/9/19 Tang, Wally, CTR, DMA-Riv/IT <Wally.Tang.CTR@dma.mil>
> $ tail -100 online.log
> 12:10:46 semctl: errno = 22>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 PANIC: Attempting to bring system down
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> 12:10:46 semctl: errno = 22
>
> Fri Sep 18 09:58:00 2009
>
> 09:58:00 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh'
> 09:58:06 DR: DRAUTO is 0 (Off)
> 09:58:06 Requested shared memory segment size rounded from 588KB to 592KB
> 09:58:06 Informix Dynamic Server Version 7.31.UD5 Software Serial
> Number A2
> 09:58:07 Informix Dynamic Server Initialized -- Shared Memory Initialized.
> 09:58:07 Dynamically allocated new virtual shared memory segment (size
> 8192KB)
> 09:58:07 Physical Recovery Started.
> 09:58:07 Physical Recovery Complete: 0 Pages Restored.
> 09:58:07 Logical Recovery Started.
> 09:58:10 Logical Recovery Complete.
>
> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
>
> 09:58:11 Dataskip is now OFF for all dbspaces
> 09:58:12 On-Line Mode
> 09:58:12 Affinitied VP 1 to phys proc 0
> 09:58:12 Checkpoint Completed: duration was 0 seconds.
> 09:58:12 Checkpoint loguniq 592, logpos 0x128018
>
> 10:03:13 Checkpoint Completed: duration was 0 seconds.
> 10:03:13 Checkpoint loguniq 592, logpos 0x129018
>
> 10:13:19 Checkpoint Completed: duration was 0 seconds.
> 10:13:19 Checkpoint loguniq 592, logpos 0x12a018
>
> 11:54:39 Informix Dynamic Server Stopped.
> 11:56:06 shmget: [EEXIST][17]: key 52574801: shared memory already exists
> 11:56:06 Could not create single shared memory segment with resident and
> non-rr
>
> titions. Proceeding to create 2 shared memory segments instead.
> 11:56:06 shmget: [EEXIST][17]: key 52574801: shared memory already exists
> 11:56:06 mt_shm_init: can't create resident segment
>
> Wally Tang
> DOD-Defense Media Center - IT
> Lockheed Martin - IT
> 23755 Z Street
> Riverside, CA 92518-2017
> 951-413-2246
> E-mail: wally.tang.ctr@dma.mil
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Tang,
> Wally, CTR, DMA-Riv/IT
> Sent: Friday, September 18, 2009 11:57 AM
> To: ids@iiug.org
> Subject: RE: shared memory not initialized for INFORMI.... [17104]
>
> Archive Information
>
> Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc.
> Initialization Time 04/10/2003 10:10:35
> System Page Size 2048
> Version 6
> Archive CheckPoint Time 09/18/2009 03:00:03
>
> Dbspaces
> number flags fchunk nchunks flags owner name
> 1 1 1 1 N informix rootdbs
> 2 1 2 2 N informix tasa
> 3 2001 3 1 N T informix tasatemp
> 4 1 4 1 N informix tasalog
> 5 11 5 1 N B informix tasablob
>
> Chunks
> chk/dbs offset size free bpages flags pathname
> 1 1 0 26000 2913 PO- /dev/ifx/rootdbs
> 2 2 0 1000000 57 PO- /dev/ifx/tasa
> 3 3 0 1000000 999897 PO- /dev/ifx/tasatemp
> 4 4 0 1000000 999947 PO- /dev/ifx/tasalog
> 5 5 0 1000000 1000000 POB /dev/ifx/tasablob
> 6 2 0 1000000 854084 PO- /dev/ifx/tasa1
>
> Continue restore? (y/n)y
> Do you want to back up the logs? (y/n)n
> oninit: Fatal error in shared memory creation
>
> Wally Tang
> DOD-Defense Media Center - IT
> Lockheed Martin - IT
> 23755 Z Street
> Riverside, CA 92518-2017
> 951-413-2246
> E-mail: wally.tang.ctr@dma.mil
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Knox,
> Ernest
> Sent: Friday, September 18, 2009 11:42 AM
> To: ids@iiug.org
> Subject: RE: shared memory not initialized for INFORMI.... [17102]
>
> Wally, are you the DBA that setup this instance? If not, you should be
> working with that person to determine what is going on with the
> instance.
>
> If you are, then we need to know what you have done to this point
> towards building, running, and securing the instance for usage and
> recovery.
>
> Thanks,
> *******************************************************************
> Ernie Knox
> IT Database Administrator Specialist
> Sears Holdings
> 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: Knox, Ernest
> Sent: Friday, September 18, 2009 1:39 PM
> To: 'ids@iiug.org'
> Subject: RE: shared memory not initialized for INFORMI.... [17100]
>
> No, you need ontape -s -L 0 something similar to this.
>
> Thanks,
> *******************************************************************
> Ernie Knox
> IT Database Administrator Specialist
> Sears Holdings
> 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
> Tang, Wally, CTR, DMA-Riv/IT
> Sent: Friday, September 18, 2009 1:36 PM
> To: ids@iiug.org
> Subject: RE: sha
what is the OUTPUT of ipcs command?
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape