7.1. Using Hue with Oracle

To set up Hue to use an Oracle database:

  1. 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.

  2. 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 
  3. 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
  4. Install or Upgrade the DJango Python library south:

    pip install south --upgrade
  5. Synchronize Hue with the external database to create the schema and load the data:

    /usr/lib/hue/build/env/bin/hue syncdb --noinput
  6. Start Hue.

    #/etc/init.d/hue start

loading table of contents...