How to connect to oracle server in java?

Question

I am trying to connect to my friends Oracle server. But while connection I am getting error please help.....

JDBC code

Class.forName(oracle.jdbc.driver.OracleDriver).newInstance();
conn=DriverManager.getConnection(jdbc:oracle:thin:@<IPaddress>:<SID>,userName,password);
conn.close();

Error Message

java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.wipro.sample.min.main(min.java:28)

    Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
   at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:359)
   at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422)
   at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:672)
   at oracle.net.ns.NSProtocol.connect(NSProtocol.java:237)
   at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
   at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
   ... 7 more

    Caused by: java.net.ConnectException: Connection refused: connect
   at java.net.PlainSocketImpl.socketConnect(Native Method)
   at java.net.PlainSocketImpl.doConnect(Unknown Source)
   at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
   at java.net.PlainSocketImpl.connect(Unknown Source)
   at java.net.SocksSocketImpl.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:141)
   at oracle.net.nt.ConnOption.connect(ConnOption.java:123)
   at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:337)
   ... 12 more

@Bozho: so what should i do on my friends system to enable the connection... — , Feb 12 '10 at 06:59
i pinged the system.. there was no problem...what i have to check in the firewall — , Feb 12 '10 at 07:03
BTW, it should be `Class.forName ("oracle.jdbc.driver.OracleDriver");` — Pascal Thivent, Feb 12 '10 at 07:33

score 2 · Accepted Answer · answered Feb 12 '10 at 07:29

2

Looks like oracle server is not listening...

Connect to the machine where oracle is present..

Run su - oracle

lsnrctl status

is listner is not active then do lsnrctl start

answered Feb 12 '10 at 07:29

score 1 · Answer 2 · answered Feb 12 '10 at 06:54

1

It seems like you can't connect to Oracle server. First try to telnet your Oracle server by using the Oracle's port.

Ex: telnet <Oracle Serrver IP> 1521

answered Feb 12 '10 at 06:54

Upul

211
1
2
6

Connecting To Could not open connection to the host, on port 1521: Connect failed – Feb 12 '10 at 07:10
above was the message i recieved when i executed the provided statement – Feb 12 '10 at 07:11
Your oracle server is refusing to connect with your application. Please check firewall configuration in the Oracle server also make sure whether Oracle server is up and running. – Upul Feb 12 '10 at 07:14
how to check the firewall configaration..... – Feb 12 '10 at 07:18
Please follow this tutorial http://www.windowsecurity.com/articles/Customizing-Windows-Firewall.html – Upul Feb 12 '10 at 07:26
Add an exception rule for Oracle server – Upul Feb 12 '10 at 07:27

score 1 · Answer 3 · answered Feb 12 '10 at 06:55

1

This error may occure when you:

Try to connect to the different host:port. Double-check your settings.
Oracle server is down. You need to start it.
Your firewall blocks your connection to oracle. You need to allow access for your application.

answered Feb 12 '10 at 06:55

uthark

113
5

score 0 · Answer 4 · answered Feb 13 '10 at 18:04

A typical Oracle network setup consists of:

The database instance on the server
As @Abhiram states, a "listener" also runs on the server, waiting for connections, by default on port 1521.
Clients connect to the server on the correct port, the listener hands off the connection to the database instance.

As others have pointed out, (1) the database needs to be up; (2) the listener needs to be running and you need to know what port; (3) firewalls need to be configured to allow traffic on the port, most often on the server side.

Can your friend use an ODBC connection on their system, by way of the listener (not a local connection)? In other words, would your code run on their system?

score -1 · Answer 5 · edited Dec 29 '14 at 20:19

Gusset do following:

ping ip address. If get time out , it means there is network connection problem.
If ping result indicates connection ok, and the still get same exception, then do: use command tracert Ip Address to gat domain name.

use domain name instead of ip addesss in your connection string:

conn=DriverManager.getConnection(jdbc:oracle:thin:@<IPaddress>:<SID>,userName,password);
conn=DriverManager.getConnection(jdbc:oracle:thin:@<domain Name>:<SID>,userName,password);

use DriverManager.registerDriver (new oracle.jdbc.OracleDriver()); instead of Class.forName(oracle.jdbc.driver.OracleDriver).newInstance();

This question has been answered nearly 5 years ago and the solution was something else entirely. — Sven, Dec 29 '14 at 20:20

How to connect to oracle server in java?

5 Answers5