How to Install Configure & Execute Oracle10g XE in UBUNTU or Debian based Linux Distribution

Introduction

This tutorial will guide you through the installation, configuration, and execution of Oracle 10g Express Edition (XE) on Ubuntu or Debian-based Linux distributions. Using Linux Mint as an example, you will learn the necessary steps to successfully set up Oracle 10g XE on your system.

Step 1: Download the Oracle 10g XE Package

Visit the provided Google Drive link to download the Oracle 10g XE installation files

Oracle 10g XE Files.
1. Locate the oracle-xe-10.2.0-1.0.i386.rpm file and download it to your local machine.

Step 2: Convert RPM Package to DEB Format

Oracle 10g XE is provided in RPM format, which is not directly compatible with Debian-based systems. To convert it, follow these steps:

1. Open the terminal.
2. Install the necessary tools for conversion:

   sudo apt-get install alien
   

3. Navigate to the directory where the RPM file is located:

   cd /path/to/downloaded/file
   

4. Convert the RPM package to DEB format:

   sudo alien -k oracle-xe-10.2.0-1.0.i386.rpm
   

Step 3: Install the Converted DEB Package

1. After conversion, install the package using the following command:

   sudo dpkg -i oracle-xe_10.2.0-1.0_i386.deb
   

2. If there are any dependency issues, fix them by running:

   sudo apt-get install -f
   

Step 4: Configure Oracle 10g XE

1. Start the configuration process by running:

   sudo /etc/init.d/oracle-xe configure
   

Follow the prompts to set up the following

• Select a port number (default is 8080).
• Set the password for the SYS and SYSTEM user accounts.
• Choose a database name (default is XE).
2. Confirm all settings, and the installation will complete.

Step 5: Start Oracle 10g XE

1. To start the Oracle service, use the command:

   sudo service oracle-xe start
   

2. You can access the Oracle Database Express Edition via a web browser at:

   http://localhost:8080/apex
   

3. Log in using the credentials you created during configuration.

Step 6: Verify the Installation

1. To verify that Oracle 10g XE is running correctly, check the service status:

   sudo service oracle-xe status
   

2. You can also connect to the database using SQL*Plus:

   sqlplus / as sysdba
   

Conclusion

You have successfully installed, configured, and executed Oracle 10g XE on your Ubuntu or Debian-based Linux distribution. You can now start using Oracle for your database projects. If you encounter any issues, check the Oracle logs located in /var/opt/oracle/. For further learning, consider exploring Oracle documentation or community forums for additional resources and support.