오라클 11g R2 RAC IP 변경 방법(IP Change)

 

OS환경 : Oracle Linux 6.8 (64bit)

 

DB 환경 : Oracle Database 10.2.0.4, 11.2.0.4

 

방법 : Oracle RAC IP 변경 방법(IP Change)

작업 전 참고사항

* $ORA_CRS_HOME 이란 oracle 10g clusterware의 HOME 경로임

* $GRID_HOME 이란 oracle 11g 이상의 grid 의 HOME 경로임

* oifcfg 명령은 한쪽 노드에서만 실행해도 됨(한쪽에서 명령어 실행하면 양쪽다 적용됨)

* /etc/hosts 수정은 양쪽 노드에서 다 해주어야함

 

0. 사전 작업

OS에 등록되어있는 네트워크 정보 확인

 

netstat -ni

OCR에 등록 되어있는 네트워크 정보 확인

$ORA_CRS_HOME/bin/oifcfg getif
eth0 192.168.137.0 global public
eth2 10.10.10.0 global cluster_interconnect

 

1. Public Network Change

1_1. 기존 정보 삭제

$ORA_CRS_HOME/bin/oifcfg delif -global eth0

 

1_2. 새로운 network 설정(137에서 138로 변경)

$ORA_CRS_HOME/bin/oifcfg setif -global eth0/192.168.138.0:public

 

1_3. 확인

1	$ORA_CRS_HOME/bin/oifcfg getif

 

 

2. Private Network Change

10g

2_1. Oracle Clusterware Stack down on all nodes

 

2_2. 각 노드의 hosts file 수정

 

2_3. stack restart

 

2_4. ip 변경

기존 private IP 삭제(10.~대역)

$GRID_HOME/bin/oifcfg delif -global eth1

 

새로운 private IP 등록(20.~대역)

$GRID_HOME/bin/oifcfg setif -global eth1/20.20.20.0:cluster_interconnect

 

11g R2

2_1. IP 변경

새로운 private IP 등록(20.~대역)

$GRID_HOME/bin/oifcfg setif -global eth1/20.20.20.0:cluster_interconnect

 

확인

$GRID_HOME/bin/oifcfg getif
eth0  192.168.138.0  global  public
eth2  10.10.10.0  global  cluster_interconnect
eth1  20.20.20.0  global  cluster_interconnect

 

2_2. root 계정으로 CRS 종료 및 비활성화 설정

crsctl stop crs
crsctl disable crs

2_3. OS 에서 private IP 구성

/etc/hosts 파일수정 및 IP 등록(vm머신으로 테스트 하는 경우 Network Adapter 추가 등록후 IP할당)

cat /etc/hosts

 

네트워크 연결 확인

ifconfig -a

 

상호 ping 확인 

rac1서버 : ping rac2-priv
rac2서버 : ping rac1-priv

 

2_4. root 계정으로 CRS 활성화 및 시작

crsctl enable crs
crsctl start crs

2_5. 기존 private IP 삭제(10.~대역)

$GRID_HOME/bin/oifcfg delif -global eth2

 

 

2_6. 변경된 IP 확인

$GRID_HOME/bin/oifcfg getif
eth0  192.168.138.0  global  public
eth1  20.20.20.0  global  cluster_interconnect

 

3. VIP Change

10g

3_1. 구성 확인

명령어 $ srvctl config nodeapps -n <node_name> -a

srvctl config nodeapps -n rac1 -a
Network exists: 1/192.168.138.0/255.255.255.0/eth0, type static
VIP exists: /rac1-vip/192.168.138.40/192.168.138.0/255.255.255.0/eth0, hosting node rac1
srvctl config nodeapps -n rac2 -a
Network exists: 1/192.168.138.0/255.255.255.0/eth0, type static
VIP exists: /rac2-vip/192.168.138.41/192.168.138.0/255.255.255.0/eth0, hosting node rac2

 

3_2. resources stop

srvctl stop asm -n <node_name>
srvctl stop instance -d <db_name> -i <inst_name>
srvctl stop nodeapps -n <node_name>
crs_stat -t ( vip offline 확인)

 

3_3. root 계정으로 vip 수정(1번노드, 2번노드 모두 동일하게 진행)

[3_1]을 참고하여 아래 스크린샷처럼 입력

srvctl modify nodeapps -n rac1 -A rac1-vip/255.255.255.0/eth0

 

3_4. vip 변경 확인

srvctl config nodeapps -n <node_name> -a (10g and 11gR1)
srvctl config nodeapps -a (11gR2)

 

11g R2

3_1. 구성 확인 - grid user

srvctl config nodeapps -a
Network exists: 1/192.168.138.0/255.255.255.0/eth0, type static
VIP exists: /rac1-vip/192.168.138.40/192.168.138.0/255.255.255.0/eth0, hosting node rac1
VIP exists: /rac2-vip/192.168.138.41/192.168.138.0/255.255.255.0/eth0, hosting node rac2

 

3_2. resource stop

srvctl stop instance -d <db_name> -n <node_name>
srvctl stop vip -n <node_name> -f
crsctl stat res -t (vip offline 확인)

 

3_3. root 계정으로 vip 수정(1번노드, 2번노드 모두 동일하게 진행)

[3_1]을 참고하여 아래 스크린샷처럼 입력

srvctl modify nodeapps -n rac1 -A rac1-vip/255.255.255.0/eth0

 

3_4. vip 변경확인

srvctl config nodeapps -a (11gR2)
srvctl config nodeapps -n <node_name> -a (10g and 11gR1)

 

 

참조 : http://www.jigi.net/4274

How to Change Interconnect/Public Network (Interface or Subnet) in Oracle Clusterware [ID 283684.1]

Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node [ID 276434.1]

How to Modify SCAN Setting or SCAN Listener Port after Installation [ID 972500.1]

How to Modify Private Network Interface in 11.2 Grid Infrastructure [ID 1073502.1]

https://positivemh.tistory.com/742

오라클 19c RAC IP 변경 방법(IP Change)