Test Database Connection Fails | Error: Unable to connect to database with provided credential |Oracle DB

0 votes
0 views
asked Aug 28, 2017 in Hadoop by admin (4,410 points)
SummaryTest Database Connection does not work for Oracle DBs that require service name instead of SID
Applies To
  • Cloudera Manager
  • Add Hue service wizard
  • Oracle using service name
Symptoms

During the adding of a Hue service to the Cluster, the database step of the wizard is failing with the following error:

Unable to connect to database with provided credential. Able to find the Database server, 
but not the specified database. Please check if the database name is correct and 
make sure that the user can access the database.

Cause

The Hue service wizard does not currently support using the service name instead of SID for connectivity.

Instructions

Workaround:

  1. Install a temp different database instance (such as MySql)  and create a Hue database.
  2. Initiate the Add Hue wizard and provide the temp database and credentials. This will allow you to get past the wizard and create the Hue service.
  3. Modify the new Hue instance by setting the following: From Cloudera Manager’s home screen Hue > Configuration:
    1. CATEGORY > Database:
      Hue Database Type=Oracle
      Hue Database Hostname=<fqdn of host with Oracle server>           
      Hue Database Port=1521
      Hue Database Username=<hueusername>
      Hue Database Password=<hue database password>
      Hue Database Name=<oracle_service_name>
    2. CATEGORY > Advanced > Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini
      [desktop]
      [[database]]
      port=0
  4. Start Hue.

Please log in or register to answer this question.

...