 |
IDS Forum
Re: shared memory not initialized for INFORMI....
Posted By: ÖÜÐÛ
Date: Monday, 21 September 2009, at 3:11 a.m.
In Response To: RE: shared memory not initialized for INFORMI.... (Tang, Wally, CTR, DMA-Riv/IT)
onmode -ky
to 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: 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.
>
>
> ****************************************************************************
>
> ***
> 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.
>
>
--0016e64c2530da86d90474112f72
Messages In This Thread
- shared memory not initialized for INFORMIXSERVER
Tang, Wally, CTR, DMA-Riv/IT -- Friday, 18 September 2009, at 12:49 p.m.
- RES: shared memory not initialized for INFORMIXSER
Alberto Romeu Pessonio Filho -- Friday, 18 September 2009, at 12:53 p.m.
- RE: shared memory not initialized for INFORMI....
Tang, Wally, CTR, DMA-Riv/IT -- Friday, 18 September 2009, at 1:03 p.m.
- RES: shared memory not initialized for INFORMI....
Alberto Romeu Pessonio Filho -- Friday, 18 September 2009, at 1:11 p.m.
- RE: shared memory not initialized for INFORMI....
Tang, Wally, CTR, DMA-Riv/IT -- Friday, 18 September 2009, at 1:23 p.m.
- RE: shared memory not initialized for INFORMI....
Tang, Wally, CTR, DMA-Riv/IT -- Friday, 18 September 2009, at 1:27 p.m.
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
