asked on

DVSYS database vault

Hi ,

SQL> /

COMP_ID COMP_NAME VERSION STATUS
---------- ------------------------------ ------------------------------ --------------------------------------------
DV Oracle Database Vault 11.2.0.3.0 INVALID
OLS Oracle Label Security 11.2.0.3.0 VALID
XDB Oracle XML Database 11.2.0.3.0 VALID
OWM Oracle Workspace Manager 11.2.0.3.0 VALID
CATALOG Oracle Database Catalog Views 11.2.0.3.0 VALID
CATPROC Oracle Database Packages and T 11.2.0.3.0 VALID
ypes

How do i make my vault component to valid state . I tried with multiple options .

OS - Solaris

Thanks,
VInay Palaparthy

Vinay kumar

ASKER

Any help on this

slightwv (䄆 Netminder)

Have you checked what is in DBA_ERRORS?

http://docs.oracle.com/database/122/REFRN/DBA_ERRORS.htm#REFRN23065

It should have any compile errors.

You may just need to recompile everything. Oracle provides a script for that:
http://docs.oracle.com/database/122/LADBI/recompiling-all-invalid-objects.htm#BEGIN

Vinay kumar

ASKER

Hi ,

Thank you for your answer . Yes ,DBA_ERRORS have errors but that doesnt help me to debug further ,find the below error messages .

DVSYS      DBMS_MACADM      PACKAGE BODY      3      3105      19      PLS-00201: identifier 'DV$POLICY_LABEL.POLICY_NAME' must be declared
DVSYS      DBMS_MACADM      PACKAGE BODY      2      430      9      PL/SQL: SQL Statement ignored
DVSYS      DBMS_MACADM      PACKAGE BODY      1      432      14      PL/SQL: ORA-00942: table or view does not exist
DVSYS      DBMS_MACSEC      PACKAGE BODY      8      337      9      PL/SQL: Statement ignored
DVSYS      DBMS_MACSEC      PACKAGE BODY      7      337      62      PLS-00320: the declaration of the type of this expression is incomplete or malformed
DVSYS      DBMS_MACSEC      PACKAGE BODY      6      330      9      PL/SQL: Statement ignored
DVSYS      DBMS_MACSEC      PACKAGE BODY      5      330      59      PLS-00320: the declaration of the type of this expression is incomplete or malformed
DVSYS      DBMS_MACSEC      PACKAGE BODY      4      328      9      PL/SQL: Statement ignored
DVSYS      DBMS_MACSEC      PACKAGE BODY      3      328      9      PLS-00320: the declaration of the type of this expression is incomplete or malformed
DVSYS      DBMS_MACSEC      PACKAGE BODY      2      307      17      PL/SQL: Item ignored
DVSYS      DBMS_MACSEC      PACKAGE BODY      1      307      17      PLS-00201: identifier 'LBACSYS.LBAC$POL' must be declared
DVSYS      DBMS_MACOLS      PACKAGE BODY      20      47      9      PL/SQL: SQL Statement ignored
DVSYS      DBMS_MACOLS      PACKAGE BODY      19      49      55      PL/SQL: ORA-00942: table or view does not exist

Also utlrp.sql doesnt help to make that component to VALID state .

Please provide alternate solution .

Thanks,
VInay Palaparthy

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Vinay kumar

ASKER

May be I will reconfigure this..