Install Oracle UCM 10gR3 on Ubuntu

Submitted by radu on March 28, 2010 - 3:24pm

Installing Oracle UCM 10gR3 on Ubuntu is quite easy. Here are the steps you'll have to take:

Install Apache Webserver
Install Oracle XE Database
Configure the database
Install Oracle UCM

Install Apache Webserver

To install Apache as a webserver, run the following command:

sudo apt-get install apache2

The UCM apache module requires some dependencies that are no longer available in modern ubuntu versions:

wget http://mirrors.kernel.org/ubuntu/pool/universe/g/gcc-2.95/libstdc++2.10-glibc2.2_2.95.4-24_i386.deb
sudo dpkg -i libstdc++2.10-glibc2.2_2.95.4-24_i386.deb

Install Oracle XE Database

Oracle databases have the bad habit of requiring at least 1GB of swap space, no matter the amount of RAM your system has. If you don't use a swap partition or the system swap space is less than 1GB, you can create a swap file only for the purpose of the install.

sudo dd if=/dev/zero of=/swapfile bs=1M count=600
sudo mkswap /swapfile
sudo swapon /swapfile

Thanks to Oracle's efforts to support Linux, installing the Oracle XE Database is a breeze.

deb http://oss.oracle.com/debian unstable main non-free to /etc/apt/sources.list
sudo wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add - 
sudo apt-get update
sudo apt-get install oracle-xe
sudo /etc/init.d/oracle-xe configure

Configure the database

Now you'll have to create a new tablespace for UCM. Connect to the database as SYSDBA using SQL*Plus and run the following commands:

CREATE TEMPORARY tablespace idc_temp 
  tempfile '/usr/lib/oracle/xe/oradata/XE/idc_temp.dbf' 
  SIZE 200M reuse autoextend ON NEXT 5120k maxsize unlimited;
 
CREATE tablespace idc_sys 
  datafile '/usr/lib/oracle/xe/oradata/XE/idc_sys.dbf' 
  SIZE 200M reuse autoextend ON NEXT 5120k maxsize unlimited;
 
CREATE USER idc 
  IDENTIFIED BY idc 
  TEMPORARY tablespace idc_temp 
  DEFAULT tablespace idc_sys 
  quota unlimited ON idc_sys;
 
GRANT CONNECT, resource TO idc;