Friday, December 23, 2016

Oracle Database 12c Silent Installation

Oracle Database 12c Silent Installation



Step 1    Prerequisites
Step 2    Assumption for Installation.
Step 3    Run installar in silent mode.
Step 4    Assumption for Database Creation.
Step 5    Run dbca in silent mode.
Step 6    Crosscheck Database Installation.



Step 1    Prerequisites

Create directory structure for following locations using root

INVENTORY_LOCATION = /mnt/devops_0/OracleSilent/oraInventory
ORACLE_HOME =/mnt/devops_0/OracleSilent/Oracle/Product/12.1.0.2/db_1
ORACLE_BASE =/mnt/devops_0/OracleSilent/Oracle

Change ownership to user db1212

$ chown -R db1212:oinstall OracleSilent/



Step 2    Assumption for Installation.

If one need to change following parameters kindly edit db_Software_Install.rsp

Parameter
Values
Remarks
InstallEdition
EE
EnterpriseEdition
oracle.install.option
INSTALL_DB_SWONLY
Install Software only
DBA_GROUP
dba
Group Information
OPER_GROUP
dba
BACKUPDBA_GROUP
dba
DGDBA_GROUP
dba
KMDBA_GROUP
dba
LANGUAGE
EN
English
DECLINE_SECURITY_UPDATES
Yes

SECURITY_UPDATES_VIA_MYORACLESUPPORT
False


Below is the sample output of db_software_install.rsp file.

#-------------------------------------------------------------------------------
# Specify the installation option.
# It can be one of the following:
#   - INSTALL_DB_SWONLY
#   - INSTALL_DB_AND_CONFIG
#   - UPGRADE_DB
#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY

#-------------------------------------------------------------------------------
# Specify the hostname of the system as set during the install. It can be used
# to force the installation to use an alternative hostname rather than using the
# first hostname found on the system. (e.g., for systems with multiple hostnames
# and network interfaces)
#-------------------------------------------------------------------------------
ORACLE_HOSTNAME=

#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory. 
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall

#-------------------------------------------------------------------------------
# Specify the languages in which the components will be installed.            
#
# en   : English                  ja   : Japanese                 
# fr   : French                   ko   : Korean                   
# ar   : Arabic                   es   : Latin American Spanish   
# bn   : Bengali                  lv   : Latvian                  
# pt_BR: Brazilian Portuguese     lt   : Lithuanian               
# bg   : Bulgarian                ms   : Malay                    
# fr_CA: Canadian French          es_MX: Mexican Spanish          
# ca   : Catalan                  no   : Norwegian                
# hr   : Croatian                 pl   : Polish                   
# cs   : Czech                    pt   : Portuguese               
# da   : Danish                   ro   : Romanian                 
# nl   : Dutch                    ru   : Russian                  
# ar_EG: Egyptian                 zh_CN: Simplified Chinese       
# en_GB: English (Great Britain)  sk   : Slovak                   
# et   : Estonian                 sl   : Slovenian                
# fi   : Finnish                  es_ES: Spanish                  
# de   : German                   sv   : Swedish                  
# el   : Greek                    th   : Thai                     
# iw   : Hebrew                   zh_TW: Traditional Chinese      
# hu   : Hungarian                tr   : Turkish                  
# is   : Icelandic                uk   : Ukrainian                
# in   : Indonesian               vi   : Vietnamese               
# it   : Italian                                                  
#
# all_langs   : All languages
#
# Specify value as the following to select any of the languages.
# Example : SELECTED_LANGUAGES=en,fr,ja
#
# Specify value as the following to select all the languages.
# Example : SELECTED_LANGUAGES=all_langs 
#-------------------------------------------------------------------------------
SELECTED_LANGUAGES=en

#-------------------------------------------------------------------------------
# Specify the installation edition of the component.                    
#                                                            
# The value should contain only one of these choices. 
#   - EE     : Enterprise Edition

#-------------------------------------------------------------------------------
oracle.install.db.InstallEdition=EE

#------------------------------------------------------------------------------
# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
#-------------------------------------------------------------------------------
oracle.install.db.DBA_GROUP=dba

#------------------------------------------------------------------------------
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
# The value to be specified for OSOPER group is optional.
#------------------------------------------------------------------------------
oracle.install.db.OPER_GROUP=dba

#------------------------------------------------------------------------------
# The BACKUPDBA_GROUP is the OS group which is to be granted OSBACKUPDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.BACKUPDBA_GROUP=dba

#------------------------------------------------------------------------------
# The DGDBA_GROUP is the OS group which is to be granted OSDGDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.DGDBA_GROUP=dba

#------------------------------------------------------------------------------
# The KMDBA_GROUP is the OS group which is to be granted OSKMDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.KMDBA_GROUP=dba

#------------------------------------------------------------------------------
# Specify whether to enable the user to set the password for
# My Oracle Support credentials. The value can be either true or false.
# If left blank it will be assumed to be false.
#
# Example    : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true
#------------------------------------------------------------------------------
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

#------------------------------------------------------------------------------
# Specify whether user doesn't want to configure Security Updates.
# The value for this variable should be true if you don't want to configure
# Security Updates, false otherwise.
#
# The value can be either true or false. If left blank it will be assumed
# to be false.
#
# Example    : DECLINE_SECURITY_UPDATES=false
#------------------------------------------------------------------------------
DECLINE_SECURITY_UPDATES=true



Step 3    Run installar in silent mode.

 Go to Installar directory
-bash-4.1$ pwd
/mnt/devops_0/Installables/database

Run below command

$ ./runInstaller -silent -responseFile /mnt/devops_0/dba/db1212/db_Software_Install.rsp INVENTORY_LOCATION=/mnt/devops_0/OracleSilent/oraInventory ORACLE_HOME=/mnt/devops_0/OracleSilent/Oracle/product/12.1.0.2/db_1 ORACLE_BASE=/mnt/devops_0/OracleSilent/Oracle


Step 4    Assumption for Database Creation.

 If one need to change following parameters kindly edit dbca.rsp


Parameter
Values
Remarks
OPERATION_TYPE
createDatabase

DATABASECONFTYPE
SI
Single Instance
CREATEASCONTAINERDATABASE
false
Container Database
CHARACTERSET
AL32UTF8

NATIONALCHARACTERSET
AL16UTF16

DATABASETYPE
MULTIPURPOSE

AUTOMATICMEMORYMANAGEMENT
TRUE

STORAGETYPE
FS

LISTENERS
(It will configure with all listerner if exists otherwise create one)


SAMPLESCHEMA
False



Below is the listing of dbca.rsp

 #-----------------------------------------------------------------------------
# GENERAL section is required for all types of database creations.
#-----------------------------------------------------------------------------
[GENERAL]

#-----------------------------------------------------------------------------
# Name          : RESPONSEFILE_VERSION
# Datatype      : String
# Description   : Version of the database to create
# Valid values  : "12.1.0"
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
RESPONSEFILE_VERSION = "12.1.0"

#-----------------------------------------------------------------------------
# Name          : OPERATION_TYPE
# Datatype      : String
# Description   : Type of operation
# Valid values  : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only) \ "createPluggableDatabase" \ "unplugDatabase" \ "deletePluggableDatabase" \ "configurePluggableDatabase"
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
OPERATION_TYPE = "createDatabase"

#-----------------------*** End of GENERAL section ***------------------------

#-----------------------------------------------------------------------------
# CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase".
#-----------------------------------------------------------------------------
[CREATEDATABASE]

#-----------------------------------------------------------------------------
# Name          : GDBNAME
# Datatype      : String
# Description   : Global database name of the database
# Valid values  : . - when database domain isn't NULL
#                              - when database domain is NULL
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
GDBNAME = "orcl12c.in.myora.com"

#-----------------------------------------------------------------------------
# Name          : DATABASECONFTYPE
# Datatype      : String
# Description   : database conf type as Single Instance, Real Application Cluster or Real Application Cluster One Nodes database
# Valid values  : SI\RAC\RACONENODE
# Default value : SI
# Mandatory     : No
#-----------------------------------------------------------------------------
DATABASECONFTYPE  = "SI"

#-----------------------------------------------------------------------------
# Name          : SID
# Datatype      : String
# Description   : System identifier (SID) of the database
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : specified in GDBNAME
# Mandatory     : No
#-----------------------------------------------------------------------------
SID = "orcl12c"

#-----------------------------------------------------------------------------
# Name          : CREATEASCONTAINERDATABASE
# Datatype      : boolean
# Description   : flag to create database as container database
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : false
# Mandatory     : No
#-----------------------------------------------------------------------------
CREATEASCONTAINERDATABASE =false

#-----------------------------------------------------------------------------
# Name          : TEMPLATENAME
# Datatype      : String
# Description   : Name of the template
# Valid values  : Template file name
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
TEMPLATENAME = "General_Purpose.dbc"

#-----------------------------------------------------------------------------
# Name          : STORAGETYPE
# Datatype      : String
# Description   : Specifies the storage on which the database is to be created
# Valid values  : FS (CFS for RAC), ASM
# Default value : FS
# Mandatory     : No
#-----------------------------------------------------------------------------
STORAGETYPE=FS

#-----------------------------------------------------------------------------
# Name          : CHARACTERSET
# Datatype      : String
# Description   : Character set of the database
# Valid values  : Check Oracle12c National Language Support Guide
# Default value : "US7ASCII"
# Mandatory     : NO
#-----------------------------------------------------------------------------
CHARACTERSET = "AL32UTF8"

#-----------------------------------------------------------------------------
# Name          : NATIONALCHARACTERSET
# Datatype      : String
# Description   : National Character set of the database
# Valid values  : "UTF8" or "AL16UTF16". For details, check Oracle12c National Language Support Guide
# Default value : "AL16UTF16"
# Mandatory     : No
#-----------------------------------------------------------------------------
NATIONALCHARACTERSET= "AL16UTF16"



Step 5    Run dbca in silent mode.

 Following parameter must be provided manually for silent installation.
  • gdbname
  • sid
  • datafileDestination
  • SysPassword
  • SystemPassword
  • emConfiguration
  • memoryPercentage
$ dbca -silent -responseFile /mnt/devops_0/dba/db1212/dbca.rsp -createDatabase -gdbname oraslnt -sid oraslnt   -emConfiguration LOCAL -datafileDestination /mnt/devops_0/OracleSilent/Oracle/oradata/oraslnt -SysPassword sysdba123  -SystemPassword sysdba123 -memoryPercentage 10

Below is the sample output of above command.

$ export ORACLE_HOME =/mnt/devops_0/OracleSilent/Oracle/Product/12.1.0.2/db_1

-bash-4.1$ dbca -silent -responseFile /mnt/devops_0/dba/db1212/dbca.rsp -createDatabase -gdbname oraslnt -sid oraslnt   -emConfiguration LOCAL -datafileDestination /mnt/devops_0/OracleSilent/Oracle/oradata/oraslnt -SysPassword sysdba123  -SystemPassword sysdba123
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/mnt/devops_0/Oracle/cfgtoollogs/dbca/oraslnt/oraslnt.log" for further details.


Step 6    Crosscheck Database Installation.

-bash-4.1$ export ORACLE_SID=oraslnt
-bash-4.1$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 15 11:36:01 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name, open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
ORASLNT   READ WRITE


SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/mnt/devops_0/OracleSilent/Oracle/oradata/oraslnt/oraslnt/system01.dbf
/mnt/devops_0/OracleSilent/Oracle/oradata/oraslnt/oraslnt/sysaux01.dbf
/mnt/devops_0/OracleSilent/Oracle/oradata/oraslnt/oraslnt/undotbs01.dbf
/mnt/devops_0/OracleSilent/Oracle/oradata/oraslnt/oraslnt/users01.dbf


SQL> select member from v$logfile;

MEMBER
----------------------------------------------------------------------------------------------------
/mnt/devops_0/OracleSilent/Oracle/oradata/oraslnt/oraslnt/redo03.log
/mnt/devops_0/OracleSilent/Oracle/oradata/oraslnt/oraslnt/redo02.log
/mnt/devops_0/OracleSilent/Oracle/oradata/oraslnt/oraslnt/redo01.log




Thanks & Regards,
Chandan Tanwani
Oracle Performance Tuning Certified Expert
 

Thursday, December 15, 2016

Deinstall Oracle Database 12c with all PDBs

Deinstall Oracle Database 12c with all PDBs


Here, i am listing how to deinstall oracle database 12c and all PDBs which are connected to the same CDB.



Step 1: Export ORACLE_HOME & PATH

bash-4.1$ export ORACLE_HOME=/mnt/Oracle/product/12.1.0.2/db_1
bash-4.1$ export PATH=$ORACLE_HOME/bin:$PATH
bash-4.1$ cd $ORACLE_HOME
bash-4.1$ cd bin


Go to the deinstall directory.

bash-4.1$ pwd
/mnt/Oracle/product/12.1.0.2/db_1/deinstall


Step 2: Run deinstall.sh, Below is the full listing of how deinstall process run through.
I have highlighted few parts in bold which needs user input and require more attention during deinstall process.


bash-4.1$ pwd
/mnt/Oracle/product/12.1.0.2/db_1/deinstall

bash-4.1$ ./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /tmp/deinstall2016-06-08_11-09-08AM/logs/

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

The product version number of the specified home cannot be determined. Is the product version 12.1.0.2.0 (y - yes, n - no)? [n]y

######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##
The deinstall tool cannot determine the home type needed to deconfigure the selected home.  Please select the type of Oracle home you are trying to deinstall.
Single Instance database - Enter 1
Real Application Cluster database - Enter 2
Grid Infrastructure for a cluster - Enter 3
Grid Infrastructure for a stand-alone server - Enter 4
Client Oracle Home - Enter 5
Transparent Gateways Oracle Home - Enter 6
GSM Oracle Home - Enter 7
1
The product version number of the specified home cannot be determined. Is the product version at least 11.2.0.1.0 (y - yes, n - no)? [n]
y



Checking for existence of the Oracle home location /mnt/Oracle/product/12.1.0.2/db_1
Oracle Home type selected for deinstall is: Oracle Single Instance Database
Oracle Base selected for deinstall is:
Checking for existence of central inventory location /mnt/Oracle/oraInventory

## [END] Install check configuration ##


Network Configuration check config START
Network de-configuration trace file location: /tmp/deinstall2016-06-08_11-09-08AM/logs/netdc_check2016-06-08_11-27-01-AM.log

Specify all Single Instance listeners that are to be de-configured. Enter .(dot) to deselect all. [LISTENERORCLNEW,LISTENER]:
Network Configuration check config END
Database Check Configuration START

Database de-configuration trace file location: /tmp/deinstall2016-06-08_11-09-08AM/logs/databasedc_check2016-06-08_11-27-11-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 [orcl12c,orclnew,orclchan]:

###### For Database 'orclnew' ######

Single Instance Database
The diagnostic destination location of the database: /mnt/Oracle/diag/rdbms/orclnew
Storage type used by the Database: FS
Database file location: /mnt/OrclNew/oradata/orclnew,/mnt/OrclNew/fast_recovery_area/orclnew
Fast recovery area location: /mnt/OrclNew/fast_recovery_area/ORCLNEW
database spfile location: /mnt/Oracle/product/12.1.0.2/db_1/dbs/spfileorclnew.ora

###### For Database 'orclchan' ######

Single Instance Database
The diagnostic destination location of the database: /mnt/Oracle/diag/rdbms/orclchan
Storage type used by the Database: FS
Database file location: /mnt/OrclChan/oradata/orclchan,/mnt/OrclChan/fast_recovery_area/orclchan
Fast recovery area location: /mnt/OrclChan/fast_recovery_area/ORCLCHAN
database spfile location: /mnt/Oracle/product/12.1.0.2/db_1/dbs/spfileorclchan.ora

The details of database(s) orclnew,orclchan have been discovered automatically. For database(s) orcl12c details will be prompted for confirmation. Do you still want to modify the details of orclnew,orclchan database(s)? [n]: y


###### For Database 'orcl12c' ######

Specify the type of this database (1.Single Instance Database|2.Oracle Restart Enabled Database) [1]: 1
Specify the diagnostic destination location of the database [/mnt/Oracle/diag/rdbms/orcl12c]:
Specify the storage type used by the Database ASM|FS []: FS

Specify the list of directories if any database files exist on a shared file system. If 'orcl12c' subdirectory is found, then it will be deleted. Otherwise, the specified directory will be deleted. Alternatively, you can specify list of database files with full path [ ]:

Specify the fast recovery area location, if it is configured on the file system. If 'orcl12c' subdirectory is found, then it will be deleted. []:

Specify the database spfile location [ ]:


###### For Database 'orclnew' ######

Specify the type of this database (1.Single Instance Database|2.Oracle Restart Enabled Database) [1]:
Specify the diagnostic destination location of the database [/mnt/Oracle/diag/rdbms/orclnew]:
Specify the storage type used by the Database ASM|FS [FS]:

Specify the list of directories if any database files exist on a shared file system. If 'orclnew' subdirectory is found, then it will be deleted. Otherwise, the specified directory will be deleted. Alternatively, you can specify list of database files with full path [/mnt/OrclNew/oradata/orclnew,/mnt/OrclNew/fast_recovery_area/orclnew]:

Specify the fast recovery area location, if it is configured on the file system. If 'orclnew' subdirectory is found, then it will be deleted. [/mnt/OrclNew/fast_recovery_area/ORCLNEW]:

Specify the database spfile location [/mnt/Oracle/product/12.1.0.2/db_1/dbs/spfileorclnew.ora]:


###### For Database 'orclchan' ######

Specify the type of this database (1.Single Instance Database|2.Oracle Restart Enabled Database) [1]:
Specify the diagnostic destination location of the database [/mnt/Oracle/diag/rdbms/orclchan]:
Specify the storage type used by the Database ASM|FS [FS]:

Specify the list of directories if any database files exist on a shared file system. If 'orclchan' subdirectory is found, then it will be deleted. Otherwise, the specified directory will be deleted. Alternatively, you can specify list of database files with full path [/mnt/OrclChan/oradata/orclchan,/mnt/OrclChan/fast_recovery_area/orclchan]:

Specify the fast recovery area location, if it is configured on the file system. If 'orclchan' subdirectory is found, then it will be deleted. [/mnt/OrclChan/fast_recovery_area/ORCLCHAN]:

Specify the database spfile location [/mnt/Oracle/product/12.1.0.2/db_1/dbs/spfileorclchan.ora]:

Database Check Configuration END
Oracle Configuration Manager check START
OCM check log file location : /tmp/deinstall2016-06-08_11-09-08AM/logs//ocm_check9495.log
Oracle Configuration Manager check END

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

####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Home selected for deinstall is: /mnt/Oracle/product/12.1.0.2/db_1
Inventory Location where the Oracle home registered is: /mnt/Oracle/oraInventory
Following Single Instance listener(s) will be de-configured: LISTENERORCLNEW,LISTENER
The following databases were selected for de-configuration : orcl12c,orclnew,orclchan
Database unique name : orcl12c
Storage used : FS
Database unique name : orclnew
Storage used : FS
Database unique name : orclchan
Storage used : FS
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: '/tmp/deinstall2016-06-08_11-09-08AM/logs/deinstall_deconfig2016-06-08_11-10-35-AM.out'
Any error messages from this session will be written to: '/tmp/deinstall2016-06-08_11-09-08AM/logs/deinstall_deconfig2016-06-08_11-10-35-AM.err'

######################## DECONFIG CLEAN OPERATION START ########################
Database de-configuration trace file location: /tmp/deinstall2016-06-08_11-09-08AM/logs/databasedc_clean2016-06-08_11-29-24-AM.log
Database Clean Configuration START orcl12c
This operation may take few minutes.
Database Clean Configuration END orcl12c
Database Clean Configuration START orclnew
This operation may take few minutes.
Database Clean Configuration END orclnew
Database Clean Configuration START orclchan
This operation may take few minutes.
Database Clean Configuration END orclchan

Network Configuration clean config START

Network de-configuration trace file location: /tmp/deinstall2016-06-08_11-09-08AM/logs/netdc_clean2016-06-08_11-33-09-AM.log

De-configuring Single Instance listener(s): LISTENERORCLNEW,LISTENER

De-configuring listener: LISTENERORCLNEW
    Stopping listener: LISTENERORCLNEW
    Listener stopped successfully.
    Deleting listener: LISTENERORCLNEW
    Listener deleted successfully.
Listener de-configured successfully.

De-configuring listener: LISTENER
    Stopping listener: LISTENER
    Warning: Failed to stop listener. Listener may not be running.
    Deleting listener: LISTENER
    Listener deleted successfully.
Listener de-configured successfully.

De-configuring Naming Methods configuration file...
Naming Methods configuration file de-configured successfully.

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

De-configuring backup files...
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 : /tmp/deinstall2016-06-08_11-09-08AM/logs//ocm_clean9495.log
Oracle Configuration Manager clean END

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


####################### DECONFIG CLEAN OPERATION SUMMARY #######################
Successfully de-configured the following database instances : orcl12c,orclnew,orclchan
Following Single Instance listener(s) were de-configured successfully: LISTENERORCLNEW,LISTENER
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/deinstall2016-06-08_11-09-08AM/response/deinstall_2016-06-08_11-10-35-AM.rsp
Location of logs /tmp/deinstall2016-06-08_11-09-08AM/logs/

############ ORACLE DEINSTALL TOOL START ############


####################### DEINSTALL CHECK OPERATION SUMMARY #######################
A log of this session will be written to: '/tmp/deinstall2016-06-08_11-09-08AM/logs/deinstall_deconfig2016-06-08_11-10-35-AM.out'
Any error messages from this session will be written to: '/tmp/deinstall2016-06-08_11-09-08AM/logs/deinstall_deconfig2016-06-08_11-10-35-AM.err'

######################## DEINSTALL CLEAN OPERATION START ########################
## [START] Preparing for Deinstall ##
Setting LOCAL_NODE to OraLinuxNode
Setting CRS_HOME to false
Setting oracle.installer.invPtrLoc to /tmp/deinstall2016-06-08_11-09-08AM/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 '/mnt/Oracle/product/12.1.0.2/db_1' from the central inventory on the local node : Done

Failed to delete the directory '/mnt/Oracle/product/12.1.0.2/db_1/bin'. The directory is in use.
Failed to delete the directory '/mnt/Oracle/product/12.1.0.2/db_1/sqlplus/mesg'. The directory is in use.
Failed to delete the directory '/mnt/Oracle/product/12.1.0.2/db_1/sqlplus'. The directory is not empty.
Failed to delete the directory '/mnt/Oracle/product/12.1.0.2/db_1/rdbms/mesg'. The directory is in use.
Failed to delete the directory '/mnt/Oracle/product/12.1.0.2/db_1/rdbms'. The directory is not empty.
Failed to delete the directory '/mnt/Oracle/product/12.1.0.2/db_1/deinstall'. The directory is in use.
Failed to delete the directory '/mnt/Oracle/product/12.1.0.2/db_1/lib'. The directory is in use.
Failed to delete the directory '/mnt/Oracle/product/12.1.0.2/db_1/oracore/zoneinfo'. The directory is in use.
Failed to delete the directory '/mnt/Oracle/product/12.1.0.2/db_1/oracore'. The directory is not empty.
Failed to delete the directory '/mnt/Oracle/product/12.1.0.2/db_1'. The directory is not empty.
Delete directory '/mnt/Oracle/product/12.1.0.2/db_1' on the local node : Failed <<<<

Delete directory '/mnt/Oracle/oraInventory' on the local node : Done
Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END

## [START] Oracle install clean ##

Clean install operation removing temporary directory '/tmp/deinstall2016-06-08_11-09-08AM' on node 'OraLinuxNode'

## [END] Oracle install clean ##


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


####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/mnt/Oracle/product/12.1.0.2/db_1' from the central inventory on the local node.
Failed to delete directory '/mnt/Oracle/product/12.1.0.2/db_1' on the local node.
Successfully deleted directory '/mnt/Oracle/oraInventory' on the local node.
Oracle Universal Installer cleanup was successful.

Run 'rm -r /opt/ORCLfmap' as root on node(s) 'OraLinuxNode' at the end of the session.
Run 'rm -r /etc/oratab' as root on node(s) 'OraLinuxNode' at the end of the session.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################


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

bash-4.1$

#######################################################################
#######################################################################


So, deinstallation completed and all files and folders also deleted except below directories.
/mnt/devops_0/Oracle/db1212/product/12.1.0.2/db_1/deinstall
This is because we have initiated deinstall process from above location hence Oracle cannot delete above directories. We can delete Oracle directory manually once deinstall process completed.



Thanks & Regards,
Chandan Tanwani
Oracle Performance Tuning Certified Expert