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 Data Warehouse 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 sales_dwh@adwc1_low SQL*Plus: Release 188.8.131.52.0 - Production on Wed Apr 3 15:09:53 2019 Version 184.108.40.206.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Enter password: Last Successful login time: Wed Apr 03 2019 14:50:39 -07:00 Connected to: Oracle Database 18c Enterprise Edition Release 220.127.116.11.0 - Production Version 18.104.22.168.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 an Autonomous Data Warehouse 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.