I ran into the following issue when I upgraded from Oracle BI 10g to Oracle BI 11g. Although the upgrade went smoothly, all of a sudden I was not able to reach the database anymore. After doing some research on the internet I stumbled upon the following thread on OTN.
The main difference between Oracle BI 10g and Oracle BI 11g is the fact that Oracle BI 11g has it’s own Oracle_Home.
Thanks to Dirk and Venkat for the possible solutions:
1.
navigate to; {ORACLE_INSTANCE}\bifoundation\OracleBIApplication\coreapplication\setup,
alter user.cmd or user.sh depending on your OS,
set your TNS_ADMIN location to point to; {MIDDLEWARE_HOME}\Oracle_BI1\network\admin
2.
Copy your tnsnames.ora to {MIDDLEWARE_HOME}\Oracle_BI1\network\admin directory
3.
Use the full expanded tnsnames as shown below and use this one as the datasource name in your Connection Pool:
(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = host_name/ip_address)(PORT = port_number))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = service_name)))
