The connection has failed in BI Admin Tool

After the installation of OBIEE 11g, everyone go for creating a new repository. but there's a problem.
You will be getting an error saying, "The connection has failed" while importing the data from database.

This is a behaviour change when we move from 10g to 11g. In BI EE 10g, there was no Oracle Client bundled along with BI EE. So, BI EE will use your Oracle DB Home client to connect to the database. Generally no issues in that case. But in BI EE 11g, the software itself contains the 11.2 DB client. So, when you try to connect to the database through the Repository or BI Server, it will try to find the tnsnames entry in the Oracle Client of BI EE 11g instead of your database.

But there's a way for every problem.. Follow these steps to overcome this issue.

1. Copy the tnsnames.ora from Oracle Database home location

This is a location where your database is installed.
E:\app\Sagar\product\11.2.0\dbhome_1\NETWORK\ADMIN to the following locations.

• C:\OBIEE\Oracle_BI1\network\admin
• C:\OBIEE\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,
C:\OBIEE\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup

3. You may need to restart the BI Components apply these changes.

That's solved.