Wallets Oracle 11g Database

  $ echo $ORACLE_HOME
  $ echo $ORACLE_BASE
  $ echo $DB_UNIQUE_NAME
  make sure all above environment variables are set properly
  
  $ mkdir $ORACLE_BASE/admin/DB_UNIQUE_NAME/wallet
  
  $ orapki wallet create -wallet $ORACLE_BASE/admin/DB_UNIQUE_NAME/wallet -auto_login -pwd xxxxxx
  
  "-autologin: enables autologin by that we don�t need to enable wallet when we restart
  
  $ ls $ORACLE_BASE/admin/DB_UNIQUE_NAME/wallet
  cwallet.sso ewallet.p12
  
  

How to set / find wallet path

  SQL> SELECT * FROM V$ENCRYPTION_WALLET;
  
  By default oracle checks for below paths. 
  
  $ORACLE_BASE/admin/DB_UNIQUE_NAME/wallet
  Or
  $ORACLE_HOME/admin/DB_UNIQUE_NAME/wallet

  If you are not using default path then you need to mention desired path in �sqlnet.ora� file. 
  Need to set either of these parameters �ENCRYPTION_WALLET_LOCATION� or �WALLET_LOCATION�
  
  $ vi sqlnet.ora
  
  ENCRYPTION_WALLET_LOCATION=
   (SOURCE=(METHOD=FILE)(METHOD_DATA=
   (DIRECTORY=/ora11g/wallet)))
  
  (or)
  
  WALLET_LOCATION =
   (SOURCE=(METHOD=FILE)(METHOD_DATA=
   (DIRECTORY=/ora11g/wallet)))

How to open and close wallet

  -- 11g version
  ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "XXXXXXX";
  ALTER SYSTEM SET ENCRYPTION WALLET CLOSE;

Check the Content of a Wallet

Use below command to check the content of the wallet.

 orapki wallet display -wallet /.p12> -pwd