OCM Metrics Job Fails with ORA-600 [psdnop-1], [4063] (Doc ID 1580306.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms