Shulou(Shulou.com)06/01 Report--

1. Grid stops the database and the cluster

Srvctl stop database-d orcl-o immediate

Srvctl stop listener

2. Root stops CRS, and several nodes should execute it.

Crsctl stop crsctl

3. Modify / etc/hosts file (original file should be backed up)

4. Modify the IP of the public network card

/ etc/sysconfig/network-scripts/ifcfg-eth0

5. Start CRS

[root@dbhost01 ~] # crsctl start crs

[root@dbhost02 ~] # crsctl start crs

6. Modify public ip address

-- View current settin

[root@dbhost01 ~] # oifcfg getif

Eth2 10.0.0.0 global cluster_interconnect

Eth0 192.168.2.0 global public

Oifcfg delif-global eth0

Oifcfg setif-global eth0/192.168.31.0:public

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

[root@dbhost01 ~] # oifcfg setif-global eth0/192.168.31.0:public

View the modified settings:

[root@dbhost01 ~] # oifcfg getif

Eth2 10.0.0.0 global cluster_interconnect

Eth0 192.168.31.0 global public

7. Modify VIP

You need to stop the database, monitoring, and VIP. If you follow the previous operation, the database and monitoring are already stopped.

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

PRCC-1017: 192.168.2.22 was already stopped on dbhost01

PRCR-1005: Resource ora.dbhost01.vip is already stopped

[root@dbhost01] # srvctl stop vip-n dbhost02

[root@dbhost01] # srvctl modify nodeapps-n dbhost01-A 192.168.31.22/255.255.255.0/eth0

[root@dbhost01] # srvctl modify nodeapps-n dbhost02-A 192.168.31.23/255.255.255.0/eth0

Verify again that the VIP modification is complete:

[grid@dbhost01] $srvctl config vip-n dbhost02

VIP exists: / 192.168.31.23/192.168.31.23/192.168.31.0/255.255.255.0/eth0, hosting node dbhost02

[grid@dbhost01] $srvctl config vip-n dbhost01

VIP exists: / 192.168.31.22/192.168.31.22/192.168.31.0/255.255.255.0/eth0, hosting node dbhost01

Start VIP:

[grid@dbhost01] $srvctl start vip-n dbhost01

PRKO-2420: VIP is already started on node (s): dbhost01

[grid@dbhost01] $srvctl start vip-n dbhost02

[grid@dbhost01 ~] $

[grid@dbhost01 ~] $

[grid@dbhost01 ~] $ifconfig

Eth0 Link encap:Ethernet HWaddr 08:00:27:30:2D:6D

Inet addr:192.168.31.20 Bcast:192.168.31.255 Mask:255.255.255.0

Inet6 addr: fe80::a00:27ff:fe30:2d6d/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

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

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

Collisions:0 txqueuelen:1000

RX bytes:241469598 (230.2 MiB) TX bytes:5248362651 (4.8GiB)

Eth0:1 Link encap:Ethernet HWaddr 08:00:27:30:2D:6D

Inet addr:192.168.31.22 Bcast:192.168.31.255 Mask:255.255.255.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

Start monitoring, database

[grid@dbhost01 ~] $srvctl start listener

[grid@dbhost01] $srvctl start database-d orcl

8. Modify SCAN IP

View scan IP settings:

[grid@dbhost02 ~] $srvctl config scan

SCAN name: 192.168.2.24, Network: 1/192.168.31.0/255.255.255.0/eth0

SCAN VIP name: scan1, IP: / 192.168.2.24/192.168.2.24

Stop scan listener

[grid@dbhost02 ~] $srvctl stop scan_listener

[grid@dbhost02 ~] $srvctl stop scan

[grid@dbhost02 ~] $srvctl status scan_listener

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is not running

[grid@dbhost02 ~] $srvctl stop scan

PRCC-1016: scan1 was already stopped

PRCR-1005: Resource ora.scan1.vip is already stopped

[grid@dbhost02 ~] $srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is not running

Use the root user to modify scan IP:

[root@dbhost02] # srvctl modify scan-n orcl-cluster-scan

[root@dbhost02] # srvctl modify scan_listener-u

[root@dbhost02 ~] # srvctl start scan_listener

[root@dbhost02 ~] # srvctl config scan

SCAN name: orcl-cluster-scan, Network: 1/192.168.31.0/255.255.255.0/eth0

SCAN VIP name: scan1, IP: / orcl-cluster-scan/192.168.31.24

Confirm that all resources in the cluster are normal:

[root@dbhost02 ~] # crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.ARCH.dg

ONLINE ONLINE dbhost01

ONLINE ONLINE dbhost02

Ora.BACKUP.dg

ONLINE ONLINE dbhost01

ONLINE ONLINE dbhost02

Ora.DATA.dg

ONLINE ONLINE dbhost01

ONLINE ONLINE dbhost02

Ora.FRA.dg

ONLINE ONLINE dbhost01

ONLINE ONLINE dbhost02

Ora.LISTENER.lsnr

ONLINE ONLINE dbhost01

ONLINE ONLINE dbhost02

Ora.VOTE.dg

ONLINE ONLINE dbhost01

ONLINE ONLINE dbhost02

Ora.asm

ONLINE ONLINE dbhost01 Started

ONLINE ONLINE dbhost02 Started

Ora.gsd

OFFLINE OFFLINE dbhost01

OFFLINE OFFLINE dbhost02

Ora.net1.network

ONLINE ONLINE dbhost01

ONLINE ONLINE dbhost02

Ora.ons

ONLINE ONLINE dbhost01

ONLINE ONLINE dbhost02

Ora.registry.acfs

ONLINE ONLINE dbhost01

ONLINE ONLINE dbhost02

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE dbhost02

Ora.cvu

1 ONLINE ONLINE dbhost01

Ora.dbhost01.vip

1 ONLINE ONLINE dbhost01

Ora.dbhost02.vip

1 ONLINE ONLINE dbhost02

Ora.oc4j

1 ONLINE ONLINE dbhost02

Ora.orcl.db

1 ONLINE ONLINE dbhost01 Open

2 ONLINE ONLINE dbhost02 Open

Ora.scan1.vip

1 ONLINE ONLINE dbhost02

Reference:

Http://www.cnblogs.com/jyzhao/p/7265903.html

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.