Oracle deinstall of one Oracle Home on OEL removes multiple Oracle Homes
Hi,
Hopefully the 'installation' forum is appropriate for me to ask a question about Oracle deinstallation.
We are running multiple Oracle homes on an OEL 5.3 Box.
Oracle Base:
/sv/app/xps_ora
We have multiple Oracle Homes on this box. They are located under the /sv/app/xps_ora/product/11.2.0 directory. Note that the Oracle Home is a subdirectory of Oracle Base. I am not entirely sure if this is technically correct or not. For what it's worth, this is the way we've always had it set up on several different OS's and Oracle versions, and we've never run into problems. The example given in this 11.2.0 Oracle Document has the Oracle Home as underneath the Oracle Base. http://download.oracle.com/docs/cd/E11857_01/em.111/e12255/oui2_manage_oracle_homes.htm#autoId1
/sv/app/xps_ora/product/11.2.0
drwxr-xr-x 6 xps_ora xps_ora 4096 Mar 30 11:22 .
drwxrwxr-x 28 xps_ora xps_ora 4096 Jun 1 08:16 ..
drwxrwxr-x 86 xps_ora xps_ora 4096 May 31 15:14 11.1.0
drwxr-xr-x 75 xps_ora xps_ora 4096 May 31 14:59 11.1.0.asm
drwxrwxr-x 77 xps_ora xps_ora 4096 May 31 14:47 11.2.0
drwxrwxr-x 76 xps_ora xps_ora 4096 May 31 15:23 11.2.0.2
Yesterday, I went to deinstall the 11.2.0 Oracle home, as it was on 11.2.0.1 and we have a new, working 11.2.0.2 Oracle homes.
Normally to remove Oracle homes, I have been running /sv/app/xps_ora/product/11.2.0/oui/bin/runInstaller. However, in the last week I have removed Oracle 11.2.0 homes on AIX and HP boxes and the installer has told me to go and run the $ORACLE_HOME/deinstall/deinsstall command. I think this is new in 11.2.0.x.
Please note that the AIX and HP boxes that I ran the /sv/app/xps_ora/product/11.2.0/deinstall/deinstall command on also had multiple oracle homes, and I did NOT experience the behaviour detailed below.
I made sure my Oracle Home was set to /sv/app/xps_ora/product/11.2.0 (not sure if I even had to), and then ran /sv/app/xps_ora/product/11.2.0/deinstall/deinstall command. This is exactly what I've done for the other Oracle homes I deinstalled on AIX/HP boxes.
I entered through all the prompts and left the operation to run in the background. Imagine my horror when I was contacted by a system tester about half an hour later, who was unable to log into an Oracle database I soon realised that the deinstall command had removed every single file underneath the Oracle Base directory - i.e. underneath /sv/app/xps_ora. This included the 3 other oracle homes on the box.
Fortunately we were able to restore from backup and only lost 3 hours of work. However, myself, the system testers, and the developers on the box are not exactly thrilled with this situation.
So, can somebody please advise me, does this sound like expected behaviour? Has anybody else experienced something similar? Can you think of anything that we might have set somewhere that is causing Oracle to do this? Is this our fault for installing Oracle Home under the Oracle Base? I think that if I had the Oracle Base as another directory specified elsewhere, the deinstall would still try and remove everything under Oracle Base, which still means that common files for other Oracle Homes would have been lost.
Also I'm putting this up in case anybody else has had the same problem, and also as a word of warning to people that have similiar setups on OEL/RHEL boxes. From now on I'm just going to manually remove the directory, and then manually detach the Oracle Home from the inventory.
I've pasted the output of the deinstall command at the bottom of this issue. I must admit, the line about ORACLE_BASE does look a bit suspicious:
Oracle Home type selected for de-install is: SIDB
Oracle Base selected for de-install is: /sv/app/xps_ora
Having said that, I have checked the output of the deinstall command on our other servers where I ran the deinstall command (where it didn't blow away my entire Oracle directory structure), and it also had the same line. I don't think it actually means 'de-install the whole oracle base', rather it means 'this is the oracle base of the oracle home selected'. The rest of the output is pretty specific that it's going to blow away the selected Oracle Home. You can see that it deletes the 11.2.0 Oracle Home successfully, and then it gets a bit carried away after that.
$ export ORACLE_HOME=/sv/app/xps_ora/product/11.2.0
xps_ora.kaluta> (/sv/app/xps_ora/product/11.2.0/deinstall)
$ ./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /u01/sv/app/xps_ora/logs/
############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################## CHECK OPERATION START ########################
Install check configuration START
Checking for existence of the Oracle home location /sv/app/xps_ora/product/11.2.0
Oracle Home type selected for de-install is: SIDB
Oracle Base selected for de-install is: /sv/app/xps_ora
Checking for existence of central inventory location /u01/sv/app/xps_ora
Install check configuration END
Network Configuration check config START
Network de-configuration trace file location: /u01/sv/app/xps_ora/logs/netdc_check155537276460637868.log
Network Configuration check config END
Database Check Configuration START
Database de-configuration trace file location: /u01/sv/app/xps_ora/logs/databasedc_check1480396078610984645.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
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /u01/sv/app/xps_ora/logs/emcadc_check.log
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : /u01/sv/app/xps_ora/logs//ocm_check4757.log
Oracle Configuration Manager check END
######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
Oracle Home selected for de-install is: /sv/app/xps_ora/product/11.2.0
Inventory Location where the Oracle home registered is: /u01/sv/app/xps_ora
No Enterprise Manager configuration to be updated for any database(s)
No Enterprise Manager ASM targets to update
No Enterprise Manager listener targets to migrate
Checking the config status for CCR
Oracle Home exists and CCR is 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/sv/app/xps_ora/logs/deinstall_deconfig2011-05-31_01-18-42-PM.out'
Any error messages from this session will be written to: '/u01/sv/app/xps_ora/logs/deinstall_deconfig2011-05-31_01-18-42-PM.err'
######################## CLEAN OPERATION START ########################
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /u01/sv/app/xps_ora/logs/emcadc_clean.log
Updating Enterprise Manager ASM targets (if any)
Updating Enterprise Manager listener targets (if any)
Enterprise Manager Configuration Assistant END
Database de-configuration trace file location: /u01/sv/app/xps_ora/logs/databasedc_clean5463829418225685448.log
Network Configuration clean config START
Network de-configuration trace file location: /u01/sv/app/xps_ora/logs/netdc_clean195290591039788342.log
De-configuring Listener configuration file...
Listener 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 : /u01/sv/app/xps_ora/logs//ocm_clean4757.log
Oracle Configuration Manager clean END
Oracle Universal Installer clean START
Detach Oracle home '/sv/app/xps_ora/product/11.2.0' from the central inventory on the local node : Done
Delete directory '/sv/app/xps_ora/product/11.2.0' on the local node : Done
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/metadata/INC_METER_PK_IMPTS.ams'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/metadata/ADR_INVALIDATION.ams'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/metadata/INC_METER_IMPT_DEF.ams'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/metadata/ADR_CONTROL.ams'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/metadata'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/alert/log.xml'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/alert'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/stage'. The directory is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/cdump'. The directory is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/sweep'. The directory is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/incident'. The directory is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/lck/AM_1096102193_3488045378.lck'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/lck/AM_1744845641_3861997533.lck'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/lck/AM_1096102262_3454819329.lck'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/lck/AM_3216668543_3129272988.lck'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/lck'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/trace/sqlnet.log'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/trace'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/metadata_dgif'. The directory is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/incpkg'. The directory is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80/metadata_pv'. The directory is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1/host_1565851746_80'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_upg800p1'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst700b6/host_1565851746_76/incident/incdir_9/ora_22870_47972364481600_i9.trc'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst700b6/host_1565851746_76/incident/incdir_9/ora_22870_47972364481600_i9.trm'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst700b6/host_1565851746_76/incident/incdir_9'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst700b6/host_1565851746_76/incident/incdir_17/ora_22789_47313628230720_i17.trc'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst700b6/host_1565851746_76/incident/incdir_17/ora_22789_47313628230720_i17.trm'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst700b6/host_1565851746_76/incident/incdir_17'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst700b6/host_1565851746_76/incident'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst700b6/host_1565851746_76'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst700b6'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_145/ora_17934_47814947172608_i145.trm'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_145/ora_17934_47814947172608_i145.trc'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_145'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_97/ora_13941_47760252426672_i97.trm'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_97/ora_13941_47760252426672_i97.trc'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_97'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_161/ora_18134_47986149163264_i161.trm'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_161/ora_18134_47986149163264_i161.trc'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_161'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_137/ora_17614_46928200474880_i137.trc'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_137/ora_17614_46928200474880_i137.trm'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_137'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_169/ora_18133_47189922169088_i169.trm'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_169/ora_18133_47189922169088_i169.trc'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_169'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_121/ora_10998_47765027449264_i121.trm'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_121/ora_10998_47765027449264_i121.trc'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_121'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_105/ora_13943_47207839336880_i105.trm'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_105/ora_13943_47207839336880_i105.trc'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_105'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_153/ora_18138_47584516591872_i153.trc'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_153/ora_18138_47584516591872_i153.trm'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_153'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_129/ora_17617_47034248712448_i129.trm'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_129/ora_17617_47034248712448_i129.trc'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_129'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_113/ora_10997_47485973367216_i113.trc'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_113/ora_10997_47485973367216_i113.trm'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident/incdir_113'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76/incident'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4/host_1565851746_76'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/diag/clients/user_tst800b4'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/diag/clients'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/diag'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/product/11.1.0.asm/rdbms/filemap/log'. The directory is in use.
Failed to delete the file '/sv/app/xps_ora/product/11.1.0.asm/rdbms/filemap/etc/filemap.ora'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/product/11.1.0.asm/rdbms/filemap/etc'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/product/11.1.0.asm/rdbms/filemap/bin/fmputl'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/product/11.1.0.asm/rdbms/filemap/bin/fmputlhp'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/product/11.1.0.asm/rdbms/filemap/bin'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/product/11.1.0.asm/log/kaluta/diskmon/diskmonOUT.log'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/product/11.1.0.asm/log/kaluta/diskmon'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/product/11.1.0.asm/log/kaluta'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/product/11.1.0.asm/log'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/product/11.1.0.asm'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/product/11.1.0/rdbms/filemap/log'. The directory is in use.
Failed to delete the file '/sv/app/xps_ora/product/11.1.0/rdbms/filemap/etc/filemap.ora'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/product/11.1.0/rdbms/filemap/etc'. The directory is not empty.
Failed to delete the file '/sv/app/xps_ora/product/11.1.0/rdbms/filemap/bin/fmputl'. The file is in use.
Failed to delete the file '/sv/app/xps_ora/product/11.1.0/rdbms/filemap/bin/fmputlhp'. The file is in use.
Failed to delete the directory '/sv/app/xps_ora/product/11.1.0/rdbms/filemap/bin'. The directory is not empty.
Failed to delete the directory '/sv/app/xps_ora/product'. The directory is not empty.
The Oracle Base directory '/sv/app/xps_ora' will not be removed on local node. The directory is not empty.
Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END
Oracle install clean START
Clean install operation removing temporary directory '/tmp/install' on node 'kaluta'
Oracle install clean END
######################### CLEAN OPERATION END #########################
####################### CLEAN OPERATION SUMMARY #######################
Cleaning the config for CCR
Cleaning the CCR configuration by executing its binaries
CCR clean is finished
Successfully detached Oracle home '/sv/app/xps_ora/product/11.2.0' from the central inventory on the local node.
Successfully deleted directory '/sv/app/xps_ora/product/11.2.0' on the local node.
Oracle Universal Installer cleanup was successful.
Oracle install successfully cleaned up the temporary directories.
#######################################################################
Edited by: user12136669 on 31/05/2011 19:10