How to open and close wallet for Oracle Databse 11g

1.Add the following entries in the $ORACLE_HOME/network/admin/sqlnet.ora (Note it is the DB's ORACLE_HOME not the GRID'S ORACLE_HOME)
Make sure that the DIR you specified in the sqlnet.ora exist on the host, Or you will encounter error when creating wallet.

WALLET_LOCATION =

  (SOURCE =

    (METHOD = FILE)

    (METHOD_DATA =

      (DIRECTORY= /u01/app/oracle/product/11.2.0.3/dbhome_1/network/admin)

    )

   )

ENCRYPTION_WALLET_LOCATION =

  (SOURCE =

    (METHOD = FILE)

    (METHOD_DATA =

      (DIRECTORY= /u01/app/oracle/admin/poddb/wallet)

    )

   )
2. Restart the listener , so that your previous configuration can take effect.
  
$ORACLE_HOME/bin/srvctl stop listener 
$ORACLE_HOME/bin/srvctl start listener 

3. Make a verify whether your wallet location config takes effect.
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=***

sqlplus / as sysdba

SQL> select wrl_type wallet,status,wrl_parameter wallet_location from v$encryption_wallet;

--the wallet_location must be the same as the value in the sqlnet.ora

4. Create and open the wallet in the open read/wirte mode.
   
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "welcome1";


5.Reopen the wallet. When the instance is restarted or the wallet is closed, you must reopen the wallet in mounted mode.

startup mount;

ALTER SYSTEM SET ENCRYPTION WALLET IDENTIFIED BY "welcome1";

alter database open;


6.Close the wallet

ALTER SYSTEM SET ENCRYPTION WALLET CLOSE IDENTIFIED BY "welcome1";