Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 359,989 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

OBIEE11g – Import Data – Connection Failed Error

Posted by Santosh Kumar Gidadmani on May 12, 2012

If you get “The connection has failed” error while trying to import data from the database using OCI call interface in RPD, perform the below steps.

1. Add the tnsnames.ora file in the BI Home Directory
Ensure, you add all the data source tns entry details in the tnsnames.ora file
Copy the tnsnames.ora file from Oracle Home (Root directory: \App\User\Product\Network\Admin) and paste the file to the below location in OBIEE11g directory
Root directory: \OBIEE11g\Oracle_BI1\network\admin and
Root directory: \OBIEE11g\oracle_common\admin

2. Add the tnsnames file location path in User.cmd file
Add the tnsnames file location path from one of the above location in the user.cmd file. The user.cmd file is found in the below location
Root directory: \OBIEE11g\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup

Now, it should work. Still if you are unable to get the data, close your RPD and try it.
Restart the services if RPD is still not importing data.

– Santosh


6 Responses to “OBIEE11g – Import Data – Connection Failed Error”

  1. venkat said

    hi sir,
    still i am getting the error connection failed after doing the above one. pls help.


  2. venkat said

    HI frens,
    I have installed oracle 10g database and obiee 11g in my pc. when i try to import metadata by selected database conection as OCI10/11g and by selecting DSN name which created in odbc and when clicked on next it is giving connection has failed error. can anyone pls help. I m learning obiee and i dont knw how to resolve the issue. Thanks in advance for ur grt answer.


  3. ram said

    hi venkat ,

    what santosh said is correct . for me it worked .what I did was ,STEP1:from this path (D:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN) I copied tnsnames ora file to this path (D:\TEMP_11G\Oracle_BI1\network\admin) and to this path (D:\TEMP_11G\oracle_common\admin)

    STEP2:Go to this path (D:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN) and open tnsnames.ora file ,Inside this file you see a path for me it is D:\app\product\11.2.0\dbhome_1\network\admin\tnsnames.ora ,just copy this path and paste it in user.cmd file .

    STEP 3:to go to user.cmd file use this path D:\TEMP_11G\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup and right click on user windows command script file and click on edit and here set TNS_Admin=D:\app\product\11.2.0\dbhome_1\network\admin\tnsnames.ora and save it . and now import and it should work .

    hope this will help you


  4. Raghavendra said

    Hi Ram

    When I SELECt the datasource in RCU and try to connect the oracle database getting connection failed error.. I tried with al the above scenarios but nothing has worked .Given all the necessary inputs to connect .. Can any please help to fix the issue

    Thanks in advance


  5. bhaskar said

    Hi Ram,
    Awesome Explanation…thanks.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: