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