1 2 Previous Next 18 Replies Latest reply: Jan 23, 2013 6:31 AM by EdStevens Go to original post RSS
      • 15. Re: ORA-12541: TNS:no listener...please help
        jgarry
        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
          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
            How did you resolve this issue?

            Could you update the steps as well..

            Thanks
            • 18. Re: ORA-12541: TNS:no listener...please help
              EdStevens
              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