Lsnrctl

From Oracle FAQ

lsnrctl is a utility used for controlling the database listener.

In the examples below, listener_name will refer to the name of the listener as defined in the listener.ora file. If you have not changed the listener's name, then it would be called LISTENER (the default).

Contents 1 Getting started 2 Lsnrctl commands 2.1 Start a listener 2.2 Check listener status 2.3 Check registered services 2.4 Stop a listener 2.5 Reload a listener 3 Also see

Getting started

Invoke the "lsnrctl" utility from the command line. Here ia a Unix/ Linux example - printing the help screen and exit:

$ lsnrctl
LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 06-MAR-2008 15:57:02
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL>
LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:

start               stop                status
services            version             reload
save_config         trace               spawn
change_password     quit                exit
set*                show*

LSNRCTL> exit

Lsnrctl commands

Start a listener

If the listener has not been started, start it with the command:

lsnrctl> start listener_name

Check listener status

Check if a listener has been started on the remote node. Check the status with the STATUS command:

lsnrctl
lsnrctl> status listener_name

Check registered services

To see what database services is registered with a listener:

lsnrctl> services listener_name

Stop a listener

To stop a database listener:

lsnrctl> stop listener_name

Reload a listener

To reload a database listener (stop and restart without disrupting the service):

lsnrctl> reload listener_name

Also see

• SQL*Net - Oracle Networking
• Listener - Database listener process
• listener.ora - Listener configuration file