Enable-Disable Database Vault on the Cloud

Oracle Database Vault restricts access to specific areas in an Oracle database from any user, including users who have administrative access. For example, you can restrict administrative access to employee salaries, customer medical records, or other sensitive information. for more information about it here

Now to enable DBV on the cloud it’s very simple all you have to do is the following :-

  • Connect to the compute node as oracle user using putty i post about this before.
  • To enable DBV Run the below command :-
    • dbaascli dv on
  • After this the output should like this “Successfully configured DV”
Congratulation DBV is enabled now.
And to Disable DBV All you have to do is Run :-
  • dbaascli dv off
Enjoy the Cloud , Cheers,
Osama Mustafa
Notes :-
  1. For the username i put C## because i am using database 12cR1 and enable pluggable..

ORA-47401: Realm violation for CREATE TABLE on SYSTEM.SYS_EXPORT_SCHEMA_07

When trying to export any user using system the below error appeared

Connected to: Oracle Database 11g Enterprise Edition Release – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing optio
ORA-31626: job does not exist
ORA-31633: unable to create master table “SYSTEM.SYS_EXPORT_SCHEMA_07”
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPV$FT”, line 1020
ORA-47401: Realm violation for CREATE TABLE on SYSTEM.SYS_EXPORT_SCHEMA_07

The above error related because the system user is not allow to access data Dictionary files.

Run the below command
realm_name => ‘Oracle Data Dictionary’,
grantee => ‘SYSTEM’);
PL/SQL procedure successfully completed.

Or you can use the GUI in Database vault and under Data Dictionray realms add the system user as participant.

Thank you