Skip to content

How to Resolve ORA-46697: Keystore password required

  • by

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.

Leave a Reply

Your email address will not be published.