DBV – Technology Geek

Enable-Disable Database Vault on the Cloud

Posted on April 3, 2017December 23, 2018 by Osama Mustafa in 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 :-

For the username i put C## because i am using database 12cR1 and enable pluggable..

ORA-29504: invalid or missing schema name

Posted on May 18, 2015December 23, 2018 by Osama Mustafa in Database

ORA-29504: invalid or missing schema name

ORA-06512: at line 8 :msg

This error appeard while trying to configure Enterprise manager and DBV for SAP

Solution:

You can ignore this error the SAP looking for User called EXFSYS and the account is not used For SAP System.

Cheers

Osama

Enable Database vault 11GR2

Posted on May 8, 2015December 23, 2018 by Osama Mustafa in Database

This Post will descirbe how to enable oracle database vault in database 11GR2.

Check the document from here.
Thanks
Osama Mustafa

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

Posted on April 28, 2015December 23, 2018 by Osama Mustafa in Database

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 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
SQL>
BEGIN
DVSYS.DBMS_MACADM.ADD_AUTH_TO_REALM(
realm_name => ‘Oracle Data Dictionary’,
grantee => ‘SYSTEM’);
END;
/
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