Wednesday, December 19, 2012

Connection Failed Error in OBIEE 11 g Admin tool -2

Hi Friends,

Recently I came across the following issue as shown in the figure below. I already posted a article on this same type of issue earlier in the blog.

There the issue was Tnsnames.ora file not present at C:\OBIHOME\Oracle_BI1\network\admin.

New Issue : - we have OBIEE installed in a remote server (Linux). My collegue installed  OBI client tool on her system. My collegue was having two older versions of  Oracle clients installed on her system and BI Admin tool was not able to figure out which one to use.

Error :

[nQSError: 17014] Could not connect to Oracle database. [[

[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified

at OCI call OCIServerAttach

Solution :  Create a system variable of the  tns file path


Right Click on My computer > Properties > Advanced system settings > Environement variables >

In the system variable create new called " TNS_ADMIN"

which is equal to your   C:\oracle\product\11.2.0\client_1\network\admin.

Click ok.

That should solve your problem.