Find the PDB violations in 19c Oracle Database

Source CDB environment file
$ sqlplus "/as  sysdba"
SQL> select * from PDB_PLUG_IN_VIOLATIONS;

Source CDB environment file
$ sqlplus "/as  sysdba"
SQL> alter session set container=TESTPDB;
SQL> select * from PDB_PLUG_IN_VIOLATIONS;

Open Wallet on PDB in 19c Oracle Database

 Source CDB environment file

$ sqlplus "/as  sysdba"
SQL> alter session set container=TESTPDB;
SQL>administer key management set keystore open force keystore identified by "<password>";

Open Wallet on CDB in 19c Oracle Database

Source CDB environment file

$ sqlplus "/as  sysdba"

SQL>administer key management set keystore open force keystore identified by "<password>";

Import Wallet on PDB in 19c Oracle Database

 SQL> alter session set container=TESTPDB;

Open the wallet

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "<password>";

Import the wallet

SQL> administer key management import encryption keys with secret "<password>" from '/d01/wallet/tde/testpdb.key' identified by "<password>" with backup;

Verify Wallet Status

SQL> select STATUS from V$ENCRYPTION_WALLET;

STATUS
OPEN

Import Wallet on CDB in 19c Oracle Database

Before import, we need to open the wallet.

Open the wallet

 SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "<password>";

 Import the wallet

SQL> administer key management import encryption keys with secret "<password>" from '/d01/wallet/tde/testpdb.key' identified by "<password>" with backup;

Verify Wallet Status

SQL> select STATUS from V$ENCRYPTION_WALLET;

           STATUS
    OPEN

Close the Wallet on PDB in 19c Oracle Database

 SQL>administer key management set keystore close identified by "<password>";

Verify the wallet Status

SQL> select status from v$encryption_wallet;

STATUS        

CLOSED            

Close the Wallet on CDB in 19c Oracle Database

 SQL>administer key management set keystore close identified by "<password>";

Verify the wallet Status

SQL> select status from v$encryption_wallet;

STATUS 

        CLOSED