RE: OCI Initialize failed 1804 check ORACLE_HOME NLS_SETTINGS

On Wed, 2006-05-31 at 19:38 +0530, rajarathnam, devaraj wrote:
> Hi John,
>
> Thanks for your mails!
>
> I tried to compile DBD:Oracle 1.15 with Oracle 10g client on HP-UX11.11
> PA_RISC2.0 machine.
>
> As in README.hpux I used -l option and set ORACLE_SID as @.
>
> But when I tried make test I got the following error:
>
> ld: /opt/oracle/product/10.2.0/lib/libclntsh.sl: Mismatched ABI. 64-bit
> PA share
> d library found in 32-bit link.
>
If have compiled perl for 32bit support, and you are using the 64bit
oracle libraries. I beleive you can get it to work, simply by using
/opt/oracle/product/10.2.0/lib32/ instead of .../lib/. (If you did not
compile perl you need to... and while you are at it, consider using a
5.8.x version of perl.

I think you might also consider using DBD-Oracle 1.16 or later. I
believe the Makefile.PL in that version and later better job off finding
the correct oracle library dir (I think I fixed that in 1.16).

(Oracle switched around the 32 and 64 bit defaults in the library
directories from /lib/ (=32bit) with /lib64 to /lib/ (=64bit)
with /lib32.

Lincoln


> What am I missing? Please could you help me?
>
>
> Thanks and Regards,
>
> Devaraj
> -----Original Message-----
> From: John Scoles [mailto:scoles@pythian.com]
> Sent: 31 May 2006 4:19 PM
> To: rajarathnam, devaraj
> Subject: Re: OCI Initialize failed 1804r
>
> You should not have to recompile Perl again but you will have to
> recompile DBD:Oracle for the 10g client. Fortunately you can use PPM to
> install the latest version of DBI.
> Cheers
>
> John Scoles
> ----- Original Message -----
> From: "rajarathnam, devaraj"
> To: "John Scoles"
> Cc:
> Sent: Wednesday, May 31, 2006 12:52 AM
> Subject: RE: OCI Initialize failed 1804r
>
>
>
> Hi John,
>
> I am using Oracle 10g client, so I infer that I need to compile
> DBD:Oracle with Oracle 10g client. But to compile DBD:Oracle with Oracle
> 10g client, do I need to start to compile Perl 5.6.1 again? If so can I
> use PPM to install Perl. Is PPM available for HP-UX.
>
> Please could you suggest me HP-UX Perl 5 mailing lists?
>
> Thanks and Regards,
>
> Devaraj
>
> -----Original Message-----
> From: John Scoles [mailto:scoles@pythian.com]
> Sent: 30 May 2006 7:22 PM
> To: rajarathnam, devaraj
> Subject: Re: OCI Initialize failed 1804r
>
> If you are still using the old Oracle 9i client no.
>
> If you have changed your Oracle client to 10g or instantclient then you
> will have to recompile your DBD::Oracle but there is no need to
> recompile DBI unless it is a very old version. If that is the case I
> would use PPM to get the latest version of DBI rather than compile it
> myself.
>
>
> ----- Original Message -----
> From: "rajarathnam, devaraj"
> To:
> Sent: Tuesday, May 30, 2006 9:31 AM
> Subject: OCI Initialize failed 1804r
>
>
>
> Hi,
>
> I have a perl 5.6.1 installation with DBI and DBD:Oracle with Oracle 9i
>
> When I try to run a script to make a connection with Oracle 10g using
> the above Perl executable, I get the error Unable to initialize OCI, OCI
> Initialize failed 1804.
>
> Do I need to compile Perl, DBI and DBD with Oracle 10g to solve this
> problem.
>
> Kindly let me know.
>
> Thanks and Regards,
> Devaraj
>
>
>