RE: [dbi] DBD::Oracle, Instantclient and HP-UX...

Tree setting SHLIB_PATH to the same value as LD_LIBRARY_PATH. Try doing
this before you build DBD::Oracle. (You are doing this with a perl you
have built right?)

If/when you get it work, try patching Makefile.PL to find the libraries
and includes so that it builds the right Makefile, if you get that work,
and send the patch to me or to Tim.

Lincoln

On Fri, 2005-08-19 at 11:16 +0200, michael.peppler@bnpparibas.com wrote:
> Thanks Martin,
>
> Unfortunately unsetting ORACLE_HOME didn't fix that problem (i.e.
> OCIEnvCreate still fails).
>
> Michael
>
>
>
>
>
> Extranet
> martin.evans@easysoft.com - 19/08/2005 10:43
>
>
> To: dbi-users
> cc:
> Subject: RE: [dbi] DBD::Oracle, Instantclient and HP-UX...
>
>
> Michael,
>
> I think with InstantClient OCIEnvCreate fails if you set ORACLE_HOME. You
> need
> to make sure libclntsh.so is on your dynamic linker search path
> (LD_LIBRARY_PATH) and do /not/ set ORACLE_HOME.
>
> Martin
> --
> Martin J. Evans
> Easysoft Ltd, UK
> Development
>
>
> On 19-Aug-2005 michael.peppler@bnpparibas.com wrote:
> > Hi,
> >
> > I'm not exactly new to DBI, but I am *very* new to Oracle, so please
> bear
> > with me...
> >
> > I'm trying to build DBD::Oracle on an HP-UX (11.11) box with the 32bit
> > instantclient package, and while the build works the make test fails,
> and
> > my googling has failed to turn up any solutions.
> >
> > I've patched the Makefile.PL so that the include files and lib files are
> > found, but the version detection doesn't appear to work.
> >
> > If I build with "perl Makefile.PL -l" I get the following error during
> > make test:
> >
> > oracle@gvasphp1:/pvar/dba/src/DBD-Oracle-1.16 $perl -Mblib t/10general.t
> > 1..31
> > DBI connect('','ops$pepm/mike',...) failed: (UNKNOWN OCI STATUS 1804)
> > OCIInitialize. Check ORACLE_HOME and NLS settings etc. at t/10general.t
> > line 12
> > Undefined subroutine &main::BAILOUT called at t/10general.t line 15.
> ># Looks like your test died before it could output anything.
> >
> >
> > If I try to force the client version to 10.x with -V 10.0 I get:
> >
> > oracle@gvasphp1:/pvar/dba/src/DBD-Oracle-1.16 $perl -Mblib t/10general.t
> > 1..31
> > DBI connect('','ops$pepm/mike',...) failed: ERROR OCIEnvNlsCreate (check
> > ORACLE_HOME and NLS settings etc.) at t/10general.t line 12
> >
> >
> > I suspect that it's something fairly simple, but I can't seem to find
> the
> > right incantation to get it to work.
> >
> > Thanks!
> >
> > Michael
> >
>
>
>
> This message and any attachments (the "message") is
> intended solely for the addressees and is confidential.
> If you receive this message in error, please delete it and
> immediately notify the sender. Any use not in accord with
> its purpose, any dissemination or disclosure, either whole
> or partial, is prohibited except formal approval. The internet
> can not guarantee the integrity of this message.
> BNP PARIBAS (and its subsidiaries) shall (will) not
> therefore be liable for the message if modified.
>
> ---------------------------------------------
>
> Ce message et toutes les pieces jointes (ci-apres le
> "message") sont etablis a l'intention exclusive de ses
> destinataires et sont confidentiels. Si vous recevez ce
> message par erreur, merci de le detruire et d'en avertir
> immediatement l'expediteur. Toute utilisation de ce
> message non conforme a sa destination, toute diffusion
> ou toute publication, totale ou partielle, est interdite, sauf
> autorisation expresse. L'internet ne permettant pas
> d'assurer l'integrite de ce message, BNP PARIBAS (et ses
> filiales) decline(nt) toute responsabilite au titre de ce
> message, dans l'hypothese ou il aurait ete modifie.
>