Oracle 11g2的監(jiān)聽器配置教程

更新時(shí)間：2012年11月30日 09:08:05 作者：

Oracle的監(jiān)聽器服務(wù)注冊(cè)方式有兩種，分別為動(dòng)態(tài)和靜態(tài),本文將詳細(xì)介紹這兩種,需要的朋友可以參考下

Oracle的監(jiān)聽器服務(wù)注冊(cè)方式有兩種，分別為動(dòng)態(tài)和靜態(tài)。通過動(dòng)態(tài)注冊(cè)的服務(wù)在lsnrctl status時(shí)顯示的狀態(tài)為ready，靜態(tài)的服務(wù)為unknown。
11g2以前的版本，監(jiān)聽器通過listener.ora文件進(jìn)行配置。在11g2版本中，監(jiān)聽器的配置方式發(fā)生了變化，增加了一個(gè)新的配置文件endpoints_listener.ora，并且此文件和原來的listener.ora文件都轉(zhuǎn)移到$GRID_HOME/network/admin目錄下了。

11g2的監(jiān)聽器的配置信息保存在$GRID_HOME/network/admin/listener.ora和endpoints_listener.ora兩個(gè)文件中。
文件endpoints_listener.ora的內(nèi)容如下：
.ora代碼

復(fù)制代碼代碼如下:

 
LISTENER_SERV2= 
(DESCRIPTION= 
( 
ADDRESS_LIST= 
(ADDRESS=(PROTOCOL=TCP)(HOST=xxdb2-vip)(PORT=1551)) 
(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.100)(PORT=1551)(IP=FIRST)) 
) 
) 

文件listener.ora的內(nèi)容如下：
.ora代碼

復(fù)制代碼代碼如下:

 
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent 
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent 
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent 
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent 
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_WFG=ON # line added by Agent 

.ora代碼
##靜態(tài)服務(wù)注冊(cè)添加條目

復(fù)制代碼代碼如下:

 
SID_LIST_LISTENER = 
(SID_LIST = 
(SID_DESC = 
(GLOBAL_DBNAME = servdb) 
(ORACLE_HOME = /u01/oracle/app/oracle/product/10.2.0/db) 
(SID_NAME = servdb1) 
) 
) 

如果需要添加靜態(tài)注冊(cè)的服務(wù)，和以前版本一樣是在listener.ora文件中添加相應(yīng)的條目。
使用lsnrctl status listener檢查監(jiān)聽器狀態(tài)，如下：
Log代碼

復(fù)制代碼代碼如下:

 
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-NOV-2012 14:18:34 
Copyright (c) 1991, 2011, Oracle. All rights reserved. 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) 
STATUS of the LISTENER 
------------------------ 
Alias listener 
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production 
Start Date 29-NOV-2012 14:11:17 
Uptime 0 days 0 hr. 7 min. 17 sec 
Trace Level off 
Security ON: Local OS Authentication 
SNMP OFF 
Listener Parameter File /u01/app/11.2.0.3/grid/network/admin/listener.ora 
Listener Log File /u01/app/grid/diag/tnslsnr/serv2/listener/alert/log.xml 
Listening Endpoints Summary... 
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) 
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.100)(PORT=1521))) 
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.101)(PORT=1521))) 
Services Summary... 
Service "+ASM" has 1 instance(s). 
Instance "+ASM2", status READY, has 1 handler(s) for this service... 
Service "SERVDG2" has 1 instance(s). 
Instance "servdb1", status READY, has 1 handler(s) for this service... 
Service "SERVDG2_XPT" has 1 instance(s). 
Instance "servdb1", status READY, has 1 handler(s) for this service... 
Service "elvdb" has 2 instance(s). 
Instance "elvdb1", status UNKNOWN, has 1 handler(s) for this service... 
Instance "elvdb2", status READY, has 1 handler(s) for this service... 
Service "elvdbXDB" has 1 instance(s). 
Instance "elvdb2", status READY, has 1 handler(s) for this service... 
The command completed successfully 

在11g2的grid infrastructure上安裝oracle 10g，10g的監(jiān)聽器配置文件也要采用$GRID_HOME/network/admin下的文件。
但需要做一個(gè)折中操作，將10g的$ORACLE_HOME/network/admin下listener.ora文件設(shè)置為$GRID_HOME/network/admin下endpoints_listener.ora的文件鏈接。

您可能感興趣的文章: