Just installed OBIEE 220.127.116.11.0 and BI Apps 18.104.22.168. 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...
It was multiple oracle homes issue. i was jusing 32bit & 64bit oracle client so it was creating conflict. after removing one of oracle client issue resolved.
Thanks for you mate...
you scored :)