Connect to Autonomous AI 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 AI Database Dedicated Workshop.

SQLPlus is a command-line interface used to enter SQL commands. SQLPlus connects to an Oracle AI Database.

To be able to connect SQLPlus to an Autonomous AI Database, the system running SQLPlus must have network access to the Autonomous AI Database. This can be achieved using either of the following ways:

• By Configuring a development system to access the database.

• By setting proper network routes with VPN (Fast connect or VPN as a Service) or any VCN peering if the compute host is in another VCN.

To install and configure the client and connect to an Autonomous AI 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 Content

About Connecting to Autonomous AI Database on Dedicated Exadata Infrastructure