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 @<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.

What am I missing? Please could you help me?


Thanks and Regards,

Devaraj
-----Original Message-----
From: John Scoles [mailto:scoles@xxxxxxxxxxx]
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" <devaraj.rajarathnam@xxxxxx>
To: "John Scoles" <scoles@xxxxxxxxxxx>
Cc: <dbi-users@xxxxxxxx>
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@xxxxxxxxxxx]
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" <devaraj.rajarathnam@xxxxxx>
To: <dbi-users@xxxxxxxx>
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



.

Relevant Pages

  • Re: DBD Oracle 1.20 ORA-24334 Error
    ... On the premise instant client and also tried to run perl Makefile.PL -V ... the status after having connected to Oracle ... Failed 2/33 tests, 93.94% okay ...
    (perl.dbi.users)
  • Re: dbd Oracle 10g AIX - install nightmare..... :<
    ... Rebuild perl with -Duse64bitall flag. ... problems with this (it's the same error as some people got with oracle ... Be sure you compile the makefiles with the right perl version;) ...
    (perl.dbi.users)
  • RE: OCI Initialize failed 1804 check ORACLE_HOME NLS_SETTINGS
    ... I tried to compile DBD:Oracle 1.15 with Oracle 10g client on HP-UX11.11 ... If have compiled perl for 32bit support, and you are using the 64bit ...
    (perl.dbi.users)
  • RE: Accessing oracle from windows 2000
    ... platforms (with caveats and issues that will be outlined below. ... I use DBD::Oracle when using an Oracle data source. ... You need to have the Oracle client installed -- and licensed -- on your ... while ago (after the Perl 5.6.x timeframe and before 5.8.x timeframe). ...
    (perl.dbi.users)
  • Re: DBD::Oracle / Instant Client segfaults
    ... I've been doing some more tests concerning this issue and it seems that it only appears with the combination of Oracle Instant client libraries, Perl configured with -Dusemymalloc on RHEL 3. ... When i run the script with the 'use Digest::SHA1;' line commented ...
    (perl.dbi.users)