SELECT ON AQ OBJECTS REPORTS ORA-00600 ERROR MESSAGE, ORA-00600: internal error code, arguments: [kope2upic:null], [0x00000033F]

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:     SELECT ON AQ OBJECTS REPORTS ORA-00600 ERROR MESSAGE, ORA-00600: internal error code, arguments: [kope2upic:null], [0x00000033F]

Symptoms:

Found ORA-00600[kope2upic2954] & ORA-07445 [__milli_divRem32U()+34] Errors in Alert log


ORA-00600: internal error code, arguments: [kope2upic:null], [0x000000055], [], [], [], [], [], []
Current SQL statement for this session:

Log files:

Alert.log when the database was in 10.2.0.2 release.

ORA-00600: internal error code, arguments: [kope2upic:null], [0x00000033F], [], [], [], [], [], []
ORA-00081: address range [0x60000000000A80A0, 0x60000000000A80A4) is not readable
ORA-00600: internal error code, arguments: [kope2upic2954], [445], [385], [79], [], [], [], []
ORA-00081: address range [0x60000000000A80A0, 0x60000000000A80A4) is not readable
ORA-00600: internal error code, arguments: [kope2upic:null], [0x000000055], [], [], [], [], [], []

sid_j002_21970.trc /

*** ACTION NAME:(PROCESS_VOYAGE_TWS) 2008-12-12 15:38:21.712
*** MODULE NAME:(DBMS_SCHEDULER) 2008-12-12 15:38:21.712
*** SERVICE NAME:(SYS$USERS) 2008-12-12 15:38:21.712
*** CLIENT ID:() 2008-12-12 15:38:21.712
*** SESSION ID:(742.49632) 2008-12-12 15:38:21.712
*** 2008-12-12 15:38:21.712
ksedmp: internal or fatal error
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x600000006672c23b, PC: [0x4000000003adea80, kgegpa()+128]
r1: 60000000000b31d0 r20: 2c12d br5: 0
r2: 3 r21: 60000000001d2640 br6: c00000000035c820
r3: 2043b r22: 60000000001d2640 br7: c0000000001ebd80
r4: 0 r23: 45584b273a3a3c3a ip: 4000000003adea80
r5: c000000000000408 r24: 4f52412d30303630 iipa: 0
r6: c00000000002c600 r25: 303a20696e746572 cfm: 8
r7: 9ffffffffd7f8f38 r26: 4f52412d30303630 um: 1a
r8: 600000006672c23a r27: 8 rsc: 1f
r9: 0 r28: 0 bsp: 9ffffffffd8044d8
r10: 600000006672c23a r29: 0 bspstore: 9ffffffffd8044d8
r11: 600000006672c23e r30: 9ffffffffffcec40 rnat: 9ffffffffd2a45e0
r12: 9ffffffffffceb20 r31: a0a0a0a0a0a0a0a ccv: 0
r13: 9ffffffffd459420 NaTs: 0 unat: 0
r14: 600000006672c23c PRs: c0000000003b01ad fpsr: 9804c8a74433f
r15: 600000006672c23b br0: 4000000003ade830 pfs: c020002dba000da3
r16: 600000006672c23d br1: 4000000003b29be0 lc: 3
r17: c0000000001ebd80 br2: 0 ec: 2
r18: 18 br3: 0 isr: 9ffffffffd8044d8
r19: 28 br4: 0 ifa: 0
Reason code: 0008
*** 2008-12-12 15:38:21.724
ksedmp: internal or fatal error
ksedmp: error stack dump failed earlier. not retrying
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_TWS_I_QTAB" tab where msgid = :1
----- PL/SQL Call Stack -----
object line object
handle number name
c000000280761b78 335 package body SYS.DBMS_AQ
c0000002806eae50 302 package body MARINE_AQ.CTMS_QUEUE_INTF_PKG
c000000280408570 1 anonymous block

Solution:

The stack due to : job_queue_process attempts to execute a schedule

 AQ propagation process seems to be the one dumping the ORA-00600 in the alert.log.

Apply bug 7661852

References:

bug 7661852

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

Bug 3784037 : "ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KOPE2UPIC2954], [277907], [557915"

Get Oracle Certifications for all Exams
Free Online Exams.com