I am an experienced SQL DBA (not an ORACLE DBA whatsoever) trying to get a reporting application (on a separate machine from the db) to connect to a WINDOWS SERVER 2008R2 Enterprise box that hosts ORACLE 11g Release 220.127.116.11.0 64BIT data.
I am not 100% sure that the server I am RDPing on is hosting the db and is the one I should be connecting the application to or whether it's another server. There are two servers: SERVERDB and SERVERTS. I RDP onto the Windows SERVERTS box. It has SQL Developer on it. After opening SQL Developer, it lists four connections/dbs. Then I authenticate into any of those connections/dbs without a problem.
How do I know with 100% certainty that those connections/dbs listed directly under Connections are hosted on the SERVERTS box that I am RDPing onto? I just want to be sure that they're not being hosted on the SERVERDB server. That SERVERDB server could be for another application. I am not sure. This is a different process than SQL Server. The following is the error I get when the APP attempts to connect. I just need to sort out the above though, for now.
Error running static method java.sql.SQLRecoverableException:
IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
Thanks for the help!