[Oracle] deletes a node from RAC, which is a oraclerac node.

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