• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Unable to connect to oracle usin type 4 thin

 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If you are using Unix/Linux you could ping where your db is and get the path name that way.
However, it looks like you may just have to add another : in the path you have.
....:1521:Orca.... for example.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic