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
>