How to configure Auto Login wallet in Oracle

 

Step1> Check the Wallet's Current Status

SQL> set linesize 200

SQL>col WALLET_DIR for a32
SQL>col status for a21

select STATUS,WRL_PARAMETER WALLET_DIR,WALLET_TYPE from V$ENCRYPTION_WALLET;
STATUS                WALLET_DIR                       WALLET_TYPE
--------------------- -------------------------------- ------------------------------------------------------------
OPEN                  +DATA1/CDB/wallet/           PASSWORD

1 row selected.

Step2> Create local Auto Login keyStore from existing keyStore

SQL> ADMINISTER KEY MANAGEMENT CREATE LOCAL AUTO_LOGIN KEYSTORE FROM KEYSTORE  '+DATA1/CDB/wallet/' IDENTIFIED BY "xxxxxx";

keystore altered.

Step3> Close the Password Wallet

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE IDENTIFIED BY "xxxx" CONTAINER=ALL;

keystore altered.

Step4> Check the Status of Auto Login Wallet

select STATUS,WRL_PARAMETER WALLET_DIR,WALLET_TYPE from V$ENCRYPTION_WALLET;

STATUS                WALLET_DIR                       WALLET_TYPE
--------------------- -------------------------------- ------------------------------------------------------------
OPEN                  +DATA1/CDB/wallet/           LOCAL_AUTOLOGIN

1 row selected.