Quite confuse when you want to re-install oracle-xe on Ubuntu. Struggling for several hours googling, I found this tip:
1. Run “sudo dpkg -P oracle-xe-universal” to get Ubuntu remove all the files as well as configuration files.
2. Delete folder: “/usr/lib/oracle/xe”
3. Restart the machine
4. Install the oracle-xe package.
5. Run “sudo /etc/init.d/oracle-xe configure" to have oracle-xe be setup
6. Access the nice Oracle web interface by pointing your Firefox to: http://127.0.0.1:8080/apex to check if everything went fine...
7. Have fun…
^^
MinhTran
[...] | LuckyStar | Monish’s Oracle [...]
Very useful post, thanks!
You helped me a lot!
Thanks!
Thanks a bunch mate! Saved my day
Hi,
Excellent sharing. Thanks for same.
Regards,
Dbametrix
http://www.dbametrix.com
May you guys find peace of mind….
^^
I was having the error below because I did not have the idea to add this “-P” parameter. Thanks a lot for the tip!
The install cannot proceed because a database instance named ‘XE’ appears to be
configured on the system. Delete the instance, remove the entry corresponding
to this instance from the oratab file (/etc/oratab), and retry the installation.
dpkg: error processing /var/cache/apt/archives/oracle-xe-universal_10.2.0.1-1.1_i386.deb (–unpack):
subprocess new pre-installation script returned error exit status 1
Errors were encountered while processing:
/var/cache/apt/archives/oracle-xe-universal_10.2.0.1-1.1_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
Thank you, thank you, thank you.
I have been trying for the past 24 hours to re-install Oracle XE on Ubuntu because I did not have the host name right the first time I did it. And you know how picky Oracle can be about host names.
Anyway, I could never reconfigure the re-installation because it always said that “Oracle has already been configured”. Even though that configuration was now wrong. This fixed it. Thanks again.
You just saved my time
2. Delete folder: “/usr/lib/oracle/xe”
2.1 adicionalmente borre el oratab
sudo rm /etc/oratab
esto con la finalidad de no encontrar error en la instalacion
3. Restart the machine
por lo demas excelente, buena ayuda, felicitaciones
thanks!
You are welcome… ^^
Yes ,its very usefull blogs .!!!!!!!!!
Thanks, Ashish!