Saturday, April 15, 2023

ORA-46697: Keystore password required

SQL> show pdbs
 
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 MYPDB1                           READ WRITE NO
 
SQL> create pluggable database testpdb from MYPDB1;
create pluggable database testpdb from MYPDB1
*
ERROR at line 1:
ORA-46697: Keystore password required.


Starting version 12.2, if you are using TDE wallet in your PDB, you MUST use clause “keystore identified by” with CREATE PLUGGABLE DATABASE command when you are performing a PDB clone. Use command similar to the following and you should not see ORA-46697 error.

SQL> create pluggable database testpdb from MYPDB1 keystore identified by wallet_password;
 
Pluggable database created


No comments:

Post a Comment

Popular Posts - All Times