7.1. Using Hue with Oracle

To set up Hue to use an Oracle database:

Create a new user in Oracle and grant privileges to manage this database using the Oracle database admin utility:

# sqlplus sys/root as sysdba 
CREATE USER $HUEUSER IDENTIFIED BY $HUEPASSWORD default tablespace “USERS” temporary tablespace “TEMP”; 
GRANT CREATE TABLE, CREATE SEQUENCE, CREATE PROCEDURE, CREATE TRIGGER, CREATE SESSION, UNLIMITED TABLESPACE TO $HUEUSER;

Where $HUEUSER is the Hue user name and $HUEPASSWORD is the Hue user password.

Open the /etc/hue/conf/hue.ini file and edit the [[database]] section (modify for your Oracle setup).

[[database]]
engine=oracle 
host=$DATABASEIPADDRESSORHOSTNAME
port=$PORT 
user=$HUEUSER 
password=$HUEPASSWORD 
name=$DBNAME

Install the Oracle instant clients and configure cx_Oracle.
1. Download and extract the instantclient-basic-linux and instantclient-sdk-linux Oracle clients from Oracle's download site.
2. Set your ORACLE_HOME environment variable to point to the newly downloaded client libraries.
3. Set your LD_LIBRARY_PATH environment variable to include ORACLE_HOME.
4. Create symbolic link for library expected by cx_Oracle:
```
ln -sf libclntsh.so.11.1 libclntsh.so
```
Install or Upgrade the DJango Python library south:
```
pip install south --upgrade
```
Synchronize Hue with the external database to create the schema and load the data:
```
/usr/lib/hue/build/env/bin/hue syncdb --noinput
```
Start Hue.
```
#/etc/init.d/hue start
```

Legal notices