Step 1: Configure the Wallet Location

You designate the directory location for the wallet in the sqlnet.ora file. You perform this step once.

To configure the wallet location:  

1. Create a directory in the $ORACLE_HOME directory in which to store the wallet.

   For example, create a directory called ORA_WALLETS in the C:\oracle\product\11.2.0\db_1 directory.

2. Create a backup copy of the sqlnet.ora file, which by default is located in the $ORACLE_HOME/network/admin directory.

3. At the end of the sqlnet.ora file, add code similar to the following, where ORA_WALLETS is the name of the directory where you plan to store the wallet:

   ENCRYPTION_WALLET_LOCATION=
    (SOURCE=
     (METHOD=file)
      (METHOD_DATA=
       (DIRECTORY=C:\oracle\product\11.2.0\db_1\ORA_WALLETS)))
   

4. Save and close the sqlnet.ora file.

5. If the compatibility of the database is set to a release earlier than Oracle Database Release 10.2, then restart the database.

   1. Log in to SQL*Plus and then check the database compatibility.

      sqlplus sys as sysdba
      Enter password: password
      

      SQL*Plus starts, connects to the default database, and then displays a SQL> prompt.

      For detailed information about starting SQL*Plus, see Starting SQL*Plus and Connecting to the Database.

   2. Check the value of the COMPATIBLE parameter.

      SHOW PARAMETER COMPATIBLE
      
      NAME                       TYPE           VALUE
      -------------------------- -------------- --------------------
      compatible                 string         11.2.0
      

   3. If the value is greater than 10.2, then you can go to Step 2: Create the Wallet. If the value is less than 10.2, then restart the database as follows.

      SHUTDOWN IMMEDIATE
      STARTUP