Oracle Wallets
Oracle Wallet is a container/repository that stores credentials such as certificates, certificate requests, and private keys, with oracle wallets we can also connect to a particular database schema without username, password instead just using a connect string with TNS ALIAS name, the username and password of the schema are encrypted and stored in oracle wallets.
The following will demonstrate how to configure schema passwords with oracle wallets.
STEP 1:
Create a directory to store the wallets and use the below command to create a wallet, it will prompt for a password.
mkstore -wrl <location of the wallet> -create
STEP2:
Make sure your listener is up and running and configure TNS entry and created a database
STEP3:
Configure SQLNET.ORA file with the parameters WALLET_OVERRIDE and WALLET_LOCATION.
wallet_location is the place where the wallets are created and stored, wallet_override will override the database schema credentials with the credentials created and stored in the wallet,
STEP4:
created a database user for configuring wallets,
STEP5:
Configure the schema password with the created wallet in this way the schema passwords are stored in the wallets.
mkstore -wrl <wallet_location> -createCredential <TNS_ALIAS> <SCHEMA_NAME>
When we execute the above command it will prompt us to enter a secret password which is noting but the database schema password and wallet password which was created at the time of wallet creation.
STEP6:
We can now directly connect to the schema by providing TNS ALIAS as sqlplus /@TNS_ALIAS and not providing username and password.
NOTE:For multiple schemas we should have a separate TNS Entry for each schemas and configure the password with wallets.
