Analysis and Dashboards Intermittently Error With ORA-12545 When Connecting To An Oracle RAC Database Datasource (Doc ID 2669140.1)

Last updated on DECEMBER 20, 2023

Applies to:

Symptoms

Intermittent "[nQSError: 17026] Oracle Error code: 12545, message: ORA-12545: Connect failed because target host or object does not exist at OCI call OCIServerAttach"  errors are occurring when running analysis/reports and dashboards that are querying from a Real Applications Cluster (RAC) database.

• The issue also occurs when testing JDBC connections in BI Publisher.
• The errors occur with both an OBI clustered, or scaled-out environment and with a single OBI environment.
• The error will go away sometimes when you refresh the analysis or dashboard.
• The error will not occur if the TNS entries are modified to use to the individual database nodes vs. using the load_balance TNS entry.

Example RAC DB Individual nodes TNS entries
TNSALIAS=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=domain1.xyz)(PORT=1410))(CONNECT_DATA=(SERVER=DEDICATED)(SID=node1)))
TNSALIAS=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=domain2.xyz)(PORT=1410))(CONNECT_DATA=(SERVER=DEDICATED)(SID=node2)))

Example RAC DB Load balancer TNS entry

TNSALIAS=
  (DESCRIPTION=
  (LOAD_BALANCE=on)
  (ADDRESS= (PROTOCOL=TCP)(HOST=domain.xyz)(PORT=1410))
  (ADDRESS=(PROTOCOL=TCP)(HOST= domain.xyz)(PORT=1410))
  (CONNECT_DATA=
  (SERVER=DEDICATED)
  (SERVICE_NAME=myServiceName)
  )
  )

Changes

Cause

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