Listener again
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Listener again

  1. #1
    Join Date
    Oct 2005
    Posts
    3

    Listener again

    Hi,

    out of the reason having two database server for playing around I put the Oracle Enterprise Server on my NT-workstation. Having finished installation I didn't see a listener.ora but requesting the status of the listener gave me:

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Verbindung mit (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=w9900057)(PORT=1521))) wird aufgebaut
    STATUS des LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
    Startdatum 14-OKT-2005 08:21:21
    Uptime 0 Tage 0 Std. 13 Min. 58 Sek.
    Trace-Ebene off
    Sicherheit OFF
    SNMP OFF
    Parameterdatei des Listener D:\programme\oracle\network\admin\listener.ora
    Log-Datei des Listener D:\programme\oracle\network\log\listener.log
    Zusammenfassung Listening-Endpunkte...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MYWS)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MYWS)(PORT=8080))(Presentation=HTTP)(Session=RAW))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MYWS)(PORT=2100))(Presentation=FTP)(Session=RAW))
    Services _bersicht...
    Dienst "PLSExtProc" hat 1 Instanz(en).
    Instanz "PLSExtProc", Status UNKNOWN, hat 1 Handler fr diesen Dienst...
    Dienst "w9900057" hat 1 Instanz(en).
    Instanz "w9900057", Status READY, hat 1 Handler fr diesen Dienst...
    Dienst "w9900057XDB" hat 1 Instanz(en).
    Instanz "w9900057", Status READY, hat 1 Handler fr diesen Dienst...

    Issueing TNSPING lead into eating up memory an CPU but no response came back. I set up a listener.ora:


    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MYWS)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\programme\oracle)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = MYWS)
    (ORACLE_HOME = d:\programme\oracle)
    (SDU = 8192)
    (SID_NAME = MYWS)
    )
    )

    corrected listener.ora

    Restarted the listener, but TNSPING again eats up memory and CPU.
    Why does listener listen?


    Any help wellcome

    matze
    Last edited by matze; 10-14-2005 at 04:01 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why does the listener listen when there is no listener.ora file? well it starts everthing with default and then your database registers with the listener so thats why it works

  3. #3
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    By default, There is a one default listener (Listener) always running. whenever you startup your database, pmon registers database with that listener.
    you can check it at lsnrctl prompt as you have already done..you can check current listener by writting.
    lsrctl> show current_Listener
    Last edited by dhar_kiran; 10-18-2005 at 02:35 AM.
    ~KD.DBA~

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by dhar_kiran
    By default, There is a one default listener (Listener) always running. whenever you startup your database, pmon registers database with that listener.
    you can check it at lsnrctl prompt as you have already done..you can check current listener by writting.
    lsrctl> show Listener
    oh really?

    Code:
    LSNRCTL for Linux: Version 9.2.0.5.0 - Production on 17-OCT-2005 09:50:53
    
    Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
    
    Welcome to LSNRCTL, type "help" for information.
    
    LSNRCTL> show listener
    NL-00853: undefined show command "listener".  Try "help show"
    perhaps try what you suggest in the future?

  5. #5
    Join Date
    May 2002
    Location
    Western Australia
    Posts
    233
    Perhaps

    Code:
    lsnrctl
    
    LSNRCTL for 32-bit Windows: Version 9.2.0.6.0 - Production on 17-OCT-2005
    57
    
    Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
    
    Welcome to LSNRCTL, type "help" for information.
    
    LSNRCTL> sho current_listener
    Current Listener is LISTENER
    LSNRCTL>

  6. #6
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    Quote Originally Posted by davey23uk
    oh really?

    Code:
    LSNRCTL for Linux: Version 9.2.0.5.0 - Production on 17-OCT-2005 09:50:53
    
    Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
    
    Welcome to LSNRCTL, type "help" for information.
    
    LSNRCTL> show listener
    NL-00853: undefined show command "listener".  Try "help show"
    perhaps try what you suggest in the future?

    yes, ngdh is right,it is
    LSNRCTL> show current_listener
    ~KD.DBA~

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width