OCI Initialize failed 1804r

------_=_NextPart_001_01C683ED.BF068DEF
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable


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


------_=_NextPart_001_01C683ED.BF068DEF--

RE: OCI Initialize failed 1804r

=20
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]=20
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

RE: OCI Initialize failed 1804r

You will need to determine the source of your Perl binary. The best way
to determine this is to:

$ perl -V

And look for which C compiler was used to build Perl. If your Perl is
not from ActiveState, I believe you will not be able to use ppm at all.

If you indeed, need to rebuild Perl, you should build Perl 5.8.8 and
install the latest DBI and DBD::Oracle modules. Be sure to read the
README* files prior to installation, so you understand exactly what is
will be happening.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: rajarathnam, devaraj [mailto:devaraj.rajarathnam@hp.com]=20
Sent: Tuesday, May 30, 2006 10:52 PM
To: John Scoles
Cc: dbi-users@perl.org
Subject: RE: OCI Initialize failed 1804r

=20
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]=20
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



This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.