RE: ORA-00600 errors after upgrade to 11g

From: Andre van Winssen <dreveewee_at_gmail.com>
Date: Mon, 21 Mar 2011 07:13:00 +0100
Message-ID: <003401cbe78f$0852e120$18f8a360$_at_com>

Hi Maureen, if your ORA-00600 [pevm_INSTC2] happens in plsql code that passes REF cursor parameters up multiple levels of the PL/SQL stack then what you see might be a revival of bug 6068126.

Andre

-----Oorspronkelijk bericht-----
Van: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Namens Maureen English
Verzonden: zondag 20 maart 2011 18:50
Aan: Oracle-L_at_freelists.org
Onderwerp: ORA-00600 errors after upgrade to 11g

Hi,

Our 11g upgrade seemed to go pretty well, until we started getting an overwhelming number of trace files with ORA-00600 and ORA-07445 messages.

These trace files all seem to be related to our self service web application,
but we're unable to find any helpful information and so far, Oracle Support is
still at the information gathering stage.

Here's an example of the messages...any ideas/suggestions regarding what's going on would be most appreciated!

DDE: Problem Key 'ORA 600 [pevm_INSTC2]' was flood controlled (0x6) (incident: 229161)
ORA-00600: internal error code, arguments: [pevm_INSTC2], [], [], [], [], [], [], [], [], [], [], []
*********START PLSQL RUNTIME DUMP************
***Got internal error Exception caught in pl/sql run-time while running
PLSQL***
***Got ORA-600 while running PLSQL***

PACKAGE BODY BANINST1.BWSKALOG:
library unit=c00000021e2fc2f8 line=132 opcode=0 static link=9fffffffbeb4ac20 scope=1
FP=9fffffffbeb4da60 PC=c00000022aebd5a0 Page=0 AP=9fffffffbeb4ac20 ST=9fffffffbeb4da70
DL0=9fffffffbf362238 GF=9fffffffbf362ce8 DL1=9fffffffbf362780 DPF=9fffffffbf362cd0 DS=c00000022ae9f5e8

   DON library unit variable list instantiation

and

• 2011-03-17 17:49:49.563
• SESSION ID:(2308.62935) 2011-03-17 17:49:49.563
• CLIENT ID:() 2011-03-17 17:49:49.563
• SERVICE NAME:(mydb.alaska.edu <http://PROD.alaska.edu>) 2011-03-17 17:49:49.563
• MODULE NAME:(httpd_at_ssbserver.alaska.edu <mailto:httpd_at_veleska.alaska.edu> (TNS V1-V3)) 2011-03-17 17:49:49.563
• ACTION NAME:() 2011-03-17 17:49:49.563

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x6100000000000001] [PC:0x400000000623F9F1, opipls()+9521] [flags: 0x0 , count: 1]
Incident 229601 created, dump file:
/ORACLE/home/admin/diag/rdbms/mydb/MYDB/incident/incdir_229601/MYDB_ora_8996 _i229601.trc
ORA-07445: exception encountered: core dump [opipls()+9521] [SIGSEGV] [ADDR:0x6100000000000001] [PC:0x400000000623F9F1] [Address not mapped to object] []

• 2011-03-17 17:50:19.129 ssexhd: crashing the process... Shadow_Core_Dump = PARTIAL
  • Maureen

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 21 2011 - 01:13:00 CDT