Skip to content
Home » Oracle » How to Resolve ORA-46627: keystore password mismatch

How to Resolve ORA-46627: keystore password mismatch

ORA-46627

Tried to clone a pluggable database (PDB) with TDE from another PDB, but it failed with ORA-46627.

SQL> create pluggable database ORCLPDB2 from ORCLPDB storage unlimited tempfile reuse file_name_convert=('ORCLPDB', 'ORCLPDB2') keystore identified by "welcome2" parallel 16;
create pluggable database ORCLPDB2 from ORCLPDB storage unlimited tempfile reuse file_name_convert=('ORCLPDB', 'ORCLPDB2') keystore identified by "welcome2" parallel 16
*
ERROR at line 1:
ORA-46627: keystore password mismatch

ORA-46627 means that the keystore password you specified in the statement mismatch the right one. You should provide the correct one for it.

Solution

Basically, operations on an encrypted database need the keystore password, In this case, the right keystore password is "welcome1", not "welcome2", we should correct the statement then issue it again.

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.

Please note that, ORA-46627 specifically complains about the wrong password which does not match the current one, nothing else.

Leave a Reply

Your email address will not be published. Required fields are marked *