My Oracle Support Banner

OBIEE 12.2.1.4.0: Can Not Connect to Oracle Database due to ORA-12154 with Tnsnames.ora (Doc ID 2408448.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Primavera Analytics - Version 18.8 to 18.8 [Release 18.8]
Information in this document applies to any platform.

Symptoms

After installing OracleBI 12.2.1.4.0 and creating the analysis, it seems that you can not access the Oracle database with the following error:

------------------------------------------------
Error details
Error code: OPR4ONWY: U9IM8TAC: U9IM8TAC: U9IM8TAC: U9IM8TAC: OI2DL65P
Condition: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058]
A general error has occurred. (HY000)
Condition: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.(HY000)
Condition: HY000. Code: 17001. [nQSError: 17001] Oracle error code: 12154,
message: ORA - 12154: TNS: could not resolve the connect identifier specified
OCI call OCIServerAttach (HY000)
Condition: HY000. Code: 17014. [nQSError: 17014] Could not connect to Oracle
database. (HY000)
SQL has been issued: SELECT 0 s_ 0, "<SUBJECT AREA>". "<PRESENTATION TABLE>"<PRESENTATION COLUMN>" s_ 1
FROM "<SUBJECT AREA>" FETCH FIRST 65001 ROWS ONLY
------------------------------------------------ 

tnsnames.ora has been put on the server side under BI_DOMAIN/config/fmwconfig/bienv/core.

With Administration Tools,

Please refer to

Troubleshooting OCI Connections

As of this posting, this behavior has been observed on OBIEE 12.2.1.4 only.

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