My Oracle Support Banner

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

Last updated on APRIL 13, 2021

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.4.200114 to 12.2.1.4.0 [Release 12g]
Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

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.




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

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
References


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