| Store | Cart

RE: OCI Initialize failed 1804 check ORACLE_HOME NLS_SETTINGS

From: Lincoln A. Baxter <l...@lincolnbaxter.com>
Wed, 31 May 2006 21:56:11 -0400
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 @<sid>.> > 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:sco...@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" <deva...@hp.com>> To: "John Scoles" <sco...@pythian.com>> Cc: <dbi-...@perl.org>> 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:sco...@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" <deva...@hp.com>> To: <dbi-...@perl.org>> 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> > > 

Recent Messages in this Thread
Lincoln A. Baxter Jun 01, 2006 01:56 am
rajarathnam, devaraj May 31, 2006 02:08 pm
Messages in this thread