Forum OpenACS Development: nsoracle driver for Oracle9i

Collapse
1: nsoracle driver for Oracle9i
Posted by Judith Pino Chial on 03/21/06 05:13 PM
I would like to know which nsoracle driver i need to use for Oracle 9i.
Collapse
2: Re: nsoracle driver for Oracle9i (response to 1)
Posted by Brian Fenton on 03/22/06 04:39 PM
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

Collapse
3: Re: nsoracle driver for Oracle9i (response to 1)
Posted by Judith Pino Chial on 03/23/06 07:09 PM
I have installed AOLserver 4.10, Oracle 9i and OpenACS 5.2.2, but I get this error:

"RDBMS type could not be determined for any pool".

The error log says:
[23/Mar/2006:10:54:03][5437.16384][-main-] Warning: modload: could not load /usr/local/aolserver/bin/nsoracle.so: libclntsh.so.8.0: cannot open shared object file: No such file or directory
[23/Mar/2006:10:54:03][5437.16384][-main-] Error: dbdrv: failed to load driver 'db9'
[23/Mar/2006:10:54:03][5437.16384][-main-] Error: dbinit: no such default pool 'pool1'

What have I done wrong?

Collapse
4: Re: Re: nsoracle driver for Oracle9i (response to 3)
Posted by Brian Fenton on 03/24/06 10:05 AM
Judy,

I searched this website using Google and found this:
https://openacs.org/forums/message-view?message_id=279468

hope it helps
Brian

Collapse
5: Re: nsoracle driver for Oracle9i (response to 1)
Posted by madhu s on 03/24/06 12:35 PM
Hi,

Make sure that you have all necessary paths loded ORACLE_HOME,bin,LD_LIBRARY_PATH etc., while running the nsd

and you might need to change packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl

ad_known_database_types , if in case there is no patch available already.

Thanks
Madhu