I have perl 5.8 DBD/DBI (latest versions) - with linux 7.2 and advanced server 2.1 both working with Oracle Client 8.1.7 and 9.2.0 -- talking to 8i and 9.2 dbs -- no problems with a few caveats.
The limitation you will find is that Oracle support for the 8.1.7 stops at RH 7.1, it was originally built for RH 6.2 (glibc 2.1.3) so in order to make it work you will need to add the compat-* packages for gcc, libs and glibc and do a little bending and hacking with java to get it to install. The same goes for RH 7.2 and 8.1.7. For 9.2 virtually no support for anything other than RH advanced server 2.1 (which is based on the RH 7.2) but the client does work on 7.2 no probs. Also there seems to be an issue with the 9.2.0.2 and 9.2.0.3 OCI (client) where I have experienced corruption of data when RowCacheSize is used. I have an Oracle TAR opened on this issue. An important item that you will need to respect is that an Oracle.so (DBD) compiled and linked for 8i will not work against a 9i set of libs and visa versa. You will need to compile and link against the Oracle Client you plan to use. I have not tested Oracle Client with RH 8.0 -- but a quick scan of the Oracle forums lends one to believe that it is not the easiest way to go -- Oracle is very fussy about the stability / difference of the OS release as compared to the release that Oracle was built against. Thats why we are using RH 7.2 and AS 2.1, it works --- anything else caveat utilitor.
As for Oracle client versions my picks are either 8.1.7.4 (8i) or 9.2.0.1 (9i r2). Most important ! if you are messing with Oracle you should have a Metalink account for Oracle support -- if not then you should check the forums that are publicly available for Oracle-ish matters of all kinds. You will need this info for doing 8.1.7 -- its just not a pleasant task if you try doing it on your own cold-turkey.
I hope this helps...
BN
Tim Bunce wrote:
----- Forwarded message from Erez Strauss <[EMAIL PROTECTED]> -----
Delivered-To: [EMAIL PROTECTED] From: Erez Strauss <[EMAIL PROTECTED]> To: "'Tim Bunce'" <[EMAIL PROTECTED]> Subject: DBD::Oracle RH8.0/9.0 Oracle 9i Date: Sun, 29 Jun 2003 18:18:56 +0300
Hi Tim,
I would like to access Oracle 9i server using perl. I understand from the docs that your DB driver is for 7i and 8i. Would it work with 9i ? Any limitations ?
I'm working with perl 5.8.0 and RedHat 8.0 - should I expect problems ? Where / what is the latest recommended version ?
Thanks a lot
Erez Strauss
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
----- End forwarded message -----
