the-connection-has-failed-error-in in obiee 11g admin tool

http://oraclebisolutions.blogspot.nl/2013/01/the-connection-has-failed-error-in.html

“The connection has failed” error in OBIEE 11g Admin tool
If you ever get the error “The connection has failed” error while trying to import database tables into repository (.rpd) using OCI call interface then please tryt he below two possible solutions.
Solution:
1.Copy the tnsnames.ora from Oracle Database home (ORACLE_HOMENETWORKADMIN) to the following locations.
* OracleBI1networkadmin (Example: C:OBIOracle_BI1networkadmin)
* oracle_commonnetworkadmin (Example: C:OBIoracle_commonnetworkadmin)
2.Set the TNS_ADMIN environment variable value with one of the copied locations in the step 1 in user.cmd or http://user.sh file depending on your OS.
This file will be found under
instancesinstance1bifoundationOracleBIApplicationcoreapplicationsetup
(Example : C:OBIinstancesinstance2bifoundationOracleBIApplicationcoreapplicationsetup)


1.Copy the tnsnames.ora from Oracle Database home (ORACLE_HOMENETWORKADMIN) to the following locations.

* OracleBI1networkadmin (Example: C:OBIOracle_BI1networkadmin)
* oracle_commonnetworkadmin (Example: C:OBIoracle_commonnetworkadmin)