Prev | Current Page 782 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

This places the user in the lsnrctl utility (as indicated by the LSNRCTL prompt).
The rest of the commands are entered from within this utility. The following examples show the
use of the lsnrctl utility to stop, start, and generate diagnostic information about the listener.
To stop the listener:
lsnrctl
LSNRCTL> set password lsnr_password
LSNRCTL> stop
To list status information for the listener:
lsnrctl status
To list the status of a listener on another host, add a service name from that host as a
parameter to the status command. The following example uses the HQ service name shown
earlier in this chapter:
lsnrctl status hq
To list version information about the listener:
lsnrctl version
To list information about the services supported by the listener:
Command Description
SPAWN Spawns a program that runs with an alias in the listener.ora file.
START Starts the listener.
STATUS Provides status information about the listener, including the time
it was started, its parameter filename, its log file, and the services
it supports. This can be used to query the status of a listener on a
remote server.
STOP Stops the listener.
TRACE Sets the trace level of the listener to one of four choices: OFF,
USER (limited tracing), ADMIN (high level of tracing), or
SUPPORT (for ORACLE Support).
VERSION Displays version information for the listener, TNS, and the
protocol adapters.
TABLE 15-2 Listener Control (lsnrctl) Utility Commands (continued)
Chapter 15: Oracle Net 531
lsnrctl
LSNRCTL> set password lsnr_password
LSNRCTL> services
NOTE
As of Oracle Database 10g Release 1, the default name for a listener
in a RAC database environment is LISTENER_HOSTNAME.


Pages:
770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794
usługi remontowe wycieczki do Skandynawii traktorki ogrodowe skarpetki narciarskie męskie perfumy fm