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 AUGUST 04, 2018

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]
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 (###.###): terminating the instance due to error 29702
<timestamp>
System state dump requested by (instance=1, osid=#### (####)), summary=[abnormal instance termination].
System State dumped to trace file /u/app/oracle/diag/rdbms/strems/strems/trace/xxxx_diag_#####_<timestamp>.trc
<timestamp>
Dumping diagnostic data in directory=[cdmp_<timestamp>], requested by (instance=1, osid=#### (####)), summary=[abnormal instance termination].
<timestamp>
Instance terminated by USER, pid = #####

 

Changes

 

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
Changes
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.