Fast DBA: ORA-28368: cannot auto-create wallet

Problem:

Trying to create the encryption key and hence the wallet file for the first time fails with the following errors:

SQL> alter system set encryption key authenticated by "password";

ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "password"

ERROR at line 1:

ORA-28368: cannot auto-create wallet

SQL> alter system set encryption key authenticated by "password";

alter system set encryption key authenticated by "password"

ERROR at line 1:

ORA-28353: failed to open wallet

Solution:

1. Create a directory named wallet in $ORACLE_BASE/admin/$ORACLE_SID/wallet:

$ mkdir –p $ORACLE_BASE/admin/$ORACLE_SID/wallet

2. Append the following entry to the sqlnet.ora file:

ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=$ORACLE_BASE/admin/$ORACLE_SID/wallet )))

3. Create and open wallet using sqlplus:

SQL> alter system set encryption key identified by "my_password";

SQL> ! ls -l /u01/oracle/admin/testdb/wallet

total 4

-rw-r--r-- 1 oracle oinstall 1309 Mar 17 13:06 ewallet.p12

Note #1: V$ENCRYPTION_WALLET displays information on the status of the wallet and the wallet location for transparent data encryption.

SQL> set linesize 200

COLUMN STATUS FORMAT A15

COLUMN WRL_PARAMETER FORMAT A55

select STATUS,WRL_PARAMETER

from V$ENCRYPTION_WALLET;

STATUS WRL_PARAMETER

--------------- -------------------------------------------------------

CLOSED /u01/oracle/admin/testdb/wallet

I hope this helps.

Please feel free to leave your questions or suggest improvements to this section.

Fast DBA