RE: ORA-00600 errors after upgrade to 11g
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <dreveewee@xxxxxxxxx>, <maureen.english@xxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Mon, 21 Mar 2011 09:59:22 -0400
Solaris 5.10, 11.2.0.1:
For what it is worth, they had me set:
optimizer_features_enable=10.2.0.1
However, I also had a lot of bad magic number messages appear in alert log.
I have not applied the patch yet.
... partial SR response.
The code fix for bug 8730312 will be incorporated into the 11.2.0.2 patch set.
11.2.0.1 patch set release on Solaris needs a one-off patch to be applied after
that patch set is installed or needs a one-off patch on top of a 11.2.0.1 PSU
for PSU #1 and PSU #2.
0/27 Note.1113594.1 Ext/R.R A "Bad Magic" Message In The Alert Log File
After Upgrade To 11gr2:
0/19 Note.1066538.1 Ext/R.R "KEWASTUNPACKSTATS() BAD MAGIC 1" APPEARING
IN DATABASE ALERT LOG:
0/6 Note.1058202.1 Ext/R.R KEWASTUNPACKSTATS() BAD MAGIC MESSAGE IN
ALERT.LOG:
3 Bug.8967729/8730312 (96) KEWASTUNPACKSTATS() BAD MAGIC MESSAGE IN
ALERT.LOG:
3 Bug.9905071 (11) KEWASTUNPACKSTATS() BAD MAGIC 1 EVEN AFTER
PATCH 8730312:
3 Bug.9893582 (10) CONCURRENT DROP/RE-CREATE MVIEW SESSIONS HANG:
3 Bug.9786897/8783690 (36) CAPTURE ABORTS WITH AN ORA-600 [KRVUATLA20]:
3 Bug.9782951 (10) SESSION HANG ON PRIMARY INSTANCE:
3 Bug.8730312/8715387 (80) FWD MERGE FOR BASE BUG 8715387 FOR 12G:
3 Bug.9726524 (33) ORA-07445 [RWOROFPRVERYFASTUNPACKROW()+219]
OCCURED:
3 Bug.8715387 (80) ORA-07445 - KEWASTUNPACKSTATS()+129 ERROR IN
BUGAP:
3 Bug.9556021 (33) ORA-00600 [KESWXREADGLOBALINFOFROMSTREAM
MAGIC]:
3 Bug.9487773/8897784 (36) DATABASE CRASH WITH ORA-600 [KTCCCDEL-5]
...
- The "kewastUnPackStats(): bad magic 1 ..." messages are expected to be raised
when an improper encoding of ASH data is detected.
-- However, the detection method used by the 11.2.0.1 release is flawed and can
give false positive results.
-- Bug 8730312 is the code fix for that flawed detection mechanism.
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Andre van Winssen
Sent: Monday, March 21, 2011 2:13 AM
To: maureen.english@xxxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
Subject: RE: ORA-00600 errors after upgrade to 11g
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Namens Maureen English
Verzonden: zondag 20 maart 2011 18:50
Aan: Oracle-L@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxx
<mailto:httpd@xxxxxxxxxxxxxxxxxx> (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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
