Installing Oracle XE on Ubuntu 32-bit

For successful installation of Oracle XE on Ubuntu 32-bit, following requirements must be satisfied :-
a) 512 MB RAM
b) 1 GB swap-space
c) 1.5 GB of free space in the mount-point containing /usr/lib directory.

For installing the Oracle 10g XE R2 do the following :
1) Install the libaio1 package .
            

sudo apt-get install libaio1

2) Download the .deb installer file : 

For the people who want to install Oracle XE on the 32-bit Ubuntu system but are not able to do the same due to unavailability of the installer from Oracle Website , here is some good news. I am sharing the original Oracle 10g R2 XE ( express edition ) installer on my cloud space.

The Link : One Drive Link

File size : 220670896
md5sum : 47a83df38f2cbcd78b9a1f110c1c5d92
sha1sum : be666229e036afa85dcc9437d48a418bf65c3468

Use the above link to download the deb installer file.
 

3) Go to the download location and run below command to install the Oracle 10g XE :
            

dpkg -i oracle-xe_10.2.0.1-1.0_i386.deb

4) Configure the installation:
           

  /etc/init.d/oracle-xe configure

Enter the following configuration information:

• A valid HTTP port for the Oracle Application Express (the default is 8080) 
• A valid port for the Oracle database listener (the default is 1521) 
• A password for the SYS and SYSTEM administrative user accounts 
• Confirm password for SYS and SYSTEM administrative user accounts  
• Whether you want the database to start automatically when the computer starts (next reboot).  

5) Set-up the environment variables :
Add following lines to .bashrc of the user which you will using to access the Oracle 10g XE:

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

export ORACLE_SID=XE 

export PATH=$ORACLE_HOME/bin:$PATH 

6) Start a new shell ( terminal window ) for the changes to take effect or execute the .profile to force the changes made in the same session.
       

  . ./.profile

7) Use the command "sqlplus sys as sysdba" and the password which you created while configuration to connect to the database.

Have a happy Ubuntu Experience...

Note:- If anyone face problem in downloading from the above link, please let me know in the comments.

Installing Windows after Ubuntu while dual-booting

    If you ever want to install windows on your system and dual boot with your current ubuntu installation, you don't have to get rid of your current installation. You can do it without re-installing ubuntu all-over again. 

Note : You need to have a working internet connection for the same or you need to have following five files correspong to your system architecture ( amd64 or i386 ) to proceed.

a) grub2-common_1.99-12ubuntu5_<architecture>.deb

b) grub-gfxpayload-lists_0.5_<architecture>.deb

c) grub-pc-bin_1.99-12ubuntu5_<architecture>.deb
d) grub-common_1.99-12ubuntu5_<architecture>.deb

e) grub-pc_1.99-12ubuntu5_<architecture>.deb

     You can download these from :

i) http://archive.ubuntu.com/ubuntu/pool/main/g/grub2/

ii) http://archive.ubuntu.com/ubuntu/pool/main/g/grub-gfxpayload-lists/

If your system satisfy the above condition then just do as in the following steps :

1) Back-up whatever you want to preserve. ( for worst-case scenario )

2) Have a Ubuntu CD / DVD / bootable USB disk with you. You will need it later on.

3) Create a partition for your windows installation from your ubuntu installation ( if you don't have one ) . The partion need-not to be formated as NTFS for now as you can do the same while installing windows. Just make a unformatted partition or simply create a blank free space (partition ) . You can do it via Gparted partition editor. If you don't have it installed , you can have it by entering following command in the terminal :

                       sudo apt-get update && sudo apt-get install gparted

4) Install Windows on the new partition.Remember not to touch the partition(s) containing your ubuntu installation or swap area.

5) At this point of time you won't be able to see or use your current ubuntu installtion as the system will straight boot into the new Windows installation.

6) Boot from your Ubuntu CD / DVD / bootable USB disk .

7) Open the terminal and enter the following command :

 i) sudo mkdir /mnt/temp ( creates a temporary directory for mounting your ubuntu partition )

ii) sudo mount /dev/sda2 /mnt/temp ( here /dev/sda2 is the partition where your ubuntu installation lies )

iii) Also mount some miscellaneous file-systems for proper working of chroot command : 

        for i in /dev /dev/pts /proc /sys; do sudo mount -B $i /mnt/temp$i; done

iv) Now chroot into your ubuntu Installation :

                                  sudo chroot /mnt/temp

v) If the above commands run successfully, the terminal prompt should include "root" ( root@ubuntu:/# ), which indicates you are in the chroot environment.

vi) Confirm you have working net connection in the chroot environment ( for downloading the grub installation files if you have not already downloaded it ) :

                               ping archive.ubuntu.com

vii) Update your package list : This step is optional if you have already downloaded the grub files.

                                sudo apt-get update

viii) Purging the Grub Loader : Do not proceed to next command if you don't have a working internet connection or you do not have access to downloaded grub files . The next command will remove grub, grub-pc (Grub 2) and grub-common. If you are sure you have never had Grub legacy on the current installation you may omit "grub" from the next command.

                             apt-get purge grub grub-pc grub-common

Here is what you will have to do:

• Press ENTER to continue.
• Read the warning during the install about removing the bootloader. TAB to highlight "<Yes>" and press ENTER.

viii) Re-install the grub packages : 

                   Command :

                           apt-get install grub-common grub-pc

Here is what will happen:

• You will be given the opportunity to add extra kernel options to the kernel line. If you don't know, you probably don't need them ; TAB to highlight "<OK>" and press ENTER.
• Read the installation notes. TAB to "<OK>" to continue.
• When presented with the device option, use the Up/Down keys to select the correct drive ( /dev/sdX ).
• Make sure the installation drive [*] /dev/sdX has an asterisk next to it ( example: [*] /dev/sda ). 
• If it doesn't, highlight it and press the SPACE bar to select it. Do not select a partition ( example: [ ] /dev/sda5 , etc). 
• TAB to "<OK>" and press ENTER. When it has finishing the installation, you should have Grub 2 installed.

ix) Update the Grub Loader files

                     update-grub

x)- Exit the chroot environment

                       exit

If you have successfully exited chroot, the terminal prompt should return to the Ubuntu Live CD prompt ( ubuntu@ubuntu:~$ ).

8) Reboot your system and you will be presented a grub based boot-menu containing the choice of operating systems ( including Windows ) you want to boot.There it goes ....

Have a happy Ubuntu Experience...

Installing minimal form of ubuntu

               The Minimal CD will download packages from online archives at installation time instead of providing them on the install CD itself. Downloading packages at install time reduces the size of the install CD to approximately 5 to 20MB depending on architecture (see below), as well as providing only the packages needed for installation. The download time savings achieved by using a Minimal CD can be significant, as only current packages are downloaded, so there is no need to upgrade packages immediately after installation. The Minimal CD uses a text-based installer like the Alternate CD, making the CD image as compact as possible.

                To use the Minimal CD download mini.iso from one of the following links given below and burn it to a CD.

                  To install, boot your computer from the the Minimal CD and type "cli" (command line install) at the prompt. You can then follow the instructions from the text-based installer. After the base system is installed, log in, and type "sudo tasksel" to select the system to install.

Links :

32-bit PC (x86)

Name : Ubuntu 11.04 "Natty Narwhal" Minimal CD 

Link : http://archive.ubuntu.com/ubuntu/dists/natty/main/installer-i386/current/images/netboot/mini.iso 

Size : 19MB 

MD5 : cc1591035877c317fdef7f4ebf1662b9  SHA1:d86f78c8343009e57b0ecda14592e76802ce1ec4

64-bit PC (amd64, x86_64)

Name : Ubuntu 11.04 "Natty Narwhal" Minimal CD 

Link : http://archive.ubuntu.com/ubuntu/dists/natty/main/installer-amd64/current/images/netboot/mini.iso 

Size : 22MB 

MD5: 13507ac70863edd2df11cdd6260011ba 

SHA1: 971f67b98323f090f3609f5c7fe78478d564122d