Configuring high availability support for Oracle RAC database

For seamless connectivity and high availability, you can use Oracle Real Application Clusters (RAC) database as Data Explorer backend database.

The correct connection string should come from your Oracle DBA and can be implemented only after the Data Explorer service was installed on a working Cloudera Base Cluster.

Log in to Cloudera Manager as an Administrator.
Go to Clusters > > Configuration > Category > Database.
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 HData Explorere service.