Install Oracle Database 10g Express in Ubuntu

In this tutorial you will learn how to install Oracle Database 10g Express in Ubuntu Lucid Lynx (Ubuntu 10.04 LTS). The express edition is free and any beginning developer can practice using Oracle on their Linux computer without needing a license. Emphasis will be placed on the installation of Oracle on a Debian Linux x86 system.

If you are curious about the limitations of the Express edition, you can read about them here: http://www.webxpert.ro/andrei/2009/03/17/disadvantages-of-using-oracle-database-10g-xe-express-edition/

Downloading the Correct Installer

Follow these steps:

1.) Go to this URL: http://www.oracle.com/technetwork/database/express-edition/downloads/index.html

2.) Click the link: Oracle Database 10g Express Edition for Linux x86 under “Oracle Database 10g Express Edition”. This will take you to this page: http://www.oracle.com/technetwork/database/express-edition/downloads/102xelinsoft-102048.html

3.) You need to have an Oracle account before you can download the installer. If you do not have an Oracle account, just click the link “Sign In/Register for Account” and proceed with the registration. Once you have a confirmed your account, login to their system. Take note of your password because you will be needing it every time you download Oracle related products.

4.) In this download page: http://www.oracle.com/technetwork/database/express-edition/downloads/102xelinsoft-102048.html, check “Accept License Agreement”.

Under “Oracle Database 10g Express Edition(Western European)”, click “oracle-xe 10.2.0.1-1.0 i386.deb” (see red font in the screenshot below).

This is the installer and it will be downloaded to the Ubuntu downloads folder. The downloading process can take long depending on your Internet connection. The .deb installer is around 210MB.

Preparing your System and Installing Required Libraries

Before you continue with the installation, make sure your Ubuntu system is fully updated. You can determine if it is by following these steps:

1.) Go to System – Update Manager.
2.) Make sure that under “Software Updates are available for this computer”, there are no critical updates. If there are updates, make sure to implement them before installing Oracle.

You then need to install libaio1 package (Linux Kernel AIO Access Library). To do this:

1.) Go to System – Administration – Synaptic Package Manager.
2.) Under “Quick Search”, type libaio1. Make sure to check all of them and install it to your system. See screenshot below:

Execute the Oracle .deb installer in Ubuntu

After successful installation of libaio1, you need to execute the .deb installer you have downloaded from Oracle. Follow these steps:

1.) Open Terminal (Applications – Accessories – Terminal).
2.) Navigate to the Downloads folder:

codex-m@codex-m-desktop:~$ cd Downloads

3.) Execute and install the .deb package: (you need root privileges, during this process Ubuntu may ask for your root password):

codex-m@codex-m-desktop:~/Downloads$ sudo dpkg -i oracle-xe_10.2.0.1-1.0_i386.deb

4.) The following is the result:

codex-m@codex-m-desktop:~/Downloads$ sudo dpkg -i oracle-xe_10.2.0.1-1.0_i386.deb

Selecting previously deselected package oracle-xe.
(Reading database … 218860 files and directories currently installed.)
Unpacking oracle-xe (from oracle-xe_10.2.0.1-1.0_i386.deb) …
Setting up oracle-xe (10.2.0.1-1.0) …
update-rc.d: warning: /etc/init.d/oracle-xe missing LSB information
update-rc.d: see <http://wiki.debian.org/LSBInitScripts>
Executing Post-install steps…
-e You must run ‘/etc/init.d/oracle-xe configure’ as the root user to configure the database.

Processing triggers for python-gmenu …
Rebuilding /usr/share/applications/desktop.en_PH.utf8.cache…
Processing triggers for desktop-file-utils …
Processing triggers for man-db …
Processing triggers for ureadahead …
Processing triggers for python-support …

{mospagebreak title=Configuring Oracle Database 10g in Ubuntu}

Before you can properly use the database, you need to configure it for its first use. Follow the steps below:

1.) In the terminal command line. Login as root:

codex-m@codex-m-desktop:~$ sudo -s -H

2.) Run the configuration command:

root@codex-m-desktop:/home/codex-m# /etc/init.d/oracle-xe configure

2.) You will then need to specify an HTTP port that will be used for Oracle application express: type 8080

3.) You will need to specify a port that will be used for database listener: type 1521

4.) You also need to specify a password for database accounts. Please remember this and write it down in a safe location.

5.) If you see the message: “Do you want Oracle database 10G express edition to start on boot". Type "n" for no. Most of the time you type no if you are not going to use Oracle on a daily basis; otherwise choose yes.

The configuration can take some time to complete, so be sure not to close the terminal until you see the message: “Installation Completed Successfully.” See the screenshot below:

Starting Oracle Database 10g Express for the First Time

After successful installation, you still need to confirm that you can run and start the Oracle database. Do the following steps:

1.) Go to Applications – Oracle database 10g Express Edition and then click “Go to Database Homepage”.

2.) Login using the following credentials:

Username: System
Password: {the password you used during the configuration}

3.) If things are working well, you should see the dashboard of the database, as shown here:

Note: In this installation, your system will automatically create an Ubuntu username known as “Oracle”. You can view it every time you restart your computer. This username does not have root privileges and you can use this for Oracle related transactions in your system.

If you have problems starting Oracle for some unknown reason, log out with your current Ubuntu username and login as “Oracle” to start the database session.

{mospagebreak title=Oracle Beginner Tips}

As a beginner, you will be overwhelmed with a lot of Oracle resources on the Internet.  Below are some good tutorials on how to get started with Oracle from scratch:

1.) Six Must Know Oracle Commands: http://www.devshed.com/c/a/Oracle/Six-Must-Know-Oracle-Commands/

What will you learn here: As a starter in Oracle, you can experience a lot of difficulties learning this database especially working with Linux environment. To minimize the problem, this six must know Oracle commands are important so that you will have skills to work around with the most important database tasks without the need to study hundreds of commands. The following are skills you will acquire after reading that tutorial:

a.) Starting and Shutting down the Oracle database.
b.) Connecting to the database using a command line.
c.) Creating new admin user to your Oracle database and granting rights. This admin user is also called DBA (database administrator).
d.) Creating tables in the database, inserting and modifying data.

2.) Oracle Debugging Tips using Oracle SQL Developer – http://www.devshed.com/c/a/Oracle/Oracle-Debugging-Tips-using-Oracle-SQL-Developer/

a.) Once you are highly familiar with the Oracle Database Homepage. You can then start designing, creating and troubleshooting Oracle projects. This is where you can use the Oracle SQL Developer. This is an IDE for working with Oracle databases.

[gp-comments width="770" linklove="off" ]

antalya escort bayan antalya escort bayan Antalya escort