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';
 This post is ad-supported
​