PDB RAC provision with TDE enabled may fail with error "Cannot snapshot virtual database <vPDB> because it is not open." (KBA8939)

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

KBA

KBA# 8939

Issue

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.

Prerequisites

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	6.0.12.0, 6.0.12.1, 6.0.13.0

Resolution

Resolution 1

The following option often works, however it is susceptible to the same issue as the provision.

Disable the vPDB
Enable the vPDB

Resolution 2

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;

Troubleshooting

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

KBA