본문 바로가기

Database/Oracle

oracle wallet open...

$ cat sqlnet.ora
ENCRYPTION_WALLET_LOCATION=(SOURCE =(METHOD = FILE)(METHOD_DATA =(DIRECTORY =/ORA19/app/oracle/product/19.0.0/db_1/network/admin/WALLET)))
[oracle@master WALLET]$ chmod 700 /ORA19/app/oracle/product/19.0.0/db_1/network/admin/WALLET
[oracle@master WALLET]$ chown -R oracle:oinstall /ORA19/app/oracle/product/19.0.0/db_1/network/admin/WALLET


ADMINISTER KEY MANAGEMENT CREATE KEYSTORE '/ORA19/app/oracle/product/19.0.0/db_1/network/admin/WALLET/' identified by "sampler123";

 

ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "sampler123" CONTAINER=ALL;

ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY  "sampler123"  WITH BACKUP CONTAINER=ALL;
ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE IDENTIFIED BY "sampler123" CONTAINER=ALL;

 

QL> select * from v$encryption_wallet;

WRL_TYPE
--------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS                         WALLET_TYPE          WALLET_OR KEYSTORE FULLY_BAC
------------------------------ -------------------- --------- -------- ---------
    CON_ID
----------
FILE
/ORA19/app/oracle/product/19.0.0/db_1/network/admin/WALLET/
OPEN                           PASSWORD             SINGLE    NONE     NO
         1