“The connection has failed” error in OBIEE 11g Admin tool while creating new Repository(.RPD)

If you get “The connection has failed” error while importing database table into repository ,you need to make two changes to make it work:

1. Copy the tnsnames.ora from Oracle Database home (ORACLE_HOME\NETWORK\ADMIN\) to the following locations.
   • \OracleBI1\network\admin (Example: C:\OBI\Oracle_BI1\network\admin)
   • \oracle_common\network\admin (Example: C:\OBI\oracle_common\network\admin)
2. Set the TNS_ADMIN environment variable value with one of the copied locations in the step 1 in user.cmd or user.sh file depending on your OS. This file will be found under \instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup (Example : C:\OBI\instances\instance2\bifoundation\OracleBIApplication\coreapplication\setup)

If Windows OS is installed in you Machine then you need to change the TNS_ADMIN path in user.cmd file and if you have any other operating system installed in your machine then you need to make changes in user.sh file.