Link to home
Start Free TrialLog in
Avatar of pae2
pae2Flag for United States of America

asked on

get ORACLE 11g instance SID value

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 11.2.0.4.0 64BIT data. The application connection info asks for an Instance SID value. How can I generate the Instance SID value? I'm not sure that I populated that value correctly. The following is the error I get when the APP attempts to connect. I just need to sort out the above first.

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

Open in new window

Thanks!

pae2
ASKER CERTIFIED SOLUTION
Avatar of Geert G
Geert G
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pae2

ASKER

Thank you Geert G and Sujith. Both answers were helpful. Sujith I did not see the Oracle Client, after a cursory glance. I will post a new question if I locate it and try it out. Thanks!
Glad to help