oracle10g RAC 0 Downtime Modify public ip&vip

First modify the 1-node

1. Modify the information for public in OCR

[Email protected] ~]$ oifcfg delif-global eth0[[email protected]c1 ~]$ oifcfg setif-global Eth0/172.168.1.0:public[[ema Il protected] ~]$ oifcfg getifeth0 172.168.1.0 Global publiceth1 192.168.1.0 Global Cluster_interconnect

2. Stop the 1-node Nodeapps resource

[Email protected] ~]$ srvctl stop nodeapps-n Rac1

3. Modify the host IP

[Email protected] ~]$ oifcfg iflisteth0  172.168.10.0eth1  192.168.1.0[[email protected] ~]# vi/etc/sysconfig/ Network-scripts/ifcfg-eth0

Modify the public IP and VIP for the 1 node in the/etc/hosts file

[Email protected] ~]# vi/etc/hosts#public ip192.168.0.10-to 192.168.1.10#vip192.168.1.20-192.168.1.20[[ Email protected] ~]# vi/etc/hosts#public ip192.168.0.10-to 192.168.1.10#vip192.168.1.20-192.168.1.20

Restart Network Service

[[Email protected] ~]# service network Restart[[email protected] ~]$ oifcfg iflisteth0  172.168.1.0eth1  192.168.1.0

4. Modify VIP

[email protected] ~]$ su                                                                   Password:                                                                             

5. Modify the Listening file

$ VI $ORACLE _home/network/admin/listener.ora

6. Start Nodeapps Resources

[[email protected] ~]$ srvctl start nodeapps-n rac1rac1:ora.rac1.LISTENER_RAC1.lsnr:rac1:ora.rac1.LISTENER_ RAC1.lsnr:LSNRCTL for linux:version 10.2.0.5.0-production on 01-sep-2014 17:13:26rac1:ora.rac1.listener_rac1.lsnr:  Rac1:ora.rac1.LISTENER_RAC1.lsnr:Copyright (c) 1991, Oracle. All Rights reserved.rac1:ora.rac1.listener_rac1.lsnr:rac1:ora.rac1.listener_rac1.lsnr:starting/oracle/app/oracle /product/10.2.0/db_1/bin/tnslsnr:please Wait...rac1:ora.rac1.listener_rac1.lsnr:rac1:ora.rac1.listener_ RAC1.lsnr:TNSLSNR for linux:version 10.2.0.5.0-productionrac1:ora.rac1.listener_rac1.lsnr:system parameter file is/ Oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.orarac1:ora.rac1.listener_rac1.lsnr:log messages Written To/oracle/app/oracle/product/10.2.0/db_1/network/log/listener_rac1.lograc1:ora.rac1.listener_rac1.lsnr: Error listening on: (Description= (Address= (protocol=tcp) (host=192.168.1.21) (port=1521) (Ip=first))) Rac1:o Ra.rac1.listener_rac1.lsnr:tns-12545:coNnect failed because target host or object does not existrac1:ora.rac1.listener_rac1.lsnr:tns-12560:tns:protocol adapter Errorrac1:ora.rac1.listener_rac1.lsnr:tns-00515:connect failed because target host or object does not existrac1:ora.ra C1. LISTENER_RAC1.lsnr:Linux Error:99:cannot Assign requested Addressrac1:ora.rac1.listener_rac1.lsnr:rac1:o Ra.rac1.LISTENER_RAC1.lsnr:Listener failed to start. See the error message (s) above...rac1:ora.rac1.listener_rac1.lsnr:rac1:ora.rac1.listener_rac1.lsnr:rac1:o Ra.rac1.LISTENER_RAC1.lsnr:LSNRCTL for linux:version 10.2.0.5.0-production on 01-sep-2014 17:13:29rac1:o  Ra.rac1.LISTENER_RAC1.lsnr:rac1:ora.rac1.LISTENER_RAC1.lsnr:Copyright (c) 1991, Oracle. All rights reserved.rac1:ora.rac1.LISTENER_RAC1.lsnr:rac1:ora.rac1.LISTENER_RAC1.lsnr:Connecting to (description= ( Address= (PROTOCOL=TCP) (host=192.168.1.21) (port=1521) (Ip=first)) Rac1:ora.rac1.listener_rac1.lsnr:tns-12560:tns :p Rotocol Adapter Errorrac1:ora.rac1.LISTENER_RAC1.lsnr:TNS-00530:protocol Adapter Errorrac1:ora.rac1.LISTENER_RAC1.lsnr:Linux error:113:no route to Hostrac1:ora.rac1.LISTENE R_RAC1.lsnr:Connecting to (description= (address= (protocol=tcp) (host=172.168.1.11) (port=1521)) Ip=first Ra.rac1.listener_rac1.lsnr:tns-12541:tns:no Listenerrac1:ora.rac1.listener_rac1.lsnr:tns-12560:tns:protocol Adapter Errorrac1:ora.rac1.listener_rac1.lsnr:tns-00511:no listenerrac1:ora.rac1.LISTENER_RAC1.lsnr:Linux Error: 111:connection refusedcrs-0215:could Not start resource ' Ora.rac1.LISTENER_RAC1.lsnr '.

Monitoring resources are not up, you can see that other resources are starting normally

[[email protected] admin]$ crs_stat-tname Type Target St Ate Host------------------------------------------------------------ora .... Sm1.asm application online online Rac1 ora .... C1.lsnr Application online OFFLINE ORA.RAC1.GSD application online online Rac1 ora.rac1.ons a pplication Online online rac1 ora.rac1.vip application online online Rac1 ora .... Sm2.asm application online online rac2 ora .... C2.lsnr application Online Online rac2 ora.rac2.gsd application online online rac2 or        A.rac2.ons application Online Online rac2 ora.rac2.vip application online online RAC2        Ora.test.db application Online Online rac1 ora....t1.inst application online online Rac1 Ora....t2.inst application online Online rac2 

7. Start monitoring manually

[[email protected] admin]$ lsnrctl startlsnrctl for linux:version 10.2.0.5.0-production on 01-SEP-2014 17:19:50Cop  Yright (c) 1991, Oracle. All rights reserved. Starting/oracle/app/oracle/product/10.2.0/db_1/bin/tnslsnr:please wait ... Tnslsnr for linux:version 10.2.0.5.0-productionsystem parameter file is/oracle/app/oracle/product/10.2.0/db_1/ Network/admin/listener.oralog messages Written to/oracle/app/oracle/product/10.2.0/db_1/network/log/ Listener.loglistening on: (Description= (Address= (protocol=tcp) (HOST=RAC1) (port=1521)) Connecting to (ADDRESS= (                   PROTOCOL=TCP) (host=) (port=1521)) STATUS of the LISTENER------------------------Alias listenerversion                    Tnslsnr for linux:version 10.2.0.5.0-productionstart Date 01-sep-2014 17:19:50uptime 0 days 0 hr. 0 min. 0 sectrace level offsecurity on:local OS Authenticatio Nsnmp Offlistener Parameter File/oraCle/app/oracle/product/10.2.0/db_1/network/admin/listener.oralistener Log file/oracle/app/oracle/product/10.2.0/  db_1/network/log/listener.loglistening Endpoints Summary ... (Description= (address= (protocol=tcp) (HOST=RAC1) (port=1521))) The listener supports no servicesthe command completed successfully

8. Dynamic Monitoring Registration

[Email protected] admin]$ sqlplus/as sysdbasql*plus:release 10.2.0.5.0-production on Mon Sep 1 17:20:06 2014Copyrigh T (c) 1982, Oracle.  All rights reserved.connected to:oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit productionwith the part Itioning, real application Clusters, OLAP, Data miningand real application Testing optionssql> alter system register; System altered.

9. Start the Monitoring resource

[Email protected] ~]$ crsctl start Resources ora.rac2.LISTENER_RAC2.lsnrStarting resources. Successfully started CRS resources

10. Check status again, all started

[[email protected] ~]$ crs_stat-tname Type Target State Host------------------------------------------------------------ora .... Sm1.asm application online online Rac1 ora ....   C1.lsnr Application online online RAC1ORA.RAC1.GSD application online online Rac1 ora.rac1.ons Application Online online rac1 ora.rac1.vip application online online Rac1 ora .... Sm2.asm application online online rac2 ora .... C2.lsnr application Online Online rac2 ora.rac2.gsd application online online rac2 or        A.rac2.ons application Online Online rac2 ora.rac2.vip application online online RAC2        Ora.test.db application Online Online rac1 ora....t1.inst application online online Rac1 Ora....t2.inst application online Online rac2 

Next, modify the 2 node and modify the 1 node with the same steps

oracle10g RAC 0 Downtime Modify public ip&vip