ORA-46655: no valid keys in the file from which keys are to be imported

Posted by Rabia on Jan 15, 2025; 11:47am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-46655-no-valid-keys-in-the-file-from-which-keys-are-to-be-imported-tp12877.html

Hi Erman,

I hope you are doing well.

I successfully cloned PDB into target environment.
The encryption key was exported from the source environment and then I transferred the exported file to target environment.
While importing the key at target I got the following issue:

SQL> ADMINISTER KEY MANAGEMENT IMPORT ENCRYPTION KEYS WITH SECRET "<>" FROM '<path>' IDENTIFIED BY "<password>";
*
ERROR at line 1:
ORA-46655: no valid keys in the file from which keys are to be imported

How to resolve this issue? I tried but I did not find any solution.

I used PDB Container session and before running this command , keystore was in open state.