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


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)


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