| OS : oracle linux 7.5 DBMS : oracle 19.3 |
| RAC 환경 vip failover 테스트 - node#1 에서 작업 진행 시 vip 가 node#2 로 넘어가는 상황 테스트 1. 인스턴스 shutdown 2. 리스너 stop 3. crs stop 요약 : crs stop 상황에서만 vip 가 다른 노드로 넘어간다 |
0. 테스트 전 현황
<node #1>
[root@svr1 ~]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:cd:59:f9 brd ff:ff:ff:ff:ff:ff
inet 192.168.56.61/24 brd 192.168.56.255 scope global noprefixroute enp0s3
valid_lft forever preferred_lft forever
inet 192.168.56.64/24 brd 192.168.56.255 scope global secondary enp0s3:1
valid_lft forever preferred_lft forever
inet6 fe80::a00:27ff:fecd:59f9/64 scope link
valid_lft forever preferred_lft forever
3: enp0s8: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:b6:86:6d brd ff:ff:ff:ff:ff:ff
inet 192.168.57.61/24 brd 192.168.57.255 scope global noprefixroute enp0s8
valid_lft forever preferred_lft forever
inet 169.254.4.14/19 brd 169.254.31.255 scope global enp0s8:1
valid_lft forever preferred_lft forever
inet6 fe80::45dc:96d8:ce3:ddc9/64 scope link noprefixroute
valid_lft forever preferred_lft forever
[root@svr1 ~]# srvctl config nodeapps -a
Network 1 exists
Subnet IPv4: 192.168.56.0/255.255.255.0/enp0s3, static
Subnet IPv6:
Ping Targets:
Network is enabled
Network is individually enabled on nodes:
Network is individually disabled on nodes:
VIP exists: network number 1, hosting node svr1
VIP Name: svr1-vip
VIP IPv4 Address: 192.168.56.64
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
VIP exists: network number 1, hosting node svr2
VIP Name: svr2-vip
VIP IPv4 Address: 192.168.56.65
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
[root@svr1 ~]# crsctl stat res -t | grep -A1 vip
ora.scan1.vip
1 ONLINE ONLINE svr2 STABLE
ora.svr1.vip
1 ONLINE ONLINE svr1 STABLE
ora.svr2.vip
1 ONLINE ONLINE svr2 STABLE
[root@svr1 ~]#
<node #2>
[root@svr2 ~]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:3d:04:f0 brd ff:ff:ff:ff:ff:ff
inet 192.168.56.62/24 brd 192.168.56.255 scope global noprefixroute enp0s3
valid_lft forever preferred_lft forever
inet 192.168.56.63/24 brd 192.168.56.255 scope global secondary enp0s3:1
valid_lft forever preferred_lft forever
inet 192.168.56.65/24 brd 192.168.56.255 scope global secondary enp0s3:3
valid_lft forever preferred_lft forever
inet6 fe80::a00:27ff:fe3d:4f0/64 scope link
valid_lft forever preferred_lft forever
3: enp0s8: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:ba:74:5f brd ff:ff:ff:ff:ff:ff
inet 192.168.57.62/24 brd 192.168.57.255 scope global noprefixroute enp0s8
valid_lft forever preferred_lft forever
inet 169.254.23.118/19 brd 169.254.31.255 scope global enp0s8:1
valid_lft forever preferred_lft forever
inet6 fe80::8577:f5bc:53b9:9403/64 scope link noprefixroute
valid_lft forever preferred_lft forever
[root@svr2 ~]# su - oracle
Last login: Mon Jun 19 20:13:47 KST 2023 on pts/0
[oracle@svr2 ~]$
[oracle@svr2 ~]$ lsnrctl stat
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-JUN-2023 20:20:22
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 19-JUN-2023 20:13:52
Uptime 0 days 0 hr. 6 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ora19/app/grid/19.3.0/network/admin/listener.ora
Listener Log File /ora19/app/grid/base/diag/tnslsnr/svr2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.62)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.65)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_OCR" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "racdb" has 1 instance(s).
Instance "racdb2", status READY, has 1 handler(s) for this service...
Service "racdbXDB" has 1 instance(s).
Instance "racdb2", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@svr2 ~]$
1. 인스턴스 shutdown(정상종료)
<node#1>
[oracle@svr1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE svr1 STABLE
ONLINE ONLINE svr2 STABLE
ora.chad
ONLINE ONLINE svr1 STABLE
ONLINE ONLINE svr2 STABLE
ora.net1.network
ONLINE ONLINE svr1 STABLE
ONLINE ONLINE svr2 STABLE
ora.ons
ONLINE ONLINE svr1 STABLE
ONLINE ONLINE svr2 STABLE
ora.proxy_advm
OFFLINE OFFLINE svr1 STABLE
OFFLINE OFFLINE svr2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE svr1 STABLE
2 ONLINE ONLINE svr2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE svr1 STABLE
2 ONLINE ONLINE svr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE svr2 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE svr1 STABLE
2 ONLINE ONLINE svr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE svr1 Started,STABLE
2 ONLINE ONLINE svr2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE svr2 STABLE
ora.qosmserver
1 ONLINE ONLINE svr1 STABLE
ora.racdb.db
1 ONLINE ONLINE svr1 Open,HOME=/ora19/app
/oracle/product/19.3
.0/db_1,STABLE
2 ONLINE ONLINE svr2 Open,HOME=/ora19/app
/oracle/product/19.3
.0/db_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE svr2 STABLE
ora.svr1.vip
1 ONLINE ONLINE svr1 STABLE
ora.svr2.vip
1 ONLINE ONLINE svr2 STABLE
--------------------------------------------------------------------------------
[oracle@svr1 ~]$ ss
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@svr1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE svr1 STABLE
ONLINE ONLINE svr2 STABLE
ora.chad
ONLINE ONLINE svr1 STABLE
ONLINE ONLINE svr2 STABLE
ora.net1.network
ONLINE ONLINE svr1 STABLE
ONLINE ONLINE svr2 STABLE
ora.ons
ONLINE ONLINE svr1 STABLE
ONLINE ONLINE svr2 STABLE
ora.proxy_advm
OFFLINE OFFLINE svr1 STABLE
OFFLINE OFFLINE svr2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE svr1 STABLE
2 ONLINE ONLINE svr2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE svr1 STABLE
2 ONLINE ONLINE svr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE svr2 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE svr1 STABLE
2 ONLINE ONLINE svr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE svr1 Started,STABLE
2 ONLINE ONLINE svr2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE svr2 STABLE
ora.qosmserver
1 ONLINE ONLINE svr1 STABLE
ora.racdb.db
1 OFFLINE OFFLINE STABLE
2 ONLINE ONLINE svr2 Open,HOME=/ora19/app
/oracle/product/19.3
.0/db_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE svr2 STABLE
ora.svr1.vip
1 ONLINE ONLINE svr1 STABLE
ora.svr2.vip
1 ONLINE ONLINE svr2 STABLE
--------------------------------------------------------------------------------
[oracle@svr1 ~]$ ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:cd:59:f9 brd ff:ff:ff:ff:ff:ff
inet 192.168.56.61/24 brd 192.168.56.255 scope global noprefixroute enp0s3
valid_lft forever preferred_lft forever
inet 192.168.56.64/24 brd 192.168.56.255 scope global secondary enp0s3:1
valid_lft forever preferred_lft forever
inet6 fe80::a00:27ff:fecd:59f9/64 scope link
valid_lft forever preferred_lft forever
3: enp0s8: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:b6:86:6d brd ff:ff:ff:ff:ff:ff
inet 192.168.57.61/24 brd 192.168.57.255 scope global noprefixroute enp0s8
valid_lft forever preferred_lft forever
inet 169.254.4.14/19 brd 169.254.31.255 scope global enp0s8:1
valid_lft forever preferred_lft forever
inet6 fe80::45dc:96d8:ce3:ddc9/64 scope link noprefixroute
valid_lft forever preferred_lft forever
[oracle@svr1 ~]$ lsnrctl stat
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-JUN-2023 20:24:43
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 19-JUN-2023 20:14:15
Uptime 0 days 0 hr. 10 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ora19/app/grid/19.3.0/network/admin/listener.ora
Listener Log File /ora19/app/grid/base/diag/tnslsnr/svr1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.61)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.64)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_OCR" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@svr1 ~]$
2. 리스너 stop(정상종료)
<node#1>
[grid@svr1 ~]$ lsnrctl stat
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-JUN-2023 20:28:04
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 19-JUN-2023 20:14:15
Uptime 0 days 0 hr. 13 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ora19/app/grid/19.3.0/network/admin/listener.ora
Listener Log File /ora19/app/grid/base/diag/tnslsnr/svr1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.61)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.64)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_OCR" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "racdb" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Service "racdbXDB" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@svr1 ~]$
[grid@svr1 ~]$ lsnrctl stop
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-JUN-2023 20:28:08
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
The command completed successfully
[grid@svr1 ~]$ lsnrctl stat
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-JUN-2023 20:28:11
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
[grid@svr1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
OFFLINE OFFLINE svr1 STABLE
ONLINE ONLINE svr2 STABLE
ora.chad
ONLINE INTERMEDIATE svr1 Wrong check return,S
TABLE
ONLINE ONLINE svr2 STABLE
ora.net1.network
ONLINE ONLINE svr1 STABLE
ONLINE ONLINE svr2 STABLE
ora.ons
ONLINE ONLINE svr1 STABLE
ONLINE ONLINE svr2 STABLE
ora.proxy_advm
OFFLINE OFFLINE svr1 STABLE
OFFLINE OFFLINE svr2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE svr1 STABLE
2 ONLINE ONLINE svr2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE svr1 STABLE
2 ONLINE ONLINE svr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE svr2 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE svr1 STABLE
2 ONLINE ONLINE svr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE svr1 Started,STABLE
2 ONLINE ONLINE svr2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE svr2 STABLE
ora.qosmserver
1 ONLINE ONLINE svr1 STABLE
ora.racdb.db
1 ONLINE ONLINE svr1 Open,HOME=/ora19/app
/oracle/product/19.3
.0/db_1,STABLE
2 ONLINE ONLINE svr2 Open,HOME=/ora19/app
/oracle/product/19.3
.0/db_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE svr2 STABLE
ora.svr1.vip
1 ONLINE ONLINE svr1 STABLE
ora.svr2.vip
1 ONLINE ONLINE svr2 STABLE
--------------------------------------------------------------------------------
[grid@svr1 ~]$ ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:cd:59:f9 brd ff:ff:ff:ff:ff:ff
inet 192.168.56.61/24 brd 192.168.56.255 scope global noprefixroute enp0s3
valid_lft forever preferred_lft forever
inet 192.168.56.64/24 brd 192.168.56.255 scope global secondary enp0s3:1
valid_lft forever preferred_lft forever
inet6 fe80::a00:27ff:fecd:59f9/64 scope link
valid_lft forever preferred_lft forever
3: enp0s8: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:b6:86:6d brd ff:ff:ff:ff:ff:ff
inet 192.168.57.61/24 brd 192.168.57.255 scope global noprefixroute enp0s8
valid_lft forever preferred_lft forever
inet 169.254.4.14/19 brd 169.254.31.255 scope global enp0s8:1
valid_lft forever preferred_lft forever
inet6 fe80::45dc:96d8:ce3:ddc9/64 scope link noprefixroute
valid_lft forever preferred_lft forever
[grid@svr1 ~]$3. crs stop(정상종료)
<node#1>
[root@svr1 ~]# crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'svr1'
CRS-2673: Attempting to stop 'ora.crsd' on 'svr1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'svr1'
CRS-2673: Attempting to stop 'ora.qosmserver' on 'svr1'
CRS-2673: Attempting to stop 'ora.chad' on 'svr1'
CRS-2673: Attempting to stop 'ora.racdb.db' on 'svr1'
CRS-2677: Stop of 'ora.chad' on 'svr1' succeeded
CRS-2677: Stop of 'ora.racdb.db' on 'svr1' succeeded
CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'svr1'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'svr1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'svr1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'svr1'
CRS-2677: Stop of 'ora.DATA.dg' on 'svr1' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'svr1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.svr1.vip' on 'svr1'
CRS-2677: Stop of 'ora.svr1.vip' on 'svr1' succeeded
CRS-2677: Stop of 'ora.asm' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'svr1'
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'svr1' succeeded
CRS-33677: Stop of resource group 'ora.asmgroup' on server 'svr1' succeeded.
CRS-2677: Stop of 'ora.qosmserver' on 'svr1' succeeded
CRS-2672: Attempting to start 'ora.svr1.vip' on 'svr2'
CRS-2676: Start of 'ora.svr1.vip' on 'svr2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'svr1'
CRS-2677: Stop of 'ora.ons' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'svr1'
CRS-2677: Stop of 'ora.net1.network' on 'svr1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'svr1' has completed
CRS-2677: Stop of 'ora.crsd' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'svr1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'svr1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'svr1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'svr1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'svr1' succeeded
CRS-2677: Stop of 'ora.asm' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'svr1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'svr1'
CRS-2673: Attempting to stop 'ora.evmd' on 'svr1'
CRS-2677: Stop of 'ora.ctssd' on 'svr1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'svr1'
CRS-2677: Stop of 'ora.cssd' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'svr1'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'svr1'
CRS-2677: Stop of 'ora.gpnpd' on 'svr1' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'svr1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'svr1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@svr1 ~]#
-- 1번 노드 vip 없어짐
[root@svr1 ~]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:cd:59:f9 brd ff:ff:ff:ff:ff:ff
inet 192.168.56.61/24 brd 192.168.56.255 scope global noprefixroute enp0s3
valid_lft forever preferred_lft forever
inet6 fe80::a00:27ff:fecd:59f9/64 scope link
valid_lft forever preferred_lft forever
3: enp0s8: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:b6:86:6d brd ff:ff:ff:ff:ff:ff
inet 192.168.57.61/24 brd 192.168.57.255 scope global noprefixroute enp0s8
valid_lft forever preferred_lft forever
inet6 fe80::45dc:96d8:ce3:ddc9/64 scope link noprefixroute
valid_lft forever preferred_lft forever
[root@svr1 ~]#
<node #2> 모든 vip 2번 노드에 존재
[root@svr2 ~]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:3d:04:f0 brd ff:ff:ff:ff:ff:ff
inet 192.168.56.62/24 brd 192.168.56.255 scope global noprefixroute enp0s3
valid_lft forever preferred_lft forever
inet 192.168.56.63/24 brd 192.168.56.255 scope global secondary enp0s3:1
valid_lft forever preferred_lft forever
inet 192.168.56.65/24 brd 192.168.56.255 scope global secondary enp0s3:3
valid_lft forever preferred_lft forever
inet 192.168.56.64/24 brd 192.168.56.255 scope global secondary enp0s3:2
valid_lft forever preferred_lft forever
inet6 fe80::a00:27ff:fe3d:4f0/64 scope link
valid_lft forever preferred_lft forever
3: enp0s8: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 08:00:27:ba:74:5f brd ff:ff:ff:ff:ff:ff
inet 192.168.57.62/24 brd 192.168.57.255 scope global noprefixroute enp0s8
valid_lft forever preferred_lft forever
inet 169.254.23.118/19 brd 169.254.31.255 scope global enp0s8:1
valid_lft forever preferred_lft forever
inet6 fe80::8577:f5bc:53b9:9403/64 scope link noprefixroute
valid_lft forever preferred_lft forever
[root@svr2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE svr2 STABLE
ora.chad
ONLINE ONLINE svr2 STABLE
ora.net1.network
ONLINE ONLINE svr2 STABLE
ora.ons
ONLINE ONLINE svr2 STABLE
ora.proxy_advm
OFFLINE OFFLINE svr2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE svr2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE svr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE svr2 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE svr2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE svr2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE svr2 STABLE
ora.qosmserver
1 ONLINE OFFLINE STABLE
ora.racdb.db
1 ONLINE OFFLINE Instance Shutdown,ST
ABLE
2 ONLINE ONLINE svr2 Open,HOME=/ora19/app
/oracle/product/19.3
.0/db_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE svr2 STABLE
ora.svr1.vip
1 ONLINE INTERMEDIATE svr2 FAILED OVER,STABLE
ora.svr2.vip
1 ONLINE ONLINE svr2 STABLE
--------------------------------------------------------------------------------
[root@svr2 ~]# crsctl stat res -t | grep -A1 vip
ora.scan1.vip
1 ONLINE ONLINE svr2 STABLE
ora.svr1.vip
1 ONLINE INTERMEDIATE svr2 FAILED OVER,STABLE
ora.svr2.vip
1 ONLINE ONLINE svr2 STABLE
[root@svr2 ~]# srvctl config nodeapps -a
Network 1 exists
Subnet IPv4: 192.168.56.0/255.255.255.0/enp0s3, static
Subnet IPv6:
Ping Targets:
Network is enabled
Network is individually enabled on nodes:
Network is individually disabled on nodes:
VIP exists: network number 1, hosting node svr1
VIP Name: svr1-vip
VIP IPv4 Address: 192.168.56.64
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
VIP exists: network number 1, hosting node svr2
VIP Name: svr2-vip
VIP IPv4 Address: 192.168.56.65
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
[root@svr2 ~]#
'DBMS > ORACLE' 카테고리의 다른 글
| DBCA delete database 작업 시 목록 안보이는 경우 (0) | 2023.06.22 |
|---|---|
| RAC VIP 변경 (0) | 2023.06.20 |
| RAC 노드 추가(OUI) (0) | 2023.06.18 |
| RAC 노드 제거(GUI) (0) | 2023.06.10 |
| LMS(License Management Services) 체크 스크립트 (0) | 2023.06.01 |
댓글