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 MARCH 01, 2019
Applies to:Big Data Appliance Integrated Software - Version 4.5.0 and later
Oracle Big Data SQL - Version 3.0 and later
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. For example in an 18 node cluster output is like below.
Clicking on the bigdatasql service takes you to the status page of the service which shows output like below:
You will see: “Process Status” shown under Health Tests in Cloudera Manager. Each node of the cluster, 18 of them in this case, reports the same "Process Status" condition. The example shows output for the starting nodes:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document