oracle rac 修改private ip-关系型数据库-互联网-天达云

oracle rac 修改private ip
更新：HHH 时间：2023-1-7

背景：由于rac环境私有ip网段和java应用冲突，因此需要修改私有ip的网段。

修改前的privateip为10.10.2网段

修改后的privateip为10.10.1网段

节点一的信息：

[root@rac1 ~]# ifconfig

eth2 Link encap:Ethernet HWaddr 00:0C:29:02:88:AB

inet addr:10.10.3.141 Bcast:10.10.3.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:fe02:88ab/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:12707984 errors:0 dropped:0 overruns:0 frame:0

TX packets:12498850 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:1565224161 (1.4 GiB) TX bytes:1103624532 (1.0 GiB)

eth2:1 Link encap:Ethernet HWaddr 00:0C:29:02:88:AB

inet addr:10.10.3.171 Bcast:10.10.3.255 Mask:255.255.255.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

eth2:3 Link encap:Ethernet HWaddr 00:0C:29:02:88:AB

inet addr:10.10.3.149 Bcast:10.10.3.255 Mask:255.255.255.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

eth3 Link encap:Ethernet HWaddr 00:0C:29:02:88:B5

inet addr:10.10.2.141 Bcast:10.10.1.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:fe02:88b5/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:655407 errors:0 dropped:0 overruns:0 frame:0

TX packets:519369 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:435070724 (414.9 MiB) TX bytes:2880177485 (2.6 GiB)

eth3:1 Link encap:Ethernet HWaddr 00:0C:29:02:88:B5

inet addr:169.254.124.116 Bcast:169.254.255.255 Mask:255.255.0.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

lo Link encap:Local Loopback

inet addr:127.0.0.1 Mask:255.0.0.0

inet6 addr: ::1/128 Scope:Host

UP LOOPBACK RUNNING MTU:16436 Metric:1

RX packets:100603 errors:0 dropped:0 overruns:0 frame:0

TX packets:100603 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:0

RX bytes:59419700 (56.6 MiB) TX bytes:59419700 (56.6 MiB)

节点二的信息：

[root@rac2 ~]# ifconfig

eth2 Link encap:Ethernet HWaddr 00:0C:29:BA:C6:20

inet addr:10.10.3.151 Bcast:10.10.3.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:feba:c620/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:9472 errors:0 dropped:0 overruns:0 frame:0

TX packets:9805 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:2233590 (2.1 MiB) TX bytes:1865980 (1.7 MiB)

eth2:1 Link encap:Ethernet HWaddr 00:0C:29:BA:C6:20

inet addr:10.10.3.159 Bcast:10.10.3.255 Mask:255.255.255.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

eth3 Link encap:Ethernet HWaddr 00:0C:29:BA:C6:2A

inet addr:10.10.2.151 Bcast:10.10.1.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:feba:c62a/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:469429 errors:0 dropped:0 overruns:0 frame:0

TX packets:518127 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:323067317 (308.1 MiB) TX bytes:421759953 (402.2 MiB)

eth3:1 Link encap:Ethernet HWaddr 00:0C:29:BA:C6:2A

inet addr:169.254.127.247 Bcast:169.254.255.255 Mask:255.255.0.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

lo Link encap:Local Loopback

inet addr:127.0.0.1 Mask:255.0.0.0

inet6 addr: ::1/128 Scope:Host

UP LOOPBACK RUNNING MTU:16436 Metric:1

RX packets:131740 errors:0 dropped:0 overruns:0 frame:0

TX packets:131740 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:0

RX bytes:57225431 (54.5 MiB) TX bytes:57225431 (54.5 MiB)

查看节点状态：

[grid@rac1 ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.DATA.dg ora....up.type ONLINE ONLINE rac1

ora.FRA.dg ora....up.type ONLINE ONLINE rac1

ora....ER.lsnr ora....er.type ONLINE ONLINE rac1

ora....N1.lsnr ora....er.type ONLINE ONLINE rac1

ora.OCR.dg ora....up.type ONLINE ONLINE rac1

ora.asm ora.asm.type ONLINE ONLINE rac1

ora.cvu ora.cvu.type ONLINE ONLINE rac1

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE rac1

ora.oc4j ora.oc4j.type ONLINE ONLINE rac1

ora.ons ora.ons.type ONLINE ONLINE rac1

ora.orcl.db ora....se.type ONLINE ONLINE rac1

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application OFFLINE OFFLINE

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip ora....t1.type ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac2

ora....C2.lsnr application ONLINE ONLINE rac2

ora.rac2.gsd application OFFLINE OFFLINE

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip ora....t1.type ONLINE ONLINE rac2

ora....ry.acfs ora....fs.type ONLINE ONLINE rac1

ora.scan1.vip ora....ip.type ONLINE ONLINE rac1

[grid@rac1 ~]$

查看hosts文件hosts

[grid@rac1 ~]$ cat /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

10.10.3.141 rac1

10.10.3.149 rac1-vip

10.10.1.141 rac1-priv

10.10.3.151 rac2

10.10.3.159 rac2-vip

10.10.1.151 rac2-priv

10.10.3.171 scan-ip

[grid@rac1 ~]$

查看所有节点CRS服务节点启动状态：

[root@rac1 bin]# ./olsnodes -h

Usage: olsnodes [ [-n] [-i] [-s] [-t] [<node> | -l [-p]] | [-c] ] [-g] [-v]

where

-n print node number with the node name

-p print private interconnect address for the local node

-i print virtual IP address with the node name

<node> print information for the specified node

-l print information for the local node

-s print node status - active or inactive

-t print node type - pinned or unpinned

-g turn on logging

-v Run in debug mode; use at direction of Oracle Support only.

-c print clusterware name

##-s 查看节点的状态 active/inactive

##-n 查看节点的名称

##-i 查看vip的地址或者名称

[root@rac1 bin]# ./olsnodes -s -n -i

rac1 1 rac1-vip Active

rac2 2 rac2-vip Active

[root@rac1 bin]#

查看IP配置信息

[root@rac1 bin]# ./oifcfg getif

eth2 10.10.3.0 global public

eth3 10.10.2.0 global cluster_interconnect

[root@rac1 bin]#

修改private配置

[root@rac1 bin]# ./oifcfg setif -global eth3/10.10.1.0:cluster_interconnect

[root@rac1 bin]# ./oifcfg getif

eth2 10.10.3.0 global public

eth3 10.10.2.0 global cluster_interconnect

eth3 10.10.1.0 global cluster_interconnect

删除原有的private信息

[root@rac1 bin]# ./oifcfg delif -global eth3/10.10.2.0

[root@rac1 bin]# ./oifcfg getif

eth2 10.10.3.0 global public

eth3 10.10.1.0 global cluster_interconnect

关闭CRS服务（所有节点都要执行）：
rac1

[root@rac1 bin]# ./crsctl stop crs -f

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'

CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'

CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'

CRS-2673: Attempting to stop 'ora.oc4j' on 'rac1'

CRS-2673: Attempting to stop 'ora.cvu' on 'rac1'

CRS-2673: Attempting to stop 'ora.OCR.dg' on 'rac1'

CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'

CRS-2673: Attempting to stop 'ora.orcl.db' on 'rac1'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'

CRS-2677: Stop of 'ora.cvu' on 'rac1' succeeded

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'

CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded

CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac1'

CRS-2677: Stop of 'ora.orcl.db' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'

CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac1'

CRS-2677: Stop of 'ora.FRA.dg' on 'rac1' succeeded

CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded

CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded

CRS-2677: Stop of 'ora.rac2.vip' on 'rac1' succeeded

CRS-2677: Stop of 'ora.oc4j' on 'rac1' succeeded

CRS-2677: Stop of 'ora.OCR.dg' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'rac1'

CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'rac1'

CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'

CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed

CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'

CRS-2673: Attempting to stop 'ora.crf' on 'rac1'

CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'

CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'

CRS-2673: Attempting to stop 'ora.asm' on 'rac1'

CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'

CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded

CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded

CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded

CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded

CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'

CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'

CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded

CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'

CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

rac2

[root@rac1 bin]# ./crsctl stop crs -f

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'

CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'

CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'

CRS-2673: Attempting to stop 'ora.oc4j' on 'rac1'

CRS-2673: Attempting to stop 'ora.cvu' on 'rac1'

CRS-2673: Attempting to stop 'ora.OCR.dg' on 'rac1'

CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'

CRS-2673: Attempting to stop 'ora.orcl.db' on 'rac1'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'

CRS-2677: Stop of 'ora.cvu' on 'rac1' succeeded

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'

CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded

CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac1'

CRS-2677: Stop of 'ora.orcl.db' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'

CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac1'

CRS-2677: Stop of 'ora.FRA.dg' on 'rac1' succeeded

CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded

CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded

CRS-2677: Stop of 'ora.rac2.vip' on 'rac1' succeeded

CRS-2677: Stop of 'ora.oc4j' on 'rac1' succeeded

CRS-2677: Stop of 'ora.OCR.dg' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'rac1'

CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'rac1'

CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'

CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed

CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'

CRS-2673: Attempting to stop 'ora.crf' on 'rac1'

CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'

CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'

CRS-2673: Attempting to stop 'ora.asm' on 'rac1'

CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'

CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded

CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded

CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded

CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded

CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'

CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'

CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded

CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'

CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

修改私有网络物理网卡IP地址和/etc/hosts文件（所有节点都要执行）

rac1

[root@rac1 bin]# vi /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

10.10.3.141 rac1

10.10.3.149 rac1-vip

10.10.1.141 rac1-priv

10.10.3.151 rac2

10.10.3.159 rac2-vip

10.10.1.151 rac2-priv

10.10.3.171 scan-ip

[root@rac1 network-scripts]# vi ifcfg-Auto_eth3

TYPE=Ethernet

BOOTPROTO=none

IPADDR=10.10.1.141

PREFIX=24

GATEWAY=10.10.1.254

DNS1=8.8.8.8

DEFROUTE=yes

IPV4_FAILURE_FATAL=yes

IPV6INIT=no

NAME="eth3"

UUID=c819dfa9-c92b-493a-b679-b6bd70f73d91

ONBOOT=yes

HWADDR=00:0C:29:02:88:B5

LAST_CONNECT=1470089776

DEVICE=eth3

USERCTL=no

NETMASK=255.255.255.0

[root@rac1 network-scripts]# /etc/init.d/network restart

Shutting down interface Auto_eth2: Device state: 3 (disconnected)

[ OK ]

Shutting down interface Auto_eth3: Device state: 3 (disconnected)

[ OK ]

Shutting down loopback interface: [ OK ]

Bringing up loopback interface: [ OK ]

Bringing up interface Auto_eth2: Active connection state: activating

Active connection path: /org/freedesktop/NetworkManager/ActiveConnection/2

state: activated

Connection activated

[ OK ]

Bringing up interface Auto_eth3: Active connection state: activated

Active connection path: /org/freedesktop/NetworkManager/ActiveConnection/3

[ OK ]

Bringing up interface eth0: Error: No suitable device found: no device found for connection 'System eth0'.

[FAILED]

[root@rac1 network-scripts]# ifconfig

eth2 Link encap:Ethernet HWaddr 00:0C:29:02:88:AB

inet addr:10.10.3.141 Bcast:10.10.3.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:fe02:88ab/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:3096 errors:0 dropped:0 overruns:0 frame:0

TX packets:2457 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:340243 (332.2 KiB) TX bytes:367593 (358.9 KiB)

eth3 Link encap:Ethernet HWaddr 00:0C:29:02:88:B5

inet addr:10.10.1.141 Bcast:10.10.1.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:fe02:88b5/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:340197 errors:0 dropped:0 overruns:0 frame:0

TX packets:201393 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:189663546 (180.8 MiB) TX bytes:2642011465 (2.4 GiB)

lo Link encap:Local Loopback

inet addr:127.0.0.1 Mask:255.0.0.0

inet6 addr: ::1/128 Scope:Host

UP LOOPBACK RUNNING MTU:16436 Metric:1

RX packets:39986 errors:0 dropped:0 overruns:0 frame:0

TX packets:39986 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:0

RX bytes:21816394 (20.8 MiB) TX bytes:21816394 (20.8 MiB)

rac2

[root@rac2 ~]# vi /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

10.10.3.141 rac1

10.10.3.149 rac1-vip

10.10.1.141 rac1-priv

10.10.3.151 rac2

10.10.3.159 rac2-vip

10.10.1.151 rac2-priv

10.10.3.171 scan-ip

[root@rac2 bin]# vi /etc/sysconfig/network-scripts/ifcfg-eth3

HWADDR=00:0C:29:BA:C6:2A

TYPE=Ethernet

BOOTPROTO=none

IPADDR=10.10.1.151

PREFIX=24

GATEWAY=10.10.1.254

DNS1=8.8.8.8

DEFROUTE=yes

IPV4_FAILURE_FATAL=yes

IPV6INIT=no

NAME="eth3"

UUID=4b34e645-d36f-4433-a7c7-99584ae252b6

ONBOOT=yes

LAST_CONNECT=1470090441

NETMASK=255.255.255.0

DEVICE=eth3

USERCTL=no

[root@rac2 bin]# /etc/init.d/network restart

Shutting down interface eth2: Device state: 3 (disconnected)

[ OK ]

Shutting down interface eth3: Device state: 3 (disconnected)

[ OK ]

Shutting down loopback interface: [ OK ]

Bringing up loopback interface: [ OK ]

Bringing up interface eth0: Error: No suitable device found: no device found for connection 'System eth0'.

[FAILED]

Bringing up interface eth2: Active connection state: activated

Active connection path: /org/freedesktop/NetworkManager/ActiveConnection/2

[ OK ]

Bringing up interface eth3: Active connection state: activated

Active connection path: /org/freedesktop/NetworkManager/ActiveConnection/3

[ OK ]

[root@rac2 bin]# ifconfig

eth2 Link encap:Ethernet HWaddr 00:0C:29:BA:C6:20

inet addr:10.10.3.151 Bcast:10.10.3.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:feba:c620/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:1343 errors:0 dropped:0 overruns:0 frame:0

TX packets:1096 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:190253 (185.7 KiB) TX bytes:155808 (152.1 KiB)

eth3 Link encap:Ethernet HWaddr 00:0C:29:BA:C6:2A

inet addr:10.10.1.151 Bcast:10.10.1.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:feba:c62a/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:143715 errors:0 dropped:0 overruns:0 frame:0

TX packets:203865 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:82696546 (78.8 MiB) TX bytes:174000173 (165.9 MiB)

lo Link encap:Local Loopback

inet addr:127.0.0.1 Mask:255.0.0.0

inet6 addr: ::1/128 Scope:Host

UP LOOPBACK RUNNING MTU:16436 Metric:1

RX packets:43603 errors:0 dropped:0 overruns:0 frame:0

TX packets:43603 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:0

RX bytes:21240615 (20.2 MiB) TX bytes:21240615 (20.2 MiB)

启动和查看CRS服务

rac1

[root@rac1 network-scripts]# cd /u01/app/11.2.0/grid/bin/

[root@rac1 bin]# ./crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

rac2

[root@rac2 bin]# cd /u01/app/11.2.0/grid/bin/

[root@rac2 bin]# ./crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

查看节点状态：

rac1

[root@rac2 bin]# ./crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.DATA.dg ora....up.type ONLINE ONLINE rac1

ora.FRA.dg ora....up.type ONLINE ONLINE rac1

ora....ER.lsnr ora....er.type ONLINE ONLINE rac1

ora....N1.lsnr ora....er.type ONLINE ONLINE rac1

ora.OCR.dg ora....up.type ONLINE ONLINE rac1

ora.asm ora.asm.type ONLINE ONLINE rac1

ora.cvu ora.cvu.type ONLINE ONLINE rac1

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE rac1

ora.oc4j ora.oc4j.type ONLINE ONLINE rac1

ora.ons ora.ons.type ONLINE ONLINE rac1

ora.orcl.db ora....se.type ONLINE ONLINE rac1

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application OFFLINE OFFLINE

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip ora....t1.type ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac2

ora....C2.lsnr application ONLINE ONLINE rac2

ora.rac2.gsd application OFFLINE OFFLINE

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip ora....t1.type ONLINE ONLINE rac2

ora....ry.acfs ora....fs.type ONLINE ONLINE rac1

ora.scan1.vip ora....ip.type ONLINE ONLINE rac1

[root@rac2 bin]#

[root@rac1 bin]# ifconfig

eth2 Link encap:Ethernet HWaddr 00:0C:29:02:88:AB

inet addr:10.10.3.141 Bcast:10.10.3.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:fe02:88ab/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:215615 errors:0 dropped:0 overruns:0 frame:0

TX packets:212941 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:26571713 (25.3 MiB) TX bytes:18946842 (18.0 MiB)

eth2:1 Link encap:Ethernet HWaddr 00:0C:29:02:88:AB

inet addr:10.10.3.171 Bcast:10.10.3.255 Mask:255.255.255.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

eth2:2 Link encap:Ethernet HWaddr 00:0C:29:02:88:AB

inet addr:10.10.3.159 Bcast:10.10.3.255 Mask:255.255.255.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

eth2:3 Link encap:Ethernet HWaddr 00:0C:29:02:88:AB

inet addr:10.10.3.149 Bcast:10.10.3.255 Mask:255.255.255.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

eth3 Link encap:Ethernet HWaddr 00:0C:29:02:88:B5

inet addr:10.10.1.141 Bcast:10.10.1.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:fe02:88b5/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:340479 errors:0 dropped:0 overruns:0 frame:0

TX packets:201737 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:189728752 (180.9 MiB) TX bytes:2642138569 (2.4 GiB)

eth3:1 Link encap:Ethernet HWaddr 00:0C:29:02:88:B5

inet addr:169.254.124.116 Bcast:169.254.255.255 Mask:255.255.0.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

lo Link encap:Local Loopback

inet addr:127.0.0.1 Mask:255.0.0.0

inet6 addr: ::1/128 Scope:Host

UP LOOPBACK RUNNING MTU:16436 Metric:1

RX packets:47152 errors:0 dropped:0 overruns:0 frame:0

TX packets:47152 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:0

RX bytes:28084290 (26.7 MiB) TX bytes:28084290 (26.7 MiB)

rac2

[root@rac1 bin]# ./crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.DATA.dg ora....up.type ONLINE ONLINE rac1

ora.FRA.dg ora....up.type ONLINE ONLINE rac1

ora....ER.lsnr ora....er.type ONLINE ONLINE rac1

ora....N1.lsnr ora....er.type ONLINE ONLINE rac1

ora.OCR.dg ora....up.type ONLINE ONLINE rac1

ora.asm ora.asm.type ONLINE ONLINE rac1

ora.cvu ora.cvu.type ONLINE ONLINE rac1

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE rac1

ora.oc4j ora.oc4j.type ONLINE ONLINE rac1

ora.ons ora.ons.type ONLINE ONLINE rac1

ora.orcl.db ora....se.type ONLINE ONLINE rac1

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application OFFLINE OFFLINE

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip ora....t1.type ONLINE ONLINE rac1

ora.rac2.vip ora....t1.type ONLINE ONLINE rac1

ora....ry.acfs ora....fs.type ONLINE ONLINE rac1

ora.scan1.vip ora....ip.type ONLINE ONLINE rac1

[root@rac2 bin]# ifconfig

eth2 Link encap:Ethernet HWaddr 00:0C:29:BA:C6:20

inet addr:10.10.3.151 Bcast:10.10.3.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:feba:c620/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:1469 errors:0 dropped:0 overruns:0 frame:0

TX packets:1272 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:206110 (201.2 KiB) TX bytes:187898 (183.4 KiB)

eth2:1 Link encap:Ethernet HWaddr 00:0C:29:BA:C6:20

inet addr:10.10.3.159 Bcast:10.10.3.255 Mask:255.255.255.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

eth3 Link encap:Ethernet HWaddr 00:0C:29:BA:C6:2A

inet addr:10.10.1.151 Bcast:10.10.1.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:feba:c62a/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:181332 errors:0 dropped:0 overruns:0 frame:0

TX packets:217652 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:120834294 (115.2 MiB) TX bytes:180351331 (171.9 MiB)

eth3:1 Link encap:Ethernet HWaddr 00:0C:29:BA:C6:2A

inet addr:169.254.127.247 Bcast:169.254.255.255 Mask:255.255.0.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

lo Link encap:Local Loopback

inet addr:127.0.0.1 Mask:255.0.0.0

inet6 addr: ::1/128 Scope:Host

UP LOOPBACK RUNNING MTU:16436 Metric:1

RX packets:50866 errors:0 dropped:0 overruns:0 frame:0

TX packets:50866 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:0

RX bytes:25967873 (24.7 MiB) TX bytes:25967873 (24.7 MiB)


返回关系型数据库教程...

新手上路

产品管理

支付方式

关于我们