Forum OpenACS Q&A: Oracle 9i client problems?

Posted by Guan Yang on 02/21/04 12:28 AM

I'm running AOLserver 4.0.2 with nsoracle 2.7 on a Red Hat 9 box. LD_KERNEL_ASSUME is set to 2.4.1. When I start up AOLserver I get the following error:

[21/Feb/2004:00:56:05][30024.1075057280][-main-] Error: nsoracle.c:2708:Ns_DbDriverInit: error in `OCIInitialize ()':
SQL: [nil]

Has anyone else experienced this? This is Oracle 9.2.0.

2: Re: Oracle 9i client problems? (response to 1)

Posted by Jose Pablo Escobedo Del Cid on 03/28/05 12:36 PM

I'm having exactly the same problem, I'm using oracle 10.0.1.3, and the oracle driver 2.7

Did you/anyone solved this problem?

This is the server log:

[28/Mar/2005:11:24:12][5679.16384][-main-] Notice: ora10 driver LobBufferSize = 32768
[28/Mar/2005:11:24:12][5679.16384][-main-] Notice: ora10 driver PrefetchRows = 0
[28/Mar/2005:11:24:12][5679.16384][-main-] Notice: ora10 driver PrefetchMemory = 0
[28/Mar/2005:11:24:12][5679.16384][-main-] Error: nsoracle.c:901:Ns_DbDriverInit: error in `OCIInitialize ()':
SQL: [nil]
[28/Mar/2005:11:24:12][5679.16384][-main-] Fatal: received fatal signal 11

3: Re: Oracle 9i client problems? (oracle 10g) (response to 1)

Posted by Jose Pablo Escobedo Del Cid on 03/29/05 10:03 AM

Just for hopefully helping someone else...

I fixed it, it was a silly mistake of my part, I forgot to edit the nsd-oracle file. I just set the right SID, ORACLE_HOME and ORACLE_BASE and it was it, now everything is running ok (at least by the moment - oracle 10.1.0.3.0, openacs-5-1, aolserver4 and debian-testing).

Regards