Interesting problem with oracle on linux
Date: 18 Mar 2004 03:06:27 -0800
Message-ID: <2cf7715d.0403180306.425e15b6_at_posting.google.com>
Hi ,
I have oracle : Oracle9i Enterprise Edition Release 9.2.0.1.0 -
Production
and linux RH9 with kernel version 2.4.20-8 .
Usualy everything is o.k. but sometimes ( one per week ) system pass to state decripted below :
- I can't log into oracle . When I try to do it .. I'em waiting long time and nothing happen.
- OS. Linux seems to be fine . But on TOP command Oracle processess is inactive.
- In alert file i have found decriptions :
Thu Jan 29 17:24:31 2004
Errors in file /u01/app/oracle/admin/SMSC/bdump/smsc_j022_28788.trc:
ORA-00600: kod błędu wewnętrznego, argumenty: [510],
[0x50042930], [shared pool], [], [], [], [], []
Thu Jan 29 17:24:33 2004
Errors in file /u01/app/oracle/admin/SMSC/bdump/smsc_j022_28788.trc:
ORA-07445: napotkano wyj?tek: zrzut pamięci [kdbmal()+27]
[SIGSEGV] [Address not mapped to object] [0x38] [] []
ORA-00600: kod błędu wewnętrznego, argumenty: [510],
[0x50042930], [shared pool], [], [], [], [], []
Thu Jan 29 17:24:33 2004
Errors in file /u01/app/oracle/admin/SMSC/bdump/smsc_j022_28788.trc:
ORA-07445: napotkano wyj?tek: zrzut pamięci [kdbmal()+27]
[SIGSEGV] [Address not mapped to object] [0x38] [] []
ORA-07445: napotkano wyj?tek: zrzut pamięci [kdbmal()+27]
[SIGSEGV] [Address not mapped to object] [0x38] [] []
ORA-00600: kod błędu wewnętrznego, argumenty: [510],
[0x50042930], [shared pool], [], [], [], [], []
Thu Jan 29 17:24:34 2004
Errors in file /u01/app/oracle/admin/SMSC/bdump/smsc_j022_28788.trc:
ORA-07445: napotkano wyj?tek: zrzut pamięci [kdbmal()+27]
[SIGSEGV] [Address not mapped to object] [0x38] [] []
ORA-07445: napotkano wyj?tek: zrzut pamięci [kdbmal()+27]
[SIGSEGV] [Address not mapped to object] [0x38] [] []
ORA-07445: napotkano wyj?tek: zrzut pamięci [kdbmal()+27]
[SIGSEGV] [Address not mapped to object] [0x38] [] []
ORA-00600: kod błędu wewnętrznego, argumenty: [510],
[0x50042930], [shared pool], [], [], [], [], []
or another description is :
PMON failed to acquire latch, see PMON dump
in PMON dump is :
PMON unable to acquire latch 584c1d40 library cache
possible holder pid = 98 ospid=1748
*** 2004-03-15 12:54:51.989
PMON unable to acquire latch 584c1d40 library cache
possible holder pid = 98 ospid=1748
*** 2004-03-15 12:54:52.290
I assume that it is lock on memory .. but I not sure .
Any
suggestion will be welcome.
With thanks,
Artur from Poland
Received on Thu Mar 18 2004 - 12:06:27 CET