Wallets

Oracle wallets

For credentials stored in oracle wallets, or auto-login oracle wallets use:

{
  "DEV": {
    "users": [
      {
        "user": "hr",
        "walletConnectString": "HR_TNSNAMES"
      },
      {
        "user": "dept",
        "walletConnectString": "DEPT_TNSNAMES"
      }
    ]
  }
}

TNSNAMES and Oracle Wallet

An autologin oracle wallet tied to the local machine can be created as follows:

wallet create -wallet "C:\#PATH_ORACLE#\oracle_home\network\admin" -pwd "PASSWORD" -auto_login_local

Create your tnsnames.ora as normal:

TNS_CONNECTION_NAME=
(description=
(address_list=
(address = (protocol = TCP)(host = yourhost)(port = yourport))
)
(connect_data =
(service_name=yourservicename)
)
)

Add an auto login credential to the wallet:

mkstore -wrl "C:\#PATH_ORACLE#\oracle_home\network\admin" -createCredential TNS_CONNECTION_NAME USER_NAME PASSWORD

Connection with sqlplus:

sqlplus /@TNS_CONNECTION_NAME

Remember to have proper environment variables in order to use sqlcl or sqlplus:

ORACLE_HOME=C:\#PATH_ORACLE#\oracle_home
TNS_ADMIN=C:\#PATH_ORACLE#\oracle_home\network\admin
SQLCL_HOME=C:\#PATH_ORACLE#\sqlcl
PATH=C:\#PATH_ORACLE#\sqlcl\bin;C:\Oracle\instantclient;C:\Oracle\wallet_manager