SET and SHOW Commands of the Listener Control utility
1-2 Oracle Database Net Services Reference
For most commands, the Listener Control utility establishes an Oracle Net connection
with the listener that is used to transmit the command. To initiate an Oracle Net
connection to the listener, the Listener Control utility must obtain the protocol
addresses for the named listener or a listener named
LISTENER
. This is done by
resolving the listener name with one of the following mechanisms:
■
listener.ora
file in the directory specified by the
TNS_ADMIN
environment
variable
■
listener.ora
file in the
ORACLE_HOME/network/admin
directory.
■ Naming method, for example, a
tnsnames.ora
file
If none of the preceding mechanisms resolve the listener name, then the Listener
Control utility uses the default listener name
LISTENER
, resolves the host name IP
address and uses port 1521.
The Listener Control utility supports several types of commands:
■ Operational commands, such as START, and STOP.
■ Modifier commands, such as SET TRC_LEVEL.
■ Informational commands, such as STATUS and SHOW LOG_FILE.
1.2 SET and SHOW Commands of the Listener Control utility
You can use the SET command to alter parameter values for a specified listener. You
set the name of the listener you want to administer with the SET CURRENT_
LISTENER command. Parameter values remain in effect until the listener is shut
down. If you want these settings to persist, then use the SAVE_CONFIG command to
save changes to the
listener.ora
.
You can use the SHOW command to display the current value of a configuration
setting.
1.3 Distributed Operations
The Listener Control utility can perform operations on a local or a remote listener.
To set up a computer to remotely administer a listener, do the following:
1. Ensure that the Listener Control utility (
lsnrctl
) executable is installed in the
ORACLE_HOME/bin
directory.
2. Ensure that the name of the listener you want to administer can be resolved
through a
listener.ora
file or a naming method, as described in "Listener Control
Utility Overview" on page 1-1.
Note: You can combine commands in a standard text file, and then
run them as a sequence of commands. To execute in batch mode, use
the format:
lsnrctl @file_name
You can use either
REM
or
#
to identify comments in the batch script; all
other lines are considered commands. Any commands that would
typically require confirmation do not require confirmation during
batch execution.
剩余209页未读，继续阅读
