4 Replies Latest reply on Mar 10, 2013 5:38 AM by Sher Ullah Baig

    OBIEE Unable to connect with Data Warehouse

    Sher Ullah Baig
      Just installed OBIEE and BI Apps 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...