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 Database using SQL*Plus, do the following:
- Prepare for Oracle Call Interface (OCI), ODBC and JDBC OCI Connections. See Prepare for Oracle Call Interface (OCI), ODBC, and JDBC OCI Connections.
- Connect using a database user, password, and database
TNS name provided in the
sqlplus adb_user@db2020adb_medium SQL*Plus: Release 126.96.36.199.0 - Production on Mon Nov 23 15:08:48 2020 Version 188.8.131.52.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 184.108.40.206.0 - Production Version 220.127.116.11.0 SQL>
The Oracle Wallet is transparent to SQL*Plus because the wallet location is specified in the
sqlnet.orafile. This is true for any Oracle Call Interface (OCI), ODBC, or JDBC OCI connection.
If you are connecting to a 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.