RE: OCI Initialize failed 1804 check ORACLE_HOME NLS_SETTINGS

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.

What am I missing? Please could you help me?


Thanks and Regards,

Devaraj
-----Original Message-----
From: John Scoles [mailto:scoles@pythian.com]=20
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