Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    SLOVAKIA
    Posts
    10

    Unanswered: JDBC error : The Network Adapter could not establish the connection

    I started a JSP page on Oracle 8.1.7.0 and I received this message :
    java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

    ..but I restarted a listener and then JSP page worked correctly!
    (Listener detect only 1 service handler)

    ...but later I started a command : lsnrctl status ....and Listener detected
    3 service handlers...and the same JSP page didn't work, because :
    java.sql.SQLException: Io exception: The Network Adapter could not establish the connection!

    I again restarted a listener => JSP pake worked


    help me??????
    Last edited by marianmt; 12-06-03 at 07:14.

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    I wonder if this is caused by dynamic listener registration overwriting a static registration. Compare the address info for your SID in file listener.ora to the local_listener parameter in file initSID.ora. This init.ora param is only necessary if your listener is not using all of the default attributes, like port=1521 and protocol=TCP. I can imagine if any of the attributes in parameter local_listener are incorrect, or need to be set but are not set, then Oracle will overwrite your in memory values established from file listener.ora.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  3. #3
    Join Date
    Dec 2003
    Location
    SLOVAKIA
    Posts
    10
    Thank you, I will try it!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •