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 11.2.0.4.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

Open in new window

Thanks for the help!

pae2
pae2Asked:
Who is Participating?
 
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.
0
 
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.
0
 
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
QlemoBatchelor, 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.
0
 
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.
0
 
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!

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

All Courses

From novice to tech pro — start learning today.