ORA-00942 IN ORACLE_OCM.MGMT_DB_LL_METRICS.collect_config_metrics in Database Alert Log (Doc ID 1155654.1)

Last updated on APRIL 23, 2015

Applies to:

Oracle Configuration Manager - Version 10.3.3.0.0 to 10.3.3.0.0
Information in this document applies to any platform.
*** Checked for relevance 13-Nov-2012 ***

Symptoms

Following errors reported in the Alert log of the database of version 11.1.0.7 :

ORACLE_OCM.MGMT_DB_LL_METRICS.collect_config_metrics in Alert Log Of Database


----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 2
ORA-00942: table or view does not exist
----- Current SQL Statement for this session (sql_id=d2nmbb77yzhm5) -----
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; BEGIN BEGIN
ORACLE_OCM.MGMT_DB_LL_METRICS.collect_config_metrics('ORACLE_OCM_CONFIG_DIR');
END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF;
END;
----- PL/SQL Stack -----
.

 ----- Error Stack Dump -----
 ----- Current SQL Statement for this session (sql_id=4yb79gnqp1v90) -----
 SELECT count(*) FROM XDB.XDB$XDB_READY
 ----- PL/SQL Stack -----
 ----- PL/SQL Call Stack -----
 object line object
 handle number name
 3978b1ef8 19 package body SYS.UTL_INADDR
 3978b1ef8 40 package body SYS.UTL_INADDR
 39011a5d8 2193 package body ORACLE_OCM.MGMT_DB_LL_METRICS
 39011a5d8 2208 package body ORACLE_OCM.MGMT_DB_LL_METRICS
 39011a5d8 2270 package body ORACLE_OCM.MGMT_DB_LL_METRICS
 39683f040 1 anonymous block

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