This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Servlets and the fly likes oracle doenot listen on TCP/IP port Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "oracle doenot listen on TCP/IP port" Watch "oracle doenot listen on TCP/IP port" New topic
Author

oracle doenot listen on TCP/IP port

shahzad
Greenhorn

Joined: Jul 31, 2001
Posts: 7
hi
I was trying to connect to oracle Database using type 4 thin drivers on win98.
I downloaded the driver from oracle site and also downloaded some more drivers
from other sites.While connecting to data base I ran into problems I am working
for about two days on this thing but couldn't succeed.

I get the following message:
Connection refused ...........

The driver is succefully loaded but when it tries to connect using

conn = DriverManager.getConnection("jdbc racle:thin:@server:1521 rcl","userid","password");
it gives the above message.

now I think that I am giving the host name incorrect I couldn't find
any way in oracle to figure out the host name.

I am giving
"jdbc racle:thin:@127.0.0.1:1521 rcl"
I have also tried other options for host name like localhost etc.but it
didn't resolve.I think that the listener for oracle is not listening at the port 1521.
I tried telnet to check that but it failed to connect at this port.I tried to do this
with mysql to connect at port 3306 using telnet it succeeded.

Second thing is that I tried to create a service name in oracle using TCP/IP protocol
giving the above mentioned host names at all the attempts it gave the error that it has performed
an illegal operation .
I think that there are some settings needed for oracle to listen at this port which
I dont know or I am giving the host name wrong . I shall be extremely thankful if u help
me to solve this problem.
Regards
shAhzad
Marcos Maia
Ranch Hand

Joined: Jan 06, 2001
Posts: 977
Hi, try to print a better message error from the catch statement doing
catch(YourErrorCathingHere yech)

yech.printStackTrace();
System.out.println(yech.getMessage());
than you should have a better message than connection refused.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: oracle doenot listen on TCP/IP port
 
Similar Threads
Unable to connect to oracle usin type 4 thin
oracle does not listens on TCP/IP port
Dynamic IP address for thin driver
Access to the Oracle database using Java Applets
JDBC ODBC host string