Hi
I am using cygwin and running with perl version 5.10.1. I have a problem to install DBD-Oracle-1.44 package on my system.
I am plan to connect perl with my oracle. Below is the steps I have run through and hopefully somebody could guide me how to install the package on my system.
1. RUN PERL MAKEPERL.PL COMMAND
$ perl Makefile.PL
Using DBI 1.620 (for perl 5.010001 on i686-cygwin-thread-multi-64int)
+installed in /usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI/
Configuring DBD::Oracle for perl 5.010001 on cygwin (i686-cygwin-threa
+d-multi-64int)
Remember to actually *READ* the README file! Especially if you have an
+y problems.
cygwin warning:
MS-DOS style path detected: C:\oracle\product\11.1.0\db_1
Preferred POSIX equivalent is: /cygdrive/c/oracle/product/11.1.0/db_
+1
CYGWIN environment variable option "nodosfilewarning" turns off this
+ warning.
Consult the user's guide for more details about POSIX paths:
http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
Installing on a cygwin, Ver#1.7
Using Oracle in C:/oracle/product/11.1.0/db_1
DEFINE _SQLPLUS_RELEASE = "1101000600" (CHAR)
Oracle version 11.1.0.6 (11.1)
Found OCI directory
Using OCI directory 'OCI'
client_version=11.1
DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.1.0.6
+\" -DORA_OCI_102
Checking for functioning wait.ph
System: perl5.010001 cygwin_nt-5.1 reini 1.7.0(0.21853) 2009-12-04 17:
+08 i686 cygwin
Compiler: gcc -O3 -DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -fno-stri
+ct-aliasing -pipe -fstack-protector -I/usr/local/include
Linker: /usr/bin/ld
Sysliblist:
WARNING: If you have problems you may need to rebuild perl with -Uusem
+ymalloc.
LD_RUN_PATH=C:/oracle/product/11.1.0/db_1/lib:C:/oracle/product/11.1.0
+/db_1/rdbms/lib
Using DBD::Oracle 1.44.
Using DBD::Oracle 1.44.
Using DBI 1.620 (for perl 5.010001 on i686-cygwin-thread-multi-64int)
+installed in /usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help.tx
+t files.
(Of course, you have read README by now anyway, haven't you?)
2. RUN MAKE COMMAND
$ make
Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
Skip blib/lib/DBD/Oracle/Troubleshooting.pm (unchanged)
Skip blib/lib/DBD/Oracle/Object.pm (unchanged)
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
gcc -c -IC:/oracle/product/11.1.0/db_1/OCI/include -IC:/oracle/produc
+t/11.1.0/db_1/rdbms/demo -I/usr/lib/perl5/site_perl/5.10/i686-cygwin/
+auto/DBI -DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -fno-strict-aliasin
+g -pipe -fstack-protector -I/usr/local/include -DUSEIMPORTLIB -O3 -
+DVERSION=\"1.44\" -DXS_VERSION=\"1.44\" "-I/usr/lib/perl5/5.10/i686-
+cygwin/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"1
+1.1.0.6\" -DORA_OCI_102 Oracle.c
gcc -c -IC:/oracle/product/11.1.0/db_1/OCI/include -IC:/oracle/produc
+t/11.1.0/db_1/rdbms/demo -I/usr/lib/perl5/site_perl/5.10/i686-cygwin/
+auto/DBI -DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -fno-strict-aliasin
+g -pipe -fstack-protector -I/usr/local/include -DUSEIMPORTLIB -O3 -
+DVERSION=\"1.44\" -DXS_VERSION=\"1.44\" "-I/usr/lib/perl5/5.10/i686-
+cygwin/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"1
+1.1.0.6\" -DORA_OCI_102 dbdimp.c
dbdimp.c: In function ‘dbd_rebind_ph_char’:
dbdimp.c:2665: warning: cast from pointer to integer of different size
dbdimp.c: In function ‘dbd_rebind_ph_xml’:
dbdimp.c:2886: warning: cast to pointer from integer of different size
gcc -c -IC:/oracle/product/11.1.0/db_1/OCI/include -IC:/oracle/produc
+t/11.1.0/db_1/rdbms/demo -I/usr/lib/perl5/site_perl/5.10/i686-cygwin/
+auto/DBI -DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -fno-strict-aliasin
+g -pipe -fstack-protector -I/usr/local/include -DUSEIMPORTLIB -O3 -
+DVERSION=\"1.44\" -DXS_VERSION=\"1.44\" "-I/usr/lib/perl5/5.10/i686-
+cygwin/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"1
+1.1.0.6\" -DORA_OCI_102 oci8.c
oci8.c: In function ‘ora_blob_read_mb_piece’:
oci8.c:1833: warning: format ‘%lu’ expects type ‘long unsigned int’, b
+ut argument 6 has type ‘ub4’
rm -f blib/arch/auto/DBD/Oracle/Oracle.dll
LD_RUN_PATH="C:/oracle/product/11.1.0/db_1/lib:C:/oracle/product/11.1.
+0/db_1/rdbms/lib" g++ --shared -Wl,--enable-auto-import -Wl,--expor
+t-all-symbols -Wl,--stack,8388608 -Wl,--enable-auto-image-base -L/usr
+/local/lib -fstack-protector Oracle.o dbdimp.o oci8.o -o blib/arch/a
+uto/DBD/Oracle/Oracle.dll \
/usr/lib/perl5/5.10/i686-cygwin/CORE/cygperl5_10.dll -L/cygd
+rive/c/Users/LENOVO/Downloads/DBD-Oracle-1.44 -loci \
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.dll
test -s Oracle.bs && cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
+&& \
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
make: [blib/arch/auto/DBD/Oracle/Oracle.dll] Error 1 (ignored)
Manifying blib/man3/DBD.Oracle.Troubleshooting.3pm
Manifying blib/man3/DBD.Oracle.3pm
Manifying blib/man3/DBD.Oracle.Object.3pm
Manifying blib/man3/DBD.Oraperl.3pm
Manifying blib/man3/DBD.Oracle.GetInfo.3pm
3. RUN MAKE TEST COMMAND
$ make test
PERL_DL_NONLAZY=1 /usr/bin/perl.exe "-MExtUtils::Command::MM" "-e" "te
+st_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/000-report-versions.t ... Test::More version 0.94 required--this is
+only version 0.92 at t/000-report-versions.t line 4.
BEGIN failed--compilation aborted at t/000-report-versions.t line 4.
t/000-report-versions.t ... Dubious, test returned 255 (wstat 65280, 0
+xff00)
No subtests run
t/00versions.t ............ Can't load '/cygdrive/c/Users/LENOVO/Downl
+oads/DBD-Oracle-1.44/blib/arch/auto/DBD/Oracle/Oracle.dll' for module
+ DBD::Oracle: Permission denied at /usr/lib/perl5/5.10/i686-cygwin/Dy
+naLoader.pm line 200.
at t/00versions.t line 10
Compilation failed in require at t/00versions.t line 10.
BEGIN failed--compilation aborted at t/00versions.t line 10.
# Looks like your test exited with 13 before it could output anything.
t/00versions.t ............ Dubious, test returned 13 (wstat 3328, 0xd
+00)
Failed 2/2 subtests
t/01base.t ................ 1/6
# Failed test 'install_driver'
# at t/01base.t line 24.
# got: 'install_driver(Oracle) failed: Can't load '/cygdrive/
+c/Users/LENOVO/Downloads/DBD-Oracle-1.44/blib/arch/auto/DBD/Oracle/Or
+acle.dll' for module DBD::Oracle: Permission denied at /usr/lib/perl5
+/5.10/i686-cygwin/DynaLoader.pm line 200.
# at (eval 9) line 3
# Compilation failed in require at (eval 9) line 3.
# Perhaps a required shared library or dll isn't installed where expec
+ted
# at t/01base.t line 21
# '
# expected: ''
# Failed to load Oracle extension and/or shared libraries
# Looks like you failed 1 test of 6.
t/01base.t ................ Dubious, test returned 1 (wstat 256, 0x100
+)
Failed 1/6 subtests
(less 2 skipped subtests: 3 okay)
..
..
Test Summary Report
-------------------
t/000-report-versions.t (Wstat: 65280 Tests: 0 Failed: 0)
Non-zero exit status: 255
Parse errors: No plan found in TAP output
t/00versions.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: Bad plan. You planned 2 tests but ran 0.
t/01base.t (Wstat: 256 Tests: 6 Failed: 1)
Failed test: 4
Non-zero exit status: 1
t/10general.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
t/12impdata.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
t/14threads.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
t/15nls.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
t/20select.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
t/21nchar.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
t/22nchar_al32utf8.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
t/22nchar_utf8.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
t/23wide_db.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
t/23wide_db_8bit.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
t/23wide_db_al32utf8.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
t/24implicit_utf8.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
..
..
t/rt74753-utf8-encoded.t (Wstat: 3328 Tests: 0 Failed: 0)
Non-zero exit status: 13
Parse errors: No plan found in TAP output
Files=36, Tests=6, 11 wallclock secs ( 0.19 usr 0.22 sys + 2.99 cusr
+ 2.62 csys = 6.02 CPU)
Result: FAIL
Failed 36/36 test programs. 1/6 subtests failed.
make: *** [test_dynamic] Error 13
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.