Oracle Wallet Manager is a password protected stand-alone Java application tool used to maintain security credentials and store SSL related information such as authentication and signing credentials, private keys, certificates, and trusted certificates.
1- Create Wallet Directory
[oracle@testdb ~] cd $ORACLE_HOME
[oracle@testdb db_home] mkdir -p ORA_WALLETS
2- Write Wallet Location Information in sqlnet.ora File
[oracle@testdb ~] cd $ORACLE_HOME/network/admin
[oracle@testdb db_home] vi sqlnet.ora
3- Configure Wallet in Oracle Database
[oracle@testdb ~] sqlplus / as sysdba
SQL> ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY “masterpassword”;
You can use wallet for encryption operations.
If you want to open or close wallet, you can use below alter system commands.
To Open:
ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY “masterpassword”;
To Close:
ALTER SYSTEM SET ENCRYPTION WALLET CLOSE IDENTIFIED BY “masterpassword”;
Important : When you restart database, you have to open manually wallet with alter system command.
If you use transparent data encryption, you have to open wallet to read or write operation on encrypt column or tablespace.