how to remove oracle advenced security option 12c (12.1.0.2) on CDB and PDB
Problem Description
---------------------------------------------------
Migrate PDB 12.1.0.2 to 19.15.0 new server by Remote Clone PDB
after dbupgrage alter pluggable database open Warning: PDB altered with errors
Source CDB 12c (12.1.0.2) have Oracle Wallet key (Oracle Advance Security) but have not Table and Tablespace encryption
Target CDB ื 19c (19.15) have not Oracle Advance Security (no license)
SQL> alter pluggable database MSDB open instances=all;
Warning: PDB altered with errors.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBDB READ WRITE YES
select * from PDB_PLUG_IN_VIOLATIONS;
Wallet Key Needed ERROR PDB needs to import keys from source.