Wednesday, March 22, 2017

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;

No comments:

Popular Posts - All Times