tests/comparison/ORACLE.txt

Contents

I. Note
II. Oracle Database server setup
III. Oracle client setup
IV. Oracle connectivity, cx_Oracle installation
TODO: config/setup
TODO: data load/migrate

I. Note

Due to licensing, we cannot distribute Oracle client binaries, and of
course we will not distribute Oracle Database. Please refer to these
guidelines if you need to use Oracle as a reference database for the
Random Query Generator.


II. Oracle Database server setup

There are lots of choices for Oracle Database. What follows are two
suggestions:

http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

https://hub.docker.com/r/wnameless/oracle-xe-11g/

Follow their instructions for installation and setup. If you can use
sqlplus or some other shell to successfully "select 1 from dual;", then
you're good to go here.


III. Oracle client setup

Use cx_Oracle.

http://cx-oracle.sourceforge.net/

Note: Installing this via pip or similar means won't work until you have
first installed prerequisites.

1. Install Oracle instant-client

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

After you choose your architecture, you need

  1. the basic client
  2. the SDK

You will likely have to register on the Oracle site to download the
instant client binaries. As of this writing, install instructions are at
the bottom of the page once you make your architecture choice.

2. Additional dependent packages in distribution

It's possible either when trying to install cx_Oracle, import it, or use
it, you will get some linker error. I cannot predict what libraries you
do and don't have. Here's a list of Linux distributions and known
package dependencies:

Ubuntu 14.04.2 LTS
libaio1

3. Ensure impala-python is working. It may be enough to simply run:

   $ impala-python

   Getting it working is out of scope of this document.

4. Run these commands to install cx_Oracle into the impala-python
   virtual environment:

   $ source "${IMPALA_HOME}"/infra/python/env/bin/activate
   (env)$ pip install cx_Oracle==5.2.1
   (env)$ deactivate

If pip install fails, double check the following:
  * ORACLE_HOME environment variable
  * LD_LIBRARY_PATH environment variable

BUILD.txt packaged with cx_Oracle has more instructions for installing
cx_Oracle.


IV. Oracle connectivity, cx_Oracle installation

Verify cx_Oracle can connect to your Oracle Database. Edit appopriately
and then run:

   $ "${IMPALA_HOME}"/tests/comparison/util/verify-oracle-connection.py