This discussion is archived
11 Replies Latest reply: Dec 9, 2012 9:54 PM by sb92075 RSS

TNS-00525

695836 Journeyer
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    Do you have other instances on this server ?
    Can you paste tnsnames.ora entry for the db2 instance ?
  • 3. Re: TNS-00525
    695836 Journeyer
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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?

Legend

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