Using Hue with Oracle

Set the properties as shown in the HUE DATABASES section under CONFIGS, then run metastoresync to set up Hue with the Oracle database.

DB FLAVOUR : Oracle
Database Name : (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<oracle database host>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<service name>)))
Database Username : <user name for hue>
Database Password : <database password for hue>
Hue Metastore Host : <oracle database host>
Hue Metastore Port : <oracle database port, default : 1521 >
Database Options : {"threaded": true}

The below Image is for reference.

Miscellaneous

Follow the below steps to create a Hue user or schema.

## OPENING SHELL TO ORACLEDB
[oracle@oracle1]$ sqlplus / as sysdba

## CONNECT TO CDB
ALTER SESSION SET CONTAINER=ORCLPDB1;
## QUERIES TO CREATE USER/SCHEMA
CREATE USER hue IDENTIFIED BY ambari_password default tablespace "USERS" temporary tablespace "TEMP";
GRANT unlimited tablespace to hue;
GRANT create session to hue;
GRANT create TABLE to hue;
GRANT create SEQUENCE to hue;