Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2008
    Posts
    6

    Unanswered: listener problem

    Hi,

    Can anyone please help me out with what a listener is? My understanding is that it "listens" to client requests and passes on the client's queries to the server. If so, then if the listener has been stopped, no client can 'connect' to the server. I got into a situation where my listener was not started , but i could still query my database using sqlplus. How?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I got into a situation where my listener was not started , but i could still query my database using sqlplus. How?
    I suspect that you were logged onto the system where the database resides.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2003
    Location
    SJ, Costa Rica
    Posts
    48
    Hi!,
    Yep, as anacedent already said.., probably you are using sqlplus in the box that has the database.
    The listener handles only the remote connections, not local ones.

    regards,
    -eduardo s.m.

  4. #4
    Join Date
    Feb 2008
    Posts
    6
    Thanks. Yes, i am on the same system as the database. I was under the wrong impression that listener handled ALL connections.How is this case handled?

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How is this case handled?
    This case as opposed to that case? Which case?

    SQL*Net (including any listener) is NOT required when both the client & the DB server processes are running on the same computer system.
    In the case where both are running on the same system/OS, the communications between them is handled by using Inter Process Communications (IPC) provided by the OS.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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