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 f³r diesen Dienst...
Dienst "w9900057" hat 1 Instanz(en).
Instanz "w9900057", Status READY, hat 1 Handler f³r diesen Dienst...
Dienst "w9900057XDB" hat 1 Instanz(en).
Instanz "w9900057", Status READY, hat 1 Handler f³r 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