OCM Metrics Job Fails with ORA-600 [psdnop-1], [4063]
(Doc ID 1580306.1)
Last updated on JUNE 12, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
OCM metrics job fails with below error:
ORA-00600: internal error code, arguments: [psdnop-1], [4063], [], [], [], [], [], [], [], [], [], []
The trace file shows the following:
----- Current SQL Statement for this session (sql_id=xxxxxxxxxx) -----
DECLARE
job BINARY_INTEGER := :job;
next_date TIMESTAMP WITH TIME ZONE := :mydate;
broken BOOLEAN := FALSE;
job_name VARCHAR2(30) := :job_name;
job_subname VARCHAR2(30) := :job_subname;
job_owner VARCHAR2(30) := :job_owner;
job_start TIMESTAMP WITH TIME ZONE := :job_start;
job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start;
window_start TIMESTAMP WITH TIME ZONE := :window_start;
window_end TIMESTAMP WITH TIME ZONE := :window_end;
chain_id VARCHAR2(14) := :chainid;
credential_owner varchar2(30) := :credown;
credential_name varchar2(30) := :crednam;
destination_owner varchar2(30) := :destown;
destination_name varchar2(30) := :destnam;
job_dest_id varchar2(14) := :jdestid;
BEGIN
BEGIN
ORACLE_OCM.MGMT_DB_LL_METRICS.WRITE_DB_CCR_FILE('ORACLE_OCM_CONFIG_DIR2', TRUE);
END;
:mydate := next_date;
IF broken THEN :b := 1;
ELSE :b := 0;
END IF;
END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x8dd5e0a0 19 package body SYS.UTL_INADDR
0x8dd5e0a0 40 package body SYS.UTL_INADDR
0x8b9fa9c8 2254 package body ORACLE_OCM.MGMT_DB_LL_METRICS
0x8b9fa9c8 2404 package body ORACLE_OCM.MGMT_DB_LL_METRICS
0x8b9fa9c8 2445 package body ORACLE_OCM.MGMT_DB_LL_METRICS
0x87ba4bd8 1 anonymous block
And the Stack Trace has the following function calls:
psdnopInit psdnop piinadgha spefcpfa spefmccallstd pextproc rpiswu2 psdextp pefccal pefcal
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |