grid默认监听未注册
上一篇 / 下一篇 2012-12-20 09:09:41 / 个人分类:数据库
grid@linux173:~>
crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE
SERVER
STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG_ORA.dg
ONLINE ONLINE
linux173
ora.LISTENER.lsnr
ONLINE INTERMEDIATE
linux173 Not All Endpoints R
egistered
ora.asm
ONLINE ONLINE
linux173
Started
ora.ons
OFFLINE OFFLINE linux173
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1
ONLINE ONLINE linux173
ora.diskmon
1
OFFLINE OFFLINE
ora.evmd
1
ONLINE ONLINE linux173
原因:
R2存在两个监听,一个是默认监听,一个是业务数据监听,信息如下:
监听名称 |
默认端口 |
管理者 |
LISTENER |
1521 |
grid |
LISTENER_ORA |
自定义 |
oracle |
其中,(OS级)grid用户管理默认监听LISTENER;(OS级)oracle用户管理业务监听,端口自定义,但不能使用1521端口。
遇见这个问题,首先查看grid的默认监听文件,确认默认监听中端口与当前crs中是否一致。通过listener.ora文件中端口与crs中启用的端口(可通过netstat –an过滤1521端口,查看1521是否处于监听状态),经相互对比,默认监听文件中端口是1522,crs中是1521,说明有人修改过默认监听配置文件中端口,导致crs中与监听配置文件中不一致。解决过程如下:
1、 修改默认监听配置文件中监听端口为1521;
2、 停掉has中默认监听资源(crsctl stop res ora.LISTENER.lsnr)
3、 从has中删掉默认监听资源(srvctl remove listener -l LISTENER)
grid@linux173:~>
crsctl stat res
-t
--------------------------------------------------------------------------------
NAME TARGET STATE
SERVER
STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG_ORA.dg
ONLINE ONLINE
linux173
ora.asm
ONLINE ONLINE
linux173 Started
ora.ons
OFFLINE OFFLINE linux173
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1
ONLINE ONLINE linux173
ora.diskmon
1
OFFLINE OFFLINE
ora.evmd
1
ONLINE INTERMEDIATE linux173
结果显示是没有默认监听资源的,已经成功删除.
4、 重新创建默认监听(srvctl add listener -l LISTENER -o $ORACLE_HOME)
grid@linux173:~>
srvctl add
listener -l LISTENER -o $ORACLE_HOME
grid@linux173:~>
crsctl stat res
-t
--------------------------------------------------------------------------------
NAME TARGET STATE
SERVER
STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG_ORA.dg
ONLINE ONLINE
linux173
ora.LISTENER.lsnr
OFFLINE OFFLINE linux173
ora.asm
ONLINE ONLINE
linux173
Started
ora.ons
OFFLINE OFFLINE linux173
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1
ONLINE ONLINE linux173
ora.diskmon
1
OFFLINE OFFLINE
ora.evmd
1
ONLINE ONLINE linux173
5、 启动默认监听(crsctl start res ora.LISTENER.lsnr)
grid@linux173:~>
crsctl start res ora.LISTENER.lsnr
CRS-2672:
Attempting to start 'ora.LISTENER.lsnr' on 'linux173'
CRS-2676: Start of
'ora.LISTENER.lsnr' on 'linux173' succeeded
6、 查看默认监听状态
grid@linux173:~>
crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE
SERVER
STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG_ORA.dg
ONLINE ONLINE
linux173
ora.LISTENER.lsnr
ONLINE ONLINE linux173
ora.asm
ONLINE ONLINE
linux173
Started
ora.ons
OFFLINE OFFLINE linux173
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1
ONLINE ONLINE linux173
ora.diskmon
1
OFFLINE OFFLINE
ora.evmd
TAG:
标题搜索
日历
|
|||||||||
日 | 一 | 二 | 三 | 四 | 五 | 六 | |||
1 | 2 | 3 | 4 | 5 | 6 | ||||
7 | 8 | 9 | 10 | 11 | 12 | 13 | |||
14 | 15 | 16 | 17 | 18 | 19 | 20 | |||
21 | 22 | 23 | 24 | 25 | 26 | 27 | |||
28 | 29 | 30 |
我的存档
数据统计
- 访问量: 74129
- 日志数: 162
- 图片数: 1
- 文件数: 13
- 建立时间: 2008-06-11
- 更新时间: 2015-09-22