ORA-46671: master key not set in root container
SQL> ADMINISTER KEY MANAGEMENT SET KEY FORCE KEYSTORE IDENTIFIED BY password WITH BACKUP CONTAINER=current;ADMINISTER KEY MANAGEMENT SET KEY FORCE KEYSTORE IDENTIFIED BY password WITH BACKUP CONTAINER=current
*
ERROR at line 1:
ORA-46671: master key not set in root container
Cause:
The cause of the error is very clear from the error message "master key not set in root container"
Solution:
Set the master key in the root container first to set the key in other container.
SQL> alter session set container=CDB$ROOT;
SQL>select STATUS,WRL_PARAMETER WALLET_DIR,WALLET_TYPE from V$ENCRYPTION_WALLET;
STATUS WALLET_DIR WALLET_TYPE
--------------------- -------------------------------- --------------------
OPEN_NO_MASTER_KEY +DG_TST_DATA/TST1T/wallet/ LOCAL_AUTOLOGIN
SQL> ADMINISTER KEY MANAGEMENT SET KEY FORCE KEYSTORE IDENTIFIED BY password WITH BACKUP CONTAINER=current;
SQL> SELECT STATUS,WRL_PARAMETER WALLET_DIR,WALLET_TYPE from V$ENCRYPTION_WALLET;
STATUS WALLET_DIR WALLET_TYPE
--------------------- -------------------------------- --------------------
OPEN +DG_TST_DATA/TST1T/wallet/ LOCAL_AUTOLOGIN
Comments
Post a Comment