導讀:1建站知識Oracle的監聽器服務注冊方式有兩種，分別為動態和靜態,本文將詳細介紹這兩種,需要的朋友可以參考下網seo優化趨勢網站建設公司。

Oracle的監聽器服務注冊方式有兩種，分別為動態和靜態。通過動態注冊的服務在lsnrctl status時顯示的狀態為ready，靜態的服務為unknown。 11g2以前的版本，監聽器通過listener.ora文件進行配置。在11g2版本中，監聽器的配置方式發生了變化，增加了一個新的配置文件endpoints_listener.ora，并且此文件和原來的listener.ora文件都轉移公司網站建設到$GRID_HOME/network/admin目錄下了。 11g2的監聽器的配置信息保存在$GRID_HOME/network/admin/listener.ora和endpoints_listener.ora兩個文件中。 文件endpoints_listener.ora的內容如下： .ora代碼

復制代碼 代碼如下:

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的內容如高端網站建設下： .ora代碼

復制代碼 代碼如下:

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代碼 ##靜態服務注冊添加條目

復制代碼 代碼如下:

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

如果需要添加靜態注冊的服務，和以前版本一樣是在listener.ora文件中添加相應的條目。 使用lsnrctl status listener檢查監聽器狀態，如下： Log代碼

復制代碼 代碼如下:

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-NOV-2012 14:18:34 Copyright (c) 1991, 2011, Oracle. All rights reser網站建設公司ved. 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

關鍵詞標簽: 標簽 監聽器