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

[Rabia]

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.

[ErmanArslansOracleBlog]

2 general actions for this -> "Check if the keys to be imported are already present by listing KEY_ID from V$ENCRYPTION_KEYS. Ensure that the keys are correctly exported from pluggable database (PDB) or CDB$ROOT at the source database."

So,  are you in the correct container? -> cloned PDB

And may that key already present in there? ->  select KEY_ID,ACTIVATING_PDBID from V$ENCRYPTION_KEYS;