12 Replies Latest reply: Jan 14, 2013 5:19 AM by Ankur ... RSS

    Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525

    Ankur ...
      Hi All,

      I am newbie to oracle and i have been struggling from last one week to get this error corrected on my database.

      Listener services are not working due to which i'm unable to proceed my work. Please provide ur help as i really want to learn.

      Edited by: 978366 on Jan 12, 2013 6:18 AM
        • 1. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
          sb92075
          978366 wrote:
          Hi All,

          I am newbie to oracle and i have been struggling from last one week to get this error corrected on my database.

          Listener services are not working due to which i'm unable to proceed my work. Please provide ur help as i really want to learn.

          Edited by: 978366 on Jan 12, 2013 6:18 AM
          listener is NOT required to access local database.

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


          It is unclear exactly what you are doing so it is not possible to say what you are doing wrong.
          12550, 00000, "TNS:syntax error"
          // *Cause: The supplied connect descriptor contains illegal syntax.
          // *Action: Check the syntax of the connect descriptor in TNSNAMES.ORA.
          [oracle@localhost ~]$ oerr tns 525
          00525, 00000, "Insufficient privilege for operation"
          // *Cause:  Operating system failed to complete operation because user
          // lacked sufficient privileges.
          // *Action: Check your platform-specific privileges.
          [oracle@localhost ~]$ oerr tns 12560
          12560, 00000, "TNS:protocol adapter error"
          // *Cause: A generic protocol adapter error occurred.
          // *Action: Check addresses used for proper protocol specification. Before
          // reporting this error, look at the error stack and check for lower level
          // transport errors. For further details, turn on tracing and reexecute the
          // operation. Turn off tracing when the operation is complete.
          multiple different errors
          SNAFU!
          • 2. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
            Ankur ...
            I know That a i don't need a listener configuration to access my database but still when i check the lsnrctl status it should work
            • 3. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
              sb92075
              978366 wrote:
              I know That a i don't need a listener configuration to access my database but still when i check the lsnrctl status it should work
              If the listener has NOT been started, errors get thrown from OS command below.

              lsnrctl status
              [oracle@localhost ~]$ lsnrctl stop
              
              LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 12-JAN-2013 07:18:15
              
              Copyright (c) 1991, 2010, Oracle.  All rights reserved.
              
              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
              The command completed successfully
              [oracle@localhost ~]$ lsnrctl status
              
              LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 12-JAN-2013 07:18:27
              
              Copyright (c) 1991, 2010, Oracle.  All rights reserved.
              
              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
              TNS-12541: TNS:no listener
               TNS-12560: TNS:protocol adapter error
                TNS-00511: No listener
                 Linux Error: 111: Connection refused
              [oracle@localhost ~]$ 
              How do I ask a question on the forums?
              SQL and PL/SQL FAQ
              • 4. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
                moreajays
                Hi,

                If its Unix then follow this

                http://samadhandba.wordpress.com/2011/09/21/tns-12555-tns-12560-tns-00525-error-listening-on-descriptionaddressprotocolipckeyextproc1/


                Thanks,
                Ajay More
                http://moreajays.blogspot.com
                • 5. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
                  sb92075
                  realize that we don't even know your Operating System name & version and solution may be OS dependent.
                  • 6. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
                    Osama_Mustafa
                    I am newbie to oracle and i have been struggling from last one week to get this error corrected on my database.
                    what is change in this week ?

                    also notice you should provide

                    DB version
                    select * from v$version;
                    and OS version

                    in every thread you post
                    • 7. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
                      Pavan Kumar
                      Hi,

                      refers to oracle docs

                      http://docs.oracle.com/cd/B28359_01/network.111/b28317/listener.htm
                      "Configuring and Administering Oracle Net Listener" - http://docs.oracle.com/cd/B28359_01/network.111/b28316/listenercfg.htm

                      - Pavan Kumar N
                      oracleinternals.blogspot.com
                      • 8. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
                        Ankur ...
                        Thank you so much for all the replies but still my question is unanswered.
                        My database version is 10.2.0.1 which is installed on OEL4 version.
                        when i try to start the listener it throws all the errors mentioned in subject line.
                        I'm unable to copy data from my vmvare so that i can give you better understanding about the problem by pasting my listener.ora,tnsname.ora and listener status
                        • 9. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
                          Osama_Mustafa
                          you could copy the content here if you installed vmware tools that enable copy & paste features.
                          • 10. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
                            sb92075
                            978366 wrote:
                            Thank you so much for all the replies but still my question is unanswered.
                            My database version is 10.2.0.1 which is installed on OEL4 version.
                            when i try to start the listener it throws all the errors mentioned in subject line.
                            I'm unable to copy data from my vmvare so that i can give you better understanding about the problem by pasting my listener.ora,tnsname.ora and listener status
                            consider to install VirtualBox & then a configured VM that includes Oracle DB from http://otn.oracle.com
                            • 11. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
                              Dizwell
                              Start by posting your listener.ora.
                              Then cut-and-pastes of the actual errors you are experiencing, and the context in which they are happening.

                              Then check other posts for some of your errors. The 525 error, in particular, is a permissions problem, and might indicate the sorts of issues that were discussed in [url https://forums.oracle.com/forums/thread.jspa?threadID=897030] this post, which has a nice example of posting the errors, the context in which they arose and the listener.ora that gave rise to them.
                              • 12. Re: Error while starting listener on my database TNS-1255,TNS-12560, TNS-00525
                                Ankur ...
                                Please take a look at all the details asked by you guys. It will really helpful if this can get fixed

                                [oraprod@mycomp admin]$ cat /etc/hosts
                                # Do not remove the following line, or various programs
                                # that require network functionality will fail.
                                10.10.10.100 mycomp.mydomain.com mycomp

                                [oraprod@mycomp admin]$ uname -a
                                Linux mycomp.mydomain.com 2.6.9-89.0.0.0.1.ELhugemem #1 SMP Tue May 19 04:38:38 EDT 2009 i686 i686 i386 GNU/Linux

                                SQL> select * from v$version;

                                BANNER
                                ----------------------------------------------------------------
                                Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
                                PL/SQL Release 10.2.0.1.0 - Production
                                CORE 10.2.0.1.0 Production
                                TNS for Linux: Version 10.2.0.1.0 - Production
                                NLSRTL Version 10.2.0.1.0 - Production


                                ---------------------------
                                listener.ora entry
                                ---------------------------

                                LISTENER =
                                (DESCRIPTION_LIST =
                                (DESCRIPTION =
                                (ADDRESS = (PROTOCOL = TCP)(HOST = mycomp.mydomain.com)(PORT = 1521))
                                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCO))
                                )
                                )

                                SID_LIST_LISTENER =
                                (SID_LIST =
                                (SID_DESC =
                                (GLOBAL_DBNAME = test.mycomp.mydomain.com)
                                (ORACLE_HOME = /u01/app/oraprod/product/1020/db_1)
                                (SID_NAME = test)
                                (SID_DESC =
                                (SID_NAME = PLSExtProc)
                                (ORACLE_HOME = /u01/app/oraprod/product/1020/db_1)
                                (PROGRAM = extproc)
                                )
                                )


                                ------------------------------------
                                tnsname.ora entry
                                -------------------------------------

                                TEST =
                                (DESCRIPTION =
                                (ADDRESS_LIST =
                                (ADDRESS = (PROTOCOL = TCP)(HOST = mycomp.mydomain.com)(PORT = 1521))
                                )
                                (CONNECT_DATA =
                                (SERVICE_NAME = TEST)
                                )
                                )


                                ---------------------------
                                listener status
                                --------------------------

                                [oraprod@mycomp admin]$ lsnrctl status

                                LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-JAN-2013 16:44:33

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

                                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mycomp.mydomain.com)(PORT=1521)))
                                TNS-12541: TNS:no listener
                                TNS-12560: TNS:protocol adapter error
                                TNS-00511: No listener
                                Linux Error: 111: Connection refused
                                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCO)))
                                TNS-12541: TNS:no listener
                                TNS-12560: TNS:protocol adapter error
                                TNS-00511: No listener
                                Linux Error: 111: Connection refused
                                [oraprod@mycomp admin]$ lsnrctl start

                                LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-JAN-2013 16:44:44

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

                                Starting /u01/app/oraprod/product/1020/db_1/bin/tnslsnr: please wait...

                                TNS-12537: TNS:connection closed
                                TNS-12560: TNS:protocol adapter error
                                TNS-00507: Connection closed
                                Linux Error: 29: Illegal seek
                                [oraprod@mycomp admin]$