ORA-04063 Errors in Oracle alert log

Document ID : KB000029052
Last Modified Date : 14/02/2018
Show Technical Document Details

In reviewing the alert_{SID}.log file, you may encounter the following error any number of times:

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"

Please follow the steps below to stop the error from occurring.

  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

  4. Open a sqlplus session with the command:

    sqlplus "sys/ehealth@[NH_DB_CONNECT_STRING] as sysdba"   (Windows)

    sqlplus "/ as sysdba"   (Solaris/Linux)

  5. From the SQL> prompt run:

    drop user ORACLE_OCM cascade;
    commit;

  6. Then when that is done, still from the SQL> prompt run:

    @/catproc.sql

  7. Exit sqlplus with the command:

    exit

  8. Restart eHealth

    nhServer start