We have Oracle 8.0.5 running on a Sun 4500 with solaris 2.6 OS.
My production database has gone down twice because of the following
error detalied at the bottom
Our Oracle version is dessuported (nothing I can do about it) so I
would appreciate any clue of how to deal with this problem.
I read in one posting that this error has something to do with one
session lossing communication or something like that. From the
documentation below I couldn't even figure what session or user or
procedure caused the crash
alert_sid.log
Tue Sep 23 20:01:27 2003
Errors in file /oracle/app/oracle/product/8.0.5/rdbms/log/produ_pmon_2184.trc:
ORA-07445: exception encountered: core dump [kssxdl()+256] [SIGSEGV]
[Address not mapped to object] [0] [] []
ORA-00601: cleanup lock conflict
ORA-00601: cleanup lock conflict
Tue Sep 23 20:01:40 2003
Thread 1 advanced to log sequence 37248
Current log# 2 seq# 37248 mem# 0: /PROD/diam/redo/redoP02.log
Tue Sep 23 20:02:01 2003
Thread 1 advanced to log sequence 37249
Current log# 3 seq# 37249 mem# 0: /PROD/diam/redo/redoP03.log
Tue Sep 23 20:02:27 2003
LGWR: terminating instance due to error 472
Tue Sep 23 20:02:28 2003
Recovery of Online Redo Log: Thread 1 Group 3 Seq 37249 Reading mem 0
Mem# 0 errs 0: /PROD/diam/redo/redoP03.log
Tue Sep 23 20:02:28 2003
Instance terminated by LGWR, pid = 2190
produ_pmon_2184.trc
Dump file /oracle/app/oracle/product/8.0.5/rdbms/log/produ_pmon_2184.trc
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production
ORACLE_HOME = /oracle/app/oracle/product/8.0.5
System name: SunOS
Node name: nautilus
Release: 5.6
Version: Generic_105181-21
Machine: sun4u
Instance name: produ
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 2184, image: ora_pmon_produ
- 2003.09.23.20.01.26.000
- SESSION ID:(1.1) 2003.09.23.20.01.26.000
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to
object), addr: 0x0, PC: kssxdl()+256
- 2003.09.23.20.01.27.000
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kssxdl()+256] [SIGSEGV]
[Address not mapped to object] [0] [] []
ORA-00601: cleanup lock conflict
ORA-00601: cleanup lock conflict
----- Call Stack Trace -----
calling call entry argument values in
hex
location type point (? means dubious
value)
-------------------- -------- --------------------
ksedmp()+148 CALL ksedst()+0 498 ? 1 ? EFFFD42C
?
EFFFCED0 ? EFFFCEB4
? 0 ?
ssexhd()+368 CALL ksedmp()+0 3 ? 0 ? 1 ?
EFFFD944 ? 1 ?
7 ?
sigacthandler()+40 PTR_CALL 00000000 B ? 1026000 ?
EFFFDCD8 ?
1026000 ? 0 ? 0 ?
kssxdl()+88 CALL 01021440 B ? EFFFDF90 ?
EFFFDCD8 ?
99886A1C ? 98276AE8
?
98402868 ?
kssdys()+148 CALL kssxdl()+0 E0E168 ? E0D588 ?
BE0 ?
98402DC8 ? EFFFE0A8
?
102239C ?
ksepop()+444 CALL kssdys()+0 98402878 ? 2 ?
99886A24 ?
98402DD0 ? 98402DC8
?
99886A1C ?
kgepop()+72 PTR_CALL 00000000 6 ? 10235BC ?
102239C ? 0 ?
EFFFE960 ? 102239C
?
rpiswu2()+1168 CALL kgerse()+0 1022334 ? EFFFE770
? D96830 ?
1019CD8 ? 0 ?
982E6D1D ?
rpidrv()+2244 CALL rpiswu2()+0 102239C ? 259 ?
1022000 ? 2 ?
EFFFE4EC ? 0 ?
rpiexe()+32 CALL rpidrv()+0 1054594 ? 0 ? 4000
?
1022000 ? EFFFE544
?
102239C ?
audupl()+696 CALL rpiexe()+0 1 ? 7 ? EFFFE6BC ?
4 ? 44 ?
0 ?
ksuxds()+1892 CALL audupl()+0 982A4A60 ? 1 ? 0 ?
28C8B ?
0 ? 8 ?
kssxdl()+236 PTR_CALL 00000000 1022000 ? 982A4A60
?
EFFFE770 ? 102239C
? 3 ? 1A ?
ksuxdl()+228 CALL kssxdl()+0 E0D5C4 ? E0D588 ?
3C ?
982A4A60 ? EFFFE960
?
102239C ?
ksukip()+368 CALL ksuxdl()+0 102239C ? 0 ?
EFFFEA48 ?
FFFFFFF8 ? 0 ?
104B88A ?
ksucln()+1524 CALL ksukip()+0 982A4A60 ? 10232F8
?
8000105C ? 0 ?
7FFFFFFF ?
80000D48 ?
ksbrdp()+640 PTR_CALL 00000000 10258CC ? 102379C ?
10235B4 ?
1023400 ? 80001800
? 1000 ?
opirip()+560 CALL ksbrdp()+0 80001AA4 ? 981F5C6C
?
D95A6C ? EFFFED20 ?
102239C ?
98276AE8 ?
opidrv()+1180 CALL opirip()+0 80009400 ? 10259E4
?
1022000 ? 1023800 ?
1022000 ?
EFFFF788 ?
sou2o()+20 CALL opidrv()+0 32 ? EFFFF848 ?
102239C ?
6C6F6700 ? 0 ? 2F ?
main()+140 CALL sou2o()+0 EFFFFAC0 ? 32 ? 0 ?
0 ?
102BCCC ? 102BCCC ?
_start()+220 CALL main()+0 1 ? 0 ? 1034FD8 ?
1022000 ?
0 ? 0 ?
----- Argument/Register Address Dump -----
Argument/Register addr=efffd42c. Dump of memory from EFFFD3EC to
EFFFD52C
EFFFD3E0 726E616C 206F7220 66617461
6C206572 726F720A
EFFFD400 00FFD868 000C9BAC 5F5F7369 6E00636F 73007369 6E00636F
7300005F 5F61636F
EFFFD420 7368005F 00000063 00000000 EFFFCC38 00000006 00000006
EFFFD848 00000006
EFFFD440 00000006 EFFFD8C8 00000006 00000006 EFFFDC18 00000006
00000006 EFFFDC78
EFFFD460 00000006 00000006 EFFFE0E8 00000006 00000006 EFFFE148
00000006 00000006
EFFFD480 EFFFE1C8 00000006 00000006 EFFFE228 00000006 00000006
EFFFE458 00000006
EFFFD4A0 00000006 EFFFE5C0 00000006 00000006 EFFFE630 00000006
00000006 EFFFE6C8
EFFFD4C0 00000006 00000006 EFFFE8C8 00000006 00000006 EFFFE9A0
00000006 00000006
EFFFD4E0 EFFFEA88 00000006 00000006 EFFFEBC0 00000006 00000006
EFFFEC28 00000006
EFFFD500 00000006 EFFFED68 00000006 00000006 EFFFF7C8 00000006
00000006 EFFFF9E0
EFFFD520 00000006 00000006 EFFFFA40
Argument/Register addr=efffced0. Dump of memory from EFFFCE90 to
EFFFCFD0
EFFFCE80 00F8159C 00F81594
00F81594 00F81594
EFFFCEA0 00F81594 00F81594 EFFFCED0 001B2ED0 003131E4 000B2580
6B736564 6D702829
EFFFCEC0 2B313438 00000000 00000000 00000001 000B2B78 6B736564
73742829 2B300000
EFFFCEE0 0000FF00 00000000 00000001 0034539C 73736578 68642829
2B333638 00000001
EFFFCF00 8000B2B4 00000001 000B24EC 6B736564 6D702829 2B30000F
00000000 00000000
EFFFCF20 00000001 EF638A0C 73696761 63746861 6E646C65 7228292B
34300034 00000001
EFFFCF40 00000000 30303030 30303030 00793A20 44415441 42415345
00000000 000E18C8
EFFFCF60 6B737378 646C2829 2B383800 44445245 53533D28 00000001
01021440 30313032
EFFFCF80 31343430 00FFD110 00000000 00000000 00000000 000E12A8
6B737364 79732829
EFFFCFA0 2B313438 00000000 00000000 00000001 000E1870 6B737378
646C2829 2B3000A4
EFFFCFC0 00000000 00000000 00000001 000B10CC
Argument/Register addr=efffceb4. Dump of memory from EFFFCE74 to
EFFFCFB4
................
................
00 ******** ******** ******** ******** ******** ******** ********
Repeat 1 times
knceug * kncem_p [10517F8, 10517FC) = 00000000
Dump of memory from 0 to 40
00 ******** ******** ******** ******** ******** ******** ********
Repeat 1 times
hogxdef* hogcu_p [10517FC, 1051800) = 00000000
Dump of memory from 0 to 40
00 ******** ******** ******** ******** ******** ******** ********
Repeat 1 times
ub4 ksmugmg2 [1051800, 1051804) = 0000CDCD
ssexhd: crashing the process...
Background_Core_Dump = full
Received on Wed Sep 24 2003 - 09:15:31 CDT