Work in progress

Oracle

# Oracle XE Debian repository
deb http://oss.oracle.com/debian unstable main non-free

Preparations

Creating users and groups

# addgroup --system oinstall
# addgroup --system dba
# adduser --system --ingroup oinstall --shell /bin/bash oracle
# adduser oracle dba

Oracle 10g on Squeeze (amd64)

Initial steps

We need to install some packages

aptitude install build-essential gcc-multilib ia32-libs libaio1 libstdc++5 rpm xauth

Oracle requirements (sysctl and security limits)

sysctl

fs.file-max = 65536
fs.aio-max-nr = 1048576
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
kernel.shmmax = 2147483648 (Oracle recommends total machine Ram -1 byte)
kernel.shmall = 2097152
kernel.shmmni = 4096
net.ipv4.ip_local_port_range = 1024 65000
vm.hugetlb_shm_group = 111
vm.nr_hugepages = 64

# sysctl -p /etc/sysctl.d/local-oracle.conf

security limits

oracle          soft    nproc           2047
oracle          hard    nproc           16384
oracle          soft    nofile          1024
oracle          hard    nofile          65536

Nasty hacks

# ln -s /usr/bin/awk /bin/awk
# ln -s /usr/bin/basename /bin/basename
# ln -s /usr/bin/rpm /bin/rpm

Installation

$ ssh -XC $SOMEUSER@orclserver.example.org

$ ssh -XC $SOMEUSER@orclserver.example.org

$ xauth list
orclserver/unix:10  MIT-MAGIC-COOKIE-1  abcdef0123456789abcdef0123456789

$ su - oracle
$ xauth add orclserver/unix:10  MIT-MAGIC-COOKIE-1  abcdef0123456789abcdef0123456789

$ /path/to/oracle/database/runInstaller -IgnoreSysPreReqs

Common problems

gcc-multilib: linking pthread problems

/usr/bin/ld: skipping incompatible /usr/lib/gcc/x86_64-linux-gnu/4.4.5/.../libpthread.a when searching for -lpthread
/usr/bin/ld: skipping incompatible /usr/lib/libpthread.so when searching for -lpthread
/usr/bin/ld: skipping incompatible /usr/lib/libpthread.a when searching for -lpthread
/usr/bin/ld: cannot find -lpthread

INFO: collect2: ld returned 1 exit status

INFO: make: *** [ctxhx] Error 1

INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'install' of makefile '/opt/oracle/product/10.2.0/db_1/ctx/lib/ins_ctx.mk'.

Oracle 11g on Squeeze (amd64)

Word in progress


?CategoryDatabases ?CategoryNonFree