It should be ok, but I can't answer you from experience. You'll probably want to do some simple test on a trial new machine before migrating to additional machines. My experience involves making Perl work correctly on a build machine and then creating an executable for each of my perl applications using perl2exe, an IndigoStar product. This negates a dependency on the deployed machine for a valid Perl configuration.
I know about caveats involving ODBC bridge drivers and DBD::ODBC (at least, version 0.28), but not your scenario with DBD::Oracle. At 02:48 PM 4/24/2002 -0500, Mahdi A. Sbeih wrote: >What about if I move the whole perl,DBI and DBD-Oracle >to an identical machine without re-compiling, >and the new machine has different paths or ORACLE_HOME...etc. > >In other ways, during the compiling is there any paths hard coded >in the executable, like for example: >ORACLE_HOME=/oracle/u01/app/oracle/product/8.1.6 > > > >-----Original Message----- >From: Andrew Crum [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, April 24, 2002 4:08 PM >To: Mahdi A. Sbeih; [EMAIL PROTECTED] >Subject: RE: Oracle version of Informix >DBD_INFORMIX_RELOCATABLE_INFORMIXDIR env variable > > >At 01:30 PM 4/24/2002 -0500, you wrote: > >Hi Andrew, > > > >It seems I was not clear enough, let me explain, > > > >When compiling DBD-Informix, the INFORMIXDIR will > >be hard coded in the in the compiled DBD-Informix, > > > >This way If the INFORMIXDIR changes for any reason, > >I will not be able to use DBD-Informix. > > > >Because of the above, I set the environment variable: > >DBD_INFORMIX_RELOCATABLE_INFORMIXDIR to yes before > >compiling DBD-Informix, this way the INFORMIXDIR > >will not be hard coded in the compiled stuff and I will > >need to set LD_LIBRARY_PATH or SHLIB_PATH in order > >to use DBD-Informix, so I don't need to worry about > >INFORMIXDIR being changed. > > > >What I am trying to find: > >Is there a similar concept for DBD-Oracle? > > > >Please advice. > >I believe the user running the application which employs DBI->DBD:Oracle >must have the $ORACLE_HOME and $PATH settings >that are correct for the local Oracle setup. > >Your code's connect string would then provide the needed SID. > >The connect string syntax we used has the following syntax: > > $dbh = DBI->connect( dbi:Oracle:<Oracle Service Name>, <user>, <pswd>, > { PrintError => 0, RaiseError => 0, >AutoCommit => 1 } > ); > >No use of $LD_LIBRARY_PATH or equivalent. > >Of course the host machine for the perl application has Oracle client >software installed. > > > > > >Regards, > >Mahdi, > > > > > >-----Original Message----- > >From: Andrew Crum [mailto:[EMAIL PROTECTED]] > >Sent: Wednesday, April 24, 2002 3:03 PM > >To: [EMAIL PROTECTED] > >Subject: Re: Oracle version of Informix > >DBD_INFORMIX_RELOCATABLE_INFORMIXDIR env variable > > > > > > > >At 03:18 PM 4/24/2002 -0400, you wrote: > > >I think ORACLE_HOME may be what your looking for. Mine's set to > > >"/opt/oracle/product/8.1.7". > > > >Agreed. > > > >You will probably need a few more Oracle parameters set before you're done. > >If you can login as the oracle administrator and then run 'env' to view its > >shell variables, > > you are likely to discover other useful and possibly required > >Oracle-related settings. > >The same might also be found if you can locate a script named like >"*oraenv" > >- there are usually a few of them, one for a specific shell syntax. > > > > > > >HTH, > > >Dave > > > > > >On Apr 24, Mahdi A. Sbeih scribed: > > > > > > > Hi all, > > > > > > > > Is there a variable for Oracle like the one used before > > > > installing DBD-Informix in case of relocatable INFORMIXDIR > > > > or in oracle this is completely different. > > > > > > > > I know this may sound simple for you guys, but I am an > > > > Informix DBA, and never used Oracle before, so some > > > > hints will be appreciated. > > > > > > > > > > > > > > > > Regards, > > > > Mahdi. > > > > > > > > > > > > > > > >-----
