"Oracle" RAC Delete node

Environment:

os:oel5.6

rac:10.2.0.1.0

There are rac1 at the moment. Rac2. RAC3 three nodes, the following is the process of deleting the RAC3 node

1. Delete The DB instance on the RAC3 node

[Email protected] ~]$ dbca-silent-deleteinstance-gdbname racdb-instancename racdb3-sysdbausername sys-sysdbapasswor D Oracle

Deleting instance

20% Complete

21% Complete

22% Complete

26% Complete

33% Complete

40% Complete

46% Complete

53% Complete

60% Complete

66% Complete

Completing instance management.

70% Complete

73% Complete

76% Complete

80% Complete

100% Complete

Look at the log file '/u01/app/oracle/product/10.2.0/db_2/cfgtoollogs/dbca/racdb.log ' for further details.

2. Delete the ASM instance on the RAC3 node

[Email protected] ~]$ srvctl stop asm-n RAC3

[Email protected] ~]$ srvctl remove Asm-n rac3

3. Delete The listener on the RAC3 node

[Email protected] ~]$ NETCA

Watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvymfkbhk5/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70 /gravity/southeast ">

Watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvymfkbhk5/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70 /gravity/southeast ">

4. Delete the $ORACLE _home folder on node 3

[Email protected] ~]$ RM-RF $ORACLE _home

Update oracle_home information for a reserved node

[Email protected] ~]$ CD $ORACLE _home/oui/bin

[Email protected] bin]$/runinstaller-updatenodelist oracle_home=/u01/app/oracle/product/10.2.0/db_2 "CLUSTER_ Nodes=rac1,rac2 "

Starting Oracle Universal Installer ...

No pre-requisite checks found in Oraparam.ini, no system pre-requisite checks would be executed.

' Updatenodelist ' was successful.

5. Clear The configuration information on the RAC

on the RAC3 node:

[email protected] ~]$ cat $CRS _home/opmn/conf/ons.config

localport=6113

remoteport=6200

Loglevel=3

Useocr=on

on the RAC1 node:

[Email protected] bin]$ racgons remove_config rac3:6200

6. Delete the rac3 node

on the RAC3 node:

[Email protected] ~]# cd/u01/app/oracle/product/10.2.0/db_1/install (crs_home)

[Email protected] install]#./rootdelete.sh

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.

Checking to see if Oracle CRS stack are down ...

Oracle CRS Stack is not running.

Oracle CRS stack is down now.

Removing script for Oracle Cluster ready Services

Updating OCR file for downgrade

Cleaning up SCR settings in '/ETC/ORACLE/SCLS_SCR '

This time has removed the CRS on the rac3

[Email protected] ~]$ crs_stat-t

Name Type Target State Host

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

Ora .... B1.inst Application Online Online Rac1

Ora .... B2.inst Application Online Online RAC2

Ora. Racdb.db Application Online Online Rac1

Ora .... Sm1.asm Application Online Online Rac1

Ora .... C1.lsnr Application Online Online Rac1

ORA.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

Ora.rac2.ons Application Online Online RAC2

ORA.RAC2.VIP Application Online Online RAC2

However, at this point, the three nodes are still not viewed by olsnodes

[Email protected] bin]#./olsnodes-n

Rac1 1

RAC2 2

RAC3 3

Remove the node from the cluster and update the OCR:

[Email protected] install]#/rootdeletenode.sh RAC3

CRS Nodeapps is deleted successfully

Clscfg:existing configuration version 3 detected.

Clscfg:version 3 is 10G Release 2.

Node deletion operation successful.

' Rac3 ' deleted successfully

RAC3 node Execution OUI Delete CRS installation folder

[Email protected] ~]$ CD $CRS _home

[Email protected] db_1]$ CD oui/

[Email protected] oui]$ CD bin/

[[email protected] bin]$./runinstaller-deinstall-silent "Remove_homes={/u01/app/oracle/product/10.2.0/db_1}" CRS= True-local

Starting Oracle Universal Installer ...

No pre-requisite checks found in Oraparam.ini, no system pre-requisite checks would be executed.

Preparing to launch Oracle Universal Installer from/tmp/orainstall2014-08-25_02-14-19pm. Please wait ... [Email protected] bin]$ Oracle Universal Installer, Version 10.2.0.1.0 Production

Copyright (C) 1999, 2005, Oracle. All rights reserved.

Starting Deinstall

Deinstall in Progress (Mon-14:14:23 CST 2014)

Warning:the directory:/u01/app/oracle/product/10.2.0/db_1 is deleted after deinstall.

Click on the "Yes" to continue.

Click on "No" to perform deinstall without deleting the directory.

Click on ' Cancel ' to go ' to ' Inventory Dialog '.

............................................................... 100% done.

Deinstall successful

End of install phases. (Mon-14:14:42 CST 2014)

End of Deinstallations

Please check the '/u01/app/oracle/orainventory/logs/silentinstall2014-08-25_02-14-19pm.log ' for more details.

Update cluster node information on the rac1 node

[Email protected] ~]$ CD $CRS _home/oui/bin/

[Email protected] bin]$/runinstaller-updatenodelist oracle_home=/u01/app/oracle/product/10.2.0/db_1 "CLUSTER_ Nodes=rac1,rac2 "Crs=true

Starting Oracle Universal Installer ...

No pre-requisite checks found in Oraparam.ini, no system pre-requisite checks would be executed.

' Updatenodelist ' was successful.

This node rac3 Delete is complete

"Oracle" RAC Delete node