Infrastructure Software

The following will explain how to install Oracle 10g XE under Linux Ubuntu 10.10, 64-bit in VMWare. I hope it will be useful.


h3. Installation of Ubuntu 10.10 and Oracle 10g XE:
h4. 1) Perform a default installation of Ubuntu 10.10 amd 64-bit
h4. 2) Select System Menu, Administration, Update Manager and install all updates as requried.
h4. 3) To add a 1 GB swapfile for Oracle 10g XE, select Applications Menu, Accessories, Terminal:
$ sudo dd if=/dev/zero of=/swapfile bs=1024 count=1048576
$ sudo mkswap /swapfile
$ sudo swapon /swapfile
$ sudo cp /etc/fstab /etc/fstab.orig
$ sudo su -
$ echo '/swapfile swap swap defaults 0 0' >> /etc/fstab (make sure to use >> !!!)
$ exit
h4. 4) Open Firefox web browser and goto http://otn.oracle.com:
Select Database 10g Express Edition from the Downloads menu, choose Linux x86
Download the appropriate .deb package installer - save the file.
h4. 5) Install 32-bit libraries and Oracle 10g XE by entering the following:
$ cd Downloads
$ sudo apt-get install libc6-i386
$ wget http://oss.oracle.com/debian/dists/unstable/main/binary-i386/libaio_0.3.104-1_i386.deb
$ sudo dpkg -i --force-architecture libaio_0.3.104-1_i386.deb
$ sudo dpkg -i --force-architecture oracle-xe*
h4. 6) From the login console, select the System Menu, Administration, Users and Groups:
Enable the Oracle account and set a new password.
h4. 7) Open a terminal window and modify nls_lang.sh by entering the following:
$ sudo gedit
Change the first line from "#! /bin/sh" to "#! /bin/bash" and save the file Crtl-s.
h4. 8) Configure Oracle 10g XE. Open a termianl window and enter:
$ sudo /etc/init.d/oracle-xe configure
This may take a while, let if finish. It should end with:
To access the Database Home Page go to "http://127.0.0.1:8080/apex"
h4. 9) Configure the Oracle user account to set necessary environment variables at next login:
$ su - oracle
$ echo "source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" >> $HOME/.bashrc
$ exit
$ su - oracle
$ printenv
The following should be automatically set:
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
h4. 10) Check Oracle SQL*Plus and set passwords for SYS and SYSTEM
$ su - oracle
$ sqlplus / as sysdba
SQL> alter user sys identified by "your_password" account unlock;
SQL> alter user system identified by "your_password" account unlock;
h4. 11) Log into the Oracle 10g XE home page and perform administration:
Open a browser window and enter the following url:
http://your_server_ip_address:8080/apex
or if you are using the Server console window:
http://127.0.0.1:8080/apex
Enter the username 'sys' and your password. Select Administration, and e.g. create a database user.


h3. Remote Access:
h4. Enable remote ssh login:
$ sudo apt-get install openssh-server


h3. VMWare Tools installation:
h4. Configure your guest OS for Bridged Networking and fixed IP.
h4. Install VMWare Tools:
Select Install VMWare Tools from the Virtual Machine Menu
Right click on VMwareTools-xxx.tar.gz and extract it to the Desktop
Open a terminal window and type the following:
$ cd Desktop
$ sudo ./vmware-install.pl
Continue to press Return and accept defaults.
$ sudo reboot
You should now be able to set a larger screen resolution from the System Menu, Preferences, Monitors.


h3. Troubleshooting:
h4. Start and stop Oracle XE:
# su - root
# /etc/init.d/oracle-xe start
# /etc/init.d/oracle-xe stop

Best of luck!