I believe I've had this problem before and it might be a linking or a permissions problem.
Make sure the user running AOLserver has execute and read permissions on the libraries needed by nsoracle.so:
# ldd /usr/local/aolserver/bin/nsoracle.so
libclntsh.so.10.1 => /oracle/app/product/10.2.0/db_1/lib/libclntsh.so.10.1 (0x0091d000)
libdl.so.2 => /lib/libdl.so.2 (0x00751000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00111000)
libc.so.6 => /lib/tls/libc.so.6 (0x00123000)
libnnz10.so => /oracle/app/product/10.2.0/db_1/lib/libnnz10.so (0x0024e000)
libm.so.6 => /lib/tls/libm.so.6 (0x00452000)
libnsl.so.1 => /lib/libnsl.so.1 (0x00475000)
/lib/ld-linux.so.2 (0x00599000)
You are able to log in to your database and view the OACS tables using sqlplus right?
