Manually delete a DBHOME when Odacli Failed to delete and left a DBHOME state as DELETING (Doc ID 2580460.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

odacli may Fail to delete an Oracle Home  after creating with error

e.g

ERROR
-----------------------


2019-07-24 16:14:01,669 DEBUG [DCSZJsonRequestHandler] [] c.o.d.c.u.CommonsUtils:
run: cmd= '[su,
 -,
 oracle,
 -c,
 export ORACLE_HOME=/u01/app/oracle/product/18.0.0.0/dbhome_1;
 /u01/app/oracle/product/18.0.0.0/dbhome_1/deinstall/deinstall -silent -checkonly]'
2019-07-24 16:14:01,693 DEBUG [DCSZJsonRequestHandler] [] c.o.d.c.u.c.CommandExecutor: Return code: 1
2019-07-24 16:14:01,693 DEBUG [DCSZJsonRequestHandler] [] c.o.d.c.u.CommonsUtils: Output :
ERROR: This Oracle home does not seem to be registered.
Deinstall tool cannot proceed.

2019-07-24 16:14:01,693 ERROR [DCSZJsonRequestHandler] [] c.o.d.a.r.s.d.DbHomeOperations: Failed to run command for response file generation
2019-07-24 16:14:01,693 ERROR [DCSZJsonRequestHandler] [] c.o.d.a.r.s.d.DbHomeActions: Failed to delete dbhome with id : 9cb0fb7f-989d-4c9b-9465-ed6fa52ad976

Then, the DB home will be left as deleting satus :

ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
xxxxxxxxxxx   OraDb12102_home1 12.1.0.2.170814 /u01/app/oracle/product/12.1.0.2/dbhome_1 Configured
xxxxxxxxxxx   OraDb12102_home3 12.1.0.2.170814 /u01/app/oracle/product/12.1.0.2/dbhome_3 Configured
xxxxxxxxxxx   OraDb12102_home4 12.1.0.2.170814 /u01/app/oracle/product/12.1.0.2/dbhome_4 Configured
xxxxxxxxxxx   OraDB18000_home1 18.5.0.0.190115 /u01/app/oracle/product/18.0.0.0/dbhome_1 Deleting <<<<<<<<<<<<<<<<<<<need to cleanup this.
xxxxxxxxxxx   OraDB18000_home2 18.5.0.0.190115 /u01/app/oracle/product/18.0.0.0/dbhome_2 Configured

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.