Oracle Database10g Express installation on Fedora 15

No replies
Anonymous

At Samhita, we are committed to the exclusive use of free and open source software. Sometimes though, we are forced to compromise on this in order to facilitate a partner that does not yet have open source capability. One example is the case of an agency with whom we are building a data exchange relationship. To accommodate them, we had to install on one of our Fedora systems, a copy of Oracle Database Express 10g, a free starter product from Oracle.

Here are instructions on the installation process on Fedora 15:

1. Download oracle-xe-univ-10.2.0.1-1.0.i386.rpm file from here:
http://download.oracle.com/otn/linux/oracle10g/xe/10201/oracle-xe-univ-10.2.0.1-1.0.i386.rpm
You will need to register on the Oracle website in order to run the download.

2. Log on to your Fedora system with root privileges and move the downloaded file oracle-xe-univ-10.2.0.1-1.0.i386.rpmt to /opt - this is where we will install it.

3. Switch to the /opt directory and install the package. Do this AFTER ensuring that the hostname set in /etc/hosts and /etc/sysconfig/network are the same.
[root@opt ]# cd /opt
[root@opt ]# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm

4. Configure the properties of Oracle Database10g express. Run the following command.
[root@opt ]# /etc/init.d/oracle-xe configure
(a) You may specify any HTTP Port as long as it is available and not in use by another service. For example, use 8081
(b) For the Database Listener, use the default 1521.
(c) When prompted for password and password confirmation for the users SYS and SYSTEM, remember not to use any special characters in the password.
(d) Enter y to set up the Oracle service to start at boot.
Fire up a web browser, and enter the URL http://127.0.0.1:8081/apex - the Oracle database GUI web interface will start up.

5. Next you have to set up the Oracle Database XE Server Environment Variables. Please add the following line in the /etc/profile file at the end. Take great care, if you mess up the profile you will be unable to log back in.
if [ -f /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh ]
then
sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
fi

6. Restart the machine. Log on with root privileges and run the following command-
[root@opt ]#echo $ORACLE_HOME
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
[root@opt ]#

7. Uninstalling the Oracle Database XE Software. Should you need to remove the package, do the following:
(a) Remove the lines you added in step 5 to the /etc/profile file. Do it with care, if you mess up you will not be able to log back in.
(b) Log on with root privileges and run the following command -
[root@opt ]#  rpm -e oracle-xe
(c) Manually remove the directories that Oracle Database XE installed, if they have not been removed already. These are the directories to remove:

  • /usr/lib/oracle/xe
  • /etc/oratab
  • etc/init.d/oracle-xe
  • /etc/sysconfig/oracle-xe
  • /usr/share/doc/oracle_xe (Oracle Database XE Server documentation)
  • /usr/share/doc/oracle_xe_client (Oracle Database XE Client documentation)

sDevNet.org webPortal v2.0 © 2011 eCubeH Research Labs + Acknowledgements