Haven't had to deal with this myself but here is my thoughts Build DBD against 9i Make sure your 8i SID/DB Name is available in the tnsnames file of the 9i oracle home. The 9i client should be able to connect to the 8i database. So alsong as you leave the oracle home set to the 9i home everything should be fine.
Ken. -----Original Message----- From: Levenson, Elliott [mailto:ELevenson@;MSA.com] Sent: 04 November 2002 16:58 To: '[EMAIL PROTECTED]' Subject: Getting DBD::Oracle 1.12 to run against both 8i and 9i If someone kindly has thoughts on this matter, The situation, simplified: Two oracle instances on a Tru-64 UNIX server. One is 9i one is 8i. DBD will run against one or the other depending on which it is compiled against. Currently it is compiled against 9i, so when I try to run DBI/DBD::Oracle against an 8i instance, it blows up: install_driver(Oracle) failed: Can't load '/usr/lib/perl-5.6.0/lib/site_perl/5.6.0/alpha-dec_osf/auto/DBD/Oracle/Oracl e.so' for module DBD::Oracle: dlopen: Cannot map library libclntsh.so.9.0 at /usr/lib/perl-5.6.0/lib/5.6.0/alpha-dec_osf/DynaLoader.pm line 200. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected Has anyone dealt with this? One thought is: Will it work if I install a second DBD::Oracle 1.12 against Oracle 8i and create another directory to put it into without the two DBD's stepping on each other? A second thought, would a change to the paths in the makefile help so it references either 8i or 9i? Any thoughts would be greatly appreciated. Thanks, Elliott Levenson Management Science Associates, Inc. Sr. Quality Assurance Analyst (412) 362-8929 x 2072 [EMAIL PROTECTED]
