"Inbal Mozes (DBA)" <[EMAIL PROTECTED]> writes: > I am trying to find a solution for multiplies oracle home on Unix machines . > Currently , for each new oracle home on the machine , a new compilation of perl with > DBD/DBI is necessary .
Well, it is not necessary to recompile Perl or DBI, a separate compilation of DBD::Oracle for each $ORACLE_HOME should be sufficient. Install each into an appropriate location (perl Makefile.PL PREFIX=$HOME/dbd-oracle-$ORACLE_HOME), and use the PERLLIB environment variable or 'use lib' statements to control which DBD::Oracle is loaded. Also, it should be perfectly possible to use a single $ORACLE_HOME for the client and still connect to multiple versions of the server. - Kristian.
