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

<<Back to DB Administration Main Page

SQL> administer key management import encryption keys with secret "xxxx" from '/tmp/pdb02_tde_key.exp' force keystore identified by "xxxx" with backup;
administer key management import encryption keys with secret "xxxxxx" from '/tmp/pdb02_tde_key.exp' force keystore identified by "xxxxxx" with backup
*
ERROR at line 1:
ORA-46655: no valid keys in the file from which keys are to be imported

Cause:
Either the keys to be imported already present in the target database or correct container (PDB) is not set.

Solution:
In my case I got the error because I attempted to import the keys for newly plugged database PDB02 from CDB$ROOT container.
To Solve the issue just switched to the correct container and re run the import.

SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT <===Wrong Container selected 

SQL> alter session set container=PDB02;
Session altered.
SQL> administer key management import encryption keys with secret "xxxxx" from '/tmp/pdb02_tde_key.exp' force keystore identified by "xxxxx" with backup;
keystore altered.


Another possibility is that the key to be imported is already present in the target database. In this case you can not import the keys.
To verify the same you run below command in source and target database and compare the keys

 SQL> select KEY_ID,ACTIVATING_PDBID from V$ENCRYPTION_KEYS;

For additional  information check out below Metalink Notes.

Doc ID 2156693.1
Doc ID 2193264.1