-
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 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
Last edited by matze; 10-14-2005 at 04:01 AM.
-
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
-
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~
-
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?
-
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>
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|