Ora-12541:TNS:no listener
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Ora-12541:TNS:no listener

  1. #1
    Join Date
    Mar 2006
    Posts
    4

    Question Ora-12541:TNS:no listener

    Hello all,

    I run an application based on Oracle 8.1.7 (Server OS: Windows 2000 SP4) and all of a sudden, on a random basis, I started to get an error message on client machines - "Ora-12541:TNS:no listener", not being able then to connect to the db. The problem happens more often on a client machine where I have the Web Server of my application.

    The OracleOra817TNSListener service is started and I even if I stop and restart it, or try the "lsnrctl stop/start" commands, the error persists. After rebooting the server the application runs fine, but after a while the message starts to come up again on a the client side.

    The TNSNAMES.ORA on the client matches the file with the same name on the server. The TNSPING on the client side runs fine and then suddenly I get the NO LISTENER error.

    I performed a fresh installation in the beginning of the year and just recently I started to get this error. I also read some previous messages on this forum regarding the error but could not conclude what is happening at my environment.

    I would appreciate any help. Thank you very much!
    Ivo

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Can you verify that the listener is going up and down?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Mar 2006
    Posts
    4
    I am not sure if I understand your question, but even when I get the error, the service is up and running. Also, even typing lsnrctl stop/start the error persists.

    Thank you!!

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Put it another way, is your listener really going up and down or is it always up even when you get these error messages?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Mar 2006
    Posts
    4
    It is always up even when I get these error messages. Again, everything is running fine and all of a sudden the error message appears. Then, after rebooting the client machine I can connect correctly to the db on the server until I get the error again (on the client side).

    Thank you again!

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I'd be looking at two things:
    1. make sure the instance is registered in the listener.ora.
    2. make sure your local_listener parameter in the init.ora is pointing to the correct listener.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Mar 2006
    Posts
    4
    On the server machine I do have a init.ora, but it does not have a local_listener parameter. There is no such file on the client side.

    The listener.ora on the server machine is like this:

    # LISTENER.ORA Network Configuration File: C:\oracle\ora817\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dx06smt3)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = dx06smt3)(PORT = 2481))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oracle\ora817)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = decasp.dx06)
    (ORACLE_HOME = C:\oracle\ora817)
    (SID_NAME = decasp)
    )
    )

    The Global name, SID, Oracle home and Host entries are all correct.

    What really surprises me is that, as I mentioned before, the problem happens more often on a client machine where I have the Web Server of my application and not on the other Win32 client machines.

    Thank you!!

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