ORA-04063: view "GFMIS.UNIFYLOGIN" has errors

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;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GRANTEE                                   NOT NULL VARCHAR2(30)
 PRIVILEGE                                 NOT NULL VARCHAR2(40)
 ADMIN_OPTION                                       VARCHAR2(3)
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;