ORA-00600: internal error code, arguments: [krvrdccs10], [], [], [], [], [],

问题：ORA-00600: internal error code, arguments: [krvrdccs10], [], [], [], [], [],

处理办法：

ORA-600 [krvrdccs10] When Running LOGMNR With ONLINE DICTIONARY OPTION (Doc ID 2747083.1)

APPLIES TO:
Oracle Database - Standard Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.
SYMPTOMS
On : 12.2.0.1 version, Internals Errors (ORA-600 & ORA-7445)

When attempting to logmnr redo with options=>dbms_logmnr.dict_from_online_catalog
the following error occurs.

ERROR
-----------------------

ORA-00600: internal error code, arguments: [krvrdccs10], [], [], [], [], [],


STEPS
-----------------------

EXECUTE dbms_logmnr.add_logfile(logfilename=>'+DATA/ONLINELOG/group_14.422.982333369',options=>dbms_logmnr.NEW);

exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);

SELECT * from V$LOGMNR_CONTENTS
Callstack

-----------------------

[06]: krvrdccs []<-- Signaling
[07]: krvrdgtloSQL_cbk []
[08]: kpdbSwitch [PROGINT]
[09]: krvrdgtlo []
[10]: krvxzgoa []
[11]: krvxbgoi_GetObjInfo []
[12]: krvxbpdl_ProcessDataLcr []
[13]: krvxbgen_GenericTx []
[14]: krvxbuild []
[15]: krvxgtsp_GetTxnSingleProcess []
[16]: krvxgt []
[17]: krvfcact2 []
[18]: krvfcact []
[19]: qerfxFetch [SQL_Execution]
[20]: rwsfcd []
[21]: qerltFetch [SQL_Execution]
[22]: ctcdrv [SQL_DDL]
[23]: opiexe [Time_Limit]
[24]: opiosq0 [OPI]
[25]: kpooprx [PROGINT_MISC]
[26]: kpoal8 [PROGINT_MISC]
[27]: opiodr [OPI]
[28]: ttcpip []
[29]: opitsk [OPI]
[30]: opiino [OPI]
[31]: opiodr [OPI]
[32]: opidrv [OPI]
[33]: sou2o []
[34]: opimai_real [OPI]
[35]: ssthrdmain []
[36]: main []
[37]: __libc_start_main []



CHANGES
 

CAUSE
 This issue is still investigated in below unpublished bug and no fix available as of writing.

Unpublished Bug 31412659 - ORA-600[KRVRDCCS10] WHEN LOGMNR SPECIFY ONLINE DICTIONARY OPTION 
 

SOLUTION
 Use workaround: Do NOT use options=>dbms_logmnr.dict_from_online_catalog

eg:

SQL> EXECUTE dbms_logmnr.add_logfile(logfilename=>'+DATA/ONLINELOG/group_14.422.982333369',options=>dbms_logmnr.NEW);

SQL> create directory test as '/home/oracle'; <===create a directory to store logmnr dictionary

SQL> BEGIN

sys.DBMS_LOGMNR_D.build (

dictionary_filename => 'dictionary.ora',

dictionary_location => 'TEST'); <===Upper case for directory name

END;

/

 

SQL> exec dbms_logmnr.start_logmnr(dictfilename=>'/home/oracle/dictionary.ora'); <=== Use the newly created dictionary.ora to mine redo

SQL> SELECT * from V$LOGMNR_CONTENTS;

相关参考：
https://debezium.io/documentation/reference/stable/connectors/oracle.html
https://blog.csdn.net/XAGU_/article/details/121037467
https://issues.redhat.com/browse/DBZ-5009