Get the App
SLTechnology News&Howtos  ›  Database  › 

Rac stops resources

Shulou Source: shulou.com Published: 2022-06-01 07:16:15 09月26日 Update

Click (here) to collapse or open

10. 6. 69. 21 node1

10. 6. 69. 23 node1-vip

192. 168. 6. 11 node1-priv

10. 6. 69. 22 node2

10. 6. 69. 24 node2-vip

192. 168. 6. 12 node2-priv

10. 6. 69. 25 scan-ip

Prohibit all nodes from automatically starting and stopping VIP

# / u01/11.2.0/grid/bin/srvctl disable vip-I node1-vip [enable/disable]

# / u01/11.2.0/grid/bin/srvctl stop vip-I node1-vip [start/stop]

# / u01/11.2.0/grid/bin/srvctl stop vip-I node1-vip-f

Or

[root] srvctl disable vip-I grdi1-vip

[root] srvctl disable vip-I grid2-vip

[grid] $srvctl stop vip-n grid1

[grid] $srvctl stop vip-n grid2

I disable and stop both sides of vip, and the current vip status

Close vip2 normally otherwise, I will force-f

Sqlplus scott/tiger@10.6.69.23/prod/1521 23 is my node1-vip. I logged in like this. If I inquire about the status of hang again, crtl+c can't stop.

Log in again in a new window

Vip has stopped scan is normal, but can not log in, which shows a small problem, the relationship between scan and vip

Vip snooping is vip snooping, scan snooping is scan snooping, but scan is skipping to vip.

-

Srvctl disable scan_listener

Srvctl stop scan_listener

If you connect to it, you can continue to inquire, but if you connect again, you will not be able to connect. Let's feel it. This also shows the essence of monitoring.

Srvctl stop scan

Srvctl disable scan

Stop the [connection] between san_listener and vip listener, when your scan can not be connected, vip can be connected.

Tags: Monitor again login status query between substance node problem enforcement contact resource Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker Shulou Information vpn macOS OPPO Reno