Four Important Steps to be follow after installation of OBIEE 11gR1

OBIEE11g    Connection Failed Error 

  Follow four steps to prevent connection error.

1. Connect with oracle database.

2. Add the tnsnames.ora file in the BI home directory.

       copy tnsnames.ora file from Oracle Home (Root diractory : app\user\product\network\admin) and paste file into below two OBIEE11g directory.

     ->  Root Directory :\ORACLE\Middleware\ORACLE_BI1\network\admin

    ->   Root Directory:\ ORACLE\Middleware\oracle_common\admin

3. Add the tnsnames.ora flie location path in user.cmd file in below location

       RootDirectory:\ORACLE\Middleware\instance\instance1\bifoundation\OracleBIApplication\coreappliction\setup

4. Set TNS_ADMIN Environmental Variable

    RootDirectory:\app\user\product\12.1.0\dbhome_1\network\admin