RE: Seek help installing DBD::Oracle
You need to install the full Oracle client. Do not try to piece-meal an install. - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: McLean, Emmett (HQP) [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 5:58 PM To: dbi-users@perl.org Subject: Seek help installing DBD::Oracle Hi, Opon attemping a DBD::Oracle install it appears that I must install OCI first to get oci.h ... But if I attempt to install OCI first it baulks that it can't find Oracle.pm Any suggestions? Here is the DBD::Oracle install attempt : System: perl5.008002 cygwin_nt-5.0 troubardix 1.5.5(0.9432) 2003-09-20 16:31 i686 unknown unknown cygwin Compiler: gcc -O2 -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing Linker: /usr/bin/ld Sysliblist: Warning: If you have problems you may need to rebuild perl with -Uusemymalloc. Checking if your kit is complete... Looks good LD_RUN_PATH=c:/oracle/ora92/lib:c:/oracle/ora92/rdbms/lib Using DBD::Oracle 1.16. Using DBD::Oracle 1.16. Using DBI 1.48 (for perl 5.008002 on cygwin-thread-multi-64int) installed in /usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI/ Writing Makefile for DBD::Oracle *** If you have problems... read all the log printed above, and the README and README.help files. (Of course, you have read README by now anyway, haven't you?) /cygdrive/c/code/dbd/DBD-Oracle-1.16 make cp Oracle.pm blib/lib/DBD/Oracle.pm 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 lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm /usr/bin/perl.exe -p -e s/~DRIVER~/Oracle/g /usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI//Drive r.xst Oracle.xsi /usr/bin/perl.exe /usr/lib/perl5/5.8.2/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.2/ExtUtils/typemap -typemap typemap Oracle.xs Oracle.xsc mv Oracle.xsc Oracle.c gcc -c -Ic:/oracle/ora92/oci/include -Ic:/oracle/ora92/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI/ -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\1.16\ -DXS_VERSION=\1.16\ -I/usr/lib/perl5/5.8.2/cygwin-thread-multi-64int/CORE -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\9.2.0\ Oracle.c In file included from Oracle.h:20, from Oracle.xs:1: dbdimp.h:44:17: oci.h: No such file or directory dbdimp.h:46:20: ocidfn.h: No such file or directory In file included from Oracle.h:20, from Oracle.xs:1: dbdimp.h:59: error: syntax error before OCIEnv dbdimp.h:59: warning: no semicolon at end of struct or union dbdimp.h:66: error: syntax error before '}' token dbdimp.h:80: error: syntax error before OCIEnv dbdimp.h:80: warning: no semicolon at end of struct or union dbdimp.h:81: warning: type defaults to `int' in declaration of `errhp' dbdimp.h:81: warning: data definition has no type or storage class dbdimp.h:82: error: syntax error before '*' token dbdimp.h:82: warning: type defaults to `int' in declaration of `srvhp' This is happens when attempting to run the boot script from the OCI distribution . /cygdrive/c/code/oci/Oracle-OCI-0.05./boot Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/lib/perl5/5.8.2/cygwin-thread-multi-64int /usr/lib/perl5/5.8.2 /usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl .) at ./boot line 15. BEGIN failed--compilation aborted at ./boot line 15. /cygdrive/c/code/oci/Oracle-OCI-0.05cd ../*6 /cygdrive/c/code/oci/Oracle-OCI-0.06./boot Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/lib/perl5/5.8.2/cygwin-thread-multi-64int /usr/lib/perl5/5.8.2 /usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl .) at ./boot line 15. BEGIN failed--compilation aborted at ./boot line 15. /cygdrive/c/code/oci/Oracle-OCI-0.06ext Emmett McLean WebFO/IT Applications Robert Half International Phone: 925-598-5244 Email: [EMAIL PROTECTED] This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution 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.
Seek help installing DBD::Oracle
Hi, Opon attemping a DBD::Oracle install it appears that I must install OCI first to get oci.h ... But if I attempt to install OCI first it baulks that it can't find Oracle.pm Any suggestions? Here is the DBD::Oracle install attempt : System: perl5.008002 cygwin_nt-5.0 troubardix 1.5.5(0.9432) 2003-09-20 16:31 i686 unknown unknown cygwin Compiler: gcc -O2 -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing Linker: /usr/bin/ld Sysliblist: Warning: If you have problems you may need to rebuild perl with -Uusemymalloc. Checking if your kit is complete... Looks good LD_RUN_PATH=c:/oracle/ora92/lib:c:/oracle/ora92/rdbms/lib Using DBD::Oracle 1.16. Using DBD::Oracle 1.16. Using DBI 1.48 (for perl 5.008002 on cygwin-thread-multi-64int) installed in /usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI/ Writing Makefile for DBD::Oracle *** If you have problems... read all the log printed above, and the README and README.help files. (Of course, you have read README by now anyway, haven't you?) /cygdrive/c/code/dbd/DBD-Oracle-1.16 make cp Oracle.pm blib/lib/DBD/Oracle.pm 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 lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm /usr/bin/perl.exe -p -e s/~DRIVER~/Oracle/g /usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI//Drive r.xst Oracle.xsi /usr/bin/perl.exe /usr/lib/perl5/5.8.2/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.2/ExtUtils/typemap -typemap typemap Oracle.xs Oracle.xsc mv Oracle.xsc Oracle.c gcc -c -Ic:/oracle/ora92/oci/include -Ic:/oracle/ora92/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI/ -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\1.16\ -DXS_VERSION=\1.16\ -I/usr/lib/perl5/5.8.2/cygwin-thread-multi-64int/CORE -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\9.2.0\ Oracle.c In file included from Oracle.h:20, from Oracle.xs:1: dbdimp.h:44:17: oci.h: No such file or directory dbdimp.h:46:20: ocidfn.h: No such file or directory In file included from Oracle.h:20, from Oracle.xs:1: dbdimp.h:59: error: syntax error before OCIEnv dbdimp.h:59: warning: no semicolon at end of struct or union dbdimp.h:66: error: syntax error before '}' token dbdimp.h:80: error: syntax error before OCIEnv dbdimp.h:80: warning: no semicolon at end of struct or union dbdimp.h:81: warning: type defaults to `int' in declaration of `errhp' dbdimp.h:81: warning: data definition has no type or storage class dbdimp.h:82: error: syntax error before '*' token dbdimp.h:82: warning: type defaults to `int' in declaration of `srvhp' This is happens when attempting to run the boot script from the OCI distribution . /cygdrive/c/code/oci/Oracle-OCI-0.05./boot Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/lib/perl5/5.8.2/cygwin-thread-multi-64int /usr/lib/perl5/5.8.2 /usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl .) at ./boot line 15. BEGIN failed--compilation aborted at ./boot line 15. /cygdrive/c/code/oci/Oracle-OCI-0.05cd ../*6 /cygdrive/c/code/oci/Oracle-OCI-0.06./boot Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/lib/perl5/5.8.2/cygwin-thread-multi-64int /usr/lib/perl5/5.8.2 /usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl .) at ./boot line 15. BEGIN failed--compilation aborted at ./boot line 15. /cygdrive/c/code/oci/Oracle-OCI-0.06ext Emmett McLean WebFO/IT Applications Robert Half International Phone: 925-598-5244 Email: [EMAIL PROTECTED]
Re: Seek help installing DBD::Oracle
On 06/14/2005 04:58 PM, McLean, Emmett (HQP) said: Hi, Opon attemping a DBD::Oracle install it appears that I must install OCI first to get oci.h ... But if I attempt to install OCI first it baulks that it can't find Oracle.pm Any suggestions? Here is the DBD::Oracle install attempt : System: perl5.008002 cygwin_nt-5.0 troubardix 1.5.5(0.9432) 2003-09-20 16:31 i686 unknown unknown cygwin Compiler: gcc -O2 -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing Linker: /usr/bin/ld Sysliblist: Warning: If you have problems you may need to rebuild perl with -Uusemymalloc. Checking if your kit is complete... Looks good LD_RUN_PATH=c:/oracle/ora92/lib:c:/oracle/ora92/rdbms/lib Using DBD::Oracle 1.16. Using DBD::Oracle 1.16. Using DBI 1.48 (for perl 5.008002 on cygwin-thread-multi-64int) installed in /usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI/ Writing Makefile for DBD::Oracle *** If you have problems... read all the log printed above, and the README and README.help files. (Of course, you have read README by now anyway, haven't you?) /cygdrive/c/code/dbd/DBD-Oracle-1.16 make cp Oracle.pm blib/lib/DBD/Oracle.pm 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 lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm /usr/bin/perl.exe -p -e s/~DRIVER~/Oracle/g /usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI//Drive r.xst Oracle.xsi /usr/bin/perl.exe /usr/lib/perl5/5.8.2/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.2/ExtUtils/typemap -typemap typemap Oracle.xs Oracle.xsc mv Oracle.xsc Oracle.c gcc -c -Ic:/oracle/ora92/oci/include -Ic:/oracle/ora92/rdbms/demo -I/usr/lib/perl5/site_perl/5.8.2/cygwin-thread-multi-64int/auto/DBI/ -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\1.16\ -DXS_VERSION=\1.16\ -I/usr/lib/perl5/5.8.2/cygwin-thread-multi-64int/CORE -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\9.2.0\ Oracle.c In file included from Oracle.h:20, from Oracle.xs:1: dbdimp.h:44:17: oci.h: No such file or directory dbdimp.h:46:20: ocidfn.h: No such file or directory In file included from Oracle.h:20, from Oracle.xs:1: The oci.h and ocidfn.h it is looking for is from Oracle's OCI or Pro*C packages, not the Perl Oracle::OCI module. It's odd that there isn't a complaint in the output of `perl Makefile.PL`. -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.