How to install Oracle Database 10g on Debian

Oracle Enterprise Database is certified to running on RedHat, SuSe and YellowDog beyond many unix and windows, but don't Debian. Recently Oracle has deployed a package of the Express (and free) version in .deb format. This how to is intented to help to install Enterprise Edition. By the way, it's with you own risks!

Install required debian packages

• rpm
• gcc
• alien
• libdb1-compat
• libdb4.4++-dev
• libdb4.4-dev
  
• libstdc++-5
• libstdc++-5-dev
  
• compat-db-4.1.25-9 = couldn't find
  
• gnome-control-center = 2.14.2.-7
  
• gcc-3.4.3-9.EL4 = gcc 4.1.1.1-15 and gcc3.4.6-5
  
• gcc-c++-3.4.3-9.EL4
  
• glibc-2.3.4-2 = libc6 2.3.6
  
• glibc-common-2.3.4-2 = libc6-dev 2.3.6
  
• gnome-libs-1.4.1.2.90-44.1
• libstdc++-3.4.3-9.EL4 = cpp-3.4 3.4.6-5 /g++-3.4 3.4.6-5 / gcc-3.4 3.4.6-5 / libstdc++-6-devel
• pev 3.4.6-5 = coundn't not found
  
• libstdc++-devel-3.4.3-9.EL4
• make-3.80-5
• pdksh-5.2.14-30 = pdksh 5.2.14-20
  
• sysstat-5.0.5-1 = sysstat 7.0.0-4
  
• xscreensaver-4.18-5.rhel4.2 = xscreensaver 4.24-5
  
• libaio-0.3.96 = libaio1 0.3.106-3
• libaio-dev 0.3.106-3
• libdb1-compat 2.1.3-9
  
• linux-kernel-header 2.6.18-7
  
• openmotif21 = lesstif2 0.94.4-2

Create some links for compatibility with Red Hat

ln -s /usr/bin/rpm /bin/rpm
cd /usr/lib
ln -s libstdc++.so.6 libstdc++.so.5

ln -s /usr/bin/awk /bin/awk

ln -s /usr/bin/rpm /bin/rpm

ln -s /usr/bin/basename /bin/basename

ln -s /etc /etc/rc.d

Some packages are from non-free pool package. So you need alter your /etc/apt/sources.list. Below you can see my sources.list:

deb http://linorg.usp.br/debian/ etch main contrib non-free
deb-src http://linorg.usp.br/debian/ etch main contrib non-free
deb ftp://ftp.debian.org/debian/ etch main contrib non-free
deb-src ftp://ftp.debian.org/debian/ etch main contrib non-free

deb http://security.debian.org/ etch/updates main contrib non-free
deb-src http://security.debian.org/ etch/updates main contrib non-free

Create Oracle user
groupadd oinstall
groupadd dba
useradd -m -g oinstall -G dba oracle
passwd oracle

Configure kernel parameters

kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Setting shell limits for oracle user

file /etc/security/limits.conf:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

file /etc/pam.d/login: (I don't need change, it's already ok)
session required /lib/security/pam_limits.so

Now: Installing Oracle software!!!

./runInstaller -IgnoreSysPrereqs

The machine is us