In rare conditions, the first snapshot of a vPDB provision of a RAC VDB with TDE enabled will fail with the error.
Cannot snapshot virtual database <vPDB> because it is not open.
This issue can occur when:
- vPDB provision, refresh, or rollback.
- Target environment is an Oracle Cluster.
- Oracle TDE is enabled.
In this situation, the vPDB Provision is successful, however the open database on some of the nodes fails due to wallet issues. It is believed this is due to a race condition within Oracle.
Applicable Delphix Versions
- Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases 6.0 220.127.116.11, 18.104.22.168, 22.214.171.124
The following option often works, however it is susceptible to the same issue as the provision.
- Disable the vPDB
- Enable the vPDB
On any nodes where the vPDB failed to open, perform the following SQL commands to open the keystore (which will reload the keystore contents into memory) and revalidate the datafiles:
ADMINISTER KEY MANAGEMENT OPEN KEYSTORE IDENTIFIED BY <keystore password>;
ALTER SYSTEM CHECK DATAFILES;
ALTER PLUGGABLE DATABASE <vPDB> OPEN READ WRITE;
To confirm the issue encountered is as described in this article, the following Oracle errors will appear in the alert for the container database holding the vPDB. There will also be a trace file generated that can be located through the alert log and the errors entry in here. Locating the error and trace files can be done by searching for the following errors in the files.
ORA-00704: bootstrap process failure
ORA-01187: cannot read from file because it failed verification tests