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
Post a Comment