This discussion is archived
4 Replies Latest reply: Mar 9, 2013 9:21 PM by Ahsan Shah RSS

OBIEE Unable to connect with Data Warehouse

Sher Ullah Baig Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points