Tech Tip: ORA-04063: package body "ORACLE_OCM.MGMT_DB_LL_METRICS" has errors

Document created by Darshan_Desai Employee on Jan 2, 2015Last modified by SamCreek on Dec 17, 2016
Version 2Show Document
  • View in full screen mode

Problem summary:

The following messages are recorded in the alert log file.

 

Tue Dec 30 22:00:02 IST 2014

Errors in file /ehealth/ora/admin/bdump/EHEALTH/ehealth_j003_10739.trc:

ORA-12012: error on auto execute of job 1663007

ORA-04063: package body "ORACLE_OCM.MGMT_DB_LL_METRICS" has errors

ORA-06508: PL/SQL: could not find program unit being called: "ORACLE_OCM.MGMT_DB_LL_METRICS"

ORA-06512: at line 1 has errors

 

 

Cause of problem:

EHealth does not create and/or support user ORACLE_OCM. It is believed that this user is created by some of the Oracle fixes (patches & CPUs), which causes the OCM.MGMT_DB_LL_METRICS errors and also seems to cause ASCII save problems.

 

 

Fix:

Drop this user ORACLE_OCM.

 

Below are the correct steps that should correct the issue:

 

1. Confirm that a valid eHealth database save exists.


2. Stop eHealth with the command

 

nhServer stop

 

3. Open a command prompt, and then change directory to NH_ORACLE_HOME/rdbms/admin

 

From there, open a sqlplus session with the command:

 

sqlplus sys/ehealth as sysdba

 

From the SQL> prompt run:

 

drop user ORACLE_OCM cascade;

 

Then when that is done, still from the sql prompt run:

 

commit;

 

Then when that is done, still from the sql prompt run:

 

@/catproc.sql

 

Then when that is done, exit sqlplus with the command:

 

commit;

exit;

 

4. Start eHealth with the command

 

nhServer start

Attachments

    Outcomes