I recompiled DBI 1.607, DBD Oracle 1.22, and perl 5.8.8. It does not
error during compiling but it coredump when DBD is called. I have
attached the DBI trace. Does anyone have any idea what I can change to
get this work correctly.
OS: Solaris 10
DB: Oracle 10.2.0
-xarch=386 (Using this parameter to forcing it to be compiled in 32bit)
Sqlplus works just fine, so the listener and database is working
correctly.
Chris
-------------------
Chris Koester
DBI 1.607-nothread default trace level set to 0x300/7 (pid 23194) at
commit.pl line 12
-> DBI->connect(dbi:Oracle:plascpdb, xost, ****, HASH(0x813dbcc))
-> DBI->install_driver(Oracle) for solaris perl=5.008008 pid=23194 ruid=717
euid=717
install_driver: DBD::Oracle version 1.22 loaded from
/xst/xstlocal/bin/lib/perl5/site_perl/5.8.8/i86pc-solaris/DBD/Oracle.pm
New 'DBI::dr' (for DBD::Oracle::dr, parent='', id=undef)
dbih_setup_handle(DBI::dr=HASH(0x8147068)=>DBI::dr=HASH(0x8147080),
DBD::Oracle::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::Oracle::dr, 108, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x8147080), Err, Null!) SCALAR(0x8146cf0)
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8147080), State, Null!) SCALAR(0x82144d4)
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8147080), Errstr, Null!) SCALAR(0x8146ca8)
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8147080), TraceLevel, Null!) 0 (already
defined)
dbih_setup_attrib(DBI::dr=HASH(0x8147080), FetchHashKeyName, Null!) 'NAME'
(already defined)
-> STORE in DBD::_::common for DBD::Oracle::dr
(DBI::dr=HASH(0x8147068)~0x8147080 'ShowErrorStatement' 1)
STORE DBI::dr=HASH(0x8147080) 'ShowErrorStatement' => 1
<- STORE= 1 at
/xst/xstlocal/bin/lib/perl5/site_perl/5.8.8/i86pc-solaris/DBD/Oracle.pm line 68
<- install_driver= DBI::dr=HASH(0x8147068)
-> connect for DBD::Oracle::dr (DBI::dr=HASH(0x8147068)~0x8147080
'plascpdb' 'scamp' **** HASH(0x81ea0a4))
New 'DBI::db' (for DBD::Oracle::db, parent=DBI::dr=HASH(0x8147080),
id=undef)
dbih_setup_handle(DBI::db=HASH(0x82a4160)=>DBI::db=HASH(0x82a566c),
DBD::Oracle::db, 82222bc, Null!)
dbih_make_com(DBI::dr=HASH(0x8147080), 8153578, DBD::Oracle::db, 136,
82a5684) thr#0
dbih_setup_attrib(DBI::db=HASH(0x82a566c), Err, DBI::dr=HASH(0x8147080))
SCALAR(0x8222448) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a566c), State, DBI::dr=HASH(0x8147080))
SCALAR(0x82224a8) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a566c), Errstr, DBI::dr=HASH(0x8147080))
SCALAR(0x8222478) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a566c), TraceLevel,
DBI::dr=HASH(0x8147080)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a566c), FetchHashKeyName,
DBI::dr=HASH(0x8147080)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a566c), HandleSetErr,
DBI::dr=HASH(0x8147080)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x82a566c), HandleError,
DBI::dr=HASH(0x8147080)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x82a566c), ReadOnly,
DBI::dr=HASH(0x8147080)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x82a566c), Profile,
DBI::dr=HASH(0x8147080)) undef (not defined)
Environment variables:
_=/xst/xstlocal/bin/bin/perl
LIBDIR=/xst/xstlocal/bin/lib
MANPATH=:/usr/man:/usr/openwin/man:/usr/share/man
HZ=
PATH=/usr/sfw/bin:/xst/xstlocal/bin/bin::/xst/xsthome/scamp/bin:/usr/local/bin:/usr/bin:/usr/sbin:/xst/xstorabin/oracle/product/10.2.0/bin:/app/xostat/apache/bin:/sbin:/usr/openwin/bin:/usr/ccs/bin:/etc:/app/XOstats/prod/bin/develop:/app/XOstats/prod/bin/util:.:/opt/SUNWspro/bin
LIB=/xst/xstlocal/bin/apache2/lib:/xst/xstlocal/bin/lib
SCAMPNAME=C.Koester
EDITOR=vi
LOGNAME=scamp
MAIL=/var/mail/scamp
RLIB=/xst/xstlocal/bin/apache2/lib:/xst/xstlocal/bin/lib
ORACLE_SID=scamp
ps1=scamp-c.koes...@plameddev01>
LDFLAGS=-L/xst/xstlocal/bin/apache2/lib -L/xst/xstlocal/bin/lib
CC=/opt/SUNWspro/bin/cc
CXX=/opt/SUNWspro/bin/CC
SHELL=/bin/ksh
CPPFLAGS=-I/xst/xstlocal/bin/apache2/include -I/xst/xstlocal/bin/include
CXXFLAGS=-xarch=386 -xmodel=medium -xO5 -KPIC
HOME=/xst/xsthome/scamp
TERM=vt100
LD_LIBRARY_PATH=/xst/xstlocal/bin/apache2/lib:/xst/xstlocal/bin/lib:/xst/xstorabin/oracle/product/10.2.0/lib32:/usr/openwin/lib:/xst/xstlocal/bin/lib/iconv
CFLAGS=-xarch=386 -xmodel=medium -xO5 -KPIC
ORACLE_HOME=/xst/xstorabin/oracle/product/10.2.0
PWD=/xst/xsthome/scamp/DBD-Oracle-1.22/Oracle.ex
TZ=US/Central
CCFLAGS=-xarch=386 -xmodel=medium -xO5 -KPIC
OCINlsEnvironmentVariableGet(1,0,93,0,2)=SUCCESS
OCINlsEnvironmentVariableGet(1,0,94,0,2)=SUCCESS
OCINlsEnvCreate(82b7528,OBJECT,2,0,0,0,0,0,0,1,1)=SUCCESS
OCIHandleAlloc(8355770,82b752c,OCI_HTYPE_ERROR,0,0)=SUCCESS
charset id=1, name=US7ASCII, ncharset id=1, name=US7ASCII (csid:
utf8=871 al32utf8=873)
OCIHandleAlloc(8355770,82b7530,OCI_HTYPE_SERVER,0,0)=SUCCESS
OCIHandleAlloc(8355770,82b7534,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
Segmentation Fault(coredump)
