oracle rac ora 12560,Oracle10gRAC监听报TNS-12545TNS-12560TNS-00515

Oracle 10g RAC监听报TNS-12545 TNS-12560 TNS-00515

昨日在客户现场一套RAC在启动监听的时候报TNS-12545 TNS-12560 TNS-00515错误，经过处理后恢复正常，，

今天在自己的虚拟机上还原了这个问题，记录下：

OS:Linux

DB:10.2.0.4 RAC

一、模拟恢复到事故发生时的情况

1、手工关闭监听后切换VIP

[Oracle@orlrac1 ~]$

[oracle@orlrac1 ~]$ srvctl stop listener -n orlrac1

[oracle@orlrac1 ~]$ srvctl stop listener -n orlrac2

[oracle@orlrac1 ~]$

[oracle@orlrac1 ~]$

[oracle@orlrac1 ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.orcldb.db application ONLINE ONLINE orlrac1

ora....b1.inst application ONLINE ONLINE orlrac1

ora....b2.inst application ONLINE ONLINE orlrac2

ora....SM1.asm application ONLINE ONLINE orlrac1

ora....C1.lsnr application OFFLINE OFFLINE

ora....ac1.gsd application ONLINE ONLINE orlrac1

ora....ac1.ons application ONLINE ONLINE orlrac1

ora....ac1.vip application ONLINE ONLINE orlrac1

ora....SM2.asm application ONLINE ONLINE orlrac2

ora....C2.lsnr application OFFLINE OFFLINE

ora....ac2.gsd application ONLINE ONLINE orlrac2

ora....ac2.ons application ONLINE ONLINE orlrac2

ora....ac2.vip application ONLINE ONLINE orlrac2

[oracle@orlrac1 ~]$

2、手工切换vip ------问题的关键，昨天的问题是两个节点的VIP不知道什么原因互换了

[oracle@orlrac1 ~]$ crs_relocate ora.orlrac1.vip -c orlrac2

Attempting to stop `ora.orlrac1.vip` on member `orlrac1`

Stop of `ora.orlrac1.vip` on member `orlrac1` succeeded.

Attempting to start `ora.orlrac1.vip` on member `orlrac2`

Start of `ora.orlrac1.vip` on member `orlrac2` succeeded.

[oracle@orlrac1 ~]$

[oracle@orlrac1 ~]$

[oracle@orlrac1 ~]$ crs_relocate ora.orlrac2.vip -c orlrac1

Attempting to stop `ora.orlrac2.vip` on member `orlrac2`

Stop of `ora.orlrac2.vip` on member `orlrac2` succeeded.

Attempting to start `ora.orlrac2.vip` on member `orlrac1`

Start of `ora.orlrac2.vip` on member `orlrac1` succeeded.

[oracle@orlrac1 ~]$

[oracle@orlrac1 ~]$

[oracle@orlrac1 ~]$

[oracle@orlrac1 ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.orcldb.db application ONLINE ONLINE orlrac1

ora....b1.inst application ONLINE ONLINE orlrac1

ora....b2.inst application ONLINE ONLINE orlrac2

ora....SM1.asm application ONLINE ONLINE orlrac1

ora....C1.lsnr application OFFLINE OFFLINE

ora....ac1.gsd application ONLINE ONLINE orlrac1

ora....ac1.ons application ONLINE ONLINE orlrac1

ora....ac1.vip application ONLINE ONLINE orlrac2

ora....SM2.asm application ONLINE ONLINE orlrac2

ora....C2.lsnr application OFFLINE OFFLINE

ora....ac2.gsd application ONLINE ONLINE orlrac2

ora....ac2.ons application ONLINE ONLINE orlrac2

ora....ac2.vip application ONLINE ONLINE orlrac1

[oracle@orlrac1 ~]$

----查看IP是否已经切换

[root@orlrac1 ~]#

[root@orlrac1 ~]# ifconfig -a

eth0 Link encap:Ethernet HWaddr 08:00:27:9F:BD:A4

inet addr:192.168.100.111 Bcast:192.168.100.255 Mask:255.255.255.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:1485 errors:0 dropped:0 overruns:0 frame:0

TX packets:992 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:141378 (138.0 KiB) TX bytes:119168 (116.3 KiB) 本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：php中文网