I recompiled DBI 1.607, DBD Oracle 1.22, and perl 5.8.8. I am still
getting the error. I have attached the DBI trace.
The listener is working correctly. I can even sqlplus from the same
server with the same TNSNAME.
Chris
-------------------
Chris Koester
From: Martin Gainty [mailto:[email protected]]
Sent: Tuesday, December 30, 2008 8:54 PM
To: Koester, Chris; [email protected]
Subject: RE: DBI core dump
Hi Chris-
too many variables to figure out what might be causing this error
get the source for your OS for each ppm package starting with
DBI 1.607 and
DBD oracle 1.22
perl 5.8.8
and compile ALL of them
make sure you have valid TNS listener setup
tnsping TNSNAME
the binaries should at least connect if not let us know ..
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official
business of Sender. This transmission is of a confidential nature and
Sender does not endorse distribution to any party other than intended
recipient. Sender does not necessarily endorse content contained within
this transmission.
> Subject: DBI core dump
> Date: Tue, 30 Dec 2008 11:20:16 -0600
> From: [email protected]
> To: [email protected]
>
> All,
>
> What would cause DBD to Segmentation coredump?
>
> 10793 Segmentation Fault(coredump)
>
> I am using perl 5.8.8 with DBI 1.607 and DBD oracle 1.22 (Oracle
10.2.0)
> It all compiles and installs with no errors but it coredumps when
trying
> to run it. Its compiled as 32bit if that makes any difference.
>
> Thanks in advance for any help or suggestion.
>
> Chris Koester
>
________________________________
It's the same Hotmail(r). If by "same" you mean up to 70% faster. Get
your account now.
<http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_bro
ad1_122008>
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)
