How to set up the Oracle Wallets in Oracle Database 19C

 

The Oracle Wallet is a container or repository that stores authentication and credentials such as certificates, certificate requests, and private keys., By using this we can connect to database without providing the schema name & password, Password will be connected by using the TNS ALIES name & hence the schema are encrypted & stored in the oracle wallets.

Let us configure the schema password by using the wallets.

Create a directory to store the wallets.


Create a directory to store the password

$ mkdir -p /u01/app/wallets

Create a wallet & provide the wallet password.

$ mkstore -wrl /u01/app/wallets/ -create

Enter password: *********
Enter password again: ********

$ ll
total 8
-rw-------. 1 oracle oinstall 194 Nov 1 14:38 cwallet.sso
-rw-------. 1 oracle oinstall 0 Nov 1 14:38 cwallet.sso.lck
-rw-------. 1 oracle oinstall 149 Nov 1 14:38 ewallet.p12
-rw-------. 1 oracle oinstall 0 Nov 1 14:38 ewallet.p12.lck

Check the status of listener

$lsnrctl status listener_name;

Configure SQLNET.ORA file with WALLET_OVERRIDE & WALLET_LOCATION Parameters.

Note:   WALLET_LOCATION is where the wallets are created & stored
WALLET_OVERRIDE will override the DB schema credentials & stored in the wallet


$ cd $ORACLE_HOME/network/admin

$ vi sqlnet.ora

####WALLET_OVERRIDE PARAMETER CONFIG########

SQLNET.WALLET_OVERRIDE=TRUE
SSL_CLIENT_AUTHENTICATION=FALSE
SSL_VERSION=0

####WALLET_LOCATION PARAMETER CONFIG########

WALLET_LOCATION=
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY= /u01/app/wallets)
)
)

Connect to database & create a user to perform the wallet configuration.
$ sqlplus / as sysdba
Create a user
SQL> create user wallets identified by wallets quota unlimited on users;
User created.
Grant connect, resource privilege to user.
SQL> grant connect, resource to wallets;
Grant succeeded.
Set the schema password by using the above created wallet.

$ mkstore -wrl /u01/app/wallets/ -createCredential ora19c wallets

Your secret/Password is missing in the command line
Enter your secret/Password: 
Re-enter your secret/Password:
Enter wallet password:

SECRET PASSWORD is your above created schema password : In my case schema password is “wallets”
WALLET PASSWORD is your above created wallet password : In my case wallet password is “******”
Finally lets connect to the schema with the given TNS ALIES as sqlplus /@TNS_ALIES.

$ sqlplus /@ora19c


SQL> show user
USER is "WALLETS"

We don’t provide the username & password, Therefore this will connect directory to the schema “wallets”

Comments

Popular posts from this blog

How to drop index and before dropping it how to get the DDL.

How to fix Oracle SQL Developer connection issue "Got minus one from a read call"

How to troubleshoot Long Running Concurrent Request in EBS 12.2

PRVG-11250 : The check "RPM Package Manager database" was not performed because

Verifying Daemon “Avahi-Daemon” Not Configured And Running …FAILED (PRVG-1360)

How to write to a CSV file using Oracle SQL*Plus

ORA-00257:archiver error, connect internal only until freed

CPU Patch Analysis

Few Important steps of Oracle Database Clone

Linux OL7/RHEL7: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm