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
pae2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Geert GOracle dbaCommented:
An oracle database instance is named OracleServiceSID in services.msc
You need the SID

from inside the database:
select instance_name from v$instance;

that's for a single instance database

are you trying to connect to the oracle db through mssql or directly ?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SujithData ArchitectCommented:
Can you post the connect string from your Java code?

Do you have Oracle Client installed in your client machine by any chance? If yes, We could verify the Database is connectable from your client.
0
pae2Author Commented:
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!
0
SujithData ArchitectCommented:
Glad to help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.