Enabling Oracle Data Connections

Availability Notes:
  • To Enable the Oracle Data connection, you must download and install two RPMs: for Oracle Instant Client, and for cx_Oracle. The packages for enabling Oracle Data Connections are for RHEL 6.x / CentOS 6.x, and RHEL 7.x / CentOS 7.x.

To enable Oracle connections, follow these steps. Our example is for Oracle 11g on RHEL or CentOS 6.x.

  1. Obtain the Oracle Instant Client RPM from the following URL: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

    • For Oracle 11g, use oracle-instantclient11.2-basic-

    • For Oracle 12c, use oracle-instantclient12.1-basic-

  2. Obtain the cx_Oracle RPM from the following URL: https://pypi.python.org/pypi/cx_Oracle/5.2.1

    • For Oracle 11g on RHEL 6.x or CentOS 6.x, use cx_Oracle-5.2.1-11g-py26-1.x86_64.rpm

    • For Oracle 11g on RHEL 7.x or CentOS 7.x, use cx_Oracle-5.2.1-11g-py27-1.x86_64.rpm

    • For Oracle 12c on RHEL 6.x or CentOS 6.x, use cx_Oracle-5.2.1-12c-py26-1.x86_64.rpm

    • For Oracle 12c on RHEL 7.x or CentOS 7.x, use cx_Oracle-5.2.1-12c-py27-1.x86_64.rpm

  3. Copy (scp, and so on) the two RPMs to the Arcadia Visualization Server.
  4. Ensure the correct RPMs are in the current directory. A directory listing request should show something similar to the following:

  5. Install the RPMs (and any dependencies).

    sudo yum install cx_Oracle-5.2.1-11g-py26-1.x86_64.rpm oracle-instantclient11.2-basic-

For the most recent configuration steps, see the following links that Oracle maintains for its users: