ORA-00600: internal error code, arguments: [kope2upic2954], ORA-07445 core dump

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    


ORA-00600: internal error code, arguments: [kope2upic2954], ORA-07445 core dump

1) ORA-00600 [1433], [60] followed by instance crash

2) ORA-00600 [kope2upic2954] (most probably related to Note 846297.1) 

Symptoms:

ORA-00600 internal error code, arguments: [1433], [60]

ORA-07445 exception encountered core dump [kslgetl()+352]

once we enable the AQ Schedule

Log files:

Alert Log
-------------

Wed Sep 2 11:52:51 2009
Errors in file /bdump/sid_arc3_20547.trc:
ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []
. . . 
Wed Sep 2 11:52:55 2009
Errors in file /bdump/sid_dbw0_20515.trc:
ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []
Wed Sep 2 11:52:55 2009
DBW0: terminating instance due to error 471
Wed Sep 2 11:52:55 2009
Errors in file /bdump/sid_j001_20555.trc:
ORA-00600: internal error code, arguments: [504], [0xC000000010610440], [256], [5], [session allocation], [0], [0], [0x000000000]
. . . 
Wed Sep 2 12:51:20 2009
Errors in file /bdump/sid_j004_23047.trc:
ORA-00600: internal error code, arguments: [kope2upic2954], [104], [105], [0], [], [], [], []
. . . 
Wed Sep 2 14:03:44 2009
Errors in file /bdump/sid_j005_26049.trc:
ORA-07445: exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalid permissions for mapped object] [0x000000000] [] []
ORA-00600: internal error code, arguments: [kope2upic2954], [209], [121], [68], [], [], [], []
ORA-00600: internal error code, arguments: [kope2upic2954], [104], [105], [0], [], [], [], []

Trace File
--------------

/bdump/sid_j004_21772.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u07/app/oracle/product/10.2.0.4
System name: HP-UX
. . .
*** ACTION NAME:(PROCESS_VOYAGE_SCH) 2009-07-23 07:58:00.745
*** MODULE NAME:(DBMS_SCHEDULER) 2009-07-23 07:58:00.745
*** SERVICE NAME:(SYS$USERS) 2009-07-23 07:58:00.745
*** CLIENT ID:() 2009-07-23 07:58:00.745
*** SESSION ID:(130.9495) 2009-07-23 07:58:00.745
*** 2009-07-23 07:58:00.745
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kope2upic2954], [104], [105], [0], [], [], [], []
Current SQL statement for this session:
select tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration, tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "MARINE_AQ"."CTMS_VOY_I_QTAB" tab where msgid = :1
----- PL/SQL Call Stack -----
object line object
handle number name
c000000066c82580 335 package body SYS.DBMS_AQ
c000000066d9b2f0 119 package body MARINE_AQ.CTMS_QUEUE_INTF_PKG
c0000000660fbd78 1 anonymous block
. . . 
Function List 
ksedst <- ksedmp <- ksfdmp <- kgerinv <- kgesinv
<- kgesin <- $cold_kope2upic2 <- 14384 <- kodpunp <- kopu2upkl2
<- kope2uattr <- kope2ucoll <- kope2upic2 <- kolcp2upkl <- $cold_kopu2upkl2
<- 2624 <- kope2uattr <- kope2upic2 <- kodpunp <- kokoupkl
<- kpcocaup <- kprcdt <- kprccu <- opifcr <- qertbFetchByRowID
<- opifch2 <- kpoal8 <- opiodr <- kpoodrc <- rpiswu2
<- kpoodr <- upirtrc <- kpurcsc <- kpuexecv8 <- kpuexec
. . . 
----------------------------------------
SO: c00000006b75c2b8, type: 4, owner: c00000006b663228, flag: INIT/-/-/0x00
(session) sid: 130 trans: c00000006a2df778, creator: c00000006b663228, flag: (48110041) USR/- BSY/-/-/-/-/-
DID: 0001-0010-00003E54, short-term DID: 0000-0000-00000000
txn branch: 0000000000000000
oct: 3, prv: 0, sql: c0000000660b7e20, psql: c000000067fabad0, user: 0/SYS
service name: SYS$USERS
O/S info: user: oracle, term: UNKNOWN, ospid: 21772, machine: jaunxdb0
program: oracle@jaunxdb0 (J004)
application name: DBMS_SCHEDULER, hash value=2478762354
action name: PROCESS_VOYAGE_SCH, hash value=3181464456
last wait for 'jobq slave wait' blocking sess=0x0000000000000000 seq=1 wait_time=1591713 seconds since wait started=2
=0, =0, =0
Dumping Session Wait History
for 'jobq slave wait' count=1 wait_time=1591713
=0, =0, =0
temporary object counter: 0

Solution:

The errorstack matches that of bug 8421532. Bug 8421532 has been closed as a duplicate of Bug 8506458.

References:

Bug 7661852 - SELECT ON AQ OBJECTS FAILS WITH ORA-600 [KOPE2UPIC:NULL] 
Status: 11,Code Bug (Response/Resolution)

Bug 8421532 - ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [KOPE2UPIC2954], [31], [32], [0], [] 
Closed as duplicate of
Bug 8506458 - ORA-600 [KOPE2UPIC2954] ENCOUNTERED BY PROPAGATION PROCESS

ug 4331301: "ORA-600[KOPE2UPIC2954] AND ORA-4031 IN OBJECT TEST"

Bug 3784037: "ORA-600 INTERNAL ERROR CODE, ARGUMENTS [KOPE2UPIC2954], 
[277907], [557915"
.
Bug 7661852: 10.2.0.3 RDBMS 10.2.0.3 AQ PRODID-5 PORTID-197
Abstract: SELECT ON AQ OBJECTS FAILS WITH ORA-600 [KOPE2UPIC:NULL]


Article-ID: Note 846297.1
Circulation: MODERATED (EXTERNAL)
Folder: ST.Server.AdvancedQueueing
Topic: Known Problems - Propagation
Title: AQ Propagation Fails : ORA-00600[kope2upic2954] or Ora-
00600[Kghsstream_copyn]

Hdr: 8506458 10.2.0.4 RDBMS 10.2.0.4 AQ PRODID-5 PORTID-212
Abstract: ORA-600 [KOPE2UPIC2954] ENCOUNTERED BY PROPAGATION PROCESS

Bug 8410497 - ORA-600 [KGHSSTREAM_COPYN]
Bug 8501556 - ORA-00600[KGHSSTREAM_COPYN] ENCOUNTERED BY PROPAGATION PROCESS

Get Oracle Certifications for all Exams
Free Online Exams.com