OBIEE 11g: The connection has failed while importing Data

The most common error when we ar ein initial stages of setting up the OBIEE 11g environment and started developing “The connection has failed” error especially while trying to import data from the database using OCI call interface in RPD, there must be nly one reason the BI server is not able to identify the connections using OCI. Just follow the steps to ensure it has all the information needed.

1. Add the tnsnames.ora file in the BI Home Directory

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



If you are still facing the issue please reopen the Admin tool and try, if it doesnt workout then try restarting the complete services.