1 2 Previous Next 18 Replies Latest reply: Jan 14, 2013 4:49 PM by 905952 RSS

    Listener refuse to reflect after creation

    905952
      Hi Everybody
      am running Oracle database 11.1.0 on RHEL 4 via vmware, I created a new listener called 'FERDICON' using netca, but the listener refuse to reflect. When I type' lsnrctl show current listener' it returns the old listener which is 'LISTENER'. Any suggestion on what to do will really be appreciated.

      Listener.ora

      FERDICON=
      (DESCRIPTION_LIST=
      (DESCRIPTION=
      (ADDRESS= (PROTOCOL=TCP) (HOST=localhost)(PORT=1521))
      (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPRO1521))
      )
      )



      tsnnames.ora

           HOSPITAL=
           (DESCRIPTION =
           (ADDRESS = (PROTOCOL=TCP)(HOST=localhost)(PORT=1521))
           
           (CONNECT_DATA=
           (SERVER=DEDICATED)
           (SERVICE_NAME=hospitalmgt
           )
           )

           LISTNER_ORCL
           (ADDRESS_LIST=
           (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1523))
           (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))
           )
           
           IMT_ADMI=
           (DESRIPTION=
           (PORT=1522))
           (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1522))
           (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1523))
           (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))
           
           (CONNECT_DATA=
           (SERVER=DEDICATED)
           (SERVICE_NAME=imt_admin
           )
           )
           
           
           LISTENER_IMTADMIN=
           (ADDRESS_LIST=
           (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1522))
           (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1523))
           (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))
           
           )
           
           ORCL=
           (DESCRIPTION=
           (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1523))
           (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))
           
           (CONNECT_DATA=
           (SERVER=DEDICATED)
           (SERVICE_NAME=orcl)
      )
      )
           





      Regards
      Ferdicon_Mary
        • 1. Re: Listener refuse to reflect after creation
          sb92075
          single listener is more than sufficient.
          single listener can support multiple everything so no need for 2nd listener.
          • 2. Re: Listener refuse to reflect after creation
            905952
            I only have a single Listener
            • 3. Re: Listener refuse to reflect after creation
              P.Forstmann
              Try to stop current listener but without any listener.ora so that LSNRCTL can connect to current listener.
              mv listener.ora listener.ora.tmp
              lsnrctl stop listener
              Then start new listener with listener.ora:
              mv listener.ora.tmp listener.ora
              lsnrctl start ferdicon
              lsnrctl status ferdicon
              lsnrctl show current_listener
              Edited by: P. Forstmann on 14 janv. 2013 19:46

              Edited by: P. Forstmann on 14 janv. 2013 19:47
              • 4. Re: Listener refuse to reflect after creation
                905952
                lsnrctl stop listener
                lsnrctl start ferdicon
                lsnrctl status ferdicon
                lsnrctl show current listener


                I tried it out and it is still showing current listener as the old one 'LISTENER'
                • 5. Re: Listener refuse to reflect after creation
                  P.Forstmann
                  Please post full output of each statement.
                  • 6. Re: Listener refuse to reflect after creation
                    sb92075
                    Ferdicon wrote:
                    lsnrctl stop listener
                    lsnrctl start ferdicon
                    lsnrctl status ferdicon
                    lsnrctl show current listener


                    I tried it out and it is still showing current listener as the old one 'LISTENER'
                    I thought you said you have only 1 listener.
                    • 7. Re: Listener refuse to reflect after creation
                      905952
                      mv listener.ora listener.ora.tmp


                      When I typed the above command, it produced an error "mv: cannot stat 'listener.ora': No such file or directory"
                      • 8. Re: Listener refuse to reflect after creation
                        905952
                        Yeah I Have only one listener which is 'FERDICON' the currently Listener showing is 'LISTENER'. i supposed the 'LISTENER' is the deleted one or so.

                        here is my listener.ora


                             FERDICON=
                             (DESCRIPTION_LIST=
                             (DESCRIPTION=
                             (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))
                             (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))
                             )
                             )
                        • 9. Re: Listener refuse to reflect after creation
                          P.Forstmann
                          I am not sure you can get the output you want. LSNRCTL considers "ferdicon" to be an alias (see "Alias" line in LSNRCTL output):
                          [oracle@lx01 admin]$ cat listener.ora
                          ferdicon=
                          (DESCRIPTION=
                           (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))
                          )
                          [oracle@lx01 admin]$ lsnrctl status ferdicon
                          
                          LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 14-JAN-2013 20:05:00
                          
                          Copyright (c) 1991, 2007, Oracle.  All rights reserved.
                          
                          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
                          STATUS of the LISTENER
                          ------------------------
                          Alias                     ferdicon
                          Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
                          Start Date                14-JAN-2013 20:02:49
                          Uptime                    0 days 0 hr. 2 min. 11 sec
                          Trace Level               off
                          Security                  ON: Local OS Authentication
                          SNMP                      OFF
                          Listener Parameter File   /u01/app/oracle/product/10.2.0/EE/network/admin/listener.ora
                          Listener Log File         /u01/app/oracle/product/10.2.0/EE/network/log/ferdicon.log
                          Listening Endpoints Summary...
                            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lx01.localdomain)(PORT=1521)))
                          The listener supports no services
                          The command completed successfully
                          
                          [oracle@lx01 admin]$ lsnrctl show current_listener
                          
                          LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 14-JAN-2013 20:03:40
                          
                          Copyright (c) 1991, 2007, Oracle.  All rights reserved.
                          
                          Current Listener is LISTENER
                          You can try:
                          [oracle@lx01 admin]$ lsnrctl
                          
                          LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 14-JAN-2013 20:05:39
                          
                          Copyright (c) 1991, 2007, Oracle.  All rights reserved.
                          
                          Welcome to LSNRCTL, type "help" for information.
                          
                          LSNRCTL> set current_listener ferdicon
                          Current Listener is ferdicon
                          LSNRCTL> show current_listener
                          Current Listener is ferdicon
                          LSNRCTL> exit
                          It looks like SHOW CURRENT_LISTENER works only in LSNRCTL command line mode (i.e. after start LSNRCTL without any parameters and entering LSNRCTL statements).

                          Edited by: P. Forstmann on 14 janv. 2013 20:08
                          • 10. Re: Listener refuse to reflect after creation
                            EdStevens
                            Ferdicon wrote:
                            Yeah I Have only one listener which is 'FERDICON' the currently Listener showing is 'LISTENER'. i supposed the 'LISTENER' is the deleted one or so.

                            here is my listener.ora


                                 FERDICON=
                                 (DESCRIPTION_LIST=
                                 (DESCRIPTION=
                                 (ADDRESS = (PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))
                                 (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))
                                 )
                                 )
                            Why? Since only one listener is needed and only one listener is recommended, why complicate your life by trying to give that one listener a non-default name? You don't even need a listener.ora file at all. Without it, your listener will start with all default values, which is sufficient to get you started.
                            • 11. Re: Listener refuse to reflect after creation
                              BobLilly
                              show current_listener only shows the value set by set current_listener. current_listener ALWAYS defaults to LISTENER--it doesn't depend on what listener you start or what you have defined in listener.ora.

                              Regards,
                              Bob
                              • 12. Re: Listener refuse to reflect after creation
                                905952
                                LSNRCTL> set current_listener ferdicon
                                Current Listener is ferdicon
                                LSNRCTL> show current_listener
                                Current Listener is ferdicon
                                LSNRCTL> exit


                                This is the same output i got. So what should I do exactly?. Thanks for the help so far.
                                • 13. Re: Listener refuse to reflect after creation
                                  P.Forstmann
                                  As already said by BobLilly and by me there is nothing you can do to have your listener name/alias in "LSNRCTL SHOW CURRENT_LISTENER" output.

                                  If you want to be sure of which listener is started look for "Alias" in LSNRCTL STATUS output or try ps:
                                  [oracle@lx01 admin]$ ps -eaf | grep tns
                                  oracle    3228     1  0 20:02 ?        00:00:00 /u01/app/oracle/product/10.2.0/EE/bin/tnslsnr ferdicon -inherit
                                  • 14. Re: Listener refuse to reflect after creation
                                    905952
                                    Thanks for the tip, So what do now? Should i discard the listerner 'FERDICON' and create a new listener with default name =LISTENER ?
                                    1 2 Previous Next