OBIEE11g Connection Failed Error (Import Tables)

OBIEE11g  Connection Failed Error (Import Tables)

I have several posts in OTN for not able to import tables in RPD.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.

•         Try to check database whether are you able to connect database or not?

•   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: \Oracle\Middleware\Oracle_BI1\network\admin 
Root directory: \Oracle\Middleware\oracle_common\admin

  

•       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: \Oracle\Middleware\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.

Thanks,

Satya Ranki Reddy