반응형
반응형
Oracle RAC VIP Relocate
#환경
OS: Oracle Linux 6.8
DBMS : Oracle RAC 12.2
Node1 Vip : 172.16.138.53
Node2 Vip : 172.16.138.54
#설명 : Oracle RAC VIP Node1 상태가 INTERMEDIATE , FAILED OVER,STABLE 발생 VIP 수동 relocate 명령을 통한 해결
#상황: 네트워크 인터페이스 문제로 인한 VIP페일 DBMS 서비스 이슈 발생
관련 로그
더보기
- 로그 경로 : /var/log/messages
- 오류 로그
May 10 17:32:43 pferpdb1 NET[96541]: /etc/sysconfig/network-scripts/ifup-post : updated /etc/resolv.conf
May 10 17:32:43 pferpdb1 network: Bringing up interface bond1: [ OK ]
May 10 17:32:44 pferpdb1 network: Bringing up interface ens161: ERROR : [/etc/sysconfig/network-scripts/ifup-eth] Device ens161 does not seem to be present, delaying initialization.
May 10 17:32:44 pferpdb1 /etc/sysconfig/network-scripts/ifup-eth: Device ens161 does not seem to be present, delaying initialization.
May 10 17:32:44 pferpdb1 network: [FAILED]
현재 VIP 상태 확인
VIP 상태 확인
[grid:pferpdb1:+ASM1:/home/grid]srvctl status vip -vip pferpdb1-vip
VIP 172.16.138.53 is enabled
VIP 172.16.138.53 is running on node: pferpdb2
[grid:pferpdb1:+ASM1:/home/grid]srvctl status vip -vip pferpdb2-vip
VIP 172.16.138.54 is enabled
VIP 172.16.138.54 is running on node: pferpdb2
CRS 상태 확인
CRS 상태 확인
[grid:pferpdb1:+ASM1:/home/grid]crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.DATA.dg
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.GRID.dg
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.LISTENER.lsnr
ONLINE OFFLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.RECO.dg
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.net1.network
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.ons
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.proxy_advm
OFFLINE OFFLINE pferpdb1 STABLE
OFFLINE OFFLINE pferpdb2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE pferpdb2 STABLE
ora.MGMTLSNR
1 OFFLINE OFFLINE STABLE
ora.asm
1 ONLINE ONLINE pferpdb1 Started,STABLE
2 ONLINE ONLINE pferpdb2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE pferpdb2 STABLE
ora.pferp.db
1 ONLINE ONLINE pferpdb1 Open,HOME=/oracle/ap
p/oracle/product/12.
2.0/dbhome_1,STABLE
2 ONLINE ONLINE pferpdb2 Open,HOME=/oracle/ap
p/oracle/product/12.
2.0/dbhome_1,STABLE
ora.pferpdb1.vip
1 ONLINE INTERMEDIATE pferpdb2 FAILED OVER,STABLE
ora.pferpdb2.vip
1 ONLINE ONLINE pferpdb2 STABLE
ora.qosmserver
1 ONLINE ONLINE pferpdb2 STABLE
ora.scan1.vip
1 ONLINE ONLINE pferpdb2 STABLE
--------------------------------------------------------------------------------[grid:pferpdb1:+ASM1:/home/grid]crsctl status resource ora.pferpdb1.vip
NAME=ora.pferpdb1.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=INTERMEDIATE on pferpdb2
[grid:pferpdb2:+ASM2:/home/grid]srvctl config vip -n pferpdb1
VIP exists: network number 1, hosting node pferpdb1
VIP Name: pferpdb1-vip
VIP IPv4 Address: 172.16.138.53
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
VIP relocate 수행
#vip relocate 수행
srvctl relocate vip -vip pferpdb1 -node pferpdb1더보기
$srvctl relocate vip -vip pferpdb1 -node pferpdb1
CRS 상태 확인
CRS 상태 확인
[grid:pferpdb1:+ASM1:/home/grid]crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.DATA.dg
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.GRID.dg
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.RECO.dg
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.net1.network
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.ons
ONLINE ONLINE pferpdb1 STABLE
ONLINE ONLINE pferpdb2 STABLE
ora.proxy_advm
OFFLINE OFFLINE pferpdb1 STABLE
OFFLINE OFFLINE pferpdb2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE pferpdb2 STABLE
ora.MGMTLSNR
1 OFFLINE OFFLINE STABLE
ora.asm
1 ONLINE ONLINE pferpdb1 Started,STABLE
2 ONLINE ONLINE pferpdb2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE pferpdb2 STABLE
ora.pferp.db
1 ONLINE ONLINE pferpdb1 Open,HOME=/oracle/ap
p/oracle/product/12.
2.0/dbhome_1,STABLE
2 ONLINE ONLINE pferpdb2 Open,HOME=/oracle/ap
p/oracle/product/12.
2.0/dbhome_1,STABLE
ora.pferpdb1.vip
1 ONLINE ONLINE pferpdb1 STABLE
ora.pferpdb2.vip
1 ONLINE ONLINE pferpdb2 STABLE
ora.qosmserver
1 ONLINE ONLINE pferpdb2 STABLE
ora.scan1.vip
1 ONLINE ONLINE pferpdb2 STABLE
--------------------------------------------------------------------------------
#정상확인
반응형
'Oracle > Oracle DBMS(RAC)' 카테고리의 다른 글
| Oracle RAC SCM0 프로세스 CPU 사용률 이슈 (0) | 2022.07.05 |
|---|---|
| RAC ASM Control file duplication(ASM 컨트롤파일 이중화) (0) | 2017.10.31 |
| RAC ASM Redo Logfile Add(ASM 리두파일 추가) (0) | 2017.10.31 |
댓글