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 NOVEMBER 18, 2021

Applies to:

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

Symptoms

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

 Error
  View Display Error
 
Odbc driver returned an error (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
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: *************

Changes

 

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.

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.