HI, My first post and I forgot the basics: OS - RedHat 4 and 5
Perl version 5.8.8 DBD::Oracle version: 1.27 Regards Pete On 28 January 2011 16:44, Peter Hitchman <pjhli...@googlemail.com> wrote: > Hi, > I have been having problems with DBD::Oracle when I tried to use a > different Oracle client version from the database server. > In this case the client is 11.2.0.2.0 and the database is 11.1.0.6.0. > > When I set my client to the 11.2 version, the connect to the database > failed with: > > "Connection to dB failed due to : ERROR OCIEnvNlsCreate. Check ORACLE_HOME > env var, NLS settings, permissions, etc.." > > > > This is because using LD_RUN_PATH when compiling, causes the dynamic > runtime linker to first look in the ORACLE_HOME > > used when Oracle.so was compiled, when executing the code. So the end > result is a mixture of versions of the Oracle libraries being > > used, if the the environment is switched to another Oracle version. > > > So what I found was that if I commented out the LD_RUN_PATH from the > makefile and re-installed the module that I could connect > > no matter what client version I used. > > > From browsing the net, it looks to me that the use of LD_RUN_PATH was > added, but to me its use just stops easily changing Oracle clients. > > Does any one have any more information on this, I would like to check that > I am not missing something else fundamental. > > > Thanks > > Pete > > > >
