【RAC】lsnrctl 工具不適合管理監聽
oracle 11gr2 不應使用lsnrctl管理LISTENER,而需使用srvctl或crsctl工具管理,否則lsnrctl將不會識別endpoints_listener.ora中的資訊,造成監聽沒有在必要地址、埠上工作。
grid@rac1:/home/grid>cat /opt/11202/11.2.0/grid/network/admin/endpoints_listener.ora
LISTENER_RAC1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.250.7.225)(PORT=1521)(IP=FIRST)))) # line added by Agent
grid@rac1:/home/grid>cat /opt/11202/11.2.0/grid/network/admin/listener.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
grid@rac1:/home/grid>
grid@rac1:/home/grid>lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 04-DEC-2011 22:15:09
Copyright (c) 1991, 2010, 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.2.0 - Production
Start Date 03-DEC-2011 22:55:26
Uptime 0 days 23 hr. 19 min. 42 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/11202/11.2.0/grid/network/admin/listener.ora
Listener Log File /opt/rac/grid/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.250.7.225)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.250.7.111)(PORT=1521)))
Services Summary...
Service "rac" has 1 instance(s).
Instance "rac1", status READY, has 1 handler(s) for this service...
Service "racXDB" has 1 instance(s).
Instance "rac1", status READY, has 1 handler(s) for this service...
The command completed successfully
grid@rac1:/home/grid>
grid@rac1:/home/grid>lsnrctl reload
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 04-DEC-2011 22:15:36
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
The command completed successfully
grid@rac1:/home/grid>lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 04-DEC-2011 22:15:38
Copyright (c) 1991, 2010, 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.2.0 - Production
Start Date 03-DEC-2011 22:55:26
Uptime 0 days 23 hr. 20 min. 12 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/11202/11.2.0/grid/network/admin/listener.ora
Listener Log File /opt/rac/grid/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
The listener supports no services
The command completed successfully
grid@rac1:/home/grid>
使用srvctl 工具重新啟動監聽
grid@rac1:/home/grid>srvctl stop listener
grid@rac1:/home/grid>srvctl status listener
監聽程式 LISTENER 已啟用
監聽程式 LISTENER 未執行
grid@rac1:/home/grid>srvctl start listener
grid@rac1:/home/grid>
grid@rac1:/home/grid>
grid@rac1:/home/grid>srvctl status listener
監聽程式 LISTENER 已啟用
監聽程式 LISTENER 正在節點上執行: rac2,rac1
grid@rac1:/home/grid>
grid@rac1:/home/grid>
grid@rac1:/home/grid>lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 04-DEC-2011 22:16:52
Copyright (c) 1991, 2010, 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.2.0 - Production
Start Date 04-DEC-2011 22:16:40
Uptime 0 days 0 hr. 0 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/11202/11.2.0/grid/network/admin/listener.ora
Listener Log File /opt/rac/grid/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.250.7.225)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.250.7.111)(PORT=1521)))
The listener supports no services
The command completed successfully
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-712696/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RAC中lsnrctl和srvctl的區別(監聽狀態異常)
- Oracle 11g RAC 監聽日常管理Oracle
- 【RAC】srvctl管理工具新增新監聽和靜態註冊
- 監聽器控制程式lsnrctl跟蹤trace file
- 融雲猿桌派:聽說女生不適合搞 IT,哈?
- rac監聽動態註冊
- Oracle LISTENER監聽檔案引數詳解及Lsnrctl命令綜述Oracle
- oracle監聽器啟動lsnrctl status例程的狀態為unknownOracle
- java監聽組合鍵Java
- oracle 資料庫lsnrctl監聽的日誌路徑和trace檔案Oracle資料庫
- 究竟你適不適合買Mac?Mac
- 12C RAC 修改監聽埠
- rac監聽不能動態註冊
- oracle rac scan監聽更改埠號Oracle
- 11g rac監聽配置解析
- 一次RAC監聽停止分析
- rac的vip和監聽莫名故障
- Oracle RAC Database 11.1.0.6監聽故障案例OracleDatabase
- 注意別聽人忽悠!其實這4類人並不適合IT行業行業
- Python適合不適合零基礎學習呢?Python
- rac scan listener log 清理監聽日誌 oracleOracle
- rac中解除安裝監聽lsnr和asmASM
- RAC 監聽中的 IP=FIRST 是啥意思?
- 如何選擇合適的小型專案管理工具?專案管理
- 選擇最適合的線上專案管理工具專案管理
- oracle 10g rac當監聽程式監聽對方vip時啟動監聽報錯TNS-12545Oracle 10g
- 【RAC】刪除RAC資料庫節點(三)——刪除監聽資料庫
- python到底適不適合大型專案呢?Python
- TNS監聽起不來的原因分析
- jsp好像不適合自學啊JS
- oracle rac的scan監聽狀態Not All Endpoints RegisteredOracle
- Oracle 10g RAC客戶端配置監聽Oracle 10g客戶端
- Flutter - 生命週期監聽和管理Flutter
- 監聽日誌檔案的管理
- 哪種代理適合價格監控?
- IT專案管理工具推薦:選擇最適合你的優秀工具專案管理
- 在rhel5上啟動監聽器lsnrctl start報錯_Linux Error: 113: No route to hostLinuxError
- 專案管理必備,如何選擇適合自己的專案管理工具?專案管理