Gunther Oracle APEX und Datenbank Wiki

Aufgabe

Nach dem OutPlace Patch mit AutoUpgrade ( AutoUpgrade - Oracle Datenbank 19c und höher automatisch patchen siehe kann das alte Oracle Home entfernt werden. Dazu wird mit „deinstall“ das Home und alle Verweise im Inventory darauf gelöscht.

User Oracle Test:

cd $ORACLE_HOME/deinstall
 
./deinstall -checkonly
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /u01/app/oracle/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/19c/dbhome_1
Oracle Home type selected for deinstall is: Oracle Single Instance Database
Oracle Base selected for deinstall is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oracle/oraInventory
ERROR: null

Debuggen über Log Ausgabe in ein Verzeichnis:

cd $ORACLE_HOME/deinstall
 
mkdir /tmp/deinst_log
 
 
./deinstall -checkonly -logdir /tmp/deinst_log
 
 
cd /tmp/deinst_log
ls
deinstall_deconfig2025-07-01_04-29-48-PM.err  deinstall_deconfig2025-07-01_04-29-48-PM.out
 
cat deinstall_deconfig2025-07-01_04-29-48-PM.err
 
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at oracle.install.db.deinstall.wrapper.Deinstall.callCheckImpl(Deinstall.java:1449)
        at oracle.install.db.deinstall.wrapper.Deinstall.main(Deinstall.java:732)
Caused by: java.lang.ExceptionInInitializerError
        at oracle.ops.verification.framework.util.Assert.assertPath(Assert.java:601)
        at oracle.cluster.verification.ClusterVerification.setPreReqXmlFile(ClusterVerification.java:9059)
        at oracle.install.db.deinstall.core.CheckInstall.checkConfig(CheckInstall.java:1083)
        ... 6 more
Caused by: java.lang.NullPointerException
        at oracle.ops.verification.framework.storage.StorageUtil.<clinit>(StorageUtil.java:194)
        ... 9 more

Auf Redhat 9 ist das Tool nicht supported!

Lösung: Verwenden mit „export CV_ASSUME_DISTID=RED8“

export CV_ASSUME_DISTID=RED8
 
./deinstall -checkonly -logdir /tmp/deinst_log
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /tmp/deinst_log/
 
############ ORACLE DECONFIG TOOL START ############
 
 
######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##
 
 
Checking for existence of the Oracle home location /u01/app/oracle/product/19c/dbhome_1
Oracle Home type selected for deinstall is: Oracle Single Instance Database
Oracle Base selected for deinstall is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oracle/oraInventory
 
## [END] Install check configuration ##
 
 
Network Configuration check config START
 
Network de-configuration trace file location: /tmp/deinst_log/netdc_check2025-07-01_04-34-16PM.log
 
Network Configuration check config END
 
Database Check Configuration START
 
Database de-configuration trace file location: /tmp/deinst_log/databasedc_check2025-07-01_04-34-16PM.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
 
######################### DECONFIG CHECK OPERATION END #########################
 
 
####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Home selected for deinstall is: /u01/app/oracle/product/19c/dbhome_1
Inventory Location where the Oracle home registered is: /u01/app/oracle/oraInventory
Location of response file generated: '/tmp/deinstall2025-07-01_04-34-12PM/response/deinstall_OraDB

cd
 
/u01/app/oracle/product/19c/dbhome_1/deinstall/deinstall -checkonly -logdir /tmp/deinst_log -o $PWD
 
# Anworten bestätigen
 
 
Datei ~\deinstall_OraDB19Home1.rsp wird angelegt

cd 
 
 
mkdir /tmp/deinst_log
 
 
/u01/app/oracle/product/19c/dbhome_1/deinstall/deinstall -logdir /tmp/deinst_log -silent -paramfile $PWD/deinstall_OraDB19Home1.rsp
 
 
 
Checking for required files and bootstrapping ...
Please wait ...
Using properties file /home/oracle/deinstall_OraDB19Home1.rsp
Location of logs /tmp/deinst_log/
 
############ ORACLE DECONFIG TOOL START ############
 
 
######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##
 
 
Checking for existence of the Oracle home location /u01/app/oracle/product/19c/dbhome_1
Oracle Home type selected for deinstall is: Oracle Single Instance Database
Oracle Base selected for deinstall is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oracle/oraInventory
 
## [END] Install check configuration ##
 
 
Network Configuration check config START
 
Network de-configuration trace file location: /tmp/deinst_log/netdc_check2025-07-01_04-49-40PM.log
 
Network Configuration check config END
 
Database Check Configuration START
 
Database de-configuration trace file location: /tmp/deinst_log/databasedc_check2025-07-01_04-49-40PM.log
 
Database Check Configuration END
 
######################### DECONFIG CHECK OPERATION END #########################
 
 
####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Home selected for deinstall is: /u01/app/oracle/product/19c/dbhome_1
Inventory Location where the Oracle home registered is: /u01/app/oracle/oraInventory
A log of this session will be written to: '/tmp/deinst_log/deinstall_deconfig2025-07-01_04-49-39-PM.out'
Any error messages from this session will be written to: '/tmp/deinst_log/deinstall_deconfig2025-07-01_04-49-39-PM.err'
 
######################## DECONFIG CLEAN OPERATION START ########################
Database de-configuration trace file location: /tmp/deinst_log/databasedc_clean2025-07-01_04-49-40PM.log
 
Network Configuration clean config START
 
Network de-configuration trace file location: /tmp/deinst_log/netdc_clean2025-07-01_04-49-40PM.log
 
De-configuring backup files...
Backup files de-configured successfully.
 
The network configuration has been cleaned up successfully.
 
Network Configuration clean config END
 
 
######################### DECONFIG CLEAN OPERATION END #########################
 
 
####################### DECONFIG CLEAN OPERATION SUMMARY #######################
#######################################################################
 
 
############# ORACLE DECONFIG TOOL END #############
 
Using properties file /home/oracle/deinstall_OraDB19Home1.rsp
Location of logs /tmp/deinst_log/
 
############ ORACLE DEINSTALL TOOL START ############
 
 
 
 
 
####################### DEINSTALL CHECK OPERATION SUMMARY #######################
A log of this session will be written to: '/tmp/deinst_log/deinstall_deconfig2025-07-01_04-49-39-PM.out'
Any error messages from this session will be written to: '/tmp/deinst_log/deinstall_deconfig2025-07-01_04-49-39-PM.err'
 
######################## DEINSTALL CLEAN OPERATION START ########################
## [START] Preparing for Deinstall ##
Setting LOCAL_NODE to bvmans04
Setting CRS_HOME to false
Setting oracle.installer.invPtrLoc to /tmp/deinstall2025-07-01_04-49-36PM/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/19c/dbhome_1' from the central inventory on the local node : Done
 
Delete directory '/u01/app/oracle/product/19c/dbhome_1' 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/oracle/product/19c/19.24'.
 
The Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is in use by central inventory.
 
Oracle Universal Installer cleanup was successful.
 
Oracle Universal Installer clean END
 
 
## [START] Oracle install clean ##
 
 
## [END] Oracle install clean ##
 
 
######################### DEINSTALL CLEAN OPERATION END #########################
 
 
####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/u01/app/oracle/product/19c/dbhome_1' from the central inventory on the local node.
Successfully deleted directory '/u01/app/oracle/product/19c/dbhome_1' on the local node.
Oracle Universal Installer cleanup was successful.
 
Review the permissions and contents of '/u01/app/oracle' on nodes(s) 'srvgpimans04'.
If there are no Oracle home(s) associated with '/u01/app/oracle', manually delete '/u01/app/oracle' and its contents.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################
 
 
############# ORACLE DEINSTALL TOOL END #############

Oracle:

• https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/oracle-deinstallation-tool-deinstall.html#GUID-71E860C5-4E1E-4D2F-AFD1-141709A172C0