Removing Oracle Database XE from Linux

I haven't blogged for a while as I've been holidaying in Thailand, but I thought it's time to get back into nerding instead of laying on beaches. (Did I just say that?!)

So, first thing I try to do is deinstall one of my Oracle Database XE installs, but I'd done a few things to the file system that made it impossible to remove using the standard deinstall procedure. After searching through the Oracle XE doc, I found this little gem to manually remove XE. I wanted to share it as I've had to do this a couple of times now. The first time I didn't know this trick and had to reinstall the o/s, just before a demo at a conference. It was a tiny bit stressful.

First off, check to see what Oracle RPMs are installed, and try removing them.

rpm -qa | grep oracle

rpm -e oracle-xe-univ

If you get an error here, move on to the next steps to manually remove XE. Remove the XE directories.

rm -Rf /usr/lib/oracle/xe
rm -Rf /etc/oratab
rm -Rf /etc/init.d/oracle-xe
rm -Rf /etc/sysconfig/oracle-xe

Hey presto! Your system no longer has any XE files and you can start again. Like I'm doing right now.

Comments:

thanks, good tips, i would put this in shell script and run it.

Posted by OracleTube.com on February 04, 2008 at 02:08 AM DDUT #

This way you are going to corrupt the RPM repository database and you will have problems later... If you just need to remove XE to reinstall it afterward, you should instead do something like: rpm -e --force --nodeps oracle-xe-univ Good luck!!!

Posted by PaoloM on July 02, 2008 at 11:25 AM DDUT #

I did that and sure it did remove XE from my system.
But when i try to install it again it installs but it won't configure and it hangs on confguring databas..
i guess there is some thing missing?
also when i check
/usr/lib/oracle/xe/oradata/XE
it is empty and there are no data files?
i've checked the internet for an answer and there is no luck

Posted by guest on June 28, 2011 at 02:54 PM DDUT #

also when i try rpm -e --force --nodeps oracle-xe-univ

it gives me this error:

rpm: only installation, upgrading, rmsource and rmspec may be forced

Posted by Monther on June 28, 2011 at 02:59 PM DDUT #

Really helpfull!
I had problems following OracleXE documentation. It just says:

Deinstalling the Oracle Database XE Software
Follow these steps:
Log on with root privileges.
Run the following command to deinstall Oracle Database XE:
# rpm -e oracle-xe

and error: package oracle-xe is not installed

grep saved me!... it was called oracle-xe-univ-10.2.0.1-1.0

^^ HappyX-Mas

Posted by CharlesOracle Student on December 22, 2011 at 02:18 PM DDUT #

simply use sudo dpkg --purge oracle-xe

Posted by guest on February 10, 2012 at 03:07 PM DDUT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

A blog on Oracle VM, PHP and any other projects I work on.

Search

Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today