Connect to Autonomous Database on Dedicated Exadata Infrastructure with SQL*Plus

Tip:

For a "try it out" alternative that demonstrates these instructions, run Task 4: Connect to your autonomous DB using SQL Worksheets from Database Actions, SQLCL and SQL Plus from Lab 2: Configure a Development System in the Oracle Autonomous Database Dedicated Workshop.
SQL*Plus is a command-line interface used to enter SQL commands. SQL*Plus connects to an Oracle database.
To be able to connect SQL*Plus to an Autonomous Database, the system running SQL*Plus must have network access to the Autonomous Database. This can be achieved using either of the following ways:

To install and configure the client and connect to an Autonomous Database using SQL*Plus, do the following:

  1. Prepare to connect by following the instructions in Prepare for ODBC and JDBC Oracle Call Interface (OCI) Connections.
  2. Connect using a database user, password, and database service name provided in the tnsnames.ora file.

    For example:

    sqlplus sales_trans@atpc1_low  

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Jan 18 09:50:13 2021
Version 18.5.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Enter password:
Last Successful login time: Mon Jan 18 2021 09:33:57 +00:00

Connected to:
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.0.0.0.0

SQL>

    Note:

    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.

Related Topics