Thread: Oracle crashed!
08-26-04, 16:19 #1Registered User
- Join Date
- Aug 2004
Unanswered: Oracle crashed!
This morning our Oracle server crashed. We were able to just start it up again, but nonetheless it's pretty odd. This is an Oracle 10g install on a Red Hat ES 3.0 system -- 2GB's memory and plenty of diskspace. Here's the error from the alert log:
Thu Aug 26 12:36:31 2004
DBW0: terminating instance due to error 472
Instance terminated by DBW0, pid = 19328
Browsing through the rest of the log, I see a lot of errors like this:
found dead shared server 'S002', pid = (16, 209)
found dead shared server 'S004', pid = (22, 120)
found dead shared server 'S005', pid = (26, 221)
found dead shared server 'S006', pid = (27, 101)
found dead shared server 'S009', pid = (30, 248)
found dead dispatcher 'D000', pid = (17, 236)
found dead dispatcher 'D001', pid = (43, 30)
Here's the top portion of one of the trace files:
ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
System name: Linux
Node name: oracle10g
Version: #1 SMP Sat Jul 31 01:25:25 EDT 2004
Instance name: dpndb
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 8891, image: oracle@oracle10g (S002)
*** SERVICE NAMEdpndb) 2004-08-26 12:36:22.336
*** SESSION ID536.46481) 2004-08-26 12:36:22.336
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x10104, PC: [0xa479a45, kghpih()+99]
%eax: 0x00010100 %ebx: 0x0bf24418 %ecx: 0x00000001
%edx: 0x00010100 %edi: 0x8ca5db28 %esi: 0x00000000
%esp: 0xbfff3184 %ebp: 0xbfff3190 %eip: 0x0a479a45
kghpih()+90 (0xa479a3c) test %eax,%eax
kghpih()+92 (0xa479a3e) je 0xa479a4c
kghpih()+94 (0xa479a40) mov 0x4(%edx),%eax
kghpih()+97 (0xa479a43) mov %eax,%edx
> kghpih()+99 (0xa479a45) mov 0x4(%eax),%eax
kghpih()+102 (0xa479a48) test %eax,%eax
kghpih()+104 (0xa479a4a) jne 0xa479a43
kghpih()+106 (0xa479a4c) mov 0xffffffe4(%edx),%eax
kghpih()+109 (0xa479a4f) lea 0xffffffe4(%edx),%ebx
*** 2004-08-26 12:36:22.351
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kghpih()+99] [SIGSEGV] [Address not mapped to object] [0x10104]  
Current SQL statement for this session:
SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
I'm not sure how to track down what's causing the problem... should we consider turning off shared servers / dispatchers?
One thing I've noticed is that our TEMP tablespace grows very quickly and when we gave it more space (up to 10GB) it immediately filled it all the way up. Maybe this is a problem?
Anyways, hoping someone can get me started diagnosing this.
08-26-04, 16:31 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
Submit an iTAR. Only Oracle support can assist you.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.