11 Replies Latest reply: Dec 9, 2012 11:54 PM by sb92075 RSS

    TNS-00525

    695836
      Hi orafamily,
      On RHEL 4, 10.2.0 64 bit , Ima unable to start listener.
      LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-MAY-2009 15:20:36
      
      Copyright (c) 1991, 2005, Oracle.  All rights reserved.
      
      Starting /u/oracle/bin/tnslsnr: please wait...
      
      TNSLSNR for Linux: Version 10.2.0.1.0 - Production
      System parameter file is /u/oracle/network/admin/listener.ora
      Log messages written to /u/oracle/network/log/listener.log
      Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
      TNS-12555: TNS:permission denied
       TNS-12560: TNS:protocol adapter error
        TNS-00525: Insufficient privilege for operation
         Linux Error: 1: Operation not permitted
      
      Listener failed to start. See the error message(s) above...
      I can DBSTART the database but not listener.
      $ ls -l lsn*
      -rwxr-x--x 1 oracle oracle 102723 Feb 24 2008 lsnrctl
      -rwxr-xr-x 1 oracle oracle 0 Jul 1 2005 lsnrctl0
      These are the contents of listener.ora file.I do not want to create a new one.
      # listener.ora Network Configuration File: /u/oracle/network/admin/listener.ora
      # Generated by Oracle configuration tools.
      
      SID_LIST_LISTENER =
        (SID_LIST =
          (SID_DESC =
            (SID_NAME = db2)
            (ORACLE_HOME = /u/oracle)
            (PROGRAM = extproc)
          )
        )
      
      LISTENER =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
            (ADDRESS = (PROTOCOL = TCP)(HOST = b1cadv)(PORT = 1521))
          )
        )
        • 1. Re: TNS-00525
          sybrand_b
          Hashmi,

          The error message looks clear enough. 'Permission denied' should provide sufficient clues.
          Either you are not using the owner of the software to start the listener, but as you hide that information, who can tell,
          or the tnslsnr execute hasn't the setgid bit set, which would have happened running rootpre.sh.
          Apart from that in cases like this one needs to look at listener.log and likely you didn't do that.

          ------------
          Sybrand Bakker
          Senior Oracle DBA
          • 2. Re: TNS-00525
            Toni Lazarin
            Do you have other instances on this server ?
            Can you paste tnsnames.ora entry for the db2 instance ?
            • 3. Re: TNS-00525
              695836
              Thankyou Sybrand for your kind comments.
              The setuid,setgid bits are not set as oracle is the owner of the software as you can see from ls -l command.As i understand setgid bit assumes every other user as the owner of the file.
              I did look up in listener.log and it states the same messages as I posted.
              Clearly it is a permission problem but not sure which permission the owner oracle is lacking.
              • 4. Re: TNS-00525
                695836
                Hi Toni,
                tnsnames.ora file has nothing to do with the error.Its a listener issue.Its a server side issue.I have only one instance running.
                • 5. Re: TNS-00525
                  Toni Lazarin
                  Could you see what error would you get if you rewrite that listener.ora like this :
                  SID_LIST_LISTENER =
                    (SID_LIST =
                      (SID_DESC =
                        (SID_NAME = PLSExtProc)
                        (ORACLE_HOME = /u/oracle)
                        (PROGRAM = extproc)
                      )
                      (SID_DESC =
                        (ORACLE_HOME = /u/oracle)
                        (SID_NAME = db2)
                          )
                    )
                  
                  LISTENER =
                    (DESCRIPTION_LIST =
                      (DESCRIPTION =
                        (ADDRESS = (PROTOCOL = TCP)(HOST = b1cadv)(PORT = 1521))
                        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
                      )
                    )
                  • 6. Re: TNS-00525
                    19426
                    Check for the existence of /var/tmp/.oracle. This directory must have 01777 permissions, something like

                    drwxrwxrwt 2 root dba 512 Apr 15 09:21 .oracle

                    Owner: root
                    Group: your <dba> group

                    Werner
                    • 7. Re: TNS-00525
                      695836
                      Tony,
                      You did the trick.
                      By changing EXTPROC1 to EXTPROC0,the listener was started.
                      Now what happened when changing EXTPROC1 to EXTPROC0?

                      Thanks
                      • 8. Re: TNS-00525
                        695836
                        Yes you are right werner.
                        The file with EXTPROC1 has daemon as owner and hence the insuffcient privilege error.
                        EXTPROC0 has oracle as owner and hence it worked.
                        There is so much necessary stuff that is not so easily available over the internet.

                        Thanks
                        • 9. Re: TNS-00525
                          977377
                          Hi ,

                          i am running into a similar issue. My DB is running(there is only one instance). I trying to connect Oracle database(on my local computer) through SQL Developer for more GUI oriented interaction. Although i am able to run queries from command line(by connecting to the oracle), I cannot connect to the database from SQL developer. It gave me the error: cannot establish connection to the Network adapter. On searching on net, i came across this article. i tried starting listener. I get the following output:

                          LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 01-DEC-2012 03:15:19

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

                          Starting /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr: please wait...

                          TNSLSNR for Linux: Version 11.2.0.2.0 - Production
                          System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
                          Log messages written to /u01/app/oracle/diag/tnslsnr/gocool/listener/alert/log.xml
                          Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                          TNS-12555: TNS:permission denied
                          TNS-12560: TNS:protocol adapter error
                          TNS-00525: Insufficient privilege for operation
                          Linux Error: 1: Operation not permitted

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




                          Also there was no error message in the log file. My listener.ora contains:
                          # listener.ora Network Configuration File:

                          SID_LIST_LISTENER =
                          (SID_LIST =
                          (SID_DESC =
                          (SID_NAME = PLSExtProc)
                          (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
                          (PROGRAM = extproc)
                          )
                          )

                          LISTENER =
                          (DESCRIPTION_LIST =
                          (DESCRIPTION =
                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
                          (ADDRESS = (PROTOCOL = TCP)(HOST = gocool)(PORT = 1521))
                          )
                          )

                          DEFAULT_SERVICE_LISTENER = (XE)



                          Please help,
                          gokul.
                          • 10. Re: TNS-00525
                            978873
                            We are using oracle 8i & unable to start listner......Please guide

                            /oracle/ora817 > lsnrctl start

                            LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 10-DEC-2012 12:06:38

                            (c) Copyright 1998 Oracle Corporation. All rights reserved.

                            Starting /oracle/ora817/bin/tnslsnr: please wait...

                            TNSLSNR for Linux: Version 8.1.7.0.0 - Production
                            System parameter file is /oracle/ora817/network/admin/listener.ora
                            Log messages written to /oracle/ora817/network/log/listener.log
                            Attempted to listen on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
                            TNS-12555: TNS:permission denied
                            TNS-12560: TNS:protocol adapter error
                            TNS-00525: Insufficient privilege for operation
                            Linux Error: 1: Operation not permitted
                            • 11. Re: TNS-00525
                              sb92075
                              user2729156 wrote:
                              We are using oracle 8i & unable to start listner......Please guide

                              /oracle/ora817 > lsnrctl start

                              LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 10-DEC-2012 12:06:38

                              (c) Copyright 1998 Oracle Corporation. All rights reserved.

                              Starting /oracle/ora817/bin/tnslsnr: please wait...

                              TNSLSNR for Linux: Version 8.1.7.0.0 - Production
                              System parameter file is /oracle/ora817/network/admin/listener.ora
                              Log messages written to /oracle/ora817/network/log/listener.log
                              Attempted to listen on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
                              TNS-12555: TNS:permission denied
                              TNS-12560: TNS:protocol adapter error
                              TNS-00525: Insufficient privilege for operation
                              Linux Error: 1: Operation not permitted
                              You should start your own thread.


                              How do I ask a question on the forums?
                              SQL and PL/SQL FAQ


                              when was last time listener started without error?
                              What changed since then?

                              It appear to be OS/Networking error.

                              what clues exist in the listener.log file?