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