6 Replies Latest reply: Jan 15, 2013 4:30 AM by Vandy_Kh RSS

    Not able to start listener.

    Danish297
      Hi All,

      I am not able to start he oracle 10g listener, after DB upgrade from 9i to 10g using DBUA, during oracle apps upgrade from 11i to R12.

      I tried following things.

      1. Creation of listener using NETCA & NETMGR
      2. Manual creation of listener.

      IN ALL CASE I GET ERROR ( CAN NOT START LISTERNER, A LISTENER IS ALREADY RUNNING)

      PLEASE HELP ME ON IT.

      I am pasting here listener.ora and tnsname.ora file.



      [oracle@apps11 bin]$ lsnrctl start LISTENER

      LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 09-JAN-2013 17:49:46

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

      Starting /u002/proddb/10.2.0/bin/tnslsnr: please wait...

      TNS-12537: TNS:connection closed
      TNS-12560: TNS:protocol adapter error
      TNS-00507: Connection closed
      Linux Error: 29: Illegal seek
      [oracle@apps11 bin]$


      Listener.ora
      ============
      # listener.ora Network Configuration File: /u001/app/oracle/product/10.2.0/network/admin/listener.ora
      # Generated by Oracle configuration tools.

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u002/proddb/10.2.0)
      (PROGRAM = extproc)
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = apps11.com)(PORT = 1521))
      )
      )


      ==============
      tnsname.ora
      ==============

      # tnsnames.ora Network Configuration File: /u001/app/oracle/product/10.2.0/network/admin/tnsnames.ora
      # Generated by Oracle configuration tools.

      PROD =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = apps11.com)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD)
      )
      )

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )
        • 1. Re: Not able to start listener.
          415289
          IN ALL CASE I GET ERROR ( CAN NOT START LISTERNER, A LISTENER IS ALREADY RUNNING)
          means listener is already running.can you check the running listener process by ps -ef|grep lsnr.
          and stop and restart it from new home.
          • 2. Re: Not able to start listener.
            Danish297
            Hi,

            Thanks for your reply...

            but i tried this too.. but still facing issue....

            error is getting like listener is running, but when i am checking listener status by using below command nothing is showing.

            ps -ef|grep lsnr

            or

            ps -ef|grep tns

            even i tried to stop the default listener, but same error :-(
            • 3. Re: Not able to start listener.
              Danish297
              Hi Kuljeet,

              it might help you to understand my problem.


              [oracle@apps11 10.2.0]$ sqlplus '/ as sysdba'

              SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jan 10 17:05:10 2013

              Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


              Connected to:
              Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
              With the Partitioning, OLAP and Data Mining options

              SQL> select name,open_mode from v$database;

              NAME OPEN_MODE
              --------- ----------
              PROD READ WRITE


              [oracle@apps11 10.2.0]$ ps -ef|grep tns
              oracle 30022 29796 0 17:03 pts/1 00:00:00 grep tns
              [oracle@apps11 10.2.0]$ ps -ef|grep lsnr
              oracle 30024 29796 0 17:04 pts/1 00:00:00 grep lsnr
              [oracle@apps11 10.2.0]$


              [oracle@apps11 10.2.0]$ lsnrctl start

              LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 10-JAN-2013 17:02:14

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

              Starting /u002/proddb/10.2.0/bin/tnslsnr: please wait...

              TNS-12537: TNS:connection closed
              TNS-12560: TNS:protocol adapter error
              TNS-00507: Connection closed
              Linux Error: 29: Illegal seek
              [oracle@apps11 10.2.0]$ lsnrctl stop

              LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 10-JAN-2013 17:02:28

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

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
              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=TCP)(HOST=apps11.com)(PORT=1521)))
              TNS-12541: TNS:no listener
              TNS-12560: TNS:protocol adapter error
              TNS-00511: No listener
              Linux Error: 111: Connection refused
              [oracle@apps11 10.2.0]$



              [oracle@apps11 10.2.0]$ cat /etc/hosts
              # Do not remove the following line, or various programs
              # that require network functionality will fail.
              192.168.48.150 apps11.com apps11
              [oracle@apps11 10.2.0]$
              • 4. Re: Not able to start listener.
                EdStevens
                Danish297 wrote:
                Hi Kuljeet,

                it might help you to understand my problem.


                [oracle@apps11 10.2.0]$ sqlplus '/ as sysdba'

                SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jan 10 17:05:10 2013

                Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


                Connected to:
                Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
                With the Partitioning, OLAP and Data Mining options

                SQL> select name,open_mode from v$database;

                NAME OPEN_MODE
                --------- ----------
                PROD READ WRITE


                [oracle@apps11 10.2.0]$ ps -ef|grep tns
                oracle 30022 29796 0 17:03 pts/1 00:00:00 grep tns
                [oracle@apps11 10.2.0]$ ps -ef|grep lsnr
                oracle 30024 29796 0 17:04 pts/1 00:00:00 grep lsnr
                [oracle@apps11 10.2.0]$


                [oracle@apps11 10.2.0]$ lsnrctl start

                LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 10-JAN-2013 17:02:14

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

                Starting /u002/proddb/10.2.0/bin/tnslsnr: please wait...

                TNS-12537: TNS:connection closed
                TNS-12560: TNS:protocol adapter error
                TNS-00507: Connection closed
                Linux Error: 29: Illegal seek
                I would start by googling ' Linux Error: 29: Illegal seek'

                [oracle@apps11 10.2.0]$ lsnrctl stop

                LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 10-JAN-2013 17:02:28

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

                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                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=TCP)(HOST=apps11.com)(PORT=1521)))
                TNS-12541: TNS:no listener
                TNS-12560: TNS:protocol adapter error
                TNS-00511: No listener
                Linux Error: 111: Connection refused
                [oracle@apps11 10.2.0]$



                [oracle@apps11 10.2.0]$ cat /etc/hosts
                # Do not remove the following line, or various programs
                # that require network functionality will fail.
                192.168.48.150 apps11.com apps11
                [oracle@apps11 10.2.0]$
                Hmm. looks like someone ignored the line in /etc/hosts -- the one that says "Do not remove the following line, or various programs". How do I know that? Because the "following line" that it refers to looks like this:
                127.0.0.1 localhost.localdomain localhost
                EVERY hosts file should have the above line for exactly the reasons stated in the header comments that warn against removing that line.
                • 5. Re: Not able to start listener.
                  Danish297
                  Thanks a lot.

                  I was struggling for this last 6-7 days. now its working fine... once again many many thanks....

                  Edited by: Danish297 on Jan 15, 2013 12:13 PM
                  • 6. Re: Not able to start listener.
                    Vandy_Kh
                    Dear All Expert,

                    Now, I can resolve this issu.

                    Thanks and regards,
                    Vandy