pae2
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.
pae2
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!pae2
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help
ASKER