Configuring high availability support for Oracle RAC database

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

  • You must have Oracle RAC installed on your CDP cluster.
  • You must have configured Oracle as Hue’s backend database.
  1. Log in to Cloudera Manager as an Administrator.
  2. Go to Clusters > Hue > Configuration > Category > Database.
    The database configurations are displayed.
  3. 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***])))
  4. Click Save Changes.
  5. Restart the Hue service.