Oracle Tips  by Burleson Consulting

The Data Warehouse Development Life Cycle

Understanding The SQL*Net Listener

To see what the Oracle listener is doing, Oracle provides a series of listener commands, including:

* lsnrctl reload--Refreshes the listener.

* lsnrctl start--Starts the listener.

* lsnrctl stop--Stops the listener.

* lsnrctl status--Shows the status of the listener.


Following is the output of a lsnrctl status command:

[oracle]ram2: lsnrctl stat

LSNRCTL for HPUX:Version 2.0.15.0.0 - Production on 16-SEP-94 15:38:00

Copyright (a) Oracle Corporation 1993. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=ram2)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX:Version 2.0.15.0.0-Production
Start Date 29-AUG-94 13:50:16
Uptime 18 days 1 hr. 47 min. 45 sec
Trace Level off
Security OFF
Listener Parameter File /etc/listener.ora
Listener Log File /usr/oracle/network/log/listener.log
Services Summary...
dev7db has 1 service handlers
ram2db has 1 service handlers
The command completed successfully

lsnrctl services - lists all servers and dispatchers

[oracle]seagull: lsnrctl services

LSNRCTL for HPUX:Version 2.0.15.0.0-Production on 16-SEP-94 15:36:47

This is an excerpt from "High Performance Data Warehousing".

If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts.  You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.