X-Recipient: archive-cygwin AT delorie DOT com
X-Spam-Check-By: sourceware.org
Message-ID: <6910a60804161219w52e6b08frc7eb97e02a29536c@mail.gmail.com>
Date: Wed, 16 Apr 2008 21:19:54 +0200
From: "Reini Urban" <rurban AT x-ray DOT at>
To: cygwin AT cygwin DOT com
Subject: Re: Trouble installing DBD::Oracle on Cygwin
In-Reply-To: <564046.43376.qm@web46014.mail.sp1.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=WINDOWS-1252
Content-Disposition: inline
References: <564046 DOT 43376 DOT qm AT web46014 DOT mail DOT sp1 DOT yahoo DOT com>
X-Google-Sender-Auth: 9c9892ac9bcda734
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Precedence: bulk
List-Id: <cygwin.cygwin.com>
List-Unsubscribe: <mailto:cygwin-unsubscribe-archive-cygwin=delorie DOT com AT cygwin DOT 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
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by delorie.com id m3GJQvkc015109

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/