Hi Andrew On Mon, Apr 26, 2004 at 11:03:14AM -0400, Andrew Piskorski wrote: > 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: [snip]
Yeah, I'd seen some bad things which is why I was planning to upgrade, but had hoped that they would at least connect. > 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. Our DBA believes that a 9i client should be able to connect to an 8i server no problem. The other way round is more problematic, but should work providing you're using above a certain version of 8, and don't do certain things - so probably best to avoid. However, there's theory and practice. :) > 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. Definitely will do. Update so far: I got the OCI headers installed on another [Linux] machine that had an 8i client on it, so I compiled stuff up there and it's all working beautifully. Compiling nsoracle against 8.1.6 client libraries I can connect to servers running both 8.1.7.4 and 9.2.0.4. So that's positive. Unfortunately that machine does have differences other than the Oracle client version, but I'm inclined to agree that the problem was with the 9i client. We are moving to 9i, so I do want to get things working with its client. Once I've got the utterly horrible installer to stick 9.2.0.4 on my original machine I'll report back with more details. Cheers -- Stuart -- 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.
