Oracle RAC IP변경

OS 등록되어있는 network information 확인

$>netstat -ni

 

OCR 에 등록 되어있는 network information 확인

$> $ORA_CRS_HOME/bin/oifcfg getif
eth0 10.2.156.0 global public
eth1 192.168.0.0 global cluster_interconnect

 

1. Public Network Change

기존 정보 삭제

% $ORA_CRS_HOME/bin/oifcfg delif -global eth0

새로운 network 설정
% $ORA_CRS_HOME/bin/oifcfg setif -global eth0/10.2.166.0:public

 

2. Private Network Change

10g

1. Oracle Clusterware Stack down on all nodes

2. 각 노드의 hosts file 수정

3. stack restart

4. ip 변경

% $ORA_CRS_HOME/bin/oifcfg delif -global eth1
% $ORA_CRS_HOME/bin/oifcfg setif -global eth1/192.168.1.0:cluster_interconnect

11g R2

1. grid user로 새로운 interface 추가

여기서

$ oifcfg setif -global eth3/192.168.0.0:cluster_interconnect

$ oifcfg getif


2. shutdown crs on all nodes  - root

# crsctl stop crs
# crsctl disable crs


3. OS 에서 private IP 구성

$ ifconfig -a
$ ping <private hostname>


4. CRS restart

# crsctl enable crs
# crsctl start crs


5. 기존 private interface 삭제

$ oifcfg delif -global eth0

 

3. VIP Change

 10g

1. 구성 확인

$ srvctl config nodeapps -n <node> -a

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. vip 수정

# srvctl modify nodeapps -n racnode1 -A racnode1-nvip/255.255.255.0/eth2

4. vip 변경 확인

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

 

 11g R2

1. 구성 확인 - grid user

2. resource stop

$ srvctl config nodeapps -a

$ srvctl stop instance -d <db_name> -n <node_name>
$ srvctl stop vip -n <node_name> -f

$ crs_stat -t (or $ crsctl stat res -t for 11gR2) (vip offline 확인)

3. vip 수정

# srvctl modify nodeapps -n racnode1 -A racnode1-nvip/255.255.255.0/eth2

4. vip 변경확인
$ srvctl config nodeapps -a (11gR2)

 

4.1 Scan name or Scan VIP Change

사전에 모든 node의 hosts file에서 scan name 변경한다

1. grid user로 resource stop

$ $GRID_HOME/bin/srvctl stop scan_listener
$ $GRID_HOME/bin/srvctl stop scan

2. root user로 SCAN 수정

# $GRID_HOME/bin/crsctl modify type ora.scan_vip.type -attr "ATTRIBUTE=SCAN_NAME,DEFAULT_VALUE=pay-scan.us.oracle.com"

3. grid user로 resource start

$ $GRID_HOME/bin/srvctl start scan_listener


4. 확인

$ $GRID_HOME/bin/srvctl config scan
$ $GRID_HOME/bin/srvctl config scan_listener

 

4.2. To change SCAN to be on second network

multiple network 환경에서 default로 scan 은 first public network로 구성되어 있다.

이 scan을 second public network로 구성하거나 다른 network로 구성하는 방법

ex) scan을 net1 -> net2

$ $GRID_HOME/bin/srvctl config network
Network exists: 1/10.1.0.0/255.255.255.128/eth3, type static
Network exists: 2/10.1.1.0/255.255.255.128/eth4, type static


1. grid user로 resource stop 후 scan_listener 제거

$ $GRID_HOME/bin/srvctl stop scan_listener
$ $GRID_HOME/bin/srvctl stop scan
$ $GRID_HOME/bin/srvctl remove scan_listener -f


2. root user로 scan 제거후 add

# $GRID_HOME/bin/srvctl remove scan -f
# $GRID_HOME/bin/srvctl add scan -n <scan-name> -k 2


3. grid user로 scan_listener 추가 및 resource start

 

$ $GRID_HOME/bin/srvctl add scan_listener -p <port>
$ $GRID_HOME/bin/srvctl start scan_listener


4.3 To modify SCAN listener port

1. grid user로 scan listener port 수정

$GRID_HOME/bin/srvctl modify scan_listener -p <new-SCAN-port>

2. grid user로 scan listener 재시작 및 새로운 포트 적용

$GRID_HOME/bin/srvctl stop scan_listener
$GRID_HOME/bin/srvctl start scan_listener

참고 reference
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]