Hi Judy!
Yes, we have AOLserver working with Oracle 9i and 10g. So it does work!
You can download it from here:
http://sourceforge.net/project/showfiles.php?group_id=3152
Follow the instructions from OpenACS documentation:
https://openacs.org/doc/current/aolserver4.html
[root nscache]# cd ../nsoracle
[root nsoracle]# make install AOLSERVER=/usr/local/aolserver40r10
Brian