ORA-46697
Create Pluggable Database
Cloning Local PDB
Tried to clone a Pluggable Database (PDB) in the same Container Database (CDB), but it failed with ORA-46697.
SQL> create pluggable database ORCLCDB2 from ORCLCDB1 storage unlimited tempfile reuse file_name_convert=('ORCLCDB1', 'ORCLCDB2') parallel 16;
create pluggable database ORCLCDB2 from ORCLCDB1 storage unlimited tempfile reuse file_name_convert=('ORCLCDB1', 'ORCLCDB2') parallel 16
*
ERROR at line 1:
ORA-46697: Keystore password required.
Cloning Remote PDB
In a similar scenario, we cloned a remote PDB. Again, we ran into ORA-46697.
SQL> create pluggable database ORCLPDB from ORCLPDB@ORCLPDB_LK storage unlimited tempfile reuse file_name_convert=('ORCLCDB1','ORCLCDB2') parallel 16;
create pluggable database ORCLPDB from ORCLPDB@ORCLPDB_LK storage unlimited tempfile reuse file_name_convert=('ORCLCDB1','ORCLCDB2') parallel 16
*
ERROR at line 1:
ORA-46697: Keystore password required.
Solution
ORA-46697 means that the operation you want to perform requires the password of keystore, you may use KEYSTORE IDENTIFIED BY to solve it.
In this case, this is because the source database you want to clone is configured with encryption, you have to provide the password in order to copy data files to the destination.
Cloning Local PDB
SQL> create pluggable database ORCLPDB2 from ORCLPDB1 storage unlimited tempfile reuse file_name_convert=('ORCLPDB1', 'ORCLPDB2') keystore identified by "welcome1" parallel 16;
Pluggable database created.
Cloning Remote PDB
SQL> create pluggable database ORCLPDB from ORCLPDB@ORCLPDB_LK storage unlimited tempfile reuse file_name_convert=('ORCLCDB1','ORCLCDB2') keystore identified by "welcome1" parallel 16;
Pluggable database created.
We solve it.