Oracle10gRAC listener reports TNS-12545TNS-12560TNS-00515

Oracle10gRAC listener reports TNS-12545TNS-12560TNS-00515

Oracle 10g RAC listener reports TNS-12545 TNS-12560 TNS-00515

Yesterday at the customer site a RAC in the start of listening when the TNS-12545 TNS-12560 TNS-00515 error, after processing back to normal ,,

Today, I restored this problem on my own virtual machine, recording:

OS: Linux

DB: 10.2.0.4 RAC

1. Simulate recovery to the event

1. Switch the VIP address after manually disabling the listener

[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 orlrac1
Ora... b1.inst application ONLINE orlrac1
Ora... b2.inst application ONLINE orlrac2
Ora... SM1.asm application ONLINE orlrac1
Ora... C1.lsnr application OFFLINE
Ora... ac1.gsd application ONLINE orlrac1
Ora... ac1.ons application ONLINE orlrac1
Ora... ac1.vip application ONLINE orlrac1
Ora... SM2.asm application ONLINE orlrac2
Ora... C2.lsnr application OFFLINE
Ora... ac2.gsd application ONLINE orlrac2
Ora... ac2.ons application ONLINE orlrac2
Ora... ac2.vip application ONLINE orlrac2
[Oracle @ orlrac1 ~] $

2. Manual vip switching ------ the key issue is that the VIP addresses of the two nodes did not know why they were exchanged.

[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 orlrac1
Ora... b1.inst application ONLINE orlrac1
Ora... b2.inst application ONLINE orlrac2
Ora... SM1.asm application ONLINE orlrac1
Ora... C1.lsnr application OFFLINE
Ora... ac1.gsd application ONLINE orlrac1
Ora... ac1.ons application ONLINE orlrac1
Ora... ac1.vip application ONLINE orlrac2
Ora... SM2.asm application ONLINE orlrac2
Ora... C2.lsnr application OFFLINE
Ora... ac2.gsd application ONLINE orlrac2
Ora... ac2.ons application ONLINE orlrac2
Ora... ac2.vip application ONLINE orlrac1
[Oracle @ orlrac1 ~] $

---- Check whether the IP address has been switched

[Root @ orlrac1 ~] #
[Root @ orlrac1 ~] # Ifconfig-
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 FIG: 1000
RX bytes: 141378 (138.0 KiB) TX bytes: 119168 (116.3 KiB)