[Oracle] deletes a node from RAC, which is a oraclerac node.
Environment:
OS: OEL5.6
RAC: 10.2.0.1.0
There are currently three rac1, rac2, and rac3 nodes. The following describes how to delete a rac3 node.
1. Delete the database instance on the rac3 Node
[Oracle @ rac1 ~] $ Dbca-silent-deleteInstance-gdbName RACDB-instanceName RACDB3-sysDBAUserName sys-sysDBAPassword 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/export toollogs/dbca/RACDB. log" for further details.
2. Delete the ASM instance on the rac3 Node
[Oracle @ rac1 ~] $ Srvctl stop asm-n rac3
[Oracle @ rac1 ~] $ Srvctl remove asm-n rac3
3. Delete listeners on the rac3 Node
[Oracle @ rac1 ~] $ Netca
4. Delete the $ ORACLE_HOME directory on node 3.
[Oracle @ rac3 ~] $ Rm-rf $ ORACLE_HOME
Update ORACLE_HOME information of a reserved Node
[Oracle @ rac1 ~] $ Cd $ ORACLE_HOME/oui/bin
[Oracle @ rac1 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 will be executed.
'Updatenodelist' was successful.
5. Clear configuration information on rac
On the rac3 node:
[Oracle @ rac3 ~] $ Cat $ CRS_HOME/opmn/conf/ons. config
Localport = 6113
Remoteport = 6200
Loglevel = 3
Useocr = on
On the rac1 node:
[Oracle @ rac1 bin] $ racgons remove_config rac3: 6200
6. delete a rac3 Node
On the rac3 node:
[Root @ rac3 ~] # Cd/u01/app/oracle/product/10.2.0/db_1/install (CRS_HOME)
[Root @ rac3 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 shoshould exit soon.
Checking to see if Oracle CRS stack is 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'
At this time, the CRS on rac3 has been deleted.
[Oracle @ rac1 ~] $ Crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora... B1.inst application ONLINE rac1
Ora... B2.inst application ONLINE rac2
Ora. RACDB. db application ONLINE rac1
Ora... SM1.asm application ONLINE rac1
Ora... C1.lsnr application ONLINE rac1
Ora. rac1.gsd application ONLINE rac1
Ora. rac1.ons application ONLINE rac1
Ora. rac1.vip application ONLINE rac1
Ora... SM2.asm application ONLINE rac2
Ora... C2.lsnr application ONLINE rac2
Ora. rac2.gsd application ONLINE rac2
Ora. rac2.ons application ONLINE rac2
Ora. rac2.vip application ONLINE rac2
However, you cannot view three nodes through olsnodes.
[Root @ rac1 bin] #./olsnodes-n
Rac1 1
Rac2 2 2
Rac3 3
Delete a node from the cluster and update OCR:
[Root @ rac1 install] #./rootdeletenode. sh rac3
CRS nodeapps are deleted successfully
Clscfg: EXISTING configuration version 3 detected.
Clscfg: version 3 is 10G Release 2.
Node deletion operation successful.
'Rac3' deleted successfully
Rac3 node run OUI to delete the CRS installation directory
[Oracle @ rac3 ~] $ Cd $ CRS_HOME
[Oracle @ rac3 db_1] $ cd oui/
[Oracle @ rac3 oui] $ cd bin/
[Oracle @ rac3 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 will be executed.
Preparing to launch Oracle Universal Installer from/tmp/OraInstall2014-08-25_02-14-19PM. Please wait... [oracle @ rac3 bin] $ Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999,200 5, Oracle. All rights reserved.
Starting deinstall
Deinstall in progress (Mon Aug 25 14:14:23 CST 2014)
WARNING: The directory:/u01/app/oracle/product/10.2.0/db_1 will be deleted after deinstall.
Click on "Yes" to continue.
Click on "No" to perform deinstall without deleting the directory.
Click on "Cancel" to go back to "Inventory Dialog ".
........................................ ....................... 100% Done.
Deinstall successful
End of install phases. (Mon Aug 25 14:14:42 CST 2014)
End of deinstallations
Please check '/u01/app/oracle/oraInventory/logs/silentInstall2014-08-25_02-14-19PM.log' for more details.
Update cluster node information on rac1 Node
[Oracle @ rac1 ~] $ Cd $ CRS_HOME/oui/bin/
[Oracle @ rac1 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 will be executed.
'Updatenodelist' was successful.
This node rac3 has been deleted
Oracle Node Deletion
Is there insufficient permissions?
Reporting: ORA-01033: Oracle initializing or disabling when connecting to an instance on the ORACLE 11gR2 RAC master node
I have set up a RAC environment for Oracle11gR2. the nodes are rac1 and rac2.
......
Instance wpsdb1 is running on node rac1
Instance wpsdb2 is running on node rac3
Node rac1, rac2, rac3?
Check Configuration
About whether ORACLE is being initialized or disabled. If it is a windows environment, open the command line.
Sqlplus "/as sysdba"
Use sysdba to check whether the instance can be logged on. If it is not connect to idle instance, the instance is started.
Use shutdown immediate or shutdown abort (note that the test environment can be used, and abort generally does not cause problems)
Then restart the database.