主頁 > 知識庫 > Oracle 11g2的監(jiān)聽器配置教程

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

熱門標簽:沈陽400電話是如何辦理 北京外呼系統(tǒng)公司排名 外呼系統(tǒng)鄭州 溫州人工外呼系統(tǒng) 百度地圖標注員是干什么 貴陽智能電銷機器人官網(wǎng) 北京營銷外呼系統(tǒng)廠家 地圖標注付款了怎么找不到了 外呼系統(tǒng)口號
Oracle的監(jiān)聽器服務(wù)注冊方式有兩種,分別為動態(tài)和靜態(tài)。通過動態(tài)注冊的服務(wù)在lsnrctl status時顯示的狀態(tài)為ready,靜態(tài)的服務(wù)為unknown。
11g2以前的版本,監(jiān)聽器通過listener.ora文件進行配置。在11g2版本中,監(jiān)聽器的配置方式發(fā)生了變化,增加了一個新的配置文件endpoints_listener.ora,并且此文件和原來的listener.ora文件都轉(zhuǎn)移到$GRID_HOME/network/admin目錄下了。

11g2的監(jiān)聽器的配置信息保存在$GRID_HOME/network/admin/listener.ora和endpoints_listener.ora兩個文件中。
文件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ù)注冊添加條目
復(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)注冊的服務(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下的文件。
但需要做一個折中操作,將10g的$ORACLE_HOME/network/admin下listener.ora文件設(shè)置為$GRID_HOME/network/admin下endpoints_listener.ora的文件鏈接。
您可能感興趣的文章:
  • Oracle監(jiān)聽器被優(yōu)化大師掛掉后的完美解決方法
  • Linux下重啟oracle服務(wù)及監(jiān)聽器和實例詳解
  • Oracle 監(jiān)聽器密碼設(shè)置方法(LISTENER)
  • Oracle監(jiān)聽口令及監(jiān)聽器安全詳解
  • Oracle監(jiān)聽器服務(wù)不能啟動的解決方法
  • Oracle安裝監(jiān)聽器錯誤的解決方法

標簽:定西 包頭 溫州 潮州 通遼 衢州 淮北 衡水

巨人網(wǎng)絡(luò)通訊聲明:本文標題《Oracle 11g2的監(jiān)聽器配置教程》,本文關(guān)鍵詞  Oracle,11g2,的,監(jiān)聽器,配置,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題,煩請?zhí)峁┫嚓P(guān)信息告之我們,我們將及時溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《Oracle 11g2的監(jiān)聽器配置教程》相關(guān)的同類信息!
  • 本頁收集關(guān)于Oracle 11g2的監(jiān)聽器配置教程的相關(guān)信息資訊供網(wǎng)民參考!
  • 推薦文章