Configure Database Wallet
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.