My Oracle Support Banner

OAC: Oracle autonomous db connection via rpd subject area throwing ORA - 12154 error at analysis (Doc ID 2627706.1)

Last updated on APRIL 20, 2023

Applies to:

Oracle Analytics Cloud - Classic - Version 105.4.0 and later
Information in this document applies to any platform.


Issue description: RPD connection pool with Autonomous Data Warehouse (ADW) throwing below error at analysis in classic OBIEE

  View Display Error
Odbc driver returned an error (SQLExecDirectW).
  Error Details
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. (HY000)
State: HY000. Code: 17014. [nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: *************



Symptoms -->

Created console data connection same as rpd cnnection pool Data source name and successfully completed row count on tables but analysis still showing the error message.

Directly defined tns entry with below format in data source name at connection pool location via online rpd is not working since changes not refelecting after publishing change via online rpd.

Data connection created in OAC console tested successfully.

Tested Direct Database Query and this failed too.


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

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