OBIEE 11G: ERROR: “ERROR CODE: OPR4ONWY:U9IM8TAC:OI2DL65P … ORA-12154: TNS COULD NOT RESOLVE THE CONNECT IDENTIFIER SPECIFIED” WHEN TRYING TO CONNECT TO ANALYTICS

ERROR:

Error

View Display Error

Odbc driver returned an error (SQLExecDirectW).

Error Details

Error Code: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] nQSError: 10058] A general error has occurred. [nQSError:

43113] [Messgage returned from OBIS. [nQSError: 17001] Oracle error code: 12154, message: ORA-12154: TNS:could not resolve

the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)

Solution: Check the data source in connection pool of using RPD.( which subject area is trying to open in Analytics)

There are 2 solutions here:

1. Edit the Connection Pool in the BI Admin Tool and enter the full connect string for the database like:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID = orcl)))

2. Set the OBIEE Mid Tier environment variable TNS_ADMIN to the path of the tnsnames.ora file and use the net service name in the Connection Pool -> Data Source Name.