Urgent: ORA-12541: TNS:no listener issue
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Urgent: ORA-12541: TNS:no listener issue

Hybrid View

  1. #1
    Join Date
    Nov 2006
    Location
    Dallas,TX
    Posts
    6

    Urgent: ORA-12541: TNS:no listener issue

    Hi All,

    I am facing a wierd issue. When I am trying to connect to oracle through SQLPlus from my laptop, I receive a ORA-12541: TNS:no listener error. The wierd thing is I could connect oracle thorugh Toad and its working fine. Also other applications(Siebel) are able to find tnsnames.ora and connect to the database.

    I have installed and uninstalled Oracle multiple times and i recieve the same error. I am using the same tnsnames.ora thats used by my other team mates, which is working fine for them.

    TNSPING also gives me the same error.

    I used tracing to see the problem.

    The following are the trace file snapshot.
    =================================================
    NOV-2006 10:46:28:923] nttbnd2addr: entry
    [07-NOV-2006 10:46:28:923] nttgetport: entry
    [07-NOV-2006 10:46:28:923] nttgetport: port resolved to 1522
    [07-NOV-2006 10:46:28:923] nttgetport: exit
    [07-NOV-2006 10:46:28:923] nttbnd2addr: looking up IP addr for host: dmnsiebel.tdmn.belo.com
    [07-NOV-2006 10:46:28:933] nttbnd2addr: exit
    [07-NOV-2006 10:46:28:933] nsmal: 492 bytes at 0xd73ad0
    [07-NOV-2006 10:46:28:933] nsmal: 2348 bytes at 0xd73cc8
    [07-NOV-2006 10:46:28:933] nsopen: opening transport...
    [07-NOV-2006 10:46:28:933] nttcon: entry
    [07-NOV-2006 10:46:28:933] nttcon: toc = 1
    [07-NOV-2006 10:46:28:933] nttcnp: entry
    [07-NOV-2006 10:46:28:933] ntvlin: entry
    [07-NOV-2006 10:46:28:933] ntvllt: entry
    [07-NOV-2006 10:46:28:933] ntvllt: tcp.validnode_checking not turned on
    [07-NOV-2006 10:46:28:933] ntvllt: exit
    [07-NOV-2006 10:46:28:933] ntvlin: exit
    [07-NOV-2006 10:46:28:933] nttcnp: Validnode Table IN use; err 0x0
    [07-NOV-2006 10:46:28:933] nttcnp: exit
    [07-NOV-2006 10:46:28:933] nttcni: entry
    [07-NOV-2006 10:46:28:933] nttcni: trying to connect to socket 1860.
    [07-NOV-2006 10:46:29:053] ntt2err: entry
    [07-NOV-2006 10:46:29:053] ntt2err: soc 1860 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0
    [07-NOV-2006 10:46:29:053] ntt2err: exit
    [07-NOV-2006 10:46:29:053] nttcni: exit
    [07-NOV-2006 10:46:29:053] nttcon: exit
    [07-NOV-2006 10:46:29:053] nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
    [07-NOV-2006 10:46:29:053] nsopen: unable to open transport
    [07-NOV-2006 10:46:29:053] nsmfr: 2348 bytes at 0xd73cc8
    [07-NOV-2006 10:46:29:053] nsmfr: 492 bytes at 0xd73ad0
    [07-NOV-2006 10:46:29:053] nladget: entry
    [07-NOV-2006 10:46:29:053] nladget: exit
    [07-NOV-2006 10:46:29:053] nsmfr: 164 bytes at 0xd65ef0
    [07-NOV-2006 10:46:29:053] nladtrm: entry
    [07-NOV-2006 10:46:29:053] nladtrm: exit
    [07-NOV-2006 10:46:29:053] nioqper: error from nscall
    [07-NOV-2006 10:46:29:053] nioqper: nr err code: 0
    [07-NOV-2006 10:46:29:053] nioqper: ns main err code: 12541
    [07-NOV-2006 10:46:29:053] nioqper: ns (2) err code: 12560
    [07-NOV-2006 10:46:29:053] nioqper: nt main err code: 511
    [07-NOV-2006 10:46:29:053] nioqper: nt (2) err code: 61
    [07-NOV-2006 10:46:29:053] nioqper: nt OS err code: 0
    [07-NOV-2006 10:46:29:053] niomapnserror: entry
    [07-NOV-2006 10:46:29:063] niqme: entry
    [07-NOV-2006 10:46:29:063] niqme: reporting NS-12541 error as ORA-12541
    [07-NOV-2006 10:46:29:063] niqme: exit
    [07-NOV-2006 10:46:29:063] niomapnserror: returning error 12541
    [07-NOV-2006 10:46:29:063] niomapnserror: exit
    [07-NOV-2006 10:46:29:063] niotns: Couldn't connect, returning 12541
    [07-NOV-2006 10:46:29:113] niotns: exit
    [07-NOV-2006 10:46:29:113] nigtrm: Count in the NI global area is now 0
    [07-NOV-2006 10:46:29:113] nrigbd: entry
    [07-NOV-2006 10:46:29:113] nrigbd: exit
    [07-NOV-2006 10:46:29:113] nigtrm: Count in the NL global area is now 0

    Can anybody help as I am with this problem for almost a week now.

    Thanks in advance for your respone.

    Regards
    Prem

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    I'm assuming your using Windows. What are the values for your PATH and ORACLE_HOME environment variables?

    They should point to the location you installed the client and under which your tnsnames.ora file is located.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Nov 2006
    Location
    Dallas,TX
    Posts
    6
    Thanks for the response.

    Yes I am using windows client and the following are the details:
    Path=C:\oracle\product\9.2.0\client_3\bin
    ORACLE_HOME=C:\oracle\product\9.2.0\client_3 (Infact I created this ORACLE_HOME variable since it was not installed default, but still toad was working).

    Thanks

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Well, one thing is sure, Toad is not using the same connection driver.

    Can you ping the host listed in your tnsnames.ora file?

    Both client and server are 9.2.x, right?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  5. #5
    Join Date
    Nov 2006
    Location
    Dallas,TX
    Posts
    6
    I can ping the host listed in tnsnames.ora and only thsping gives me the same error.

    The server version of Oracle is 10.2 and every one in the team is using Oracle 9.2.x client to connect since its compatable with Toad (the version we use) and everybody else is able to connect.

  6. #6
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Something is different!

    Maybe I'm smokin crack here, but it looks like the server rejected the request (according to Oracle's published error text):

    ORA-12541: TNS:no listener
    Cause:
    The connection request could not be completed because the listener is not running.
    Action:
    Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  7. #7
    Join Date
    Nov 2006
    Location
    Dallas,TX
    Posts
    6
    Is there a way that we can track as what exactly is going wrong apart from the normal tracing?

  8. #8
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Is the database installed on your laptop or it is on another machine (server).
    The TOAD maigth connect using other protocol or if it is TCP/IP the port where the listener listens could be different.
    Log to the server and issue
    lsnrctl status
    (If it is windows do it in dos window)
    see where exactly the listener listens ( protocol host port) and fix that in the tnsnames.ora

    Good Luck

  9. #9
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    I even see the error in your trace
    port resolved to 1522

    Usually the listener listens on 1521

    Change that in the tnsnames

  10. #10
    Join Date
    Nov 2006
    Location
    Dallas,TX
    Posts
    6
    the database is running on a different box and the port is configured to listen only at 1522. The listerner is up and running and I could connect with the same tnsnames.ora from other client machines as well.

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