Using Instant Client with Oracle Database Exadata Express Cloud Service

Connecting C and C++ applications with Instant Client

Instant Client 12.2 allows C and C++ applications to connect to Oracle Database Exadata Express Cloud Service. Network security is enforced by using an Oracle Wallet, which can be downloaded from the database service.

1. Download and Install Instant Client 12.2

Obtain Instant Client 12.2 by downloading the 'basic' package for the desired architecture:

Unzip the 'basic' or 'basiclite' package, for example to C:\instantclient_12_2 or /home/myuser/instantclient_12_2.

On Windows, add C:\instantclient_12_2 to the PATH variable in the "System variables" section of the Environment Variables pane. On Windows 8 this can be accessed by navigating to Control Panel>System>Advanced System Settings>Environment Variables. If you have multiple versions of Oracle libraries installed, make sure the new directory occurs first in the path.

Make network and network/admin subdirectories in the Instant Client directory and unzip the client credentials there, for example so the files are in the C:\instantclient_12_2\network\admin, /home/myuser/instantclient_12_2/network/admin or /usr/lib/oracle/12.2/client64/lib/network/admin directory.

Secure the files so that only users who are authorized to connect to the Exadata Express service have access to them. By default, Oracle recommends granting permissions only to the file owner.

3. Run Your Application

Update your application connection code.

Use the Oracle network service name given in the unzipped tnsnames.ora file. For example, use dbaccess as the connect string. Alternatively, change the connect string in tnsnames.ora to match the string used by your application.

Use your Oracle Database Exadata Express database username and password. See Creating Database Schemas if you need to create a user.