ORA-46633: creation of a password-based keystore failed

You can face this error while creating a keystore but you have specified a wrong keystore location while executing the statement.

SQL> ADMINISTER KEY MANAGEMENT CREATE KEYSTORE 'C:\APP\ORACLE\ADMIN\WALLET\SALMAN12C\WALLET' IDENTIFIED BY salman12; ADMINISTER KEY MANAGEMENT CREATE KEYSTORE 'C:\APP\ORACLE\ADMIN\SALMAN12C\WALLET' IDENTIFIED BY salman12 * ERROR at line 1: ORA-46633: creation of a password-based keystore failed

Solution:
1. Check if you have properly set keystore location in SQLNET.ORA file by using “ENCRYPTION_WALLET_LOCATION” parameter.

ENCRYPTION_WALLET_LOCATION=                (SOURCE=                (METHOD=FILE)(METHOD_DATA=(DIRECTORY=C:\APP\ORACLE\ADMIN\WALLET\SALMAN12C))                )

2. Check if destination directory for keystore exists. For this example, the location is “C:\APP\ORACLE\ADMIN\WALLET\SALMAN12C“ as specified in sqlnet.ora file.

3. Check if you have specified keystore destination directory correctly in the statement being executed to create the keystore.

ADMINISTER KEY MANAGEMENT CREATE KEYSTORE 'C:\APP\ORACLE\ADMIN\WALLET\WALLET\SQLMAN12C' IDENTIFIED BY salman12;

 Related Articles

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

TDE Related Error Messages

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