Compile the invalid objects of database vault in Oracle

  1. Check the list of invalid objects for DVSYS schema belong to database vault.
select owner, object_name, object_type from dba_objects where owner='DVSYS' and status='INVALID';

2. You need to disable the database vault before compile the objects.

Connect dvowner/password
--Disable the database vault
SQL>EXEC DBMS_MACADM.DISABLE_DV;

3. Restart the Oracle database with SYS user.

SQL> Shutdown immediate
SQL> startup

4. Compile the invalid objects present in database.

@?\rdbms\admin\utlrp.sql;
OR
@?\rdbms\admin\utlirp.sql;
OR 
ALTER PACKAGE ... COMPILE

5. Connect with database vault user and enable it.

EXEC DBMS_MACADM.ENABLE_DV;

6. Check the invalid object status.

select owner, object_name, object_type from dba_objects where owner='DVSYS' and status='INVALID';

7. Verify the database vault status.

select comp_id, version, status from dba_registry where comp_id='DV';

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.