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 JULY 04, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
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, "SH". "CHANNELS". "CHANNEL_TOTAL" s_ 1
FROM "SH" 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!


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