Prev | Current Page 778 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

The following command can be used to perform this check:
[oracle@dw ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.1.0.5.0 - Beta on 08-AUG-2007 19:58:40
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dw)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.5.0 ??“ Beta
Start Date 02-AUG-2007 19:06:23
Uptime 6 days 0 hr. 52 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File
/u01/app/oracle/diag/tnslsnr/dw/listener/alert/log.xml
528 Oracle Database 11g DBA Handbook
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dw)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "dw.world" has 1 instance(s).
Instance "dw", status READY, has 1 handler(s) for this service...
Service "dwXDB.world" has 1 instance(s).
Instance "dw", status READY, has 1 handler(s) for this service...
Service "dw_XPT.world" has 1 instance(s).
Instance "dw", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@dw ~]$
If the listener is named anything other than LISTENER in the listener.


Pages:
766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790
spa nad morzem Apartamenty nad morzem alveo aminokwasy tatralandia hotele