OBIEE 11g Admin tool Connection failed error

After installation of both Oracle database 11g and obiee 11.1.1.7 in my windows 7 64bit laptop, I use OBIEE administration tools to import metadata into the physical layer using connection type of ‘OCI 10g/11g’. And It end up with the following error:

The connection has failed.

1	The connection has failed.

The reason is that BI administration tool is a client tool, and it does not use the traditional  tnsnames.ora in the  $ORACLE_HOME/network/admin directory, Administration tool look for the tnsnames.ora file in the below directory instead.

D:\obiee\Oracle_BI1\network\admin

1	D:\obiee\Oracle_BI1\network\admin

You have to create a tnsnames.ora file in the above directory with the following like content (just change the host/port/service_name to your own setting)

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dev.iniu.net)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )

1 2 3 4 5 6 7 8

ORCL =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = dev.iniu.net)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = orcl)     )   )

And now you could use administration tool to import medata from the database of your laptop!
 

GO to COMPUTER and Write click

 

 

 

 

Set environment Varible

C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client Tools\oraclebi\orainst\bifoundation\OracleBIServerComponent\coreapplication\repository