Obiee 11g Data Source Problem Of The Connection Has Faild When Importing Metadata Using Bi Administration Tools

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

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

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)
)
)

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