Configuring Database Wallet on Oracle 12c PDB: A Step-by-Step Guide

Note: These steps were performed on Oracle 12c environment, but can be followed in newer releases.

Introduction

Ensuring the security of sensitive data is a paramount concern for any database administrator. One powerful tool to achieve this in Oracle 12C PDB is the Database Wallet. This guide walks you through the process of configuring and utilizing the Oracle Database Wallet seamlessly.

Setup

HOSTNAME= iadoracletesting01

PDB_NAME= test_user

PDB_USER= test_user_ADMIN

WALLET LOCATION= /u01/app/oracle/product/12.1.0.2/db_1/wallet

 

Step 1: Create a Directory for Wallet Files

Navigate to your Oracle Home and create a dedicated directory for wallet files.

$ cd $ORACLE_HOME
$ mkdir -p wallet
$ cd wallet

 

Step 2: Set SQLNET.ORA Entry on Client

Edit the 'sqlnet.ora' file to include the wallet location and necessary configurations.

WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /u01/app/oracle/product/12.1.0.2/db_1/wallet)
)
)

SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0

 

Step 3: Create a Wallet to Hold the Credentials

Use the orapki tool to create a wallet with a specified location and password.

$ orapki wallet create -wallet “/u01/app/oracle/product/12.1.0.2/db_1/wallet” -pwd “oracle123” -auto_login_local

 

Step 4: Create a Credential Associated with a TNS Alias

Utilize the mkstore command to create a credential associated with a TNS alias.

$ mkstore -wrl “/u01/app/oracle/product/12.1.0.2/db_1/wallet” -createCredential test_user test_user_ADMIN oracle123

 

Step 5: List External Password Store

Verify the credentials stored in the wallet using the mkstore command.

$ mkstore -wrl “/u01/app/oracle/product/12.1.0.2/db_1/wallet” -listCredential

 

Step 6: Check Connection Using Wallet

Ensure successful connection using SQLPlus.

$ sqlplus

Enter user-name: /@test_user
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
…

 

Conclusion

Congratulations! You’ve successfully configured the Database Wallet on Oracle 12C PDB. This added layer of security ensures that your sensitive data is protected while maintaining convenient access.