Database Reference
In-Depth Information
And then selecting the listener service for Oracle and then
pressing the “play” on the tool bar of services console.
Figure 8-14: Starting listener process under Windows environment
using Services application (snap-in for MS Management Console)
under Control Panel > Administrative Tools.
C:\>lsnrctl start
This command will start the listener whereas if you replace
“start” with “stop” you can stop the listener. To check the status
of the listener use the following command.
C:\>lsnrctl status
What if you don't want to have default listener or in other words
you don't want the listener name to be LISTENER or port to be
1521 or even protocol to be TCP/IP. In this case you have to
define three more initialization parameters viz.,
INSTANCE_NAME, SERVICE_NAMES and
LOCAL_LISTENER for Oracle to register with the listener
dynamically e.g. if you want to run the listener on port other than
1521 then create the listener.ora file using that port number and
mention this information in the LOCAL_LISTENER parameter
in the init.ora file. For Oracle Instance to register dynamically
with the listener you have to set the INSTACNE_NAME to
name of the Instance in our case it should be takveen and the
 
Search WWH ::




Custom Search