It is important to understand that the procedure to uninstall Oracle RDBMS is same as if you uninstalling on non-exadata system. I decided to write this blog to provide some clarity around uninstall process and outlines steps to safely remove RDBMS home from Exadata Machine. There can be a rare situation when you are required to uninstall Oracle RDBMS on EXADATA machine. For example if have upgraded your databases from 11g to 12c and you no longer require old RDBMS software on the Machine.
As per Oracle
“Oracle recommends that you use the deinstallation tool to remove the entire Oracle home associated with the Oracle Database, Oracle Clusterware, Oracle ASM, Oracle RAC, or Oracle Database client installation. Oracle does not support the removal of individual products or components.”
In any case you can use following steps to uninstall RDBMS home from Oracle EXADATA machine.
- Set correct ORACLE_HOME and PATH variable to target database Home.
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export PATH=$PATH:/u01/app/oracle/product/11.2.0/dbhome_1/bin
- Check /etc/oratab for database homes and make sure there are no database running from that home
- Make sure listener is not running from Target RDBMS Home
srvctl config listener -a
- Check if there are no processes running from target ORACLE_HOME and ORACLE_HOME/bin
cd $ORACLE_HOME /sbin/fuser -u * cd $ORACLE_HOME/bin /sbin/fuser -u *
Note : – If there are any processes running from target RDBMS location , you will see following output.
- Backup target RDBMS homes on all Exadata nodes using tar
tar -cvf /Exadata/software/backup_1120_node1 /u01/app/oracle/product/11.2.0
- Change to $ORACLE_HOME/deinstall and deinstall utility
cd $ORACLE_HOME/deinstall ./deinstall -o /XXXXXXXX/software/
- Remove leftover directory using rmdir