4 Replies Latest reply: Mar 9, 2013 11:21 PM by Ahsan Shah RSS

    OBIEE Unable to connect with Data Warehouse

    Sher Ullah Baig
      Hi
      Just installed OBIEE 11.1.1.6.0 and BI Apps 6.9.6.4. I am not able to connect BI Apps RPD to Data warehouse. i followed bellow steps.
      1- Added Data warehouse TNS details in C:\Oracle_BI1\Oracle_BI1\network\admin\tnsnames.ora
      2- Added TNS location path in file USER.CMD at C:\OBIA\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup
      3- IN RPD (BI Apps) connection pool changed OCI 10/11g
      4- Entered Connection details in RPD for Data warehouse with same Oracle DB Service.

      I also tried with ODBC 2.0 and 3.5 but same results. When i test connection while creating ODBC driver it shows successful but when i tired in RPD it gives me message "*Connection has Failed*". is there anything i m missing????
      need your help on this guys...

      Regards
      Sher