[ORACLE] Public, Private IP 변경 - Host Address만 변경

 

OS / ORACLE ENVIRONMENT
EDITION	EE
RAC	RAC 2 NODE
VERSION	Oracle Database19c
SERVER	Linux 7.9 (5.4.17-2102.201.3.el7uek.x86_64)

 

GI_HOME	/u01/app/19c/grid
ORACLE_SID	ug191, ug192
ORACLE_BASE	/u01/app/oracle
ORACLE_HOME	/u01/app/oracle/product/19.0.0/dbhome_1
oraInventory	/u01/app/oraInventory

		기존	변경
Public IP	node 1	10.0.5.111	10.0.5.113
	node 2	10.0.5.112	10.0.5.114
Private IP	node 1	10.0.1.111	10.0.1.113
	node 2	10.0.1.112	10.0.1.114

 

사전 준비

1. listener.ora [oracle 계정 / node 1, 2]

사용 중인 LISTENER에 대한 IP 주소 변경 / 없다면 변경 X

cd $ORACLE_HOME/network/admin
vi listener.ora
------------------------------------------------------------------------
# node 1 listener.ora
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.5.111)(PORT = 1537))
--> 
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.5.113)(PORT = 1537))

# nore 2 listener.ora
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.5.112)(PORT = 1537))
--> 
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.5.114)(PORT = 1537))

 

2. tnsnames.ora [oracle 계정 / node 1, 2]

사용 중인 TNS에 대한 IP 주소 변경 / 없다면 변경 X

cd $ORACLE_HOME/network/admin
vi tnsnames.ora
------------------------------------------------------------------------
# node 1 listener.ora
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.5.111)(PORT = 1537))
--> 
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.5.113)(PORT = 1537))

# nore 2 listener.ora
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.5.112)(PORT = 1537))
--> 
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.5.114)(PORT = 1537))

3. ORACLE local_listener parameter

<Private IP to Private IP>

sqlplus / as sysdba
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.1.113)(PORT=1521))' scope=both sid=ug191;
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.1.114)(PORT=1521))' scope=both sid=ug192;

 

[ Public, Private IP 변경 ] - * host 주소만 변경 *

1. database 종료 - [oracle 계정 / node 1]

$ srvctl stop database -d ug19

2. listener 종료  - [grid 계정 / node 1, 2]

$ lsnrctl stop LISTENER

3. interface configuration file 수정 - [root 계정 / node 1, 2]

# 1. /etc/hosts - node 1, 2
# public
#10.0.5.111             ug191           ug191.localdomain
#10.0.5.112             ug192           ug192.localdomain
10.0.5.113              ug191           ug191.localdomain
10.0.5.114              ug192           ug192.localdomain

# private
#10.0.1.111             ug191-priv      ug191-priv.localdomain
#10.0.1.112             ug192-priv      ug192-priv.localdomain
10.0.1.113              ug191-priv      ug191-priv.localdomain
10.0.1.114              ug192-priv      ug192-priv.localdomain



# 2. /etc/sysconfig/network-scripts/ifcfg-enp0s3
-- node 1
#IPADDR=10.0.5.111
IPADDR=10.0.5.113

-- node 2
#IPADDR=10.0.5.112
IPADDR=10.0.5.114


# 3. /etc/sysconfig/network-scripts/ifcfg-enp0s8
-- node 1
#IPADDR=10.0.1.111
IPADDR=10.0.1.113

-- node 2
#IPADDR=10.0.1.112
IPADDR=10.0.1.114

4. interface public down / up - [root 계정 / node 1, 2]

$ ifdown enp0s3
$ ifup enp0s3

$ ifdown enp0s8
$ ifup enp0s8

# 상태 확인
$ systemctl status network

root@ug191:/root# systemctl status network
● network.service - LSB: Bring up/down networking
   Loaded: loaded (/etc/rc.d/init.d/network; bad; vendor preset: disabled)
   Active: active (exited) since Wed 2023-09-13 09:45:34 KST; 1h 45min ago
     Docs: man:systemd-sysv-generator(8)
  Process: 1150 ExecStart=/etc/rc.d/init.d/network start (code=exited, status=0/SUCCESS)
    Tasks: 0
   Memory: 0B

Sep 13 09:45:33 ug191.localdomain systemd[1]: Starting LSB: Bring up/down networking...
Sep 13 09:45:34 ug191.localdomain network[1150]: Bringing up loopback interface:  [  OK  ]
Sep 13 09:45:34 ug191.localdomain network[1150]: Bringing up interface enp0s3:  [  OK  ]
Sep 13 09:45:34 ug191.localdomain network[1150]: Bringing up interface enp0s8:  [  OK  ]
Sep 13 09:45:34 ug191.localdomain systemd[1]: Started LSB: Bring up/down networking.


$ ifconfig
-- node 1
enp0s3: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 10.0.5.113  netmask 255.255.255.0  broadcast 10.0.5.255
        inet6 fe80::a00:27ff:fe93:7e8d  prefixlen 64  scopeid 0x20<link>
        ether 08:00:27:93:7e:8d  txqueuelen 1000  (Ethernet)
        RX packets 235271  bytes 297253771 (283.4 MiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 190263  bytes 228802289 (218.2 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

enp0s8: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 10.0.1.113  netmask 255.255.255.0  broadcast 10.0.1.255
        inet6 fe80::a00:27ff:fe79:ccea  prefixlen 64  scopeid 0x20<link>
        ether 08:00:27:79:cc:ea  txqueuelen 1000  (Ethernet)
        RX packets 2322621  bytes 2056304609 (1.9 GiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 2109458  bytes 1576379819 (1.4 GiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

-- node 2 
enp0s3: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 10.0.5.114  netmask 255.255.255.0  broadcast 10.0.5.255
        inet6 fe80::a00:27ff:fea9:572f  prefixlen 64  scopeid 0x20<link>
        ether 08:00:27:a9:57:2f  txqueuelen 1000  (Ethernet)
        RX packets 191615  bytes 228816651 (218.2 MiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 235748  bytes 297614773 (283.8 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0
        
enp0s8: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 10.0.1.114  netmask 255.255.255.0  broadcast 10.0.1.255
        inet6 fe80::a00:27ff:fe07:63af  prefixlen 64  scopeid 0x20<link>
        ether 08:00:27:07:63:af  txqueuelen 1000  (Ethernet)
        RX packets 1717625  bytes 1308706664 (1.2 GiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 1923653  bytes 1747849316 (1.6 GiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

5. listener 시작 - [grid 계정 / node 1, 2]

$ lsnrctl start LISTENER

6. database 시작 - [oracle 계정 / node 1]

$ srvctl start database -d ug19​