Oracle rac listener启动出错

最新推荐文章于 2021-04-06 12:13:25 发布
最新推荐文章于 2021-04-06 12:13:25 发布
阅读量207 收藏 1
点赞数
分类专栏： ORACLE管理 文章标签： Oracle UP
问题症状
在二节点启动一节点监听出错
[quote][oracle@racsvr2 bdump]$ srvctl start listener -n racsvr1
CRS-0215: Could not start resource 'ora.racsvr1.LISTENER_RACSVR1.lsnr'.[/quote]
查看crs资源状态，发现一节点vip启动在二节点上
[quote]# su - oracle
[oracle@racsvr1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE OFFLINE
ora....R1.lsnr application ONLINE OFFLINE
ora....vr1.gsd application ONLINE ONLINE racsvr1
ora....vr1.ons application ONLINE ONLINE racsvr1
[color=red]ora....vr1.vip application ONLINE ONLINE racsvr2 [/color]
ora....SM2.asm application ONLINE ONLINE racsvr2
ora....R2.lsnr application ONLINE ONLINE racsvr2
ora....vr2.gsd application ONLINE ONLINE racsvr2
ora....vr2.ons application ONLINE ONLINE racsvr2
ora....vr2.vip application ONLINE ONLINE racsvr2 [/quote]
查看二节点网卡情况，crs状态反映真实
[quote]# ifconfig -a
eth0 Link encap:Ethernet HWaddr 00:0C:29:1B:8B:60
inet addr:130.36.21.3 Bcast:130.36.21.255 Mask:255.255.255.0
inet6 addr: fec0::e:20c:29ff:fe1b:8b60/64 Scope:Site
inet6 addr: 2002:8224:1501:e:20c:29ff:fe1b:8b60/64 Scope:Global
inet6 addr: fe80::20c:29ff:fe1b:8b60/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:3122 errors:0 dropped:0 overruns:0 frame:0
TX packets:3033 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:444832 (434.4 KiB) TX bytes:505264 (493.4 KiB)
Interrupt:67 Base address:0x2424

eth0:1 Link encap:Ethernet HWaddr 00:0C:29:1B:8B:60
inet addr:130.36.21.222 Bcast:130.36.21.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:67 Base address:0x2424

eth0:2 Link encap:Ethernet HWaddr 00:0C:29:1B:8B:60
inet addr:130.36.21.111 Bcast:130.36.21.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:67 Base address:0x2424

eth1 Link encap:Ethernet HWaddr 00:0C:29:1B:8B:6A
inet addr:192.168.1.3 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr: fec0::e:20c:29ff:fe1b:8b6a/64 Scope:Site
inet6 addr: 2002:8224:1501:e:20c:29ff:fe1b:8b6a/64 Scope:Global
inet6 addr: fe80::20c:29ff:fe1b:8b6a/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:32620 errors:0 dropped:0 overruns:0 frame:0
TX packets:26075 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:31691043 (30.2 MiB) TX bytes:19874273 (18.9 MiB)
Interrupt:75 Base address:0x24a4

lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:20619 errors:0 dropped:0 overruns:0 frame:0
TX packets:20619 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:13941404 (13.2 MiB) TX bytes:13941404 (13.2 MiB)

sit0 Link encap:IPv6-in-IPv4
NOARP MTU:1480 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b) [/quote]
一节点重新分配vip资源
[quote]# ./crs_relocate ora.racsvr1.vip -c racsvr1
Attempting to stop `ora.racsvr1.vip` on member `racsvr2`
Stop of `ora.racsvr1.vip` on member `racsvr2` succeeded.
Attempting to start `ora.racsvr1.vip` on member `racsvr1`
Start of `ora.racsvr1.vip` on member `racsvr1` succeeded.
# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE OFFLINE
ora....R1.lsnr application ONLINE OFFLINE
ora....vr1.gsd application ONLINE ONLINE racsvr1
ora....vr1.ons application ONLINE ONLINE racsvr1
ora....vr1.vip application ONLINE ONLINE racsvr1
ora....SM2.asm application ONLINE ONLINE racsvr2
ora....R2.lsnr application ONLINE ONLINE racsvr2
ora....vr2.gsd application ONLINE ONLINE racsvr2
ora....vr2.ons application ONLINE ONLINE racsvr2
ora....vr2.vip application ONLINE ONLINE racsvr2 [/quote]
接下来启动资源正常
[quote]# srvctl start asm -n racsvr1
# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE racsvr1
ora....R1.lsnr application ONLINE OFFLINE
ora....vr1.gsd application ONLINE ONLINE racsvr1
ora....vr1.ons application ONLINE ONLINE racsvr1
ora....vr1.vip application ONLINE ONLINE racsvr1
ora....SM2.asm application ONLINE ONLINE racsvr2
ora....R2.lsnr application ONLINE ONLINE racsvr2
ora....vr2.gsd application ONLINE ONLINE racsvr2
ora....vr2.ons application ONLINE ONLINE racsvr2
ora....vr2.vip application ONLINE ONLINE racsvr2
# srvctl start listener -n racsvr1
# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE racsvr1
ora....R1.lsnr application ONLINE ONLINE racsvr1
ora....vr1.gsd application ONLINE ONLINE racsvr1
ora....vr1.ons application ONLINE ONLINE racsvr1
ora....vr1.vip application ONLINE ONLINE racsvr1
ora....SM2.asm application ONLINE ONLINE racsvr2
ora....R2.lsnr application ONLINE ONLINE racsvr2
ora....vr2.gsd application ONLINE ONLINE racsvr2
ora....vr2.ons application ONLINE ONLINE racsvr2
ora....vr2.vip application ONLINE ONLINE racsvr2 [/quote]
zhoul77777
关注
专栏目录
Oracle R2 11g rac监听启动/停止
weixin_33804990的博客
01-07 1万+
切换到grid用户，在其中一个节点执行如下： srvctl stop listener -n ams2 srvctl start listener -n ams2 srvctl stop listener -n ams1 srvctl start listener -n ams1 crs_stop ora.LISTENER_SCAN1.lsnr crs_stop ora.scan1.vip ...
【Oracle】之Centos7.6安装部署Oracle19c RAC集群
博学思的博客
11-01 1252
生产环境根据企业业务发展和项目需求，会根据业务的重要性，对业务数据库选型，并建立数据模型，数据库设计等。本次针对Oracle数据库的RAC集群环境做安装部署，RAC集群是企业最在orale数据库中最常用的一种部署方案，通过RAC集群可实现oracle数据库实例级别的高可用。磁盘RAID、共享存储、DG、OGG及流技术可实现oracle集群架构的组合高可用方案，可同城灾备，也可异地容灾。
RAC环境下listener无法启动案例分析
lb517290079的专栏
04-26 193
RAC系统重新配置listener后无法启动: [root@rac02 admin]# [root@rac01 bin]# ./crs_start ora.rac02.LISTENER1_RAC02.lsnrAttempting to start `ora.rac02.LISTENER1_RAC02.lsnr` on member `rac02`Start of `ora.rac02.LIS...
RAC其中一个节点VIP资源和Listener资源无法启动
12-19 331
前两天帮客户处理了一个故障，故障现象如下：10.2.0.4RAC两节点，AIX操作系统，其中一个节点的VIP资源和listener资源无法启动。因为监听文件中配置了对vip的监听，所以，问题的关键是先将vip资源...
启动listener 出错 Linux Error: 29: Illegal seek error
cm771207的博客
07-23 125
在linux中运行lsnrctl start出现错误 LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 23-JUL-2009 12:09:01 Copyright ...
oracle rac 注册监听,oracle rac下添加静态注册监听器listener
weixin_39976413的博客
04-03 568
通过设置不同的listener，可以在一台服务器多实例c环境下实现业务的隔离，方便业务起停和管理。添加的方法除了netca外，比较简单的方式是使用srvctl命令，具体用法如下 [grid@dtydb5 ~]$ srvctl add listener -hAdds a listener configuration to the Oracle Clusterware.Usage: srvctl ad...
Oracle RAC环境实时数据迁移
夜澜偶作庄周梦 酒后聊为楚客狂
01-06 7717
Oracle RAC环境实时数据迁移———————————————————————————————————————系统要求及安装前的说明Oracle GoldenGate可以在Oracle不同版本间移动数据，也可以在Oracle和其它类型数据库之间移动数据。Oracle GoldenGate支持数据的过滤、映射和转换。Oracle还能在相似的Oracle数据库之间复制DDL操作。注意下面一句：当D
Oracle 11gR2 RAC实时应用集群
yangpingping94的博客
07-24 1145
Oracle11gR2 RAC实时应用集群在RedHat Enterprise Linux5 x86_64下的集群(ASM篇) (Oracle11gR2 + Grid + RHEL5 + ASM)    RAC(Real Application Clusters,实时应用集群)，是多台主机组成的集群计算环境，是Oracle数据库支持网格计算环境的核心技术。     普通Oracle数据库
oracle 数据库起监听,oracle启动数据库监听
weixin_42562124的博客
04-06 983
linux/Aix启动、关闭Oracle及监听Aix环境下管理Oracle1、Aix下查看、启动数据库监听器以oracle用户执行以下命令：① lsnrctl status //-查看监听器状态② lsnrctl start //-启动监听器2、Aix下启动/停止Oracle数据库实例① su – oracle ...文章undefault2014-06-05814浏览量linux/Aix启...
oracle11用pfile启动,oracle11g pfile 与spfile
weixin_32284931的博客
04-05 733
今天，改动了oracle数据库实例的启动配置文件，导致数据库不能启动，出现各种错误，幸好在网上搜到了大量的解决方案，虽然不全符合，但综合起来最终解决问题。首先描述一下问题：我误改了D:\oracle\app\Administrator\product\11.2.0\dbhome_1\database\下的SPFILEMYORCL.ORA文件。“D:\oracle\app\Administrator...
oracle crs中监听资源状态异常(ora.LISTENER.lsnr)
渔夫数据库笔记
11-11 7984
oracle crs中监听资源状态异常(ora.LISTENER.lsnr)
oracle集群监听启动,在RAC中lsnrctl和srvctl操作监听区别
weixin_28848833的博客
04-05 2441
朋友今天询问了一个问题RAC中使用srvctl 操作监听和lsnrctl 操作监听结果不一样，下面我通过实验说明问题0.listener.ora文件内容LISTENER_RAC1 =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)(IP = FIRST))(ADDRE...
【DB笔试面试733】在Oracle中，RAC中REMOTE_LISTENER的作用是什么？
小麦苗DBA宝典
01-17 2079
♣题目部分在Oracle中，RAC中REMOTE_LISTENER的作用是什么？ ♣答案部分REMOTE_LISTENER参数主要用于RAC环境中监听器的远程注册，监听器的远程注...
oracle 11g rac 监听无法启动
weixin_33716557的博客
05-22 1073
1.数据库启动集群报错 [root@db1 bin]# ./crs_stat -t -v Name Type R/RA F/FT Target State Host ----------------------------------------------------------------------...
oracle scan ip 手动切换节点
qq_40066204的博客
01-22 1693
grid@wxoadb01:~$srvctl status scan SCAN VIP scan1 已启用 SCAN VIP scan1 正在节点 wxoadb01 上运行 grid@wxoadb01:~$srvctl status scan_listener SCAN 监听程序 LISTENER_SCAN1 已启用 SCAN 监听程序 LISTENER_SCAN1 正在节点 wxoadb01 上运行 grid@wxoadb01:~$timed out waiting for input: auto-log
启动ASM 实例 报错 先启动LISTENER 在启动 ASM
数据库天地
01-01 279
[oracle@node2 bin]$ ./crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....B1.inst application ONLINE ONLINE node1 ora....B2.inst applicati...
/tmp文件系统无权限导致监听listener启动失败
conggangdian4456的博客
02-23 522
启动监听失败： cli19-hx8uat<*tpi3hx8*/orahome/app/oracle/network/admin>$lsnrctl start TPI3HX8...
检测Oracle服务,oracle 服务的故障转移测试
weixin_39980809的博客
04-04 181
###################SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 29 10:47:09 2020Version 19.7.0.0.0创建新的服务[oracle@rac1:/home/oracle]$ srvctl add service -d tbcsa -s tbcsa2_1 -r tbcsa2 -a tbcsa1[...
Oracle RAC数据库启动与关闭操作指南
"该文档详细介绍了Oracle RAC数据库的正常启动和关闭操作步骤，适合数据库操作人员参考。" 在Oracle数据库操作中，特别是对于Real Application Clusters (RAC)环境，正确的启动和关闭过程至关重要，以确保数据的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值