Deinstall Oracle Software in Silent Mode

All kind of installations and configurations including de-installation of Oracle RAC or Database, we can perform using either GUI or Silent mode. GUI mode is more easier as it shows all option (with details) step by step but it may not possible for all the cases or may not support on environment. So we can use all oracle provided tools/utility with silent mode which is more faster and you will able to do this by using putty.

To run any tools with silent mode, DBA should have good understand for each parameter.

For any oracle command which runs using OS command like rman or expdp can get help with tool_name -help. So you don’t need to memorize parameters/options for these tools.

To get all parameters/options list run below command:

$ dbca -help
$ rman -help

List of available tools in Oracle:

  • runInstaller -deinstall -silent # for GI and Database Software
  • deinstall -deinstall -silent # for GI and Database Software
  • dbca -silent
  • asmca -silent
  • netca -silent
  • dbua -silent
  • oifcfg -help # Oracle Interface Configuration Tool

We will discuss in details with each tools:

Oracle RDBMS Software uninstall with Silent Mode: Two Node RAC

[oracle@racdr2 deinstall]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_1/deinstall
[oracle@racdr2 deinstall]$ ls
bootstrap_files.lst  deinstall     deinstall.xml  readme.txt  sshUserSetup.sh
bootstrap.pl         deinstall.pl  jlib           response    utl

[oracle@ocmnode1 deinstall]$ ./deinstall
[oracle@ocmnode1 deinstall]$ ./deinstall -help

deinstall
               [ -silent <-checkonly | -paramfile <complete path of input parameter properties file>> ]
               [ -checkonly ]
               [ -local ]
               [ -paramfile <complete path of input parameter properties file> ]
               [ -params <name1=value[ name2=value name3=value ...]> ]
               [ -o <complete path of directory for saving files> ]
               [ -tmpdir <complete path of temporary directory to use> ]
               [ -logdir <complete path of log directory to use> ]
               [ -help : Display this help message. ]

Once you run deinstall, it will ask below two confirmation and it will show Home (with path) details with list of Nodes which will uninstall.

If Home has multiple databases, provide the db list with comma separator. Then Final confirmation by providing y|yes.

Specify the list of database names that are configured in this Oracle home []: orcl, racdb
Do you want to continue (y - yes, n - no)? [n]: y
[oracle@ocmnode1 deinstall]$ ./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /u001/app/oraInventory/logs/

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

######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##

Checking for existence of the Oracle home location /u001/app/oracle/product/12.1.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 /u001/app/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /u001/app/12.1.0/grid
The following nodes are part of this cluster: ocmnode1,ocmnode2
Active Remote Nodes are ocmnode2
Checking for sufficient temp space availability on node(s) : 'ocmnode1,ocmnode2'

## [END] Install check configuration ##

Network Configuration check config START

Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_check2020-06-27_01-42-17-AM.log

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_check2020-06-27_01-42-20-AM.log

Use comma as separator when specifying list of values as input

Specify the list of database names that are configured in this Oracle home []:
Database Check Configuration END
Oracle Configuration Manager check START
OCM check log file location : /u01/app/oraInventory/logs//ocm_check7230.log
Oracle Configuration Manager check END

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

####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /u01/app/12.1.0/grid
The following nodes are part of this cluster: ocmnode1,ocmnode2
Active Remote Nodes are ocmnode2
The cluster node(s) on which the Oracle home deinstallation will be performed are:ocmnode1,ocmnode2
Oracle Home selected for deinstall is: /u01/app/oracle/product/12.1.0/dbhome_1
Inventory Location where the Oracle home registered is: /u001/app/oraInventory
Checking the config status for CCR
ocmnode1 : Oracle Home exists with CCR directory, but CCR is not configured
ocmnode2 : 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_deconfig2020-06-27_01-42-01-AM.out'
Any error messages from this session will be written to: '/u001/app/oraInventory/logs/deinstall_deconfig2020-06-27_01-42-01-AM.err'

######################## DECONFIG CLEAN OPERATION START ########################
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_clean2020-06-27_01-43-09-AM.log

Network Configuration clean config START

Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_clean2020-06-27_01-43-09-AM.log

De-configuring Listener configuration file on all nodes...
Listener configuration file de-configured successfully.

De-configuring Naming Methods configuration file on all nodes...
Naming Methods configuration file de-configured successfully.

De-configuring Local Net Service Names configuration file on all nodes...
Local Net Service Names configuration file de-configured successfully.

De-configuring Directory Usage configuration file on all nodes...
Directory Usage configuration file de-configured successfully.

De-configuring backup files on all nodes...
Backup files de-configured successfully.

The network configuration has been cleaned up successfully.

Network Configuration clean config END

Oracle Configuration Manager clean START
OCM clean log file location : /u01/app/oraInventory/logs//ocm_clean7230.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/deinstall2020-06-27_01-41-40AM/response/deinstall_2020-06-27_01-42-01-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_deconfig2020-06-27_01-42-01-AM.out'
Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2020-06-27_01-42-01-AM.err'

######################## DEINSTALL CLEAN OPERATION START ########################
## [START] Preparing for Deinstall ##
Setting LOCAL_NODE to ocmnode1
Setting REMOTE_NODES to ocmnode2
Setting CLUSTER_NODES to ocmnode1,ocmnode2
Setting CRS_HOME to false
Setting oracle.installer.invPtrLoc to /tmp/deinstall2020-06-27_01-41-40AM/oraInst.loc
Setting oracle.installer.local to false

## [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.1.0/dbhome_1' from the central inventory on the local node : Done

Failed to delete the directory '/u01/app/oracle/product/12.1.0/dbhome_1'. The directory is in use.
Delete directory '/u01/app/oracle/product/12.1.0/dbhome_1' on the local node : Failed <<<<

The Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/u01/app/12.1.0/grid'.

Detach Oracle home '/u01/app/oracle/product/12.1.0/dbhome_1' from the central inventory on the remote nodes 'ocmnode2' : Done

Delete directory '/u01/app/oracle/product/12.1.0/dbhome_1' on the remote nodes 'ocmnode2' : Done

The Oracle Base directory '/u01/app/oracle' will not be removed on node 'ocmnode2'. The directory is in use by Oracle Home '/u01/app/12.1.0/grid'.

Oracle Universal Installer cleanup was successful.

Oracle Universal Installer clean END

## [START] Oracle install clean ##

Clean install operation removing temporary directory '/tmp/deinstall2020-06-27_01-41-40AM' on node 'ocmnode1'
Clean install operation removing temporary directory '/tmp/deinstall2020-06-27_01-41-40AM' on node 'ocmnode2'

## [END] Oracle install clean ##
######################### DEINSTALL CLEAN OPERATION END #########################
####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/u01/app/oracle/product/12.1.0/dbhome_1' from the central inventory on the local node.
Failed to delete directory '/u01/app/oracle/product/12.1.0/dbhome_1' on the local node.
Successfully detached Oracle home '/u01/app/oracle/product/12.1.0/dbhome_1' from the central inventory on the remote nodes 'ocmnode2'.
Successfully deleted directory '/u01/app/oracle/product/12.1.0/dbhome_1' on the remote nodes 'ocmnode2'.
Oracle Universal Installer cleanup was successful.

Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################
############# ORACLE DEINSTALL TOOL END #############

Oracle Home can be uninstalled by using runInstaller utility also.

[oracle@ocmnode2 bin]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_1/oui/bin
[oracle@ocmnode2 bin]$ ls
addLangs.sh    detachHome.sh  filesList.properties  lsnodes   runConfig.sh  runInstaller.sh
attachHome.sh  filesList.bat  filesList.sh          resource  runInstaller  runSSHSetup.sh

[oracle@ocmnode1 bin]$ ./runInstaller -deinstall -help
Checking for required space in /tmp directory ...
Space check on /tmp directory passed
Bootstrapping the deinstall components
Please wait ...
Bootstrapping completed

deinstall -home <Complete path of Oracle home>
               [ -silent <-checkonly | -paramfile <complete path of input parameter properties file>> ]
               [ -checkonly ]
               [ -local ]
               [ -paramfile <complete path of input parameter properties file> ]
               [ -params <name1=value[ name2=value name3=value ...]> ]
               [ -o <complete path of directory for saving files> ]
               [ -tmpdir <complete path of temporary directory to use> ]
               [ -logdir <complete path of log directory to use> ]
               [ -help : Display this help message. ]

Example of de-installation of Oracle Software:

./runInstaller -deinstall -home complete path of Oracle home [-silent] [-checkonly] [-paramfile complete path of input response file] [-params name1=value name2=value . . .] 
[-o complete path of directory for saving files]
[-tmpdir complete path of temporary directory to use]
[-logdir complete path of log directory to use] [-help]
[oracle@ocmnode1 database]$ ./runInstaller -deinstall -home /u01/app/oracle/product/12.1.0/dbhome_1

Checking for required space in /tmp directory ...
Space check on /tmp directory passed
Bootstrapping the deinstall components
Please wait ...
Bootstrapping completed
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.1.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/12.1.0/grid
The following nodes are part of this cluster: ocmnode1,ocmnode2

####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /u01/app/12.1.0/grid
The following nodes are part of this cluster: ocmnode1,ocmnode2
The cluster node(s) on which the Oracle home deinstallation will be performed are:ocmnode1
Oracle Home selected for deinstall is: /u01/app/oracle/product/12.1.0/dbhome_1
Inventory Location where the Oracle home registered is: /u01/app/oraInventory
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_deconfig2020-06-27_01-00-18-PM.out'
...... ....

Delete Database with Silent Mode using DBCA

[oracle@ocmnode1 ~]$ dbca -help

dbca  [-silent | -progressOnly] {<command> <options> }  | { [<command> [options] ] -responseFile  <response file > } [-continueOnNonFatalErrors <true | false>]

 <command> : -createDatabase | -configureDatabase | -addInstance | -deleteInstance | -createTemplateFromDB | -createCloneTemplate | -generateScripts | -deleteDatabase | -createPluggableDatabase | -unplugDatabase | -deletePluggableDatabase | -configurePluggableDatabase

Enter "dbca -<command> -help" for more option

Example of dropping / deleting ORCL database using dbca with Silent Mode

[oracle@ocmnode1 ~]$ dbca -silent -deleteDatabase -sourceDB orcl
Connecting to database
9% complete
14% complete
19% complete
23% complete
28% complete
33% complete
38% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instances and datafiles
66% complete
80% complete
95% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl1.log" for further details.

Leave a Reply