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

Thread: Listener again

Threaded View

  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.

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