Prev | Current Page 779 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

ora file, you must add the
name of the listener to the status command. For example, if the listener is named MY_LSNR,
the command is
lsnrctl status my_lsnr
The status output will show if the listener has been started and the services it is currently
supporting, as defined by its listener.ora file. The listener parameter file and its log file location
will be displayed.
If you wish to see the operating system??“level processes that are involved, use the following
command. This example uses the Unix ps -ef command to list the system??™s active processes. The
grep tnslsnr command then eliminates those rows that do not contain the term ???tnslsnr.???
[oracle@dw ~]$ ps -ef | grep tnslsnr
oracle 5931 1 0 Aug04 ? 00:00:46
/u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr LISTENER ??“inherit
oracle 25124 23035 0 20:02 pts/2 00:00:00 grep tnslsnr
[oracle@dw ~]$
This output shows two processes: the listener process and the process that is checking for it.
The first line of output is wrapped to the second line and may be truncated by the operating system.
Controlling the Listener Server Process
You can use the Listener Control utility, lsnrctl, to start, stop, and modify the listener process on
the database server. Its command options are listed in Table 15-2. Each of these commands may
be accompanied by a value; for all except the set password command, that value will be a listener
name. If no listener name is specified, the default (LISTENER) will be used.


Pages:
767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791
hosting seo szafy buchsbaum loans online instant approval Spa w Ciechocinku