Got the “The connection has failed” error while trying to import database tables into repository (.rpd) using OCI call interface.
Solution:
- 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)
- 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)