Dec 22 2014

How to Create Oracle Wallet for Encrpytion

Category: Administration,Database SecurityFatih Acar @ 14:35

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

oracle_wallet_sqlnetora

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.

13,880 total views, 2 views today

Tags: Database Administration, Database Security, Oracle Administration, Oracle Security, Oracle Wallet

facebook comments:

Leave a Reply

Time limit is exhausted. Please reload CAPTCHA.