ORA-error stack (00600[k2gteget: pdbid], 00600[kpdbSwitchPreRestore: txn])
ORA-error stack (00600[k2gteget: pdbid], 00600[kpdbSwitchPreRestore: txn]).
ORA-00600 is an internal error code for Oracle databases. It indicates that an unexpected condition has occurred and the system encountered an internal inconsistency. The first part of the error stack, “k2gteget: pdbid,” is related to the retrieval of the plug-in database identifier (PDBID). The second part, “kpdbSwitchPreRestore: txn,” is associated with the pre-restore process for switching a PDB.
When encountering an ORA-00600 error, it is advisable to contact Oracle Support for further assistance. They will have access to the specific details of your Oracle version, configuration, and database state, which are crucial for debugging and troubleshooting.
Work around:
Disabled sql tuning advisor against CDB as part of work around.
| SQL> SELECT client_name, status FROM dba_autotask_client;
CLIENT_NAME STATUS SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED |
For complete alert Details
==============================
Subject: EM Event: Critical:ORCLP1_ORCLP12 – ORA-error stack (00600[k2gteget: pdbid], 00600[kpdbSwitchPreRestore: txn])
logged in /u01/app/oracle/diag/rdbms/orclp1/ORCLP12/trace/alert_ORCLP12.log.
Host=exanode08
Target type=Database Instance
Target name=ORCLP1_ORCLP12
Categories=Fault
Message=ORA-error stack (00600[k2gteget: pdbid], 00600[kpdbSwitchPreRestore: txn])
logged in /u01/app/oracle/diag/rdbms/orclp1/ORCLP12/trace/alert_ORCLP12.log.
Severity=Critical
Event reported time=Dec 6, 2016 4:00:33 AM GMT
Operating System=Linux
Platform=x86_64
Associated Incident Id=123368
Associated Incident Status=New
Associated Incident Owner=
Associated Incident Acknowledged By Owner=No
Associated Incident Priority=None
Associated Incident Escalation Level=0
Event Type=Metric Alert
Event name=alertLog:genericErrStack
Metric Group=Alert Log
Metric=Generic Alert Log Error
Metric value=Dumping diagnostic data in directory=[cdmp_20161206040033], requested by
(instance=2, osid=75978 (J002)), summary=[incident=156202].~Use ADRCI or Support Workbench to package the incident.
~See Note 411.1 at My Oracle Support for error and packaging details.~
Errors in file /u01/app/oracle/diag/rdbms/orclp1/ORCLP12/trace/ORCLP12_j002_75978.trc
(incident=156203) (PDBNAME=CDB$ROOT):~ORA-00600: internal error code,
arguments: [k2gteget: pdbid], [3], [1], [], [], [], [], [], [], [], [], []
~ORA-00600: internal error code, arguments: [kpdbSwitchPreRestore: txn], [0x2CB32E338], [0], [2685403136], [], [], [], [], [], [], [], []
~Incident details in: /u01/app/oracle/diag/rdbms/orclp1/ORCLP12/incident/incdir_156203/ORCLP12_j002_75978_i156203.trc
Key Value=Tue Dec 06 04:00:33 2016/99491
Key Column 1=Time/Line Number
Rule Name=DEFAULT_RULESET_FOR_ALL_TARGETS,METRIC_ALERT_INCIDENT_CREATION
Rule Owner=
Update Details:
ORA-error stack (00600[k2gteget: pdbid], 00600[kpdbSwitchPreRestore: txn]) logged in /u01/app/oracle/diag/rdbms/orclp1/ORCLP12/trace/alert_ORCLP12.log.
Incident created by rule (Name = Incident management rule set for all targets, Create incident for critical metric alerts [System generated rule]).
Solution:
Upgrade the DB to 12.2.0 or higher
After upgrade run below command.
| SQL> EXEC dbms_auto_task_admin.disable(‘SQL TUNING ADVISOR’,NULL, NULL);
PL/SQL procedure successfully completed. SQL> |
See also: