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 fix Oracle SQL Developer connection issue "Got minus one from a read call"

Few Important steps of Oracle Database Clone

How to troubleshoot Long Running Concurrent Request in EBS 12.2