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

First, the preparatory work 1. Database information

Operating system version: OEL5.4 x64

Database version: Oracle 10.2.0.5 x64 RAC

2. IP address correspondence information

Note: the server host name can not be changed, if you really want to change the name, you need to reinstall CRS solution, it is better to reinstall it.

The environment of this paper is 10g rac+ocfs+asm, and the heartbeat address remains the same. Due to the limitation of the environment, the IP address temporarily uses the same network segment and different IP address, but the process is the same as that of different network segments.

Original IP address:

192.168.0.6 node1 is modified to: 192.168.0.206

192.168.0.7 node2 is modified to: 192.168.0.207

192.168.0.8 node1-vip is modified to: 192.168.0.208

192.168.0.9 node2-vip is modified to: 192.168.0.209

10.10.10.10 node1-priv unchanged

10.10.10.20 node2-priv unchanged

Adjusted IP address:

192.168.0.206 node1

192.168.0.207 node2

192.168.0.208 node1-vip

192.168.0.209 node2-vip

10.10.10.10 node1-priv

10.10.10.20 node2-priv

Stop the oracle rac service. 1. Close the ORACLE RAC process, which can be executed on any node, using node 1. 0.

[root@node1 ~] # cd / u01/app/oracle/product/10.2.0/crs/bin

[root@node1 ~] # pwd

/ u01/app/oracle/product/10.2.0/crs/bin

# close the database, asm, node application, crs in turn

[root@node1 bin] #. / srvctl stop database-d orcl

[root@node1 bin] #. / srvctl stop asm-n node1

[root@node1 bin] #. / srvctl stop asm-n node2

[root@node1 bin] #. / srvctl stop nodeapps-n node1

[root@node1 bin] #. / srvctl stop nodeapps-n node2

# check the shutdown

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

Name Type Target State Host

Ora....SM1.asm application OFFLINE OFFLINE

Ora....E1.lsnr application OFFLINE OFFLINE

Ora.node1.gsd application OFFLINE OFFLINE

Ora.node1.ons application OFFLINE OFFLINE

Ora.node1.vip application OFFLINE OFFLINE

Ora....SM2.asm application OFFLINE OFFLINE

Ora....E2.lsnr application OFFLINE OFFLINE

Ora.node2.gsd application OFFLINE OFFLINE

Ora.node2.ons application OFFLINE OFFLINE

Ora.node2.vip application OFFLINE OFFLINE

Ora.orcl.db application OFFLINE OFFLINE

Ora....l1.inst application OFFLINE OFFLINE

Ora....l2.inst application OFFLINE OFFLINE

two。 Close the crs background process

# Note: root user execution must be performed on all (node1,node2) nodes.

[root@node1 bin] # / etc/init.d/init.crs stop

Shutting down Oracle Cluster Ready Services (CRS):

Stopping resources.

Successfully stopped CRS resources

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

Shutdown has begun. The daemons should exit soon.

[root@node2 bin] # / etc/init.d/init.crs stop

Shutting down Oracle Cluster Ready Services (CRS):

Stopping resources.

Successfully stopped CRS resources

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

Shutdown has begun. The daemons should exit soon.

Modify the server IP address 1. Node1,node2 modify / etc/hosts file. Keep the consistency of the two nodes

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

192.168.0.206 node1

192.168.0.207 node2

192.168.0.208 node1-vip

192.168.0.209 node2-vip

10.10.10.10 node1-priv

10.10.10.20 node2-priv

two。 Modify the eth0 address and gateway on the two nodes respectively, and the heartbeat address remains unchanged.

Node1 node:

[root@node1 bin] # more / etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0

BOOTPROTO=static

HWADDR=00:0C:29:EA:C7:1F

IPADDR=192.168.0.206

NETMASK=255.255.255.0

ONBOOT=yes

Node2 node:

[root@node2 bin] # more / etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0

BOOTPROTO=static

ONBOOT=yes

IPADDR=192.168.0.207

NETMASK=255.255.255.0

HWADDR=00:0c:29:6c:08:aa

3. Restart network services

# service network restart

# service network restart

Fourth, start crs.1. Start crs on both nodes (node1,node2) and turn off the services started with crs

[root@node1 bin] # / etc/init.d/init.crs start

Startup will be queued to init within 30 seconds.

[root@node2 bin] # / etc/init.d/init.crs start

Startup will be queued to init within 30 seconds.

# because the IP address has not been modified, some servers cannot be started successfully and need to be shut down.

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

Name Type Target State Host

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

Ora....E1.lsnr application ONLINE OFFLINE

Ora.node1.gsd application ONLINE OFFLINE

Ora.node1.ons application ONLINE ONLINE node1

Ora.node1.vip application ONLINE ONLINE node1

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

Ora....E2.lsnr application ONLINE OFFLINE

Ora.node2.gsd application ONLINE OFFLINE

Ora.node2.ons application ONLINE ONLINE node2

Ora.node2.vip application ONLINE ONLINE node2

Ora.orcl.db application ONLINE OFFLINE

Ora....l1.inst application ONLINE OFFLINE

Ora....l2.inst application ONLINE OFFLINE

# disable all services

[root@node1 bin] #. / srvctl stop database-d orcl

[root@node1 bin] #. / srvctl stop asm-n node1

[root@node1 bin] #. / srvctl stop asm-n node2

[root@node1 bin] #. / srvctl stop nodeapps-n node1

[root@node1 bin] #. / srvctl stop nodeapps-n node2

# confirm shutdown

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

Name Type Target State Host

Ora....SM1.asm application OFFLINE OFFLINE

Ora....E1.lsnr application OFFLINE OFFLINE

Ora.node1.gsd application OFFLINE OFFLINE

Ora.node1.ons application OFFLINE OFFLINE

Ora.node1.vip application OFFLINE OFFLINE

Ora....SM2.asm application OFFLINE OFFLINE

Ora....E2.lsnr application OFFLINE OFFLINE

Ora.node2.gsd application OFFLINE OFFLINE

Ora.node2.ons application OFFLINE OFFLINE

Ora.node2.vip application OFFLINE OFFLINE

Ora.orcl.db application OFFLINE OFFLINE

Ora....l1.inst application OFFLINE OFFLINE

Ora....l2.inst application OFFLINE OFFLINE

[root@node1 bin] #

two。 Use oifcfg to modify the network card settings, oifconfig can be used to set and view the way the network card is used.

Note: if you operate on node1,node2, you don't have to do it if you modify the same network segment, but if you have other network segments, you can do it as follows

# View current configuration

[root@node1 bin] #. / oifcfg getif-global

Eth0 192.168.0.0 global public

Eth2 10.10.10.0 global cluster_interconnect

# Delete the current configuration

[root@node1 bin] #. / oifcfg delif-global eth0

[root@node1 bin] #. / oifcfg delif-global eth2

[root@node1 bin] #. / oifcfg getif

# re-add, inline and heartbeat network segment (configure network segment corresponding to IP address subnet mask)

[root@node1 bin] #. / oifcfg setif-global eth0/192.168.0.0:public

[root@node1 bin] #. / oifcfg setif-global eth2/10.10.10.0:cluster_interconnect

[root@node1 bin] #. / oifcfg getif

Eth0 192.168.0.0 global public

Eth2 10.10.10.0 global cluster_interconnect

[root@node1 bin] #. / oifcfg iflist

Eth0 192.168.0.0

Eth2 10.10.10.0

3. Node1,node2 modifies VIP address

[root@node1 bin] #. / srvctl modify nodeapps-n node1-A 192.168.0.208/255.255.255.0/eth0

[root@node1 bin] #. / srvctl modify nodeapps-n node2-A 192.168.0.209/255.255.255.0/eth0

4. Node1,node2 sets listener.ora and tnsnames.ora

# check the original IP address and change it to the current IP address.

[root@node1 bin] # vi / u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

SID_LIST_LISTENER_NODE1 =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = / u01/app/oracle/product/10.2.0/db_1)

(PROGRAM = extproc)

)

)

LISTENER_NODE1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = node1-vip) (PORT = 1521) (IP = FIRST))

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.206) (PORT = 1521) (IP = FIRST))

)

)

5. Operate on node1 and start node application, asm, database

[root@node1 bin] #. / srvctl start nodeapps-n node1

[root@node1 bin] #. / srvctl start nodeapps-n node2

[root@node1 bin] #. / srvctl start asm-n node1

[root@node1 bin] #. / srvctl start asm-n node2

[root@node1 bin] #. / srvctl start instance-d orcl-I orcl1

[root@node1 bin] #. / srvctl start instance-d orcl-I orcl2

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

Name Type Target State Host

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

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

Ora.node1.gsd application ONLINE ONLINE node1

Ora.node1.ons application ONLINE ONLINE node1

Ora.node1.vip application ONLINE ONLINE node1

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

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

Ora.node2.gsd application ONLINE ONLINE node2

Ora.node2.ons application ONLINE ONLINE node2

Ora.node2.vip application ONLINE ONLINE node2

Ora.orcl.db application ONLINE ONLINE node2

Ora....l1.inst application ONLINE ONLINE node1

Ora....l2.inst application ONLINE ONLINE node2

If there is a problem with the startup, make a judgment.

6. Confirm IP, the modification is complete.

[root@node1 bin] # ifconfig

Eth0 Link encap:Ethernet HWaddr 00:0C:29:EA:C7:1F

Inet addr:192.168.0.206 Bcast:192.168.0.255 Mask:255.255.255.0

Eth0:1 Link encap:Ethernet HWaddr 00:0C:29:EA:C7:1F

Inet addr:192.168.0.208 Bcast:192.168.0.255 Mask:255.255.255.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

Eth2 Link encap:Ethernet HWaddr 00:0C:29:EA:C7:29

Inet addr:10.10.10.10 Bcast:10.10.10.255 Mask:255.255.255.0

[root@node2 ~] # ifconfig

Eth0 Link encap:Ethernet HWaddr 00:0C:29:6C:08:AA

Inet addr:192.168.0.207 Bcast:192.168.0.255 Mask:255.255.255.0

Eth0:1 Link encap:Ethernet HWaddr 00:0C:29:6C:08:AA

Inet addr:192.168.0.209 Bcast:192.168.0.255 Mask:255.255.255.0

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

Eth2 Link encap:Ethernet HWaddr 00:0C:29:6C:08:B4

Inet addr:10.10.10.20 Bcast:10.10.10.255 Mask:255.255.255.0

7. Restart the node test, rac startup is normal, no problem.

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.