Question : Can I deinstall old ORACLE_HOME even if old ORACLE_HOME already detached from lsinventory ?
It seems old ORACLE_HOME has been only detached when upgrading to 12c and 11g's directory and files are still left..
So I want to deinstall but also want to check if there's any issue or concerns when I execute deinstall command in this situation.
Such as deinstall tool delete my current 12c home ..! I'm really nervous about this.. (because when I deinstall old home on DEV, all listeners processes stopped unexpectedly.. so I'm really worried about deinstall command)
Could you check and give me some comment about my 'deinstall -checkonly' log, 'opatch lsinventory -all' and response file..and deinstall command which will be used at deinstall time?
Thank you in advance...!
Question Details :
I have 2 oracle home(11g and 12c) and I'm about to remove old ORACLE_HOME on my PROD environment.
old HOME : /u01/ORACLE/baseDB/product/11.2.0.4/homeDB
current HOME : /u01/ORACLE/baseDB/product/12.1.0.2/homeDB
So I was about to get parameter file(response file) and it gave me following unexpected messages.
> cd /u01/ORACLE/baseDB/product/11.2.0.4/homeDB/deinstall
> ./deinstall -checkonly
######################### 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
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]
So I checked PROD lsinventory and result seems 11.2.0.4 ORACLE_HOME already has been detached.. (but relevant files are still left in directory)
> /u01/ORACLE/baseDB/product/11.2.0.4/homeDB/OPatch/opatch lsinventor y -all
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/ORACLE/baseDB/product/12.1.0.2/homeDB
Central Inventory : /u01/ORACLE/oraInventory
from : /u01/ORACLE/baseDB/product/12.1.0.2/homeDB/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 12.1.0.2.0
Log file location : /u01/ORACLE/baseDB/product/12.1.0.2/homeDB/cfgtoollogs/opatch/opatch2017-02-21_16-09-33PM_1.log
Lsinventory Output file location : /u01/ORACLE/baseDB/product/12.1.0.2/homeDB/cfgtoollogs/opatch/lsinv/lsinventory2017-02-21_16-09-33PM.txt
List of Oracle Homes:
Name Location
agent12c1 /u01/ORACLE/baseDB/agent/core/12.1.0.5.0
sbin12c1 /u01/ORACLE/baseDB/agent/sbin
OraHome1 /u01/ORACLE/baseDB/agent/plugins/oracle.sysman.xa.discovery.plugin_12.1.0.6.0
OraHome2 /u01/ORACLE/baseDB/agent/plugins/oracle.sysman.db.discovery.plugin_12.1.0.8.0
OraHome3 /u01/ORACLE/baseDB/agent/plugins/oracle.sysman.emas.discovery.plugin_12.1.0.8.0
OraHome4 /u01/ORACLE/baseDB/agent/plugins/oracle.sysman.oh.discovery.plugin_12.1.0.5.0
OraHome5 /u01/ORACLE/baseDB/agent/plugins/oracle.sysman.oh.agent.plugin_12.1.0.5.0
OraHome6 /u01/ORACLE/baseDB/agent/plugins/oracle.sysman.db.agent.plugin_12.1.0.8.0
OraDB12Home1 /u01/ORACLE/baseDB/product/12.1.0.2/homeDB
OraHome7 /u01/ORACLE/baseDB/agent/plugins/oracle.db.ott.discovery.plugin_12.1.0.3.0
OraHome8 /u01/ORACLE/baseDB/agent/plugins/oracle.db.ott.agent.plugin_12.1.0.3.0
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (3) :
...
and there's log file as following.. I don't know why 11.2.0.4 has been detached when upgrading.
> cd /u01/ORACLE/oraInventory/logs
> find . -name "*Detach*"| xargs grep -n "11.2.0.4"|more
/DetachHome2015-10-07_04-57-55PM.log:36:INFO: ORACLE_HOME = /u01/ORACLE/baseDB/product/11.2.0.4/ho
meDB
So currently my plan is to deinstall by the response file and command as below.
> ./deinstall -paramfile /home/oracle/deinstall_dtrpl_11g.rsp
ORACLE_HOME=/u01/ORACLE/baseDB/product/11.2.0.4/homeDB
NETCA_LOCAL_LISTENERS=LISTENER_EXP,LISTENER_DB,LISTENER_AP
LOGDIR=/u01/ORACLE/oraInventory/logs/
ObaseCleanupPtrLoc=/tmp/deinstall2017-02-21_04-18-01PM/utl/orabase_cleanup.lst
ORACLE_BASE=
INVENTORY_LOCATION=/u01/ORACLE/oraInventory
DB_UNIQUE_NAME_LIST=
HOME_TYPE=SIDB
CRS_HOME=false
ORACLE_BINARY_OK=true
LOCAL_NODE=dtrpl109
local=false
inst_group=oracle
inventory_loc=/u01/ORACLE/oraInventory
MinimumSupportedVersion=11.2.0.1.0
silent=false
CCR_CONFIG_STATUS=CCR_DEL_HOME
ORACLE_HOME=/u01/ORACLE/baseDB/product/11.2.0.4/homeDB
ORACLE_HOME_VERSION_VALID=true