Hello,
I've done my
absolute best to figure this out without asking for help, I've spent at least 12
hours trying everything. But no luck, so here goes.
The facts:
Oracle 8.0.6
database running on Windows 2000 Server
Oracle 8.1.7 client
running on Solaris 8 / Apache (mod_perl) server
Perl 5.6.1 on
Solaris machine
Attempting to use
DBD-Oracle-1.12
Can successfully
connect to Oracle database from Solaris client from SQL*Plus - can successfully
perform any SQL statement
Installation of
DBD-Oracle-1.12 results in many errors during 'make test'. However, I ran
make install and tested my program anyway.
My program
(loadca.pl) reads a file called testext.txt then after parsing data, inserts
records in the Win2K Oracle database. I ran
the program from the command line, not thru Apache
mod_perl. After installing DBD-Oracle-1.12, the records
SUCCESSFULLY inserted. However when the program completed, I got a
Segmentation Fault core dump. So I created a simpler program called
oratest.pl that simply connects then disconnects from Oracle, still got a core
dump. Then I tried another Perl program that didn't use DBI at all, it
worked fine, NO core dump.
I've tried
everything listed in the Readme and Readme.help. I'm convinced that this
is an Oracle version problem. One message in Readme.clients mentioned
copying files from the Oracle database server's directories onto the client
machine. However, it was in the context of the Oracle database being
installed on another Unix machine, not on a Bill Gates
special.
I've included a
listing from the DBD build (dbd.txt inside
dbd.zip - had to work around your e-mail system's size limitation), I've
included the original and test programs (*.pl), the test data
(testext.txt), listing showing 'perl -V' (perl.txt), listing showing run
time (runtime.txt) and the call stack (stack.txt).
Any ideas? I'm
really frustrated. Is there any info on working with Oracle databases
installed on Windows? I'm very sorry to pester busy people on this, but
I've nowhere else to turn.
Thanks in advance
for your help,
Bill
Benner
dbd.zip
Script started on Sun Sep 23 14:19:49 2001
# perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=solaris, osvers=2.8, archname=i86pc-solaris
uname='sunos unixbox 5.8 generic_108529-07 i86pc i386 i86pc '
config_args='-de'
hint=previous, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
Compiler:
cc='gcc', ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64',
optimize='-O',
cppflags='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64'
ccversion='', gccversion='2.95.3 20010315 (release)', gccosandvers='solaris2.8'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=4, usemymalloc=y, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib '
libpth=/usr/local/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc
perllibs=-lsocket -lnsl -ldl -lm -lc
libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under solaris
Compiled at Sep 23 2001 09:06:51
@INC:
/usr/local/lib/perl5/5.6.1/i86pc-solaris
/usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/i86pc-solaris
/usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl
.
# ^D
script done on Sun Sep 23 14:20:01 2001
Script started on Sun Sep 23 14:20:25 2001 # perl oratest.pl commit disconnect end Segmentation Fault - core dumped # ^D script done on Sun Sep 23 14:20:51 2001
(gdb) bt #0 0xdf8c3f28 in _bind_guard () from /usr/lib/libthread.so.1 #1 0xdfbc8051 in ?? () #2 0xdfbcb807 in ?? () #3 0xdfbcfb89 in ?? () #4 0xdfbc30c9 in ?? () #5 0xdf9871bc in XS_DBD__Oracle__st_DESTROY (cv=0x81ec530) at Oracle.xsi:457 #6 0xdf9c670c in XS_DBI_dispatch () from /usr/local/lib/perl5/site_perl/5.6.1/i86pc-solaris/auto/DBI/DBI.so #7 0x80a5cdd in Perl_pp_entersub () #8 0x8064ee5 in S_call_body () #9 0x8064cbe in perl_call_sv () #10 0x80abb64 in Perl_sv_clear () #11 0x80ac09d in Perl_sv_free () #12 0x80abe37 in Perl_sv_clear () #13 0x80ac09d in Perl_sv_free () #14 0x80991a5 in Perl_mg_free () #15 0x80abcae in Perl_sv_clear () #16 0x80ac09d in Perl_sv_free () #17 0x80bce59 in Perl_free_tmps () #18 0x80643cd in perl_run () #19 0x8061dc9 in main () #20 0x8061c53 in _start ()
PHONE ACTIVITY BY EXTENSION Page: 001
From 07/01/01 to 07/31/01
Ext: ____ to ____ (Incoming, Outgoing or Both): B
|Date |Time |Length |Trnk| Cost|Telephone No |Client |Destination |
| |
|Ext 23>1 Current User: Dept: |
|07/14/01|19:57|00:02:00|2501| |INCOMING CALL | | |
|07/16/01|08:14|00:03:00|2515| 0.57|(602) 769-7592| |AZ PEACH SPG|
|07/17/01|08:29|00:01:00|2519| 0.19|(602) 909-9936| |AZ NPA SUMMR|
|07/30/01|12:54|00:01:00|2510| 0.19|(602) 909-9936| |AZ NPA SUMMR|
|Ext 23>1 Totals -> Calls: 22 Time: 1:15:00 Cost: $ 12.73 Avr. 3.4|
PHONE ACTIVITY BY EXTENSION Page: 002
From 07/01/01 to 07/31/01
Ext: ____ to ____ (Incoming, Outgoing or Both): B
|Date |Time |Length |Trnk| Cost|Telephone No |Client |Destination |
| |
|Ext 23>3 Current User: Dept: |
|07/18/01|10:37|00:05:00|2509| |(602) 769-7592| |AZ PEACH SPG|
|07/18/01|12:07|00:05:00|2519| 0.95|(602) 769-7592| |AZ PEACH SPG|
|07/19/01|10:18|00:01:00|2510| 0.19|(602) 909-9936| |AZ NPA SUMMR|
|07/24/01|11:03|00:01:00|2512| 0.19|(602) 909-9936| |AZ NPA SUMMR|
|07/25/01|13:08|00:01:00|2511| 0.19|(602) 769-7592| |AZ PEACH SPG|
|Ext 23>3 Totals -> Calls: 5 Time: 0:13:00 Cost: $ 1.52 Avr. 2.6|
PHONE ACTIVITY BY EXTENSION Page: 079
From 07/01/01 to 07/31/01
Ext: ____ to ____ (Incoming, Outgoing or Both): B
|Date |Time |Length |Trnk| Cost|Telephone No |Client |Destination |
| |
|Ext 4001 Current User: WILSON RUDD Dept: |
|07/16/01|08:14|00:01:00|2524| |INCOMING CALL | | |
|07/16/01|08:22|00:03:00|2514| |(916) 206-3290| |CA NPA SUMMR|
|07/16/01|08:28|00:18:00|2513| |(858) 486-4500| | |
|07/16/01|08:55|00:09:00|2509| |(212) 271-3620| |NY NYCZ 1 |
|07/16/01|10:31|00:02:00|2510| |(858) 486-4500| | |
|07/16/01|10:34|00:10:00|2519| |(916) 206-3290| |CA NPA SUMMR|
|07/31/01|16:35|00:01:00|2513| |(916) 204-7328| |CA NPA SUMMR|
|07/31/01|16:40|00:01:00|2514| |(650) 424-5500| | |
|07/31/01|16:46|00:04:00|2511| |(916) 204-7328| | |
|07/31/01|17:28|00:15:00|2510| |(650) 424-4964| | |
|Ext 4001 Totals -> Calls: 131 Time: 13:33:00 Cost: $ 8.17 Avr. 6.2|
PHONE ACTIVITY BY EXTENSION Page: 082
From 07/01/01 to 07/31/01
Ext: ____ to ____ (Incoming, Outgoing or Both): B
|Date |Time |Length |Trnk| Cost|Telephone No |Client |Destination |
| |
|Ext 4002 Current User: Dayal's Modem Dept: |
|07/14/01|08:57|00:01:00|2522| |INCOMING CALL | | |
|07/16/01|10:34|00:01:00|2510| |(800) 831-3541| | |
|07/16/01|10:36|00:02:00|2518| 0.38|(602) 278-6696| |AZ PHOENIX |
|07/16/01|10:58|00:01:00|2522| |INCOMING CALL | | |
|07/16/01|12:55|00:01:00|2307| |INCOMING CALL | | |
|07/17/01|09:30|00:02:00|2515| 0.38|(602) 278-6696| |AZ PHOENIX |
|07/17/01|10:01|00:01:00|2513| |(800) 831-3541| | |
|07/31/01|17:46|00:01:00|2307| |INCOMING CALL | | |
|07/31/01|17:47|00:01:00|2305| |INCOMING CALL | | |
|07/31/01|19:18|00:01:00|2523| |INCOMING CALL | | |
|Ext 4002 Totals -> Calls: 33 Time: 0:42:00 Cost: $ 2.85 Avr. 1.3|
