We are having an issue with virtual databases that is related to Oracle Database Vault.
When we provision a virtual database to a Target environment (which has Oracle v12.1 installed) the operation ends with an error in the Delphix with the following error.
command: umask 027; . $DB_SCRIPT_DIR/setup-oraenv.sh; $DLPX_SHELL $DB_SCRIPT_DIR/doOpenDatabase.sh "$LOGON_STR"output:END_OF_SETUPWARNING: cannot read alert log file /export/home/oracle/app/oracle/diag/rdbms/mxuatx/MXUATX/alert/alert_MXUATX.logdb_status=' || status from v$instanceALERT_LOG_FILE_PATH=/export/home/oracle/app/oracle/diag/rdbms/mxuatx/MXUATX/alert/alert_MXUATX.logPRE_OPEN_LINE_COUNT=<o:p></o:p>
When we check the error in detail with Delphix Support we have found out that it is actually related to Oracle Database Vault:
ERROR:ORA-47306: 20007: DB Vault Connect Rule -- DB Connection Not Allowed
When we tried to disable the Oracle Database Vault using Oracle documentation (Disabling and Enabling Oracle Database Vault) we have still experiencing problems that are related to the Database Vault and the vDB cannot be provisioned successfully.
We have also noticed that Oracle Passwordfile does not exist in the Oracle DB home.
Any suggestions are welcome!
Here are some more details:
delphix@mxdbtst1:/var/opt/delphix/toolkit/Delphix_93f5c60830be_d696501c3b4a_1104_host/databases/oracle/MXTRY1/MXTRY1$ sqlplus / as sysdba
SQL*Plus: Release 184.108.40.206.0 Production on Thu Dec 24 16:26:22 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> select instance_name, status from v$instance;
select instance_name, status from v$instance
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
ORA-47306: 20007: DB Vault Connect Rule -- DB Connection Not Allowed
One idea is to check in the source if there is any ip restriction rule set, if so just update it accprdinally to your need.to get it into work.
Thanks a lot for your valueable comments. As you have suggested we already set up a meeting with the Security Team (in this case we were informed by the customer that Security team sets the DB Vault config) and it is due to next week.
Hopefully I will share the results and how to resolve this issue here.
------------------------------Rahim CetinelSolution Architect | Delphix Blackbelt------------------------------
Let me share an update: After making Database Vault configuration updates at the Source and taking a SnapSync at Delphix, the next vDB from the latest snapshot were provisioned successfully.
Solution Architect | Delphix Blackbelt
M:+905334112490 | Skype: rahim.cetinel
Glad to hear it and that the suggested idea made you overcome the situation after updating the DB firewall configuration