Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

how to remove oracle advenced security option 12c (12.1.0.2) on CDB and PDB

edited May 23, 2022 3:52PM in Database Install/Upgrade/Opatch (MOSC) 1 commentQuestion

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center