After Enabling Oracle Big Data SQL 3.0.1 on BDA 4.5/4.6/4.7 Cloudera Manager shows Big Data SQL as "Green" but Each Big Data SQL Node Has a Process Status Error

(Doc ID 2157831.1)

Last updated on APRIL 18, 2017

Applies to:

Big Data Appliance Integrated Software - Version 4.5.0 and later
Oracle Big Data SQL - Version 3.0 and later
Linux x86-64

Symptoms

After “bdacli enable big_data_sql” completes successfully, Cloudera Manager (CM) shows Big Data SQL as a "green" service. However there is a "red" exclamation mark next to it with a number representing the number of nodes in the cluster Big Data SQL was enabled on.

Clicking on the bigdatasql service takes you to the status page of the service. 

 

“Process Status” is shown under Health Tests in Cloudera Manager.  Each node of the cluster, 18 of them in this case, reports the same "Process Status" condition.





 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms