This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jan 23, 2013 4:31 AM by EdStevens Go to original post RSS
  • 15. Re: ORA-12541: TNS:no listener...please help
    jgarry Guru
    Currently Being Moderated
    user10525117 wrote:
    Hi All,

    "lsnrctl status" has resulted in this -

    LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 26-NOV-2008 15:01:42

    Copyright (c) 1991, 2005, Oracle. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    IBM/AIX RISC System/6000 Error: 79: Connection refused






    "lsnrctl start" -

    LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 26-NOV-2008 15:03:31

    Copyright (c) 1991, 2005, Oracle. All rights reserved.

    Starting /ora10g/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

    TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
    NL-00280: error creating log stream /ora10g/oracle/product/10.2.0/db_1/network/log/listener.log
    NL-00278: cannot open log file
    SNL-00016: snlfohd: error opening file
    IBM/AIX RISC System/6000 Error: 13: Permission denied

    Listener failed to start. See the error message(s) above...
    Try:

    ls -l /ora10g/oracle/product/10.2.0/db_1/network/log/listener.log

    It is possible the file exists and was created by someone whom you are not allowed to write over. It is also possible you have hit a limitation on the size of the file. It is also possible you simply don't have permissions to write to the file, do an ls -l on the whole directory and see who owns it and what permissions it has.

    >
    >
    >
    >
    /ora10g/oracle/product/10.2.0/db_1/network/log/listener.log says this -

    TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 26-NOV-2008 13:24:17

    Copyright (c) 1991, 2005, Oracle. All rights reserved.

    System parameter file is /etc/listener.ora
    Log messages written to /ora10g/oracle/product/10.2.0/db_1/network/log/listener.log
    Trace information written to /ora10g/oracle/product/10.2.0/db_1/network/trace/listener.trc
    Trace level is currently 0

    Started with pid=1839352
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.21.161.60)(PORT=1521)))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    TNS-12555: TNS:permission denied
    TNS-12560: TNS:protocol adapter error
    TNS-00525: Insufficient privilege for operation
    IBM/AIX RISC System/6000 Error: 1: Not owner
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.21.161.60)(PORT=1521)))
    Well, I guess that rules out a 2G file :-)

    You have some serious ownership issues. You need to find out which user/group installed Oracle, and whether root.sh was run. Then run the lsnrctl start as that user, especially checking the group id beforehand. Also check /tmp and maybe /var/tmp, it is possible to start up with a different owner, then not be able to start again with the correct owner, leaving files out there that mess you up.
  • 16. Re: ORA-12541: TNS:no listener...please help
    668640 Newbie
    Currently Being Moderated
    Thanks to all of you guys, the issue was resolved.

    The listener was down while the db was up.although we faced some issues starting the listener, but it was finally started well.
  • 17. Re: ORA-12541: TNS:no listener...please help
    986535 Newbie
    Currently Being Moderated
    How did you resolve this issue?

    Could you update the steps as well..

    Thanks
  • 18. Re: ORA-12541: TNS:no listener...please help
    EdStevens Guru
    Currently Being Moderated
    983532 wrote:
    How did you resolve this issue?

    Could you update the steps as well..

    Thanks
    Welcome to the forum. Did you notice that you were responding to a message that is over FOUR years old?
    Before proceeding, please read the forum FAQ. The link is in the upper right corner of this very page.
    I would then suggest you start your own thread, describing your own problem and what diagnostic steps you have already taken.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points