Error connecting to Oracle DB from Java

Question

Could someone please help me on why I received the following error while trying to connect to Oracle db from java....

The connection call is:

Connection con = DriverManager.getConnection(
     "jdbc:oracle:thin:@winson.net:1522/hcrod", 
     "manager", "passing");

I receive the following error:

java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:802)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at test_sample.main(test_sample.java:15)

Izzy · Accepted Answer · 2014-10-23 15:25:17Z

6

in a similar case for me worked a slightly other connect string: jdbc:oracle:thin:@winson.net:1522:hcrod

really without the // and with : instead of /

edited Oct 23, 2014 at 15:25

Izzy

6,8988 gold badges44 silver badges92 bronze badges

answered Oct 23, 2014 at 15:05

uwe

691 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Luke Woodward · Accepted Answer · 2011-11-13 18:13:39Z

1

I've seen this error come up a few times when I've started the TNS listener after I started the database. When the database starts up it registers itself with the listener if the listener is running, but if the listener isn't running it can't do this.

It's possible to manually persuade the database to register itself with the listener. To do this, connect to the database as SYS and run the SQL statement ALTER SYSTEM REGISTER;.

answered Nov 13, 2011 at 18:13

Luke Woodward

65.3k16 gold badges94 silver badges108 bronze badges

1 Comment

Luke Woodward Over a year ago

I've given the only command you need. Log in as sys - I know you can do this as you've commented on this answer - and run the one command I've mentioned.

Ricky · Accepted Answer · 2011-11-12 11:27:19Z

0

It sounds like the port on the server isn't listening, port 1522.

Can you telnet the port successfully?

answered Nov 12, 2011 at 11:27

Ricky

7,9082 gold badges36 silver badges48 bronze badges

1 Comment

Winz Over a year ago

The connection host 'winson.net:1522/hcrod' is correct as I could connect to it successfully thru' SQL devloper.

Scott A · Accepted Answer · 2011-11-13 16:40:56Z

0

Oracle's JDBC thin URI syntax is as follows:

jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE

So:

jdbc:oracle:thin:@//winson.net:1522/hcrod"

Note the two slashes added after the @ symbol.

answered Nov 13, 2011 at 16:40

Scott A

7,8643 gold badges35 silver badges47 bronze badges

Comments

Mallikharjun · Accepted Answer · 2013-09-02 10:39:06Z

0

i think port number for oracle is 1521

answered Sep 2, 2013 at 10:39

Mallikharjun

11 bronze badge

Collectives™ on Stack Overflow

Error connecting to Oracle DB from Java

5 Answers 5

Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related