Connect SQL*Plus with a Wallet (mTLS)

SQL*Plus is a command-line interface used to enter SQL commands. SQL*Plus connects to an Oracle database.

To install and configure the client and connect to the Autonomous JSON Database using SQL*Plus with client credentials (mTLS), do the following:

1. Prepare for Oracle Call Interface (OCI), ODBC and JDBC OCI Connections. See Prepare for Oracle Call Interface (OCI), ODBC, and JDBC OCI Connections with Wallets (mTLS).
2. Connect using a database user, password, and database TNS name provided in the tnsnames.ora file.

   For example:

   sqlplus ads_user@adsc_medium
   
   SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 23 15:08:48 2020
   Version 19.8.0.0.0
   
   Copyright (c) 1982, 2020, Oracle.  All rights reserved.
   
   Enter password:
   Last Successful login time: Wed Nov 18 2020 12:36:56 -08:00
   
   Connected to:
   Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
   Version 19.5.0.0.0
   
   SQL>

Notes:

• The Oracle Wallet is transparent to SQL*Plus because the wallet location is specified in the sqlnet.ora file. This is true for any Oracle Call Interface (OCI), ODBC, or JDBC OCI connection.

• If you are connecting to a JSON database using Microsoft Active Directory credentials, then connect using an Active Directory user name in the form of "AD_domain\AD_username" (double quotes must be included), and Active Directory user password. See Use Microsoft Active Directory with Autonomous Database for more information.