Oracle Database drivers for scripting languages including Node.js, Python, R, PHP and Ruby can connect to Oracle Database Exadata Express Cloud Service using Instant Client 18c. Network security is enforced by using an Oracle Wallet, which can be downloaded from the database service.

1. Download and Install Instant Client 18c

• Obtain the Instant Client 18c 'basic' package for your desired architecture by downloading it from the Instant Client pages. The smaller 'basiclite' package may be used instead of 'basic'. The smaller package contains only English error messages and has support for Unicode, ASCII, and Western European character sets.
  • Microsoft Windows x64 or Windows 32-bit
  • Apple macOS
  • Linux x86-64 or Linux x86
  • Solaris x86-64 or Solaris x86
  • Solaris SPARC 64-bit or Solaris SPARC 32-bit
  • AIX on POWER Systems 64-bit or AIX on POWER Systems 32-bit
  • HP-UX Itanium 64-bit or HP-UX Itanium 32-bit

  For other platforms, download using links from the Oracle Instant Client page. Review Support Note 2183770.1 for any required updates.

• If building a language API or driver from source code, the Instant Client SDK will commonly also be needed.
• Unzip the 'basic' or 'basiclite' package, for example to C:\instantclient_18_5 or /home/myuser/instantclient_18_5. If the SDK was downloaded it should be unzipped to the same directory.
• On Windows, add C:\instantclient_18_5 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.
• On Windows, install a Visual Studio Redistributable from Microsoft. For Instant Client 18c and 12.2, install the VS 2013 Redistributable. Use a 64-bit or 32-bit Redistributable to match your Instant Client architecture.
• On non-Windows platforms, create a symbolic link for libclntsh.so if one does not already exist, for example:
  Copy

       cd /home/myuser/instantclient_18_5
      ln -s libclntsh.so.18.1 libclntsh.so

  Applications and tools that use the OCCI C++ API also need the symbolic link:

  Copy

       ln -s libocci.so.18.1 libocci.so

  Set the library path:

  Copy

       export LD_LIBRARY_PATH=/home/myuser/instantclient_18_5:$LD_LIBRARY_PATH

  Instead of setting LD_LIBRARY_PATH, you could create an ldconfig configuration file if there is no other Oracle software that will be impacted:

  Copy

       sudo sh -c "echo /home/myuser/instantclient_18_5 > /etc/ld.so.conf.d/oic.conf"
      sudo ldconfig
      

  The Linux 'basic' or 'basiclite' RPMs can also be used. With these, it is not necessary to create a symbolic link.

2. Enable Oracle Network Connectivity and Download the Client Wallet

• In your web browser, navigate to the Exadata Express service console.
• If Client Access is not currently enabled, click Enable Client Access on the console.
• Click Download Client Credentials on the console to download client_credentials.zip containing your security credentials and network configuration files that will allow client access to your cloud database. Save this zip file to a secure location.
• Make network and network/admin subdirectories in the Instant Client directory, if they do not exist, and unzip the client credentials there. For example unzip the wallet so the files are in the C:\instantclient_18_5\network\admin, /home/myuser/instantclient_18_5/network/admin or /usr/lib/oracle/18.5/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.

• Alternatively, put the unzipped wallet files in a secure directory and set the TNS_ADMIN environment variable to that directory name.

3. Install Database Drivers

Follow the language-specific instructions to install database drivers using the updated Instant Client.

• To install cx_Oracle for Python, use the binaries from PyPI or follow these instructions.
• To install node-oracledb for Node.js follow these instructions.
• To install ROracle for R follow these instructions.
• To install PHP OCI8 for PHP, follow these instructions. Windows DLLs are included in PHP and are also available from PECL.
• To install PHP PDO_OCI for PHP, follow these instructions. Windows DLLs are included in PHP.
• To install ruby-oci8 for Ruby, follow these instructions.
• To install DBD::Oracle for Perl, set ORACLE_HOME and your library search path such as LD_LIBRARY_PATH or PATH to the Instant Client directory and follow these instructions.

4. 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. If you haven't created a new user, see Creating Database Schemas, or test with the administrator username PDB_ADMIN and password. Note the password is not the wallet password. See Managing the Administrator User (PDB_ADMIN) for information about the PDB_ADMIN password.

• Review Known Issues for Oracle Database Exadata Express Cloud Service.
• Run your application.