My Oracle Support Banner

Installing Big Data SQL on One ORACLE_HOME on a Single non-Exadata Database Server with Two ORACLE_HOMEs Prevents the Other ORACLE_HOME from Starting (Doc ID 2416651.1)

Last updated on FEBRUARY 06, 2020

Applies to:

Big Data Appliance Integrated Software - Version 3.1.0 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Linux x86-64

Symptoms

In the case of 2 ORACLE_HOMEs installed on a single non-Exadata Database server where Big Data SQL is installed in one ORACLE_HOME, the other instance can not start.  The other instance can not start even with the latest PSU applied.  Instead errors like below are raised:

USER (<USER>): terminating the instance due to error 29702
<timestamp>
System state dump requested by (instance=1, osid=<OSID> (<DSKM> ), summary=[abnormal instance termination].
System State dumped to trace file /<PATH_TO_TRACE_FILES>/<ID>_diag_<ID>_<timestamp>.trc
<timestamp>
Dumping diagnostic data in directory=[cdmp_<timestamp>], requested by (instance=1, osid=<OSID> (<DSKM>)), summary=[abnormal instance termination].
<timestamp>
Instance terminated by USER, pid = <PID>

 

Cause

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
Symptoms
Cause
Solution


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