Connection Failed Error – While Importing Data – OBIEE11g

I have installed OBIEE 11.1.1.5.0. When I started creating a repository and enter the data source and hit next, it throws an error "The connection has failed". I have referred to different forums to resolve this issue.

Step:

1.    Copy the tnsnames.ora file from Oracle Database.

Path : C:\oracle\product\10.2.0\db_1\network\ADMIN

2.    paste the file to the below location in OBIEE11g directory
C:\OBIEE11g\Oracle_BI1\network\admin
C:\OBIEE11g\oracle_common\admin

3.    Add the tnsnames file location path in User.cmd file

4.    User.cmd path C:\OBIEE11g\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup

5.    Closed you’re RPD and reopen late

6.    After doing this I am able to import the data from oracle database.

-RAKESH PATIL

OBIEE 11g Server Name :

Hello All,

Please find the below OBIEE server name..

Oracle BI Server :	RPD and Admin Activities will be controlled by Oracle BI Server
Oracle BI Presentation Server(OBIPS) :	Report and Dashboards Controlled by OBIPS
Oracle BI Java Host :	To display the Chart properly
Oracle BI Scheduler :	Usefull for Sheduling Report
Oracle BI Cluster Controlle :	Integrate 'N' Number of Server
Web Logic Server :	To Access reports and Dashboards Globally
OPMNCTL :	Wiil be Integrated : Oracle BI Server,Oracle BI Presentation Server(OBIPS),Oracle BI Java Host,Oracle BI Scheduler,Oracle BI Scheduler,Oracle BI Cluster Controlle all Server
-Rakesh Patil	OPMNCTL is the supported tool for starting and stopping all components in an Oracle Application Server instance