Thursday, April 2, 2015

ORA-28368: cannot auto-create wallet

While setting up the TDE in one of our systems, faced this issue


SQL> alter system set encryption key identified by dbawa11et;
alter system set encryption key identified by dbawa11et
*
ERROR at line 1:
ORA-28368: cannot auto-create wallet

Check the path where oracle is looking at


SQL> select * from v$encryption_wallet;

WRL_TYPE
--------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS                         WALLET_TYPE          WALLET_OR FULLY_BAC
------------------------------ -------------------- --------- ---------
    CON_ID
----------
FILE
/etc/ORACLE/WALLETS/DBNAME/
NOT_AVAILABLE                  UNKNOWN              SINGLE    UNDEFINED
         0

check if that path exists

SQL> !ls /etc/ORACLE/WALLETS/DBNAME/
ls: /etc/ORACLE/WALLETS/DBNAME/: No such file or directory

if Not , create it

:[DBNAME]oracle@server:/home/oracle
==> mkdir -p /etc/ORACLE/WALLETS/DBNAME/
mkdir: cannot create directory `/etc/ORACLE': Permission denied
:[DBNAME]oracle@server:/home/oracle
==> sudo  mkdir -p /etc/ORACLE/WALLETS/DBNAME/
:[DBNAME]oracle@server:/home/oracle
==> chown oracle:dba /etc/ORACLE
chown: changing ownership of `/etc/ORACLE': Operation not permitted
:[DBNAME]oracle@server:/home/oracle
==> sudo chown -R oracle:dba /etc/ORACLE
:[DBNAME]oracle@server:/home/oracle
==> exit


No comments:

Post a Comment