ORA-28417: password-based keystore is not open

You may face this error while creating a master encryption key while having/using auto-login (or local auto-login) keyswtore, but your password-based keystore is still closed which is required to be open before you can create master encryption key.

SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY salman12 WITH BACKUP USING 'initial_backup' CONTAINER = ALL ; ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY salman12 WITH BACKUP USING 'initial_backup' CONTAINER = ALL * ERROR at line 1: ORA-28417: password-based keystore is not open

Open the password based keystore and create the master encryption key as follows

SQL> administer key management set keystore open identified by salman12; keystore altered. -- Now create the keystore. SQL> SELECT WRL_PARAMETER, STATUS, WALLET_TYPE FROM V$ENCRYPTION_WALLET; WRL_PARAMETER                                                        STATUS                                            WALLET_TYPE ---------------------------------------- ------------------------------ -------------------- ------------------------------------------ C:\APP\ORACLE\ADMIN\SALMAN12C\WALLET     OPEN_NO_MASTER_KEY             PASSWORD SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY salman12 WITH BACKUP USING 'initial_backup' CONTAINER = ALL ;

Related Articles

• Configuring Transparent Data Encryption (TDE) in 11g
• Configuring Transparent Data Encryption (TDE) in 12c

TDE Related Error Messages

• ORA-46630
• ORA-46633
• ORA-46658
• ORA-28354
• ORA-46661
• ORA-28365