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
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/