Re: oracle crashes - ORA-07445 ORA-00601

You may be running into a bug (#2200934) which is fixed in 9.2.0.2. Sounds like an upgrade is definitely in order. And that's the first thing Oracle Support will tell you to do anyway.

HTH,
Brain

Nat wrote:
>
> 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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"