On Mon, Apr 26, 2004 at 12:02:25PM +0100, Stuart Children wrote: > [23/Apr/2004:14:17:53][15952.4164528][-conn:server1::0] Error: > nsoracle.c:2926:Ns_OracleOpenDb: error in `OCISessionBegin ()': > ORA-00604: error occurred at recursive SQL level 1 > ORA-00911: invalid character > > I'm currently compiling against Oracle 9.2.0.1, and connecting to an 8i > server. Neither the Oracle demo applications that I've compiled up or > sqlplus have any problem establishing the same connection.
Oh, ** 9.2.0.1 ** ? That's VERY bad, the Oracle 9.2.0.1 client libs, at least on Linux, have enormously huge massive memory leaks, e.g., see: http://openacs.org/forums/message-view?message_id=142793 http://openacs.org/forums/message-view?message_id=152747 Besides that, using the 9i client libs like that might the problem. There seem to have been a few vague reports of certain versions of nsoracle maybe not working right with some 9i client libraries, but from those, it has not been clear to me what the problem is - or even if there really is any problem! (Your email is the clearest symptom report I'm aware of, btw.) See also: http://openacs.org/forums/message-view?message_id=124299 http://openacs.org/forums/message-view?message_id=62673 http://openacs.org/forums/message-view?message_id=175208 http://openacs.org/bugtracker/openacs/bug?bug_number=1720 http://openacs.org/forums/message-view?message_id=177730 http://openacs.org/forums/message-view?message_id=120496 http://openacs.org/forums/message-view?message_id=81045 Supposedly various different people have been running OpenACS successfully on Oracle 9i for a long time now, but I have never seen any precise report on exactly what versions of all the different software pieces those people are using. However, my guess is that those folks are most likely using all the same Oracle library versions on both the server AND the client. And I've definitely heard that Oracle changed various OCI APIs for 9i, so any mixed 8i server 9i client (or vice versa) may be much more likely to have problems. As of yet there are no Oracle 9i (or 10i for that matter) install instructions in the OpenACS docs, only 8.1.7. > What I haven't tried yet is a more recent 9i client (I've downloaded > 9.2.0.4, and am currently going through the hoops to fetch the patchsets > and get that installed), or using the 8i client. I hope to also have a 9i > database running next week to test connecting to. Additionally, I'll try > on one of our Solaris boxes - but I need to get the client libraries > installed on that first. I have not yet tried using 9i at all, anywhere, so I can't really be very helpful. But it sounds like you are well on your way to figuring out what the problem is exactly, so when you do please be sure to let us know! That would be REALLY helpful. -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com/ -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
