EM12c : ORA-12012 ERROR ON AUTO EXECUTE OF JOB EM_REPOS_SEV_EVAL.C_2_2 (Doc ID 1941345.1)

Last updated on OCTOBER 26, 2016

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.3.0 and later
Information in this document applies to any platform.

Symptoms

Observing the EM_REPOS_SEV_EVAL errors in Repository DB alert log in 12.1.0.3 OMS.
Issue can be in newly installed or upgraded environments.

Errors from the alert log file:

Mon Oct 07 00:21:55 2013
LNS: Standby redo logfile selected for thread 1 sequence 14570 for
destination LOG_ARCHIVE_DEST_2
Mon Oct 07 00:21:57 2013
Archived Log entry 42623 added for thread 1 sequence 14569 ID
0xffffffffbf1dbeab dest 1:
Mon Oct 07 00:22:40 2013
Errors in file
/u01/app/oracle/diag/rdbms/emrep/EMREP/trace/EMREP_j001_38338630.trc:
ORA-12012: error on auto execute of job "SYSMAN"."EM_REPOS_SEV_EVAL"."C_3_1"
ORA-00942: table or view does not exist
Mon Oct 07 01:08:09 2013
Thread 1 advanced to log sequence 14571 (LGWR switch)
  Current log# 15 seq# 14571 mem# 0:
+OEM_REDO_01/emrep/onlinelog/group_15.272.797691725
  Current log# 15 seq# 14571 mem# 1:
+OEM_REDO_02/emrep/onlinelog/group_15.272.797691729
Mon Oct 07 01:08:09 2013
LNS: Standby redo logfile selected for thread 1 sequence 14571 for
destination LOG_ARCHIVE_DEST_2
Mon Oct 07 01:08:12 2013
Archived Log entry 42627 added for thread 1 sequence 14570 ID
0xffffffffbf1dbeab dest 1:
Mon Oct 07 02:00:00 2013
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter

 

Errors in the referenced /u01/app/oracle/diag/rdbms/emrep/EMREP/trace/EMREP_j001_38338630.trc: file

ORA-12012: error on auto execute of job "SYSMAN"."EM_REPOS_SEV_EVAL"."C_3_1"
ORA-00942: table or view does not exist

 

 

Changes

 

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