Listener Status
June 8, 2009
Tags: oracle listener
监听有三种状态:block、unkown、ready
Service “+ASM” has 1 instance(s).
Instance “+ASM2″, status BLOCKED, has 1 handler(s) for this service…
监听有动态注册与静态注册两种
动态注册的情况下,服务的状态主要是以下2种:
BLOCKED:表示此实例不能接受客户端连接,只能通过本机访问。ASM实例不需要客户端连接,当然是BLOCK状态。如果客户端需要访问ASM,将ASM实例配置为静态注册即可!
READY:表示此实例可接受连接
UNKNOWN状态,表示此实例在listener.ora文件中注册而不是通过动态服务注册,因而不知道其状态。
下面是RAC监听的配置文件,动态注册
LISTENER_NEWSDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = newsdb1-vip)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 本机物理IP)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
监听状态:
Service “+ASM_XPT” has 1 instance(s).
Instance “+ASM2″, status BLOCKED, has 1 handler(s) for this service…
Service “dyora” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 2 handler(s) for this service…
Service “newsdb” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 2 handler(s) for this service…
Service “newsdbXDB” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 1 handler(s) for this service…
Service “newsdb_XPT” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 2 handler(s) for this service…
静态注册:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /db/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = IntranetOracle)
(ORACLE_HOME = /db/oracle/product/10.2.0/db_1)
(SID_NAME = cdcIntranet)
)
)
)
June 8, 2009
Tags: oracle listener
监听有三种状态:block、unkown、ready
Service “+ASM” has 1 instance(s).
Instance “+ASM2″, status BLOCKED, has 1 handler(s) for this service…
监听有动态注册与静态注册两种
动态注册的情况下,服务的状态主要是以下2种:
BLOCKED:表示此实例不能接受客户端连接,只能通过本机访问。ASM实例不需要客户端连接,当然是BLOCK状态。如果客户端需要访问ASM,将ASM实例配置为静态注册即可!
READY:表示此实例可接受连接
UNKNOWN状态,表示此实例在listener.ora文件中注册而不是通过动态服务注册,因而不知道其状态。
下面是RAC监听的配置文件,动态注册
LISTENER_NEWSDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = newsdb1-vip)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 本机物理IP)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
监听状态:
Service “+ASM_XPT” has 1 instance(s).
Instance “+ASM2″, status BLOCKED, has 1 handler(s) for this service…
Service “dyora” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 2 handler(s) for this service…
Service “newsdb” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 2 handler(s) for this service…
Service “newsdbXDB” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 1 handler(s) for this service…
Service “newsdb_XPT” has 2 instance(s).
Instance “newsdb1″, status READY, has 1 handler(s) for this service…
Instance “newsdb2″, status READY, has 2 handler(s) for this service…
静态注册:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /db/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = IntranetOracle)
(ORACLE_HOME = /db/oracle/product/10.2.0/db_1)
(SID_NAME = cdcIntranet)
)
)
)