DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: listener question

  1. #1
    Join Date
    Sep 2000
    Posts
    77
    I have a database on sever TEST and when i connect to database via sqlplus from same machine i am able to connect and everything is fine. But when i am trying to connect through jdbc calls from a java program from a webserver i am not able to connect and then i found listener is down on server. I want to know that even if listener is down on and if i make connections from same machine on which database resides via sqlplus works or not. Does it use any bequeath process or something for this type of process. Please advise
    Thanks

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    You should have listener Up and Running when you want to connect remotely where as it is not required if you are connecting from your server.

    I don't know what else you need to set if you are running to Apps
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    You are not using sqlnet if you are not using a connect string:
    e.g. sqlplus system/manager connects w/o using the tnsname lookup or listener.

    sqlplus system/manager@myproddb will connect you via sqlnet, even when you and the database are on the same server.

    Please note that this is applicable for unix; i am not as familiar with NT or Windoze.

    D.

  4. #4
    Join Date
    Jun 2000
    Location
    Santa Clara, CA, USA
    Posts
    12
    you said JAVA means need to check JDBC connections. And if I am not wrong, you need to use HOST, PORT, and SID in your java programs. if you pass all three values correctly, should not be any problem, if JDBC working fine.

Posting Permissions

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


Click Here to Expand Forum to Full Width