1. Choose Method Use Parcels and click More Options.
2. Click and add the URL for your Oracle Remote Parcel Repository:
   
   
3. Click Save Changes.
4. Select the newly added radio button by ORACLE_INSTANT_CLIENT and click Continue.
   
   

   The Oracle parcel is downloaded, distributed, and activated at Cluster Installation, step 6 (Installing Selected Parcels).
   
   

1. Select Use Custom Database.
2. Under Hue, set the connection properties to the Oracle database.
     Note: Copy and store the password for the Hue embedded database (just in case).

   Database Hostname (and port): <fqdn of host with Oracle server>:1521
   Database Type (or engine): Oracle
   Database SID (or name): orcl
   Database Username: hue
   Database Password: <hue database password>

3. Click Test Connection and click Continue when successful.
   
   

1. Go to Clusters > Hue > Configuration.
2. Filter by Category, Hue-service and Scope, Advanced.
3. Add support for a multi-threaded environment by setting Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini:

   [desktop]
   [[database]]
   options={"threaded":true}

4. Click Save Changes.

1. In Cloudera Manager, navigate to Cluster > Hue.
2. Select Actions > Stop.
     Note: If necessary, refresh the page to ensure the Hue service is stopped: .

1. Select Actions > Dump Database.
2. Click Dump Database. The file is written to /tmp/hue_database_dump.json on the host of the Hue server.
3. Log on to the host of the Hue server in a command-line terminal.
4. Edit /tmp/hue_database_dump.json by removing all objects with useradmin.userprofile in the model field. For example:

   # Count number of objects
   grep -c useradmin.userprofile /tmp/hue_database_dump.json

   vi /tmp/hue_database_dump.json

   {
     "pk": 1,
     "model": "useradmin.userprofile",
     "fields": {
       "last_activity": "2016-10-03T10:06:13",
       "creation_method": "HUE",
       "first_login": false,
       "user": 1,
       "home_directory": "/user/admin"
     }
   },
   {
     "pk": 2,
     "model": "useradmin.userprofile",
     "fields": {
       "last_activity": "2016-10-03T10:27:10",
       "creation_method": "HUE",
       "first_login": false,
       "user": 2,
       "home_directory": "/user/alice"
     }
   },

1. Configure Database connections:
   • Go to Hue > Configuration and filter by category, Database.
   • Set database properties and click Save Changes:

   Hue Database Type (or engine): Oracle
   Hue Database Hostname: <fqdn of host with Oracle server>
   Hue Database Port: 1521
   Hue Database Username: hue
   Hue Database Password: <hue database password>
   Hue Database Name (or SID): orcl

2. Add support for a multi-threaded environment:
   • Filter by Category, Hue-service and Scope, Advanced.
   • Set Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini and click Save Changes:

   [desktop]
   [[database]]
   options={"threaded":true}

1. Select Actions > Synchronize Database
2. Click Synchronize Database.

  Important: All user tables in the Hue database must be empty. You cleaned them at step hue_dbs_oracle_pkg.html#concept_t3s_bkp_zw_unique_1__orcl_clean_hue_tables_unique_3 of Create Hue Database. Ensure they are still clean.

sqlplus hue/<your hue password> < delete_from_tables.ddl

1. Navigate to Cluster > Hue.
2. Select Actions > Start, and click Start.
3. Click Hue Web UI to log on to Hue with a custom Oracle database.