Results 1 to 13 of 13
  1. #1
    Join Date
    Oct 2003
    Location
    Minnesota
    Posts
    7

    Unanswered: TNS-12541 No listener

    We are experiencing No Listener on a few of several Win2k machines that the day worked the prior day. Nothing on the client machines has changed and the DBA says nothing has changed on our Oracle 8.1.5
    database. We suspect that something changed on the our network
    that would allow some machines to work and others with the same
    configuration to work.

    We can ping the host just can't successfully tnsping the sid.

    How can I further troubleshoot?

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Make sure the listener is running.
    Look at what the hostname is when you tnsping.
    Check if the hostname in the listener.ora on the server is the same.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Oct 2003
    Posts
    1

    Re: TNS-12541 No listener

    Hi,

    check if the server is logged on the domain. sometimes you can get this kind of messages when the server uses its hostname as logon server.

    KR
    Vincent

    Originally posted by heinh
    We are experiencing No Listener on a few of several Win2k machines that the day worked the prior day. Nothing on the client machines has changed and the DBA says nothing has changed on our Oracle 8.1.5
    database. We suspect that something changed on the our network
    that would allow some machines to work and others with the same
    configuration to work.

    We can ping the host just can't successfully tnsping the sid.

    How can I further troubleshoot?

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    On the clients machine ... Look at the sqlnet.ora (...\network\admin
    and see if

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    exists ...

    Try:

    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    HTH
    Gregg

  5. #5
    Join Date
    Oct 2003
    Location
    Minnesota
    Posts
    7

    Thumbs down

    listener is running, hostname is okay

  6. #6
    Join Date
    Oct 2003
    Location
    Minnesota
    Posts
    7

    Thumbs down

    Originally posted by gbrabham
    On the clients machine ... Look at the sqlnet.ora (...\network\admin
    and see if

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    exists ...

    Try:

    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    HTH
    Gregg
    Neither of these settings helped.

  7. #7
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    In the Client's tnsnames.ora, try instead of HOSTNAME using IP address
    Maybe there has been some change to the dhcp and they are not
    recognizing the translation ...

    Gregg

  8. #8
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    What did you do??

    What did you do to fix the listener?
    Michellea Southern-David

  9. #9
    Join Date
    Oct 2003
    Location
    Minnesota
    Posts
    7

    Thumbs down

    Originally posted by gbrabham
    In the Client's tnsnames.ora, try instead of HOSTNAME using IP address
    Maybe there has been some change to the dhcp and they are not
    recognizing the translation ...

    Gregg
    I've already tried hardcoding the IP in both the tnsnames.ora and in the hosts files. I heard that our Net Admin group
    made changes over the weekend and that may have caused the problem.

  10. #10
    Join Date
    Oct 2003
    Location
    Minnesota
    Posts
    7

    Re: What did you do??

    Originally posted by msouthern
    What did you do to fix the listener?
    Didn't need to fix listener because several clients are able
    to connect.

  11. #11
    Join Date
    Oct 2003
    Location
    Minnesota
    Posts
    7

    trace file for TNS-12541 No listener

    Originally posted by heinh
    We are experiencing No Listener on a few of several Win2k machines that the day worked the prior day. Nothing on the client machines has changed and the DBA says nothing has changed on our Oracle 8.1.5
    database. We suspect that something changed on the our network
    that would allow some machines to work and others with the same
    configuration to work.

    We can ping the host just can't successfully tnsping the sid.

    How can I further troubleshoot?
    Here is the trace file for this problem
    sqlnet.trc

    nsopen: opening transport...
    nttcnp: Validnode Table IN use; err 0x0
    nttcni: trying to connect to socket 404.
    ntt2err: soc 404 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0
    nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0
    nsopen: unable to open transport

  12. #12
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Could it be that you have a wrong port in your tnsnames?

    If you tnsping, does it give the same PORT as in your listener.ora?
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  13. #13
    Join Date
    Oct 2003
    Location
    Minnesota
    Posts
    7

    Smile Problem Resolution

    After a round of finger pointing between DBA's and NetAdmin's
    the DBA's bounced the package and now everybody can
    connect. So it was an Oracle and not a network problem.

Posting Permissions

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