My Oracle Support Banner

OBIEE 11g Dashboards On Exalytics Randomly Failing With Errors: "ODBC" and "ORA-12545: Connect failed because target host or object does not exist" (Doc ID 1586849.1)

Last updated on APRIL 11, 2018

Applies to:

Oracle Exalytics Software - Version 1.0.0.1.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.0 and later
Information in this document applies to any platform.
Checked for relevance 21-May-2015.

Symptoms

When running Oracle Business Intelligence Enterprise Edition (OBIEE) 11g dashboards in a two-node, vertical cluster on an Exalytics server, there are intermittent ODBC errors.
If refresh is clicked, the errors go away.

In this environment, the Repository Creation Utility (RCU)  database is installed on an Exadata server with two IPs defined.
The TNSNAMES.ORA entries list each IP with SDP protocol and LOAD_BALANCE (on).  For example:

 

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!


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