How to enable an oracle wallet

An oracle wallet is a feature of oracle advanced security option and it is used for encryption of oracle database table columns and tablespaces. The wallet is an operating system file that contains encryption keys.

Below are the steps to enable oracle wallet:

1. Modify the SQLNET.ORA file to contain the location of the wallet:

   ENCRYPTION_WALLET_LOCATION=
    (SOURCE=(METHOD=FILE) (METHOD_DATA=
    (DIRECTORY=/u01/app/oracle/product/12.1.0.1/db_1/network/admin)))

2. Create the wallet file (ewallet.p12) with the ALTER SYSTEM command:

   SQL> alter system set encryption key identified by Mereba;

3. Enable encryption:

   SQL> alter system set encryption wallet open identified by Mereba;