This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jan 14, 2013 2:49 PM by 905952 RSS

Listener refuse to reflect after creation

905952 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I only have a single Listener
  • 3. Re: Listener refuse to reflect after creation
    P.Forstmann Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    Please post full output of each statement.
  • 6. Re: Listener refuse to reflect after creation
    sb92075 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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