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