Applications and tools connect to an Autonomous Data Warehouse instance using Oracle Net Services (also known as SQL*Net). Oracle Net Services enables a network session from a client application to an Oracle Database server.
When a network session is established, Oracle Net Services acts as the data courier for both the client application and the database. It is responsible for establishing and maintaining the connection between the client application and the database, as well as exchanging messages between them.
Oracle Net Services support a variety of connection types to the Autonomous Data Warehouse, including:
Oracle Call Interface (OCI), which is used by many applications written in C language. Examples include Oracle utilities such as Oracle SQL*Plus, SQL*Loader, and Oracle Data Pump.
Connect with SQL*Plus
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.
Before making an Oracle Call Interface(OCI), ODBC, or JDBC OCI connection, do the following:
Step1:-Install Oracle Client software version 126.96.36.199 (or higher) on your computer. Either the full Oracle Client or the Oracle Instant Client may be used. The Instant Client contains the minimal software needed to make an Oracle Call Interface connection. The Instant Client is sufficient for most applications.
Step2:-Download client credentials and store the file in a secure folder on your computer. See Download Client Credentials (Wallets) here
Step3:-Unzip/uncompress the credentials file into a secure folder on your computer.
Copy this (sqlnet.ora& tnsnames.ora) file to ?\network\admin
Step4:-Edit the sqlnet.ora file in the folder where you unzip the credentials file, replacing “?/network/admin” with the name of the folder containing the client
WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="?/network/admin"))) SSL_SERVER_DN_MATCH=yes
WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="DIRECTORY="D:\walletcloud"))) SSL_SERVER_DN_MATCH=yes
Step5:-Connect using a database user, password, and database service name provided in the tnsnames.ora file.
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.
Successfully connected using Sql*Plus.
Catch Me On:- Hariprasath Rajaram Telegram:https://t.me/joinchat/I_f4DkeGfZsxfzXxHD6gTg LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/ Facebook:https://www.facebook.com/HariPrasathdba FB Group:https://www.facebook.com/groups/894402327369506/ FB Page: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba