Shulou(Shulou.com)05/31 Report--

Editor to share with you how oracle11g RAC modifies PUBLIC-IP, VIP, PRIV-IP, SCAN-IP, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. IP modifies the plan

Hostname

Before modification

After modification

Public-ip

Node1

192.168.150.11

192.168.114.11

Node2

192.168.150.12

192.168.114.12

VIP

Node1

192.168.150.13

192.168.114.13

Node2

192.168.150.14

192.168.114.14

SCAN-IP

Node1

Node2

192.168.150.15

192.168.114.15

192.168.150.16

192.168.114.16

192.168.150.17

192.168.114.17

Priv-ip

Node1

172.168.146.101

172.168.146.11

Node2

172.168.146.102

172.168.146.12

two。 Hosts file before modification

Name Type Target State Host

Ora.CRS.dg ora....up.type ONLINE ONLINE node1

Ora.DATA.dg ora....up.type ONLINE ONLINE node1

Ora....ER.lsnr ora....er.type ONLINE ONLINE node1

Ora.LSNR2.lsnr ora....er.type ONLINE ONLINE node1

Ora....N1.lsnr ora....er.type ONLINE ONLINE node2

Ora....N2.lsnr ora....er.type ONLINE ONLINE node1

Ora....N3.lsnr ora....er.type ONLINE ONLINE node1

Ora.LSNR3.lsnr ora....er.type ONLINE ONLINE node1

Ora.asm ora.asm.type ONLINE ONLINE node1

Ora.cvu ora.cvu.type ONLINE ONLINE node1

Ora.gsd ora.gsd.type ONLINE OFFLINE

Ora....network ora....rk.type ONLINE ONLINE node1

Ora....SM1.asm application ONLINE ONLINE node1

Ora....E1.lsnr application ONLINE ONLINE node1

Ora....E1.lsnr application ONLINE ONLINE node1

Ora....E1.lsnr application ONLINE ONLINE node1

Ora.node1.gsd application ONLINE OFFLINE

Ora.node1.ons application ONLINE ONLINE node1

Ora.node1.vip ora....t1.type ONLINE ONLINE node1

Ora....SM2.asm application ONLINE ONLINE node2

Ora....E2.lsnr application ONLINE ONLINE node2

Ora....E2.lsnr application ONLINE ONLINE node2

Ora....E2.lsnr application ONLINE ONLINE node2

Ora.node2.gsd application ONLINE OFFLINE

Ora.node2.ons application ONLINE ONLINE node2

Ora.node2.vip ora....t1.type ONLINE ONLINE node2

Ora.oc4j ora.oc4j.type ONLINE ONLINE node1

Ora.ons ora.ons.type ONLINE ONLINE node1

Ora.scan1.vip ora....ip.type ONLINE ONLINE node2

Ora.scan2.vip ora....ip.type ONLINE ONLINE node1

Ora.scan3.vip ora....ip.type ONLINE ONLINE node1

Ora.tan.db ora....se.type ONLINE ONLINE node1

[root@node2] # srvctl status database-d tan

Instance tan1 is running on node node1

Instance tan2 is running on node node2

4. Turn off data and CRS

Database-d tan

[root@node1 ~] # srvctl status database-dtan

Instance tan1 is not running on node node1

Instance tan2 is not running on node node2

[root@node1 ~] # srvctl stop listener-nnode1

[root@node1 ~] # srvctl stop listener-nnode2

[root@node1] # srvctl stop vip-n node1

[root@node1] # srvctl stop vip-n node2

PRCC-1017: node2-vip was already stoppedon node2

PRCR-1005: Resource ora.node2.vip isalready stopped

[root@node1 ~] # srvctl stop scan_listener

[root@node1 ~] # srvctl stop scan

Both nodes need to stop CRS.

With the CRSdaemon.

[root@node1 ~] # crsctl check crs

CRS-4639: Could not contact Oracle HighAvailability Services

[root@node1 ~] # crsctl check cluster

CRS-4639: Could not contact Oracle HighAvailability Services

CRS-4000: Command Check failed, orcompleted with errors.

[root@node1 ~] #

[root@node1 ~] # ps-ef | grep grid

Root 14062 26218 0 23:46 pts/2 00:00:00 grep grid

5. Modify public-ip,vip,scan-ip in 2-node hosts

Do not modify Priv-ip for the time being. After modification, it is as follows:

"eth0"

BOOTPROTO= "static"

HWADDR= "00:0C:29:7D:D1:29"

NM_CONTROLLED= "yes"

ONBOOT= "yes"

TYPE= "Ethernet"

IPADDR=192.168.114.11

NETMASK=255.255.255.0

GATEWAY=192.168.115.254

~

[root@node2 ~] # cd/etc/sysconfig/network-scripts/

[root@node2network-scripts] # vi ifcfg-eth0

DEVICE= "eth0"

BOOTPROTO=static

ONBOOT= "yes"

TYPE= "Ethernet"

IPADDR=192.168.114.12

NETMASK=255.255.255.0

GATEWAY=192.168.114.254

HWADDR= "00:50:56:27:B7:1A"

7. Cluster starts CRS

Check crs

CRS-4638: Oracle High Availability Servicesis online

CRS-4535: Cannot communicate with ClusterReady Services

CRS-4529: Cluster Synchronization Servicesis online

CRS-4534: Cannot communicate with EventManager

We'll see it later.

Check crs

CRS-4638: Oracle High Availability Services is online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

[root@node1 ~] # crs_stat-t

Name Type Target State Host

Ora.CRS.dg ora....up.type ONLINE ONLINE node1

Ora.DATA.dg ora....up.type ONLINE ONLINE node1

Ora....ER.lsnr ora....er.type OFFLINE OFFLINE

Ora.LSNR2.lsnr ora....er.type OFFLINE OFFLINE

Ora....N1.lsnr ora....er.type OFFLINE OFFLINE

Ora....N2.lsnr ora....er.type OFFLINE OFFLINE

Ora....N3.lsnr ora....er.type OFFLINE OFFLINE

Ora.LSNR3.lsnr ora....er.type OFFLINE OFFLINE

Ora.asm ora.asm.type ONLINE ONLINE node1

Ora.cvu ora.cvu.type ONLINE OFFLINE

Ora.gsd ora.gsd.type ONLINE OFFLINE

Ora....network ora....rk.type ONLINE OFFLINE

Ora....SM1.asm application ONLINE ONLINE node1

Ora....E1.lsnr application OFFLINE OFFLINE

Ora....E1.lsnr application OFFLINE OFFLINE

Ora....E1.lsnr application OFFLINE OFFLINE

Ora.node1.gsd application ONLINE OFFLINE

Ora.node1.ons application ONLINE OFFLINE

Ora.node1.vip ora....t1.type OFFLINE OFFLINE

Ora....SM2.asm application ONLINE ONLINE node2

Ora....E2.lsnr application OFFLINE OFFLINE

Ora....E2.lsnr application OFFLINE OFFLINE

Ora....E2.lsnr application OFFLINE OFFLINE

Ora.node2.gsd application ONLINE OFFLINE

Ora.node2.ons application ONLINE OFFLINE

Ora.node2.vip ora....t1.type OFFLINE OFFLINE

Ora.oc4j ora.oc4j.type ONLINE ONLINE node1

Ora.ons ora.ons.type ONLINE OFFLINE

Ora.scan1.vip ora....ip.type OFFLINE OFFLINE

Ora.scan2.vip ora....ip.type OFFLINE OFFLINE

Ora.scan3.vip ora....ip.type OFFLINE OFFLINE

Ora.tan.db ora....se.type OFFLINE OFFLINE

8. Use oifcfg to modify public-IP

[root@node1 ~] # oifcfg getif

Eth0 192.168.150.0 global public

Eth2 172.168.146.0 global cluster_interconnect

[root@node1 ~] # oifcfg delif-global eth0

[root@node1 ~] # oifcfg setif-global eth0/192.168.114.0:public

[root@node1 ~] # oifcfg getif

Eth2 172.168.146.0 global cluster_interconnect

Eth0 192.168.114.0 global public

9. Use srvctl to modify VIP

[root@node2] # srvctl stop database-d tan-o immediate

PRCC-1016: tan was already stopped

[root@node2] # srvctl config vip-n node1

VIP exists:/node1-vip/192.168.114.13/192.168.150.0/255.255.255.0/eth0, hosting node node1

[root@node2] # srvctl config vip-n node2

VIP exists:/node2-vip/192.168.114.14/192.168.150.0/255.255.255.0/eth0, hosting node node2

[root@node2 ~] # srvctl stop listener-nnode1

[root@node2 ~] # srvctl stop listener-nnode2

[root@node2] # srvctl stop vip-n node1

[root@node2] # srvctl stop vip-n node2

[root@node2] # srvctlmodify nodeapps-n node1-A 192.168.114.13/255.255.255.0/eth0

[root@node2] # srvctlmodify nodeapps-n node2-A 192.168.114.14/255.255.255.0/eth0

[root@node2] # srvctl config vip-n node1

VIP exists:/node1-vip/192.168.114.13/192.168.114.0/255.255.255.0/eth0, hosting node node1

[root@node2] # srvctl config vip-n node2

VIP exists:/node2-vip/192.168.114.14/192.168.114.0/255.255.255.0/eth0, hosting node node2

10. Use srvctl to modify SCANIP

Modify SCANIP

[root@node1 ~] # srvctl config scan

SCAN name: scanip, Network:1/192.168.114.0/255.255.255.0/eth0

SCAN VIP name: scan1, IP:/scanip/192.168.150.15

SCAN VIP name: scan2, IP:/scanip/192.168.150.16

SCAN VIP name: scan3, IP:/scanip/192.168.150.17

[root@node1 ~] # srvctl stop scan_listener

[root@node1 ~] # srvctl stop scan

[root@node1] # srvctlmodify scan-n scanip

Note: the scanip here is the name in / etc/hosts

192.168.114.15 scanip

192.168.114.16 scanip

192.168.114.17 scanip

Check to confirm:

[root@node1 ~] # srvctl config scan

SCAN name: scanip, Network:1/192.168.114.0/255.255.255.0/eth0

SCAN VIP name: scan1, IP:/scanip/192.168.114.15

SCAN VIP name: scan2, IP:/scanip/192.168.114.16

SCAN VIP name: scan3, IP:/scanip/192.168.114.17

Start scan

[root@node1 ~] # srvctl start scan

[root@node1 ~] # srvctl start scan_listener

11. Use oifcfg to modify private PRIV-IP

[root@node1 ~] # oifcfg getif

Eth2 172.168.146.0 global cluster_interconnect

Eth0 192.168.114.0 global public

It is a network segment, so there is no need to change it here. If you need to change it, refer to modify public-ip.

Modify 2 nodes / etc/hosts

172.168.146.11 node1-priv

172.168.146.12 node2-priv

Modify 2-node eth2 physical location

"eth2"

BOOTPROTO= "static"

HWADDR= "00:0C:29:7D:D1:33"

NM_CONTROLLED= "yes"

ONBOOT= "yes"

TYPE= "Ethernet"

IPADDR=172.168.146.11

NETMASK=255.255.255.0

GATEWAY=172.168.150.1

~

[root@node2 network-scripts] # vi ifcfg-eth2

DEVICE= "eth2"

BOOTPROTO= "static"

HWADDR= "00:50:56:3E:DF:A5"

NM_CONTROLLED= "yes"

ONBOOT= "yes"

TYPE= "Ethernet"

IPADDR=172.168.146.12

NETMASK=255.255.255.0

GATEWAY=172.168.150.1

twelve。 Start the relevant processes one by one

[root@node1] # srvctl start vip-n node1

[root@node1] # srvctl start vip-n node2

[root@node1 ~] # srvctl start listener-nnode1

[root@node1 ~] # srvctl start listener-nnode2

[root@node2 ~] # srvctl start database-dtan

[root@node1 ~] # srvctl status database-dtan

Instance tan1 is running on node node1

Instance tan2 is running on node node2

13. Modify parameter local_listener

Alter system setlocal_listener=' (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.114.13) (PORT=1524) 'sid='tan1'

Alter system setlocal_listener=' (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.114.14) (PORT=1524) 'sid='tan2'

14. test

SQL > conn system/oracle@tanx

Connected.

The above is all the contents of the article "how oracle11g RAC modifies PUBLIC-IP, VIP, PRIV-IP, SCAN-IP". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.