For seamless connectivity and high availability, you can use Oracle Real Application
Clusters (RAC) database as Hue’s backend database.
The correct connection string should come from your Oracle
DBA and can be implemented only after the Hue service was installed on a working
Cloudera Base Cluster.
-
Log in to Cloudera Manager as an Administrator.
-
Go to .
The database configurations are displayed.
-
Specify the database name in the following format in the Hue
Database Name field:
(DESCRIPTION=(LOAD_BALANCE=off)(FAILOVER=on)(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS=(PROTOCOL=TCP)(HOST=[***HOSTNAME-OR-SCAN-IP***])(PORT=[***PORT***]))(CONNECT_DATA=(SERVICE_NAME=[***SERVICE-NAME***])))
-
Click Save Changes.
-
Restart the Hue service.