Oracle Express on NetBSD

started by Emmanuel Kasper

Oracle Express is a free beer version of the Oracle Database. You are free to use it in production, and to redistribute it, but it has harcoded limits of use one CPU, 1 GB of RAM, and 4 GB for a table size.

Download the binary at http://www.oracle.com/technology/software/products/database/xe/index.html

Convert the rpm in cpio format

pkg_add -v rpm2cpio
rpm2cpio.pl oracle-xe-univ-10.2.0.1-1.0.i386.rpm > oracle-xe-univ-10.2.0.1-1.0.i386.cpio

Unpack the cpio archive (it installs in /usr/lib/oracle )

cpio -idv < oracle-xe-univ-10.2.0.1-1.0.i386.cpio

Install the Suse linux environnment. I don't need what exactly needed, so I prefer to install all.

pkg_add -v suse-9.1nb3

Add oracle libraries to ldconfig library cache

echo /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib >> /emul/linux/etc/ld.so.conf
/emul/linux/sbin/ldconfig

Test sqlplus binary

sqlplus /nolog 

Right now we have a sqlplus binary that works and is abled to connect over the network to a database but creating a database fails with the error:

ERROR:
ORA-12549: TNS:operating system resource quota exceeded

I guess some kernel recompile is necessary. See http://n0se.shacknet.nu/