• 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

Oracle8 Personal Edition and jdbc URL

 
Ranch Hand
Posts: 560
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
All,
I've installed Oracle 8 Personal edition in my NT box and created an instance called MDM. Now I am trying to write a simple JDBC code to connect to the database. I don't know the port number that I supposed to specify in

I tried "1521" for the port and I get the exception:
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
I like to know how to find the port number that Oracle service is lisening? or Is there any other way to make connection with out the port number? Thanks a million
PS: Ignore the apostrophe in front of the word Oracle
[ October 17, 2002: Message edited by: Sai Prasad ]
 
Ranch Hand
Posts: 114
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
have u created any listener for ur database?
unless u havenot changed the port number of oracle it is 1521.
if u are not developing on an intranet "locathost" can be used as the host name.
also to check wheter you have installed ur oracle correctly try to log onto SQLPLUS using user name/password and databse
 
Sai Prasad
Ranch Hand
Posts: 560
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello Prabhat,
Thanks for the reply. I can logon to the database from the command line using the command:
"sqlplus sprasad/sprasad". I get connected to the MDM instance because that is the only instance running in my machine.
I am not able to specify any instance name like
"sqlplus sprasad/sprasad@MDM"
 
Sai Prasad
Ranch Hand
Posts: 560
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I solved it. I was supposed to create a TNS listener using the Net8Configuration assistant for the port 1521. Now everything works great! Thanks.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic