ORA-04063: view "GFMIS.UNIFYLOGIN" has errors
错误为UNIFYLOGIN这个视图没有被授权。
解决办法是给GFMIS.UNIFYLOGIN授权。
------------------------------------------------------------------------------------------------------
还有一种情况会报ORA-04063错误。
ORA-04063: 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"
解决办法:
SQL> select username from dba_users;
USERNAME
------------------------------------------------------------
SCOTT
ORACLE_OCM
ANONYMOUS
CTXSYS
MDSYS
OUTLN
ORDPLUGINS
SI_INFORMTN_SCHEMA
OLAPSYS
XDB
ORDSYS
USERNAME
------------------------------------------------------------
WMSYS
DIP
TSMSYS
MDDATA
DMSYS
EXFSYS
SYSTEM
SYS
PATROL
DBADM
COGNOS
USERNAME
------------------------------------------------------------
SYSMAN
DSG
CHANNEL
CHANNELDEV
TRAINAPP
QCOAGT
TRAIN
CHANNELAPP
PERFSTAT
MGMT_VIEW
DBSNMP
33 rows selected.
SQL> desc dba_sys_privs;
SQL>select privilege from dba_sys_privs where grantee='ORACLE_OCM';
PRIVILEGE
--------------------------------------------------------------------------------
SELECT ANY DICTIONARY
SQL> grant execute on UTL_FILE to oracle_ocm;
SQL> grant execute on DBMS_SCHEDULER to oracle_ocm;
SQL> ALTER PACKAGE ORACLE_OCM.MGMT_DB_LL_METRICS COMPILE;
SQL> ALTER PACKAGE ORACLE_OCM.MGMT_CONFIG COMPILE;