DBI-DBD::ORACLE EROR

------_=_NextPart_001_01C8625E.9B1D313D
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable


Hello ,

=20

Now I want to use DBI for my current project

Here I have trying to install DBD::ORACLE PACKAGE it is thronging error
And it is now allowing to install this package

=20

Please help us in installing this package

=20

Please tell me what are the steps to be taken care while installing this
packages

=20

I am getting following error while installing this package

=20

=20

While executing the perl MakefilePL is getting executed and the make
is failing with the following error

# make

cp Oraclepm blib/lib/DBD/Oraclepm

cp mktapl blib/lib/DBD/mktapl

cp oraperlph blib/lib/oraperlph

cp dbdimph blib/arch/auto/DBD/Oracle/dbdimph

cp ocitraceh blib/arch/auto/DBD/Oracle/ocitraceh

cp Oraperlpm blib/lib/Oraperlpm

cp Oracleh blib/arch/auto/DBD/Oracle/Oracleh

cp mkpm blib/arch/auto/DBD/Oracle/mkpm

cp lib/DBD/Oracle/GetInfopm blib/lib/DBD/Oracle/GetInfopm

/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g"
/opt/perl_32/lib/site_perl/588/PA-RISC1=
1-thread-multi/auto/DBI/Driver
..xst > Oraclexsi

/usr/bin/perl /opt/perl_32/lib/588/ExtUtils/xsubpp -typemap
/opt/perl_32/lib/588/ExtUtils/typemap -typemap typemap Oraclexs >
Oraclexsc && mv Oraclexsc Oraclec

cc -c -I/opt/app/oracle/product/9206/rdbms/demo -I
-I/opt/app/oracle/product/9206/precomp/public
-I/opt/app/oracle/product/9206/rdbms/public
-I/opt/app/oracle/product/9206/rdbms/demo
-I/opt/app/oracle/product/9206/plsql/public
-I/opt/app/oracle/product/9206/network/public
-I/opt/perl_32/lib/site_perl/588/PA-RISC11-thread-m ulti/auto/DBI
-D_POSIX_C_SOURCE=3D199506L -D_REENTRANT -Ae -D_HPUX_SOURCE
-Wl,+vnocompatwarnings +Z -DUSE_SITECUSTOMIZE -DNO_HASH_SEED
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64 -fast +Onolimit
+Opromote_indirect_calls +DAportable +DS20 -DVERSION=3D\"120\"
-DXS_VERSION=3D\"120\" +Z
"-I/opt/perl_32/lib/588/PA-RISC11-thread-multi/CORE " =
-DUTF8_SUPPORT
-DNEW_OCI_INIT -DORA_OCI_VERSION=3D\"9206\" Oraclec

cpp: "Oracleh", line 37: error 4036: Can't open include file 'ocih'=


cpp: "Oracleh", line 39: error 4036: Can't open include file
'ocidfnh'

cpp: "Oracleh", line 40: error 4036: Can't open include file 'oridh'=


cpp: "Oracleh", line 41: error 4036: Can't open include file 'orih'=


*** Error exit code 1

=20

Stop

=20

=20

=20

I am waiting for your reply

=20

I have Perl version V588

DBI version is 151

=20



This message contains information that may be privileged or confidential=
and is the property of the Capgemini Group It is intended only for the=
person to whom it is addressed If you are not the intended recipient, =
you are not authorized to read, print, retain, copy, disseminate, =
distribute, or use this message or any part thereof If you receive this=
message in error, please notify the sender immediately and delete all =
copies of this message

------_=_NextPart_001_01C8625E.9B1D313D--

Re: DBI-DBD::ORACLE EROR

It would be nice to see the output for the Makefile.PL as well

Looks like either one of few things

1) you do not have the full oracle 9 client installed
2) you do not have the ORACLE_HOME= or LD_LIBRARY_PATH set correctly
3) you do not have execute permissions on the *.h files

Have a look at the README.linux.txt and try some of the suggestions
there as well

cheers
John Scoles
Mohammed, Shafi wrote:
> Hello ,
>
>
>
> Now I want to use DBI for my current project.
>
> Here I have trying to install DBD::ORACLE PACKAGE it is thronging error.
> And it is now allowing to install this package.
>
>
>
> Please help us in installing this package.
>
>
>
> Please tell me what are the steps to be taken care while installing this
> packages.
>
>
>
> I am getting following error while installing this package.
>
>
>
>
>
> While executing the perl Makefile.PL is getting executed and the make
> is failing with the following error.
>
> # make
>
> cp Oracle.pm blib/lib/DBD/Oracle.pm
>
> cp mkta.pl blib/lib/DBD/mkta.pl
>
> cp oraperl.ph blib/lib/oraperl.ph
>
> cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
>
> cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
>
> cp Oraperl.pm blib/lib/Oraperl.pm
>
> cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
>
> cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
>
> cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
>
> /usr/bin/perl -p -e "s/~DRIVER~/Oracle/g"
> /opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/aut o/DBI/Driver
> ..xst > Oracle.xsi
>
> /usr/bin/perl /opt/perl_32/lib/5.8.8/ExtUtils/xsubpp -typemap
> /opt/perl_32/lib/5.8.8/ExtUtils/typemap -typemap typemap Oracle.xs >
> Oracle.xsc && mv Oracle.xsc Oracle.c
>
> cc -c -I/opt/app/oracle/product/9.2.0.6/rdbms/demo -I.
> -I/opt/app/oracle/product/9.2.0.6/precomp/public
> -I/opt/app/oracle/product/9.2.0.6/rdbms/public
> -I/opt/app/oracle/product/9.2.0.6/rdbms/demo
> -I/opt/app/oracle/product/9.2.0.6/plsql/public
> -I/opt/app/oracle/product/9.2.0.6/network/public
> -I/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/a uto/DBI
> -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE
> -Wl,+vnocompatwarnings +Z -DUSE_SITECUSTOMIZE -DNO_HASH_SEED
> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +Onolimit
> +Opromote_indirect_calls +DAportable +DS2.0 -DVERSION=\"1.20\"
> -DXS_VERSION=\"1.20\" +Z
> "-I/opt/perl_32/lib/5.8.8/PA-RISC1.1-thread-multi/CORE" -DUTF8_SUPPORT
> -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.6\" Oracle.c
>
> cpp: "Oracle.h", line 37: error 4036: Can't open include file 'oci.h'.
>
> cpp: "Oracle.h", line 39: error 4036: Can't open include file
> 'ocidfn.h'.
>
> cpp: "Oracle.h", line 40: error 4036: Can't open include file 'orid.h'.
>
> cpp: "Oracle.h", line 41: error 4036: Can't open include file 'ori.h'.
>
> *** Error exit code 1
>
>
>
> Stop.
>
>
>
>
>
>
>
> I am waiting for your reply.
>
>
>
> I have Perl version V5.8.8
>
> DBI version is 1.51
>
>
>
>
>
> This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
>
>

Re: DBI-DBD::ORACLE EROR

Hello!

On Tue, 29 Jan 2008, John Scoles wrote:

> It would be nice to see the output for the Makefile.PL as well
>
> Looks like either one of few things
>
> 1) you do not have the full oracle 9 client installed
> 2) you do not have the ORACLE_HOME= or LD_LIBRARY_PATH set correctly
> 3) you do not have execute permissions on the *.h files

You mean read permissions, don't you?

Bye. Alex.

RE: DBI-DBD::ORACLE EROR

I need following files.

Please give me these files.
It will helpful for me

cpp: "Oracle.h", line 37: error 4036: Can't open include file 'oci.h'.

cpp: "Oracle.h", line 39: error 4036: Can't open include file
'ocidfn.h'.

cpp: "Oracle.h", line 40: error 4036: Can't open include file 'orid.h'.

cpp: "Oracle.h", line 41: error 4036: Can't open include file 'ori.h'.

I need this files.

Regards,
Mohammed Shafi|Capgemini | Bengalooru
Main: +91 80 66567000|Extn: 4264
shafi.mohammed@capgemini.com
Join the Collaborative Business Experience at www.capgemini.com

-----Original Message-----
From: Alexander V Alekseev [mailto:alex@alemate.ru]
Sent: Tuesday, January 29, 2008 6:56 PM
To: John Scoles
Cc: Mohammed, Shafi; dbi-users@perl.org
Subject: Re: DBI-DBD::ORACLE EROR

Hello!

On Tue, 29 Jan 2008, John Scoles wrote:

> It would be nice to see the output for the Makefile.PL as well
>
> Looks like either one of few things
>
> 1) you do not have the full oracle 9 client installed
> 2) you do not have the ORACLE_HOME= or LD_LIBRARY_PATH set correctly
> 3) you do not have execute permissions on the *.h files

You mean read permissions, don't you?

Bye. Alex.

This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.

Re: DBI-DBD::ORACLE EROR

There are part of the Oracle client. Sending them to you will not help
you problem, and only break numerous copyright laws,
If you do not have them then you are missing your Oracle client or you
path/enlivenment is not pointing to the correct directory.

If you do not have a copy of the Oracle client go to the Oracle website
and download the Instantclient and use that one instead.

check out the README.64bit.txt and the README.hpux.txt read mes they
have very good instructions on what to do.

Mohammed, Shafi wrote:
> I need following files.
>
> Please give me these files.
> It will helpful for me
>
> cpp: "Oracle.h", line 37: error 4036: Can't open include file 'oci.h'.
>
> cpp: "Oracle.h", line 39: error 4036: Can't open include file
> 'ocidfn.h'.
>
> cpp: "Oracle.h", line 40: error 4036: Can't open include file 'orid.h'.
>
> cpp: "Oracle.h", line 41: error 4036: Can't open include file 'ori.h'.
>
> I need this files.
>
> Regards,
> Mohammed Shafi|Capgemini | Bengalooru
> Main: +91 80 66567000|Extn: 4264
> shafi.mohammed@capgemini.com
> Join the Collaborative Business Experience at www.capgemini.com
>
> -----Original Message-----
> From: Alexander V Alekseev [mailto:alex@alemate.ru]
> Sent: Tuesday, January 29, 2008 6:56 PM
> To: John Scoles
> Cc: Mohammed, Shafi; dbi-users@perl.org
> Subject: Re: DBI-DBD::ORACLE EROR
>
> Hello!
>
> On Tue, 29 Jan 2008, John Scoles wrote:
>
>
>> It would be nice to see the output for the Makefile.PL as well
>>
>> Looks like either one of few things
>>
>> 1) you do not have the full oracle 9 client installed
>> 2) you do not have the ORACLE_HOME= or LD_LIBRARY_PATH set correctly
>> 3) you do not have execute permissions on the *.h files
>>
>
> You mean read permissions, don't you?
>
> Bye. Alex.
>
> This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
>
>
>

Re: DBI-DBD::ORACLE EROR

------=_Part_19102_26709263.1201662891690
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Jan 29, 2008 5:31 AM, Mohammed, Shafi
wrote:

> I need following files.
>

As has already been explained to you -- you need to get those files from a
legitimate source, namely Oracle, or your authorized Oracle supplier.
Nothing else will work; no-one who respects the law will help you other than
by telling you to get them from Oracle.

Please wake up, read the messages, and act on them.

--
Jonathan Leffler #include
Guardian of DBD::Informix - v2007.0914 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

------=_Part_19102_26709263.1201662891690--

Re: DBI-DBD::ORACLE EROR

--wzJLGUyc3ArbnUjN
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2008-01-29 19:14:51 -0800, Jonathan Leffler wrote:
> On Jan 29, 2008 5:31 AM, Mohammed, Shafi
> wrote:
>=20
> > I need following files.
> >
>=20
> As has already been explained to you -- you need to get those files from a
> legitimate source, namely Oracle, or your authorized Oracle supplier.
> Nothing else will work; no-one who respects the law will help you other t=
han
> by telling you to get them from Oracle.

And from a technical point of view: Sending him these few files won't
help him. He does need the complete package, and the complete package is
available for free from the Oracle web-site, so that's simply the
easiest way for him to get it.

hp

--=20
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | hjp@wsr.ac.at | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users

--wzJLGUyc3ArbnUjN
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHoD3RMdFfQa64PCwRAteAAJ9x/EcsO6nPTLWO0KUez6/X3IPm/ACf elVg
kJ7Ms4x1PgaSMU2e9zxhC7k=
=hf+2
-----END PGP SIGNATURE-----

--wzJLGUyc3ArbnUjN--