Search In The Blog

Sunday 26 August 2018

How to uninstall Oracle Home 12c on Exadata step by step


How to uninstall Oracle Home 12c on Exadata step by step

Owner of the oracle Home is oradbxp
Oracle Home is /u01/app/oracle/product/12.1.0.2/oradbxp_dbhome
This is Exadata machine and three node RAC

Steps to uninstall Oracle Home on exadata and normal server is same. below steps uninstall Oracle home from all nodes.

[oradbxp@myexa01 database]$
[oradbxp@myexa01 database]$ cd -
/u01/app/oracle/product/12.1.0.2/oradbxp_dbhome/deinstall
[oradbxp@myexa01 deinstall]$
[oradbxp@myexa01 deinstall]$
[oradbxp@myexa01 deinstall]$ pwd
/u01/app/oracle/product/12.1.0.2/oradbxp_dbhome/deinstall
[oradbxp@myexa01 deinstall]$
[oradbxp@myexa01 deinstall]$ cd -
/u01/app/oracle/Oeda/Software/12.1.0.2/database
[oradbxp@myexa01 database]$
[oradbxp@myexa01 database]$
[oradbxp@myexa01 database]$ ls -lrt
total 36
-rwxr-xr-x  1 oracle oinstall  500 Feb  7  2013 welcome.html
-rwxr-xr-x  1 oracle oinstall 8533 Jul  7  2014 runInstaller
drwxr-xr-x  2 oracle oinstall 4096 Jul  7  2014 rpm
drwxrwxr-x  2 oracle oinstall 4096 Jul  7  2014 sshsetup
drwxrwxr-x  2 oracle oinstall 4096 Jul  7  2014 response
drwxr-xr-x  4 oracle oinstall 4096 Jul  7  2014 install
drwxr-xr-x 14 oracle oinstall 4096 Nov 13 16:06 stage
-rw-------  1 oracle oinstall    0 Nov 23 18:16 nohup.out
[oradbxp@myexa01 database]$
[oradbxp@myexa01 database]$ ./runInstaller -deinstall -home /u01/app/oracle/product/12.1.0.2/oradbxp_dbhome
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.2/oradbxp_dbhome
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.2/grid
The following nodes are part of this cluster: myexa01,ctsddbadm02,ctsddbadm03
Active Remote Nodes are ctsddbadm02,ctsddbadm03
Checking for sufficient temp space availability on node(s) : 'myexa01,ctsddbadm02,ctsddbadm03'

## [END] Install check configuration ##


Network Configuration check config START

Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_check2017-11-29_03-57-07-PM.log

Specify all RAC listeners (do not include SCAN listener) that are to be de-configured. Enter .(dot) to deselect all. [LISTENER_XLHYPPRD]:

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_check2017-11-29_03-57-37-PM.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 [xlhypprd1]:

###### For Database 'xlhypprd1' ######

Specify the type of this database (1.Single Instance Database|2.Oracle Restart Enabled Database|3.RAC Database|4.RAC One Node Database) [1]: 3
Specify the list of nodes on which this database has instances [myexa01]: myexa01,ctsddbadm02,ctsddbadm03
Specify the list of instance names [xlhypprd1]: xlhypprd1,xlhypprd2,xlhypprd3
Specify the local instance name on node   [xlhypprd1]:
Specify the diagnostic destination location of the database [/u01/app/oracle/diag/rdbms/xlhypprd_dr]:
Specify the storage type used by the Database ASM|FS []: ASM


Database Check Configuration END
Oracle Configuration Manager check START
OCM check log file location : /u01/app/oraInventory/logs//ocm_check9896.log
Oracle Configuration Manager check END

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


####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /u01/app/12.1.0.2/grid
The following nodes are part of this cluster: myexa01,ctsddbadm02,ctsddbadm03
Active Remote Nodes are ctsddbadm02,ctsddbadm03
The cluster node(s) on which the Oracle home deinstallation will be performed are:myexa01,ctsddbadm02,ctsddbadm03
Oracle Home selected for deinstall is: /u01/app/oracle/product/12.1.0.2/oradbxp_dbhome
Inventory Location where the Oracle home registered is: /u01/app/oraInventory
Following RAC listener(s) will be de-configured: LISTENER_XLHYPPRD
The following databases were selected for de-configuration : xlhypprd1
Database unique name : xlhypprd1
Storage used : ASM
Checking the config status for CCR
myexa01 : Oracle Home exists with CCR directory, but CCR is not configured
ctsddbadm02 : Oracle Home exists with CCR directory, but CCR is not configured
ctsddbadm03 : 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_deconfig2017-11-29_03-57-01-PM.out'
Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2017-11-29_03-57-01-PM.err'

######################## DECONFIG CLEAN OPERATION START ########################
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_clean2017-11-29_03-59-07-PM.log
Database Clean Configuration START xlhypprd1
This operation may take few minutes.
Database Clean Configuration END xlhypprd1

Network Configuration clean config START

Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_clean2017-11-29_03-59-26-PM.log

De-configuring RAC listener(s): LISTENER_XLHYPPRD

De-configuring listener: LISTENER_XLHYPPRD
    Stopping listener: LISTENER_XLHYPPRD
    Listener stopped successfully.
    Unregistering listener: LISTENER_XLHYPPRD
    Listener unregistered successfully.
Listener de-configured successfully.

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_clean9896.log
Oracle Configuration Manager clean END

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


####################### DECONFIG CLEAN OPERATION SUMMARY #######################
Successfully de-configured the following database instances : xlhypprd1
Following RAC listener(s) were de-configured successfully: LISTENER_XLHYPPRD
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/deinstall2017-11-29_03-56-52PM/response/deinstall_2017-11-29_03-57-01-PM.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_deconfig2017-11-29_03-57-01-PM.out'
Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2017-11-29_03-57-01-PM.err'

######################## DEINSTALL CLEAN OPERATION START ########################
## [START] Preparing for Deinstall ##
Setting LOCAL_NODE to myexa01
Setting REMOTE_NODES to ctsddbadm02,ctsddbadm03
Setting CLUSTER_NODES to myexa01,ctsddbadm02,ctsddbadm03
Setting CRS_HOME to false
Setting oracle.installer.invPtrLoc to /tmp/deinstall2017-11-29_03-56-52PM/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.2/oradbxp_dbhome' from the central inventory on the local node : Done

Delete directory '/u01/app/oracle/product/12.1.0.2/oradbxp_dbhome' 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/app/12.1.0.2/grid'.

Detach Oracle home '/u01/app/oracle/product/12.1.0.2/oradbxp_dbhome' from the central inventory on the remote nodes 'ctsddbadm03,ctsddbadm02' : Done

Delete directory '/u01/app/oracle/product/12.1.0.2/oradbxp_dbhome' on the remote nodes 'ctsddbadm02,ctsddbadm03' : Done

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

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

Oracle Universal Installer cleanup was successful.

Oracle Universal Installer clean END


## [START] Oracle install clean ##

Clean install operation removing temporary directory '/tmp/deinstall2017-11-29_03-56-52PM' on node 'myexa01'
Clean install operation removing temporary directory '/tmp/deinstall2017-11-29_03-56-52PM' on node 'ctsddbadm02,ctsddbadm03'

## [END] Oracle install clean ##


######################### DEINSTALL CLEAN OPERATION END #########################


####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/u01/app/oracle/product/12.1.0.2/oradbxp_dbhome' from the central inventory on the local node.
Successfully deleted directory '/u01/app/oracle/product/12.1.0.2/oradbxp_dbhome' on the local node.
Successfully detached Oracle home '/u01/app/oracle/product/12.1.0.2/oradbxp_dbhome' from the central inventory on the remote nodes 'ctsddbadm03,ctsddbadm02'.
Successfully deleted directory '/u01/app/oracle/product/12.1.0.2/oradbxp_dbhome' on the remote nodes 'ctsddbadm02,ctsddbadm03'.
Oracle Universal Installer cleanup was successful.

Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################


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

[oradbxp@myexa01 database]$

[oradbxp@myexa01 database]$