OBIEE 11.1.1.X Scheduler Configuration

http://docs.oracle.com/cd/E23943_01/doc.1111/e18562/schedconfig.htm

Administration Tool Import Error “The connection has failed”

Action :- Importing Table in Repository Using OCI Connection from a  11g database

Error :- “The connection has failed”

Product "Oracle Business Intelligence (11.1.1.x)" Administration Tool

Solution

1.      Copy  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 (user.cmd / user.sh )

 File Location 

                                  \instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup

 (Example : D:\OBI11g\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup)