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?
Reply With Quote