OBIEE 11g: Error: “Error Code: OPR4ONWY:U9IM8TAC:OI2DL65P … ORA-12154: TNS Could Not Resolve The Connect Identifier Specified” When Trying to Connect to 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=orldss-apps.us.oracle.com)(PORT=1523)))(CONNECT_DATA=(SID = vis)))

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.