ORA-46663: master keys not created for all PDBs for REKEY

<<Back to Oracle DB Security Main Page

ORA-46663: master keys not created for all PDBs for REKEY

SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY xxxx WITH BACKUP CONTAINER = ALL ;
ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY xxxxx WITH BACKUP CONTAINER = ALL
*
ERROR at line 1:
ORA-46663: master keys not created for all PDBs for REKEY
Cause:
ORA-46663 is meant to be raised upon a SET KEY for all containers, when at least one of the PDBs is in CLOSED or MOUNT mode.
SOLUTION:
Open all containers and retry the command
OR
Omit CONTAINER=ALL clause but this will set the master key only for the current container
SQL> DMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY xxxxx WITH BACKUP ;