BhanuDBA: Delete Node

Steps To delete a node from an RAC cluster .

In this Example , I have three node RAC . I am deleting the 3rd node from cluster .

ORACLE_HOME DEINSTALL

Take Backup of the OCR

[root@ora12cr2n1 bin]# ./ocrconfig -manualbackup

ora12cr2n1 2019/02/11 01:31:23 +DATA:/ora12cr2-rac/OCRBACKUP/backup_20190211_013123.ocr.295.999912689 0
[root@ora12cr2n1 bin]#
[root@ora12cr2n1 bin]#

Remove Instance name from Services .

Remove instance from cluster database .

dbca -silent -deleteInstance -nodeList ora12cr2n3 -gdbName cdbrac -instanceName cdbrac3 -sysDBAUserName sys -sysDBAPassword welcome

Remove any listeners running from database home .

srvctl disable listener -l -n

srvctl stop listener -l -n

Update oracle inventory on the node that is being removed as oracle user.

cd $ORACLE_HOME/oui/bin
./runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1 "CLUSTER_NODES={ora12cr2n3}" -local

[oracle@ora12cr2n3 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1 "CLUSTER_NODES={ora12cr2n3}" -local

Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 3967 MB Passed
The inventory pointer is located at /etc/oraInst.loc
'UpdateNodeList' was successful.

Deinstall ORACLE HOME on the node that is being removed .

cd $ORACLE_HOME/deinstall
./deinstall -local

[oracle@ora12cr2n3 deinstall]$ ./deinstall -local

Checking for required files and bootstrapping …
Please wait …
Location of logs /u01/app/oraInventory/logs/

############ ORACLE DECONFIG TOOL START ############

######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##
Checking for existence of the Oracle home location /u01/app/oracle/product/12.2.0.1/db_1
Oracle Home type selected for deinstall is: Oracle Real Application Cluster Database
Oracle Base selected for deinstall is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /u01/grid_soft
The following nodes are part of this cluster: ora12cr2n3,ora12cr2n2,ora12cr2n1
Checking for sufficient temp space availability on node(s) : 'ora12cr2n3'
## [END] Install check configuration ##
Network Configuration check config START
Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_check2019-02-11_10-11-39-AM.log
Network Configuration check config END
Database Check Configuration START
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_check2019-02-11_10-11-59-AM.log
Use comma as separator when specifying list of values as input
Specify the list of database names that are configured locally on this node for this Oracle home. Local configurations of the discovered databases will be removed [cdrac3]:
Database Check Configuration END
Oracle Configuration Manager check START
OCM check log file location : /u01/app/oraInventory/logs//ocm_check6664.log
Oracle Configuration Manager check END
######################### DECONFIG CHECK OPERATION END #########################
####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /u01/grid_soft
The following nodes are part of this cluster: ora12cr2n3,ora12cr2n2,ora12cr2n1
The cluster node(s) on which the Oracle home deinstallation will be performed are:ora12cr2n3
Oracle Home selected for deinstall is: /u01/app/oracle/product/12.2.0.1/db_1
Inventory Location where the Oracle home registered is: /u01/app/oraInventory
The option -local will not modify any database configuration for this Oracle home.
Checking the config status for CCR
Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2019-02-11_10-11-23-AM.out'
Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2019-02-11_10-11-23-AM.err'

######################## DECONFIG CLEAN OPERATION START ########################

Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_clean2019-02-11_10-20-30-AM.log

Network Configuration clean config START
Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_clean2019-02-11_10-20-30-AM.log
Network Configuration clean config END
Oracle Configuration Manager clean START
OCM clean log file location : /u01/app/oraInventory/logs//ocm_clean6664.log
Oracle Configuration Manager clean END

######################### DECONFIG CLEAN OPERATION END #########################

####################### DECONFIG CLEAN OPERATION SUMMARY #######################

Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
#######################################################################

############# ORACLE DECONFIG TOOL END #############

Using properties file /tmp/deinstall2019-02-11_10-09-04AM/response/deinstall_2019-02-11_10-11-23-AM.rsp
Location of logs /u01/app/oraInventory/logs/
############ ORACLE DEINSTALL TOOL START ############
####################### DEINSTALL CHECK OPERATION SUMMARY #######################

A log of this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2019-02-11_10-11-23-AM.out'

Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2019-02-11_10-11-23-AM.err'

######################## DEINSTALL CLEAN OPERATION START ########################

## [START] Preparing for Deinstall ##

Setting LOCAL_NODE to ora12cr2n3
Setting CLUSTER_NODES to ora12cr2n3
Setting CRS_HOME to false
Setting oracle.installer.invPtrLoc to /tmp/deinstall2019-02-11_10-09-04AM/oraInst.loc
Setting oracle.installer.local to true
## [END] Preparing for Deinstall ##
Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START
Detach Oracle home '/u01/app/oracle/product/12.2.0.1/db_1' from the central inventory on the local node : Done
Delete directory '/u01/app/oracle/product/12.2.0.1/db_1' on the local node : Done
The Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/u01/grid_soft'.
Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END
## [START] Oracle install clean ##
## [END] Oracle install clean ##
######################### DEINSTALL CLEAN OPERATION END #########################

####################### DEINSTALL CLEAN OPERATION SUMMARY #######################

Successfully detached Oracle home '/u01/app/oracle/product/12.2.0.1/db_1' from the central inventory on the local node.
Successfully deleted directory '/u01/app/oracle/product/12.2.0.1/db_1' on the local node.
Oracle Universal Installer cleanup was successful.
Review the permissions and contents of '/u01/app/oracle' on nodes(s) 'ora12cr2n3'.
If there are no Oracle home(s) associated with '/u01/app/oracle', manually delete '/u01/app/oracle' and its contents.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################

############# ORACLE DEINSTALL TOOL END #############

[oracle@ora12cr2n3 deinstall]$
NOTE : Do not forgot to mention -local , if not oracle home will be removed from all the nodes .

NOTE : If this is an shared Oracle Home , We should only detach the oracle home .

cd $ORACLE_HOME/oui/bin
./runInstaller -detachHome ORACLE_HOME=<OH>

Once Oracle home has been deinstalled , We need to update the inventory with the available nodes in the cluster from the active nodes .

ora12cr2n1

cd $ORACLE_HOME/oui/bin

./runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1 "CLUSTER_NODES={ora12cr2n1,ora12cr2n2}"

[oracle@ora12cr2n1 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1 "CLUSTER_NODES={ora12cr2n1,ora12cr2n2}"

Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 3955 MB Passed
The inventory pointer is located at /etc/oraInst.loc
'UpdateNodeList' was successful.
[oracle@ora12cr2n1 bin]$

ora12cr2n2

cd $ORACLE_HOME/oui/bin

./runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1 "CLUSTER_NODES={ora12cr2n1,ora12cr2n2}"

[oracle@ora12cr2n2 ~]$ cd $ORACLE_HOME/oui/bin
[oracle@ora12cr2n2 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1 "CLUSTER_NODES={ora12cr2n1,ora12cr2n2}"
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 3966 MB Passed
The inventory pointer is located at /etc/oraInst.loc
'UpdateNodeList' was successful.
[oracle@ora12cr2n2 bin]$

GRID DEINSTALL

Unpin the Node to be deleted from the cluster

[oracle@ora12cr2n1 bin]$ ./olsnodes -n -t -s
ora12cr2n1      1       Active Unpinned
ora12cr2n2      2       Active Unpinned
ora12cr2n3      3       Active Unpinned
[oracle@ora12cr2n1 bin]$

[root@ora12cr2n3 bin]# ./crsctl unpin css -n ora12cr2n3

CRS-4667: Node ora12cr2n3 successfully unpinned.
[root@ora12cr2n3 bin]#

As root user run the below script

/u01/grid_soft/crs/install
./rootcrs.sh –deconfig -force

[root@ora12cr2n3 install]# ./rootcrs.sh -deconfig -force

Using configuration parameter file: /u01/grid_soft/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/oracle/crsdata/ora12cr2n3/crsconfig/crsdeconfig_ora12cr2n3_2019-02-11_10-47-47AM.log
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ora12cr2n3'
CRS-2673: Attempting to stop 'ora.crsd' on 'ora12cr2n3'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'ora12cr2n3'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'ora12cr2n3'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'ora12cr2n3'
CRS-2677: Stop of 'ora.FRA.dg' on 'ora12cr2n3' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'ora12cr2n3' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'ora12cr2n3'
CRS-2677: Stop of 'ora.asm' on 'ora12cr2n3' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'ora12cr2n3'
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'ora12cr2n3' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ora12cr2n3' has completed
CRS-2677: Stop of 'ora.crsd' on 'ora12cr2n3' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'ora12cr2n3'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'ora12cr2n3'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'ora12cr2n3'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'ora12cr2n3'
CRS-2677: Stop of 'ora.drivers.acfs' on 'ora12cr2n3' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'ora12cr2n3' succeeded
CRS-2677: Stop of 'ora.storage' on 'ora12cr2n3' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'ora12cr2n3'
CRS-2677: Stop of 'ora.mdnsd' on 'ora12cr2n3' succeeded
CRS-2677: Stop of 'ora.asm' on 'ora12cr2n3' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ora12cr2n3'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ora12cr2n3' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'ora12cr2n3'
CRS-2673: Attempting to stop 'ora.evmd' on 'ora12cr2n3'
CRS-2677: Stop of 'ora.ctssd' on 'ora12cr2n3' succeeded
CRS-2677: Stop of 'ora.evmd' on 'ora12cr2n3' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'ora12cr2n3'
CRS-2677: Stop of 'ora.cssd' on 'ora12cr2n3' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'ora12cr2n3'
CRS-2677: Stop of 'ora.gipcd' on 'ora12cr2n3' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ora12cr2n3' has completed
CRS-4133: Oracle High Availability Services has been stopped.

2019/02/11 10:49:34 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.
2019/02/11 10:50:12 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.
2019/02/11 10:50:13 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node
[root@ora12cr2n3 install]#

[oracle@ora12cr2n3 ~]$ ps -ef|grep d.bin

oracle 23295 23250 0 10:52 pts/1 00:00:00 grep --color=auto d.bin
[oracle@ora12cr2n3 ~]$

Deinstall GRID_HOME as GRID user

$GRID_HOME/deinstall/deinstall -local

[oracle@ora12cr2n3 deinstall]$ ./deinstall -local

Checking for required files and bootstrapping …
Please wait …
Location of logs /tmp/deinstall2019-02-11_10-53-08AM/logs/

############ ORACLE DECONFIG TOOL START ############

######################### DECONFIG CHECK OPERATION START #########################

## [START] Install check configuration ##

Checking for existence of the Oracle home location /u01/grid_soft

Oracle Home type selected for deinstall is: Oracle Grid Infrastructure for a Standalone Server
Oracle Base selected for deinstall is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oraInventory
Checking for existence of the Oracle Grid Infrastructure home
## [END] Install check configuration ##
Traces log file: /tmp/deinstall2019-02-11_10-53-08AM/logs//crsdc_2019-02-11_10-53-22-AM.log
Network Configuration check config START
Network de-configuration trace file location: /tmp/deinstall2019-02-11_10-53-08AM/logs/netdc_check2019-02-11_10-53-23-AM.log
Specify all Oracle Restart enabled listeners that are to be de-configured. Enter .(dot) to deselect all. [ASMNET1LSNR_ASM,LISTENER,LISTENER_SCAN3,LISTENER_SCAN2,LISTENER_SCAN1]:
Network Configuration check config END
Asm Check Configuration START
ASM de-configuration trace file location: /tmp/deinstall2019-02-11_10-53-08AM/logs/asmcadc_check2019-02-11_10-54-45-AM.log
ASM configuration was not detected in this Oracle home. Was ASM configured in this Oracle home (y|n) [n]: y
Automatic Storage Management (ASM) instance is detected in this Oracle home /u01/grid_soft.
ASM Diagnostic Destination : /u01/app/oracle
ASM Diskgroups :
ASM diskstring : /dev/oracleasm/*
Diskgroups will not be dropped

If you want to retain the existing diskgroups or if any of the information detected is incorrect, you can modify by entering 'y'. Do you want to modify above information (y|n) [n]: y

Specify the ASM Diagnostic Destination [/u01/app/oracle]:
Specify the diskstring [/dev/oracleasm/*]:
Specify the diskgroups that are managed by this ASM instance []: DATA,FRA

De-configuring ASM will drop the diskgroups at cleanup time. Do you want deconfig tool to drop the diskgroups (y|n) [y]: n

Database Check Configuration START

Database de-configuration trace file location: /tmp/deinstall2019-02-11_10-53-08AM/logs/databasedc_check2019-02-11_10-56-41-AM.log
Database Check Configuration END

######################### DECONFIG CHECK OPERATION END #########################

####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is:
Oracle Home selected for deinstall is: /u01/grid_soft
Inventory Location where the Oracle home registered is: /u01/app/oraInventory
Following Oracle Restart enabled listener(s) will be de-configured: ASMNET1LSNR_ASM,LISTENER,LISTENER_SCAN3,LISTENER_SCAN2,LISTENER_SCAN1
ASM instance will be de-configured from this Oracle home
Do you want to continue (y - yes, n - no)? [n]: y

A log of this session will be written to: '/tmp/deinstall2019-02-11_10-53-08AM/logs/deinstall_deconfig2019-02-11_10-53-20-AM.out'

Any error messages from this session will be written to: '/tmp/deinstall2019-02-11_10-53-08AM/logs/deinstall_deconfig2019-02-11_10-53-20-AM.err'

######################## DECONFIG CLEAN OPERATION START ########################

Database de-configuration trace file location: /tmp/deinstall2019-02-11_10-53-08AM/logs/databasedc_clean2019-02-11_10-56-58-AM.log
ASM de-configuration trace file location: /tmp/deinstall2019-02-11_10-53-08AM/logs/asmcadc_clean2019-02-11_10-56-58-AM.log

ASM Clean Configuration START

ASM Clean Configuration END

Network Configuration clean config START

Network de-configuration trace file location: /tmp/deinstall2019-02-11_10-53-08AM/logs/netdc_clean2019-02-11_10-57-03-AM.log

De-configuring Oracle Restart enabled listener(s): ASMNET1LSNR_ASM,LISTENER,LISTENER_SCAN3,LISTENER_SCAN2,LISTENER_SCAN1

De-configuring listener: ASMNET1LSNR_ASM

Stopping listener: ASMNET1LSNR_ASM

Warning: Failed to stop listener. Listener may not be running.

Deleting listener: ASMNET1LSNR_ASM

Listener deleted successfully.