Prepare for Oracle Call Interface (OCI), ODBC, and JDBC OCI Connections
You prepare for Oracle Call Interface (OCI), ODBC, and JDBC OCI connections by downloading and installing Oracle Instant Client and then downloading the client credentials for your Autonomous Database and making them available to Oracle Instant Client.
-
Download and install the Oracle Instant Client basic package for your system's OS and architecture:
-
Oracle Linux:
-
Enable the Instant Client channel:
yum -y install oracle-release-el7
-
Download and install the Instant Client 19.3 basic package:
yum -y install oracle-instantclient19.3-basic
-
-
Other OSes and architectures:
-
Go to the Oracle Instant Client Downloads page and select the download for your system's OS and architecture.
-
On the download page, accept the Oracle Technology Network License Agreement, download the latest version of the Basic Package, and then install it by following the instructions at the bottom of the download page.
-
-
-
Download the zip file containing client credentials for your database to a secure directory on your computer.
This zip file is available for download from the database's Details page in the Oracle Cloud console. See Download Client Credentials for information on downloading client credentials for Autonomous Database.
-
After downloading the zip file, follow these steps:
-
Unzip the client credentials zip file.
-
Edit the
sqlnet.ora
file provided in the client credentials, replacing"?/network/admin"
with the full path of the directory where you unzipped the client credentials; for example, change:(DIRECTORY="?/network/admin")
to:
(DIRECTORY="/users/jdoe/adbcredentials")
-
Create the
TNS_ADMIN
environment variable, setting its value to the full path of the directory where you unzipped the client credentials.
-
Parent topic: Development Workflow