X-Recipient:	archive-cygwin AT delorie DOT com
X-Spam-Check-By:	sourceware.org
X-Yahoo-Newman-Property:	ymail-5
X-Yahoo-Newman-Id:	673502 DOT 77040 DOT bm AT omp400 DOT mail DOT sp1 DOT yahoo DOT com
X-YMail-OSG:	SQLlhpMVM1m4FzNG3rdAV3pD378kn_oyIvq1mICIwnHpBt3oqJ2bGoHfL7fPs2H5Zw--
X-Mailer:	YahooMailRC/902.40 YahooMailWebService/0.7.185
Date:	Wed, 16 Apr 2008 13:50:25 -0700 (PDT)
From:	Dunston Rocks <rocksdunston AT yahoo DOT com>
Subject:	Re: Trouble installing DBD::Oracle on Cygwin
To:	Reini Urban <rurban AT x-ray DOT at>, cygwin AT cygwin DOT com
MIME-Version:	1.0
Message-ID:	<426315.10576.qm@web46009.mail.sp1.yahoo.com>
X-IsSubscribed:	yes
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
X-MIME-Autoconverted:	from quoted-printable to 8bit by delorie.com id m3GKp7Ul028849

I can't seem to find any of the header files oci.h, Oracle.h:37:17: oci.h: No such file or directory
Oracle.h:39:20: ocidfn.h: No such file or directory
Oracle.h:40:18: orid.h: No such file or directory
Oracle.h:41:17: ori.h: No such file or directory
under C:\oracle\

I realize I should have checked for this before, but does anyone know where I can download them from?

Dunston
----- Original Message ----
From: Reini Urban <rurban AT x-ray DOT at>
To: cygwin AT cygwin DOT com
Sent: Wednesday, April 16, 2008 3:19:54 PM
Subject: Re: Trouble installing DBD::Oracle on Cygwin

2008/4/16, Dunston Rocks:
> Hilling DBD::Oracle on Cygwin
>  Steps followed  :
>   Download from CPAN
>  tar –zxvf  DBD-Oracle-1.20.tar.gz
>  cd DBD-Oracle-1.20
>  make  realclean
>  perl Makefile.pl
>  make : *** [ Oracle.o ]  Error 1 ; output attached (make_results.txt)
>  perl – V (attached :  perl_V.out)
>  make  realclean
>  perl Makefile.pl -g
>  make (Same error as  above in Step 6) ) ;
>  output attached (make_results_debugmode.txt)
>  Oracle 10g Client at  C:\oracle\product\10.2.0\client_2
>  ORACLE_HOME set to  above
>  SQLPLUS set to  "C:\oracle\product\10.2.0\client_2\bin\sqllplus" and
>  am able to connect to all  databases in   C:\oracle\product\10.2.0\client_2\network\ADMIN\tnsnames.ora from cygwin bash shell
>  Cygwin Installation : A  complete installation from latest build from Cygwin.com on April 10th 2008
>  DBI is installed, but  attempting to run code that uses DBD::Oracle throws below error    install_driver(Oracle)  failed: Can't locate DBD/Oracle..pm in @INC (@INC contains: %PERL5LIB%;C  \Documents and Settings\dunston\My  Documents\scripts\parse;C \Program Files\Mozilla  Firefox\tpsf;C \Documents and Settings\dunston\My  Documents\scripts\parse;C \Program Files\Mozilla  Firefox\tpsf /usr/lib/perl5/5.8/cygwin /usr/lib/perl5/5.8  /usr/lib/perl5/site_perl/5..8/cygwin /usr/lib/perl5/site_perl/5.8  /usr/lib/perl5/site_perl/5.8 /usr/lib/perl5/vendor_perl/5.8/cygwin  /usr/lib/perl5/vendor_perl/5..8 /usr/lib/perl5/vendor_perl/5.8 .) at (eval 3)  line 3.

Change your PERL5LIB to a sane value.
I know, Oracle 10 messes up the PERL5LIB environment variable,
because they ship their own perl and apache.
I just unset PERL5LIB and add the POSIX paths of the Oracle dirs to
your perl Makefile.PL
line..

$ PERL5LIB= ORACLE_HOME=/cygdrive/oracle/product/10.2.0/client_2 perl
Makefile.PL

maybe add
-h <path to headers>

Also check out
http://search.cpan.org/src/PYTHIAN/DBD-Oracle-1.21/README.wingcc.txt
if the importlib was correctly created.

>  Would appreciate your input on  installing this library in Cygwin
>   Thanks
>
>
>
>  ------
>  gcc -g -c  -IC:/oracle/product/10.2.0/client_2/oci/include

gcc cannot handle this path anymore!
/cygdrive/c/oracle/product/10.2.0/client_2/oci/include is better.

-IC:/oracle/product/10.2.0/client_2/rdbms/demo
-I/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI -g
-DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -DUSEIMPORTLIB    -DVERSION=\"1.20\"
-DXS_VERSION=\"1.20\"  "-I/usr/lib/perl5/5.8/cygwin/CORE"  -Wall
-Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT
-DORA_OCI_VERSION=\"9.2.0.1\" Oracle.c
>  In file included from Oracle.xs:1:
>  Oracle.h:37:17: oci.h: No such file or directory
>  Oracle.h:39:20: ocidfn.h: No such file or directory
>  Oracle.h:40:18: orid.h: No such file or directory
>  Oracle.h:41:17: ori.h: No such file or directory
-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/






      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -