Saturday, January 12, 2013

The connection has failed” error in OBIEE 11g Admin tool


Got the “The connection has failed” error while trying to import database tables into repository (.rpd) using OCI call interface.
Solution:
  1. Copy the tnsnames.ora from Oracle Database home (ORACLE_HOME\NETWORK\ADMIN\) to the following locations.
    • \OracleBI1\network\admin (Example: C:\OBI\Oracle_BI1\network\admin)
    • \oracle_common\network\admin (Example: C:\OBI\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 \instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup (Example : C:\OBI\instances\instance2\bifoundation\OracleBIApplication\coreapplication\setup)