내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 7.6 (64bit)
DB 환경 : Oracle Database 19.3.0.0
에러 : [INS-41118] The interface (ens224) chosen as Public or Private is not on a shared subnet on the following nodes: ora19db2
rac 구성 중 grid 설치시 Gui - Network Interface Usage 에서 발생한 메세지
1 | [INS-41118] The interface (ens224) chosen as Public or Private is not on a shared subnet on the following nodes: ora19db2 |
해결 방법 : 서브넷 마크스를 동일하게 맞춰준다
현재 네트워크 설정 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | # ifconfig ens161: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet 192.168.10.242 netmask 255.255.255.0 broadcast 192.168.10.255 inet6 fe80::20c:29ff:fedb:65af prefixlen 64 scopeid 0x20<link> ether 00:0c:29:db:65:af txqueuelen 1000 (Ethernet) RX packets 492728 bytes 724310176 (690.7 MiB) RX errors 0 dropped 53 overruns 0 frame 0 TX packets 263586 bytes 19819301 (18.9 MiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 ens224: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet 10.10.10.20 netmask 255.255.255.255 broadcast 10.10.10.255 inet6 fe80::f7d6:8ce3:7f9b:983b prefixlen 64 scopeid 0x20<link> ether 00:0c:29:db:65:a5 txqueuelen 1000 (Ethernet) RX packets 2262 bytes 339572 (331.6 KiB) RX errors 0 dropped 52 overruns 0 frame 0 TX packets 151 bytes 17350 (16.9 KiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 |
ens161(Public IP)는 서브넷 마스크(netmask)가 255.255.255.0 임(24)
하지만 ens 224(Private IP)는 서브넷 마스크가 255.255.255.255임(32)
네트워크 설정파일 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | # cd /etc/sysconfig/network-scripts/ # vi ifcfg-static-ens224 TYPE=Ethernet PROXY_METHOD=none BROWSER_ONLY=no BOOTPROTO=none IPADDR=10.10.10.20 PREFIX=32 DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no IPV6_ADDR_GEN_MODE=stable-privacy NAME=static-ens224 UUID=2f065f76-03b9-4b7a-a38e-9a4ce058ae19 DEVICE=ens224 ONBOOT=yes |
현재 PREFIX(서브넷 마스크)가 32로 되어있음
PREFIX를 24로 수정
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | # cd /etc/sysconfig/network-scripts/ # vi ifcfg-static-ens224 TYPE=Ethernet PROXY_METHOD=none BROWSER_ONLY=no BOOTPROTO=none IPADDR=10.10.10.20 PREFIX=24 DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no IPV6_ADDR_GEN_MODE=stable-privacy NAME=static-ens224 UUID=2f065f76-03b9-4b7a-a38e-9a4ce058ae19 DEVICE=ens224 ONBOOT=yes |
저장 후 나가기
해당 네트워크 재기동
1 2 3 | # ifdown ens224 Device 'ens224' successfully disconnected. # ifup ens224 |
다시 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | # ifconfig ens161: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet 192.168.10.242 netmask 255.255.255.0 broadcast 192.168.10.255 inet6 fe80::20c:29ff:fedb:65af prefixlen 64 scopeid 0x20<link> ether 00:0c:29:db:65:af txqueuelen 1000 (Ethernet) RX packets 492840 bytes 724320452 (690.7 MiB) RX errors 0 dropped 53 overruns 0 frame 0 TX packets 263644 bytes 19831992 (18.9 MiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 ens224: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet 10.10.10.20 netmask 255.255.255.0 broadcast 10.10.10.255 inet6 fe80::f7d6:8ce3:7f9b:983b prefixlen 64 scopeid 0x20<link> ether 00:0c:29:db:65:a5 txqueuelen 1000 (Ethernet) RX packets 2270 bytes 340384 (332.4 KiB) RX errors 0 dropped 52 overruns 0 frame 0 TX packets 154 bytes 17523 (17.1 KiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 |
정상적으로 netmask 부분이 255.255.255.0으로 나옴
네트워크 설정 작업 이후 gridSetup.sh 을 다시 실행해서 진행
정상적으로 넘어감
원인 : Public IP와 Private IP 간 상이한 서브넷 마스크 문제
Public IP와 Private IP 간 상이한 서브넷 마스크 문제
참조 : http://www.jeepxie.net/article/234676.html