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.

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-11.2.0.4.0-1.x86_64.rpm
- For Oracle 12c, use oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
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
Copy (scp, and so on) the two RPMs to the Arcadia Visualization Server.
Ensure the correct RPMs are in the current directory. A directory listing request should show something similar to the following:
```
cx_Oracle-5.2.1-11g-py26-1.x86_64.rpm
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
```

Install the RPMs (and any dependencies).

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

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