lsnrctl中關于status狀態(tài)的說明

LSNRCTL status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lixora)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 11-AUG-2014 00

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lixora)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 11-AUG-2014 00:42:37
Uptime 0 days 0 hr. 24 min. 32 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u02/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lixora)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ora10g" has 1 instance(s).
Instance "ora10g", status READY, has 1 handler(s) for this service...
Service "ora10gXDB" has 1 instance(s).
Instance "ora10g", status READY, has 1 handler(s) for this service...
Service "ora10g_XPT" has 1 instance(s).
Instance "ora10g", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

關于‘Instance "ora10g", status READY, has 1 handler(s) for this service...’
中status 狀態(tài)解釋：
這個status 指的的是instance 的狀態(tài)

Instance Specifies the name of the instance associated with the service along
with its status and number of service handlers associated with the
service
Status can be one of the following:
■ A READY status means that the instance can accept connections.
-----實例是動態(tài)由pmon注冊，所以顯示的status 當然是‘ready’

■ A BLOCKED status means that the instance cannot accept connections.
-----實例無法接受連接，一般是實例處于nomount 狀態(tài)下，pmon 無法將注冊到監(jiān)聽，因為這時數(shù)據(jù)庫還沒有打開pmon無法確定db能否對外服務

■ A READY/SECONDARY status means that this is a secondary instance in an Oracle9 i Real Application Clusters
primary/secondary configuration and is ready to accept connections.

■ An UNKNOWN status means that the instance is registered statically in the listener.ora file rather than dynamically
with service registra tion. Therefore, the status is non known.
------這個‘unknown’ 表征實例是靜態(tài)注冊到監(jiān)聽

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com