After installation of both Oracle database 11g and obiee 220.127.116.11 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)
(ADDRESS = (PROTOCOL = TCP)(HOST = dev.iniu.net)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
And now you could use administration tool to import medata from the database of your laptop!