Failed to Delete an Environment Due to Existing Dependencies on Oracle Container Database (CDB) (KBA6621)

Issue

This issue can happen in the following cases:

Case 1:  Delphix does not allow an environment to be deleted while any dataset object exists with an association to the host environment, for example, a dSource associated with CDB dependency.

Case 2: Delphix cannot delete a container database when it has an existing dependent PDB database.

Case 2.1: Similarly migrating a vPDB from a linked CDB to another linked CDB does not delete an empty CDB.

Users will be prompted with the following message:

Cannot delete container database "DELPDDGS11B" because it has existing dependent pluggable database(s).
Action: Try again after deleting dependent pluggable database(s).

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.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1
5.3	5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0
5.2	5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

Resolution

The solution to the above cases is to delete the dependents using the CLI.

Case 1:  Delphix does not allow an environment to be deleted while any dataset object exists with an association to the host environment, for example, a dSource associated with CDB dependency.

 

1. Delete the CDB using the CLI.

delphix-03> /database; select DELPDDGS11B
delphix-03 database 'DELPDDGS11B'> delete 
delphix-03 database 'DELPDDGS11B' delete *> commit
    Dispatched job JOB-33
    DB_DELETE job started for "Source DB/DELPDDGS11B".
    DB_DELETE job for "Source DB/DELPDDGS11B" completed successfully.

2. Once the dependency is removed, the Environment can then be removed. This can also be done via CLI, or via GUI. Again, expected output is provided below.

delphix-03> /environment
delphix-03 environment> select DELPDDGS11Benv
delphix-03 environment 'DELPDDGS11Benv'> delete
delphix-03 environment 'DELPDDGS11Benv' delete *> commit
    Dispatched job JOB-34
    ENVIRONMENT_DELETE job started for "DELPDDGS11Benv".
    Validating host delphix01.company.com [delphix01.company.com].
    Loading host configuration of host delphix01.company.com
     [delphix01.company.com].
    Uninstalling common toolkits from host delphix01.company.com
     [delphix01.company.com].
    Deleting host configuration of the host delphix01.company.com 
    [delphix01.company.com].
    Finished deleting host delphix01.company.com [delphix01.company.com].
    ENVIRONMENT_DELETE job for "DELPDDGS11Benv" completed successfully.

Case 2: CDB remains in GUI after delete a PDB dSource.

1. Delete the CDB using the CLI.

delphix-03> /database; select DELPDDGS11B
delphix-03 database 'DELPDDGS11B'> delete 
delphix-03 database 'DELPDDGS11B' delete *> commit
    Dispatched job JOB-35
    DB_DELETE job started for "Source DB/DELPDDGS11B".
    DB_DELETE job for "Source DB/DELPDDGS11B" completed successfully.