Applies to:
Oracle Server – Enterprise Edition – Version: 8.1.7.4 to 10.2.0.3
This problem can occur on any platform.
Symptoms
1>ORA-00600: internal error code, arguments: [kcbgcur_9], [8388849], [31], [2147483648],[2147483648], [], [], []
during alter database create logical standby controlfile as
2>Call Stack Trace: -
ksedmp kgerinv kgeasnmierr kcbgcur ktugusc ktucwt3 krvslcf adbdrv opiexe opiosq0 kpooprx kpoal8
3>Process state contains a lock on a row in the “dc_rollback_segments” row cache.
4>Process state contains a KTU SMU HEADER BLOCK dump and there is at least one transaction in the TRN TBL where
state=2 and cflags has bit 0×4 set.
Cause
There are in-doubt distributed transactions needing recovery.
Bug 5523987
Abstract: ORA-600 [KCBGCUR_9] ON ALTER DATABASE CREATE LOGICAL STANDBY CONTROLFILE AS …
Fixed In Ver: 11.1
Solution
Find the in-doubt distributed transaction(s) and manually resolve it.
Select *
from X$KTUXE
where KTUXESTA=’PREPARED’
and KTUXECFL like ‘%REV%’;
or
Select local_tran_id, global_tran_id, state, mixed, host, commit#
from dba_2pc_pending
where state=’PREPARED’;
Refer to the Admin Guide or to Note 100664.1 ‘How to troubleshoot distributed transactions’ in resolving this distributed transaction.
References
NOTE:100664.1 – How to Troubleshoot Distributed Transactions
Related Posts