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:
- Modify the SQLNET.ORA file to contain the location of the wallet:
123
ENCRYPTION_WALLET_LOCATION=
(SOURCE=(METHOD=FILE) (METHOD_DATA=
(DIRECTORY=/u01/app/oracle/product/12.1.0.1/db_1/network/admin)))
- Create the wallet file (ewallet.p12) with the ALTER SYSTEM command:
1
SQL>
alter
system
set
encryption
key
identified
by
Mereba;
- Enable encryption:
1
SQL>
alter
system
set
encryption wallet
open
identified
by
Mereba;
Ezana Answered question 30/11/2022