My Oracle Support Banner

Big Data SQL 3.2 Installation and Runtime Logs for Troubleshooting Installation Issues (Doc ID 2335081.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Big Data SQL - Version 3.2.0 and later
Linux x86-64

Purpose

This document describes how to troubleshoot Big Data SQL (BDS) 3.2 installations using the installation logs.  The note also discusses the main logs for troubleshooting runtime issues.

The examples here make use of an $ORACLE_SID of "pt1orcl" and a three node Hadoop cluster.  When mentioning the Cloudera Manager node, or Ambari node, that implies a CDH or HDP cluster respectively.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Overview
 BDS 3.2 Background on the Logs for Troubleshooting Installation and Runtime Issues
 BDS 3.2 Background on the Logs for Troubleshooting Hadoop Cluster Installation Issues
 BDS 3.2 Background on the Logs for Troubleshooting Runtime Issues
 Hadoop Cluster Installation Logs
 Installation Logs at /var/log/bigdatasql
 jaguar Installation Logs at  /var/log/bigdatsql/DM
 /var/log/bigdatasql/DM/jaguar.log
 /var/log/bigdatasql/DM/deployment_manager.log
 /var/log/bigdatasql/DM/env.log
 /var/log/bigdatasql/DM/api.log
 /var/log/bigdatasql/DM/service/bigdatasql
 jaguar Installation Logs at /var/log/bigdatasql/DS
 jaguar Installation Logs at /var/log/bigdatasql/cloudera or /var/log/bigdatasql/ambari
  /var/log/bigdatasql/<cluster_type>/service
 /var/log/bigdatasql/<cluster_type>/service  Naming Convention and Layout
 /var/log/bigdatasql/<cluster_type>/service/BDSAGENT-<timestamp>-agent_checkrequirements.log
 /var/log/bigdatasql/<cluster_type>/service/DSAGENT-<timestamp>-agent_add.log
 /var/log/bigdatasql/<cluster_type>/service/BDSAGENT-<timestamp>-agent_doinstall.log
 /var/log/bigdatasql/<cluster_type>/service/BDSAGENT-<timestamp>-server_setdbkey.log
 /var/log/bigdatasql/<cluster_type>/service/BDSAGENT-<timestamp>-server_getdbkey.log
 /var/log/bigdatasql/<cluster_type>/service/BDSAGENT-<timestamp>-server_doinstall.log
 /var/log/bigdatasql/<cluster_type>/service/BDSAGENT-<timestamp>-server_runrole.log
 Oracle Database Installation Logs
 Oracle Database Installation Logs at $ORACLE_HOME/install
 Hadoop Cluster Runtime Logs
 Hadoop Cluster Runtime Logs  at /var/log/oracle/diag/bdsql/cell
 Hadoop Cluster Runtime Logs at /opt/oracle/bigdatasql/bdcell-12.1/log
 Oracle Database Runtime Logs
 Oracle Database Runtime Logs at $ORACLE_HOME/bigdatasql/log
 Oracle Database Runtime Logs at $ORACLE_HOME/hs
 Oracle Database Runtime Logs at /home/oracle/install/app/oracle/diag/rdbms/<$ORACLE_SID>/<$ORACLE_SID>/trace
 Oracle Database Runtime Logs at /home/oracle/install/app/oracle/diag/crs
 Oracle Database Runtime Log $ORACLE_HOME/log/<dbhost>/diskmon/diskmon.log

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.