application to WINDOWS/ORACLE 11g connection

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 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( at oracle.jdbc.driver.PhysicalConnection.<init>( at oracle.jdbc.driver.T4CConnection.<init>( at oracle.jdbc.driver.T4CDriverExtension.getConnection( at oracle.jdbc.driver.OracleDriver.connect( at java.sql.DriverManager.getConnection( at java.sql.DriverManager.getConnection( at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke( at sun.reflect.DelegatingMethodAccessorImpl.invoke( at java.lang.reflect.Method.invoke( Caused by: The Network Adapter could not establish the connection

Open in new window

Thanks for the help!

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

Russ SuterCommented:
What does your connection string look like? Please redact sensitive information when answering this question. I'm just looking for the overall structure.
pae2Author Commented:
The application asks for the Server, Port, User, Password, Instance SID, Schema Name. I am not certain of the Instance SID or the Schema Name.
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Look at the connection strings used in SQL Developer. If it a "simple connection" type, server name and SID (equivalent to instance name) are noted there.
Schema is nothing else than in MSSQL - just the user name, usually.
The default port of Oracle is 1521.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

SujithData ArchitectCommented:
>> 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?

Right click on the connection in SQL Developer and click on properties. It will show the connection type and other details of the connection.
Now, depending on the connection type; You can find out which server the DBs are hosted on.

If it is TNS/LDAP - open a command window and issue a tnsping command with the connection alias/network identifier. It will tell you the box on which the DB is hosted on.

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
Mark GeerlingsDatabase AdministratorCommented:
Every Oracle database has just one Instance SID that was assigned when that database was created.  Another way that you can find this outside of the database is by looking at the listener.ora file on the database server.  This is a plain-text file that you can open with Notepad or Wordpad.  It is located in the Oracle_home\network\admin directory.  

Where exactly is the "Oracle_home" directly on your Oracle database server?  That is a good question.  It could be anywhere, depending on who did the install of the Oracle software.  It may be something like: C:\Oracle\Oracle11...

Most connections to an Oracle database will require at least these three values:
1. host (server name)
2. port (Oracle's default is: 1521)
3. Instance name or SID (this was assigned when the database was created, the default for Oracle on Windows is: ORCL)

Some of the other values you mentioned (user, schema, password) may also be required depending on the database or application.
1. A "user" (or "username") is a database user account that a database administrator set up to allow users or applications to identify themselves to the database.
2. a "password" will usually be required to log in to each "user" account.
3. a "schema" in an Oracle database is the collection of tables, indexes, procedures, etc. that are owned by a particular "user" in that database.  There may be schemas named "accounting" or "HR" for example.
pae2Author Commented:
Thank you Sujith and Mark Geerlings. Both answers were very helpful. My connection-string is not working, but it might have something to do with firewalls. I have much more insight now into what I am trying to accomplish. I will be posting follow-up questions at some point today or tomorrow.

Thanks for the help!

SujithData ArchitectCommented:
Glad to know. All the best.
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
I didn't tell you something helpful?
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.