Deleting Oracle Database 19c RAC from Nodes on Linux
Deleting Instances from Oracle RAC Databases
Use DBCA in silent mode to delete a database instance from a node, execute on the remaining nodes.
~]$ dbca -silent -deleteInstance -nodeList oracle19crac03 -gdbName coco -instanceName coco3 -sysDBAUserName sys -sysDBAPassword oracle [WARNING] [DBT-19203] The Database Configuration Assistant will delete the Oracle instance and its associated OFA directory structure. All information about this instance will be deleted.
Prepare for db operation 40% complete Deleting instance 48% complete 52% complete 56% complete 60% complete 64% complete 68% complete 72% complete 76% complete 80% complete Completing instance management. 100% complete Instance "coco3" deleted successfully from node "oracle19crac03". Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/coco/coco.log"for further details.
Removing Oracle RAC
If there is a listener in the Oracle RAC home on the node you are deleting, then you must disable and stop it before deleting the Oracle RAC software.
~]$ crsctl stat res ora.LISTENER.lsnr -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE oracle19crac01 STABLE ONLINE ONLINE oracle19crac02 STABLE OFFLINE OFFLINE oracle19crac03 STABLE --------------------------------------------------------------------------------
Deinstall the Oracle home — only if the Oracle home is not shared.
Oracle Software:
~]$ export CV_ASSUME_DISTID=OL7 ~]$ $ORACLE_HOME/deinstall/deinstall -local Checking for required files and bootstrapping ... Please wait ... Location of logs /u01/app/oraInventory/logs/
Checking for existence of the Oracle home location /u01/app/oracle/product/19.0.0/dbhome_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/app/19.0.0/grid The following nodes are part of this cluster: oracle19crac03,oracle19crac02,oracle19crac01 Checking for sufficient temp space availability on node(s) : 'oracle19crac03'
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 []: Database Check Configuration END
######################### DECONFIG CHECK OPERATION END #########################
####################### DECONFIG CHECK OPERATION SUMMARY ####################### Oracle Grid Infrastructure Home is: /u01/app/19.0.0/grid The following nodes are part of this cluster: oracle19crac03,oracle19crac02,oracle19crac01 The cluster node(s) on which the Oracle home deinstallation will be performed are:oracle19crac03 Oracle Home selected for deinstall is: /u01/app/oracle/product/19.0.0/dbhome_1 Inventory Location where the Oracle home registered is: /u01/app/oraInventory 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_deconfig2023-06-04_02-43-02-PM.out' Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2023-06-04_02-43-02-PM.err'
####################### DEINSTALL CHECK OPERATION SUMMARY ####################### A log of this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2023-06-04_02-43-02-PM.out' Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2023-06-04_02-43-02-PM.err'
######################## DEINSTALL CLEAN OPERATION START ######################## ## [START] Preparing for Deinstall ## Setting LOCAL_NODE to oracle19crac03 Setting CLUSTER_NODES to oracle19crac03 Setting CRS_HOME to false Setting oracle.installer.invPtrLoc to /tmp/deinstall2023-06-04_02-42-05PM/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/19.0.0/dbhome_1' from the central inventory on the local node : Done
Delete directory '/u01/app/oracle/product/19.0.0/dbhome_1' on the local node : Done
The Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is not empty. User needs to manually cleanup this directory.
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/19.0.0/dbhome_1' from the central inventory on the local node. Successfully deleted directory '/u01/app/oracle/product/19.0.0/dbhome_1' on the local node. Oracle Universal Installer cleanup was successful.
Review the permissions and contents of '/u01/app/oracle' on nodes(s) 'oracle19crac03'. 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 #############
Grid Infrastructure:
~]$ export CV_ASSUME_DISTID=OL7 ~]$ $ORACLE_HOME/deinstall/deinstall -local Checking for required files and bootstrapping ... Please wait ... Location of logs /tmp/deinstall2023-06-04_02-45-48PM/logs/
Checking for existence of the Oracle home location /u01/app/19.0.0/grid Oracle Home type selected for deinstall is: Oracle Grid Infrastructure for a Cluster Oracle Base selected for deinstall is: /u01/app/grid Checking for existence of central inventory location /u01/app/oraInventory Checking for existence of the Oracle Grid Infrastructure home /u01/app/19.0.0/grid The following nodes are part of this cluster: oracle19crac03,oracle19crac02,oracle19crac01 Checking for sufficient temp space availability on node(s) : 'oracle19crac03'
Oracle Grid Management database was found in this Grid Infrastructure home
Database Check Configuration END
######################### DECONFIG CHECK OPERATION END #########################
####################### DECONFIG CHECK OPERATION SUMMARY ####################### Oracle Grid Infrastructure Home is: /u01/app/19.0.0/grid The following nodes are part of this cluster: oracle19crac03,oracle19crac02,oracle19crac01 The cluster node(s) on which the Oracle home deinstallation will be performed are:oracle19crac03 Oracle Home selected for deinstall is: /u01/app/19.0.0/grid Inventory Location where the Oracle home registered is: /u01/app/oraInventory Option -local will not modify any ASM configuration. Oracle Grid Management database was found in this Grid Infrastructure home Oracle Grid Management database will be relocated to another node during deconfiguration of local node Do you want to continue (y - yes, n - no)? [n]: y A log of this session will be written to: '/tmp/deinstall2023-06-04_02-45-48PM/logs/deinstall_deconfig2023-06-04_02-46-43-PM.out' Any error messages from this session will be written to: '/tmp/deinstall2023-06-04_02-45-48PM/logs/deinstall_deconfig2023-06-04_02-46-43-PM.err'
Press Enter after you finish running the above commands
<----------------------------------------
######################### DECONFIG CLEAN OPERATION END #########################
####################### DECONFIG CLEAN OPERATION SUMMARY ####################### Local node configuration of Oracle Grid Management database was removed successfully Oracle Clusterware is stopped and successfully de-configured on node "oracle19crac03" Oracle Clusterware is stopped and de-configured successfully. #######################################################################
############# ORACLE DECONFIG TOOL END #############
Using properties file /tmp/deinstall2023-06-04_02-45-48PM/response/deinstall_2023-06-04_02-46-43-PM.rsp Location of logs /tmp/deinstall2023-06-04_02-45-48PM/logs/
####################### DEINSTALL CHECK OPERATION SUMMARY ####################### A log of this session will be written to: '/tmp/deinstall2023-06-04_02-45-48PM/logs/deinstall_deconfig2023-06-04_02-46-43-PM.out' Any error messages from this session will be written to: '/tmp/deinstall2023-06-04_02-45-48PM/logs/deinstall_deconfig2023-06-04_02-46-43-PM.err'
######################## DEINSTALL CLEAN OPERATION START ######################## ## [START] Preparing for Deinstall ## Setting LOCAL_NODE to oracle19crac03 Setting CLUSTER_NODES to oracle19crac03 Setting CRS_HOME to true Setting oracle.installer.invPtrLoc to /tmp/deinstall2023-06-04_02-45-48PM/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/19.0.0/grid' from the central inventory on the local node : Done
Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home/tomcat/webapps/tfa/jet/v6.0.0'. Either user has no permission to delete or it is in use. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home/tomcat/webapps/tfa/jet'. The directory is not empty. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home/tomcat/webapps/tfa/css/images'. Either user has no permission to delete or it is in use. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home/tomcat/webapps/tfa/css/rat'. Either user has no permission to delete or it is in use. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home/tomcat/webapps/tfa/css/codeMirror'. Either user has no permission to delete or it is in use. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home/tomcat/webapps/tfa/css/fonts'. Either user has no permission to delete or it is in use. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home/tomcat/webapps/tfa/css/site'. Either user has no permission to delete or it is in use. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home/tomcat/webapps/tfa/css'. The directory is not empty. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home/tomcat/webapps/tfa'. The directory is not empty. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home/tomcat/webapps'. The directory is not empty. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home/tomcat'. The directory is not empty. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03/tfa_home'. The directory is not empty. Failed to delete the directory '/u01/app/19.0.0/grid/tfa/oracle19crac03'. The directory is not empty. Failed to delete the directory '/u01/app/19.0.0/grid/tfa'. The directory is not empty. Failed to delete the directory '/u01/app/19.0.0/grid'. The directory is not empty. Delete directory '/u01/app/19.0.0/grid' on the local node : Failed <<<<
Delete directory '/u01/app/oraInventory' on the local node : Done
The Oracle Base directory '/u01/app/grid' will not be removed on local node. The directory is not empty. User needs to manually cleanup this directory.
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/19.0.0/grid' from the central inventory on the local node. Failed to delete directory '/u01/app/19.0.0/grid' on the local node due to error : Either user has no permission to delete or file is in use. Review the permissions and manually delete '/u01/app/19.0.0/grid' on local node. Successfully deleted directory '/u01/app/oraInventory' on the local node. Oracle Universal Installer cleanup was successful.
Run 'rm -r /etc/oraInst.loc' as root on node(s) 'oracle19crac03' at the end of the session.
Run 'rm -r /opt/ORCLfmap' as root on node(s) 'oracle19crac03' at the end of the session. Review the permissions and contents of '/u01/app/grid' on nodes(s) 'oracle19crac03'. If there are no Oracle home(s) associated with '/u01/app/grid', manually delete '/u01/app/grid' and its contents. Oracle deinstall tool successfully cleaned up temporary directories. #######################################################################
############# ORACLE DEINSTALL TOOL END #############
Deleting Nodes from the Cluster
During remove RAC software, running the prompted command de-configure the local node from cluster.
~]# /u01/app/19.0.0/grid/crs/install/rootcrs.sh -force -deconfig -paramfile "/tmp/deinstall2023-06-04_02-45-48PM/response/deinstall_OraGI19Home1.rsp" Using configuration parameter file: /tmp/deinstall2023-06-04_02-45-48PM/response/deinstall_OraGI19Home1.rsp The log of current session can be found at: /tmp/deinstall2023-06-04_02-45-48PM/logs/crsdeconfig_oracle19crac03_2023-06-04_02-49-24PM.log Redirecting to /bin/systemctl restart rsyslog.service 2023/06/04 14:52:14 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector. 2023/06/04 14:52:14 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector. 2023/06/04 14:52:39 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node
