Hello, I am new to BI Publisher. I have setup BIP 11.1.1.7.0 on two servers - BIP application on one and database on the separate server. I am trying to setup JDBC connection from the BIP Enterprise Page --> Administration --> JDBC --> Add Data Source. So I add the folllowing:
jdbc:oracle:thin:@SERVER NAME:1521:DEVL
I can connect as this user on that SERVER NAME via sqlplus. However, when I try to set it up in the above BIP, I get "Could not establish connection". I was able to traceroute SERVERNAME 1521, so ports are open. When I try to google the solution, I get that I need to make sure that my TNSNAMES.ORA entry is correct. However, I do not have Oracle home defined on the application server, as the database was installed on the separate server. What am I doing wrong? How do I debug this? Is there a log somewhere on the app server I can look at for a more defined error message? Thank you!