DBD::Oracle Installation - N2C5 EDR Analytics

DBD::Oracle Installation Guide

This guide describes how to install the necessary components to integrate with a remote Oracle DB database instance with the N2C5 EDR Analytics Module.

You must install these Oracle DB integration components if you wish to use any of the following features of the analytics module ETL processor.

OCNCC DB Extractor

Note that if N2C5 has previously been installed, then you will already have the necessary Oracle components installed.

Pre-Requisites

The target system is Ubuntu (Debian) 12.04 or newer.
The target system is 64-bit.
The target system has package repository access such that apt-get install works. Without package repository access any missing pre-requisite packages will need to be manually copied to the target system and installed using dpkg.

Oracle Instant Client Installation

Access the Oracle Instant Client download page at:

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

Accept the OTN Licence Agreement.

Download the "Basic", "SqlPlus" & "SDK/Devel" packages. Note that vErsions may differ.

oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-devel-12.1.0.1.0-1.x86_64.rpm

Install the alien program on the target server:
```
sudo apt-get install alien
```
Use the alien program to convert the .rpm packages into .deb format. Note that this step may be done on a representative machine that is not the target machine, but the software versions, OS and architecture must all be equivalent.
```
sudo alien oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64.rpm
sudo alien oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.x86_64.rpm
sudo alien oracle-instantclient12.1-devel-12.1.0.1.0-1.x86_64.rpm
```

Install the .deb packages.

sudo dpkg --install oracle-instantclient12.1-basic_12.1.0.1.0-2_amd64.deb
sudo dpkg --install oracle-instantclient12.1-sqlplus_12.1.0.1.0-2_amd64.deb
sudo dpkg --install oracle-instantclient12.1-devel_12.1.0.1.0-2_amd64.deb

Set the ORACLE_HOME environment variable.

export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib

Test the software installed. Connect to an existing SMF database.
```
sqlplus64 smf/smf@<hostname-or-ip-address>/SMF
```
If you see the following error:
```
sqlplus64: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
```
Then you must install libaio with the command
```
sudo apt-get install libaio1
```
If you receive an error:
```
ORA-21561 OID generation failed
```
Ensure you add the output of hostname to /etc/hosts, e.g. if running hostname gives richards.nsquared.co.nz, add a line such as:
```
10.30.5.105 richards.nsquared.co.nz
```
to /etc/hosts

Install and Build DBD::Oracle

Retrieve and install the files via cpan:

export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
sudo cpan
install DBD::Oracle

If you see the following error (this may occur on Ubuntu 14.04 LTS):

Unable to locate an oracle.mk or other suitable *.mk

add a link to the demo.mk file to allow the installer to see it:

ln -s /usr/share/oracle/12.1/client64/demo/demo.mk /usr/share/oracle/12.1/client64/.

and re-run the installation command install DBD::Oracle.