Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Seek help installing DBD::Oracle

1 view
Skip to first unread message

Emmett McLean

unread,
Jun 14, 2005, 7:58:26 PM6/14/05
to dbi-...@perl.org
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.05>cd ../*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.06>ext

Emmett McLean
WebFO/IT Applications
Robert Half International
Phone: 925-598-5244
Email: emmett...@rhi.com

Michael A Chase

unread,
Jun 14, 2005, 8:58:02 PM6/14/05
to McLean, Emmett (HQP), dbi-...@perl.org

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.

Ron Reidy

unread,
Jun 15, 2005, 10:08:49 AM6/15/05
to McLean, Emmett (HQP), dbi-...@perl.org
You need to install the full Oracle client. Do not try to piece-meal an install.

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.


Hi,

Any suggestions?


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.

0 new messages