FW: trace.log
am 19.10.2007 21:55:20 von Peter.LooHello All,
While I am able to logon to one Oracle database, I am getting core dump
on another. I turned on the DBI->trace and here is what I have. Will
anyone help me with this? In debug mode, the last line before core dump
is:
DBI::_new_dbh(/usr/local/lib/perl5/site_perl/5.8.7/sun4-sola ris/DBI.pm:1
237):
1237: _new_handle($app_class, $drh, $attr, $imp_data, $imp_class);
=20
DB<3>=20
DBD::Oracle::dr::connect(/usr/local/lib/perl5/site_perl/5.8. 7/sun4-solar
is/DBD/Oracle.pm:222):
222: DBD::Oracle::db::_login($dbh, $dbname, $user, $auth,
$attr)
223: or return undef;
Trace Log:
DBI 1.58-nothread default trace level set to 0x0/1 (pid 26646) at
testrun.pl line 20
-> DBI->connect(dbi:Oracle:xxxx, xxxxxx, ****, HASH(0x715c7c))
-> DBI->install_driver(Oracle) for solaris perl=3D5.008007 =
pid=3D26646
ruid=3Dxxxx euid=3Dxxxx
install_driver: DBD::Oracle version 1.17 loaded from
/usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/DBD/Oracle .pm
<- STORE('ShowErrorStatement' 1)=3D 1 at Oracle.pm line 61
<- install_driver=3D DBI::dr=3DHASH(0x81a41c)
DBI 1.58-nothread default trace level set to 0x0/10 (pid 26678) at
testrun.pl line 20
-> DBI->connect(dbi:Oracle:xxxxxx, xxxxxx, ****, HASH(0x715c7c))
-> DBI->install_driver(Oracle) for solaris perl=3D5.008007 =
pid=3D26678
ruid=3Dxxxx euid=3Dxxxx
install_driver: DBD::Oracle version 1.17 loaded from
/usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/DBD/Oracle .pm
New 'DBI::dr' (for DBD::Oracle::dr, parent=3D'', id=3Dundef)
=
dbih_setup_handle(DBI::dr=3DHASH(0x81a3c8)=3D>DBI::dr=3DHASH (0x81a2c0),
DBD::Oracle::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::Oracle::dr, 108, 0) thr#0
dbih_setup_attrib(DBI::dr=3DHASH(0x81a2c0), Err, Null!)
SCALAR(0x8364d0) (already defined)
dbih_setup_attrib(DBI::dr=3DHASH(0x81a2c0), State, Null!)
SCALAR(0x433024) (already defined)
dbih_setup_attrib(DBI::dr=3DHASH(0x81a2c0), Errstr, Null!)
SCALAR(0x836500) (already defined)
dbih_setup_attrib(DBI::dr=3DHASH(0x81a2c0), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=3DHASH(0x81a2c0), FetchHashKeyName, Null!)
'NAME' (already defined)
>> STORE DISPATCH (DBI::dr=3DHASH(0x81a3c8) rc1/1 @3 g0 ima41c =
pid#26678) at
/usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/DBD/Oracle .pm line 61
via at /usr/local/lib/perl5/5.8.7/perl5db.pl line 3731
-> STORE in DBD::_::common for DBD::Oracle::dr
(DBI::dr=3DHASH(0x81a3c8)~0x81a2c0 'ShowErrorStatement' 1)
STORE DBI::dr=3DHASH(0x81a2c0) 'ShowErrorStatement' =3D> 1
<- STORE=3D 1 at
/usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/DBD/Oracle .pm line 61
via at /usr/local/lib/perl5/5.8.7/perl5db.pl line 3731 install_method
DBI::db::ora_lob_read install_method DBI::db::ora_lob_write
install_method DBI::db::ora_lob_append install_method
DBI::db::ora_lob_trim install_method DBI::db::ora_lob_length
install_method DBI::db::ora_nls_parameters install_method
DBI::db::ora_can_unicode
<- install_driver=3D DBI::dr=3DHASH(0x81a3c8)
>> connect DISPATCH (DBI::dr=3DHASH(0x81a3c8) rc2/3 @5 g0 =
ima8001=20
pid#26678) at /usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/DBI.pm
line 633 via at /usr/local/lib/perl5/5.8.7/perl5db.pl line 3731
-> connect for DBD::Oracle::dr (DBI::dr=3DHASH(0x81a3c8)~0x81a2c0
'xxxxxx'=20
'xxxxxx' **** HASH(0x39978c))
New 'DBI::db' (for DBD::Oracle::db, =
parent=3DDBI::dr=3DHASH(0x81a2c0),
id=3Dundef)
=
dbih_setup_handle(DBI::db=3DHASH(0x814a14)=3D>DBI::db=3DHASH (0x814930),
DBD::Oracle::db, 4333b4, Null!)
dbih_make_com(DBI::dr=3DHASH(0x81a2c0), 6edb40, DBD::Oracle::db, =
132,
0) thr#0
dbih_setup_attrib(DBI::db=3DHASH(0x814930), Err,
DBI::dr=3DHASH(0x81a2c0))
SCALAR(0x43d35c) (already defined)
dbih_setup_attrib(DBI::db=3DHASH(0x814930), State,
DBI::dr=3DHASH(0x81a2c0)) SCALAR(0x43d3d4) (already defined)
dbih_setup_attrib(DBI::db=3DHASH(0x814930), Errstr,
DBI::dr=3DHASH(0x81a2c0)) SCALAR(0x43d398) (already defined)
dbih_setup_attrib(DBI::db=3DHASH(0x814930), TraceLevel,
DBI::dr=3DHASH(0x81a2c0)) 0 (already defined)
dbih_setup_attrib(DBI::db=3DHASH(0x814930), FetchHashKeyName,
DBI::dr=3DHASH(0x81a2c0)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=3DHASH(0x814930), HandleSetErr,
DBI::dr=3DHASH(0x81a2c0)) undef (not defined)
dbih_setup_attrib(DBI::db=3DHASH(0x814930), HandleError,
DBI::dr=3DHASH(0x81a2c0)) undef (not defined)
dbih_setup_attrib(DBI::db=3DHASH(0x814930), ReadOnly,
DBI::dr=3DHASH(0x81a2c0)) undef (not defined)
dbih_setup_attrib(DBI::db=3DHASH(0x814930), Profile,
DBI::dr=3DHASH(0x81a2c0)) undef (not defined) Environment variables:
_=3D./testrun.pl
CA_OPR_WRITE_MSGACK=3DY
MANPATH=3D:/opt/sas913/utilities/man:/usr/share/man
NZ_HOST=3Dxxxxxx
CAIGLBL0002=3DCACRITMON
CAI_ENF_DEBUG=3D0
CAIGLBL0000=3D/opt/uni
CAIGLBL0006=3DCASNMPMGR
SSH_TTY=3D/dev/pts/6
CAISCHD0042=3D0
CAI_ENF_PROGRAM=3D/opt/uni/enf/bin
=09
PATH=3D/opt/app/oracle/product/10.2/bin:/opt/CA/SharedCompon ents/dmscript=
/
bin:/usr/bin:/usr/bin:/opt/app/oracle/product/9.2.0.4/bin:/u sr/local/bin
:/usr/local/apps/common/devl/bin:/opt/Navisphere:/opt/sas913 :/opt/sas913
/sasexe:/opt/uni/bin:/opt/uni/scripts:/etc:/opt/EMCpower/bin /sparcv9:/et
c/emc/bin:/usr/local/nz/bin/:/usr/ccs/bin:.
CAISCHD0040=3DNo
DMS_PATH=3D/opt/CA/SharedComponents/dmscript
CA_DB=3D
TK2_PRINT_STATUS=3Decho
CAI_ENF_LIBRARY=3D/opt/uni/enf/lib/5.9
CAISCHD0023=3D30
CAISCHD0022=3DREMOTE
CAISCHD0021=3DNORMAL
CAISCHD0020=3Danything
CAISCHD0027=3D500
CAISCHD0026=3D500
CATALINA_HOME=3D/usr/local/tomcat/apache-tomcat-5.5.20
CAISCHD0025=3D500
CAISCHD0220=3DN
CAISCHD0024=3D3
EDITOR=3Dvi
CAISCHD0032=3D5
CAISCHD0029=3D5
CAISCHD0030=3D20
CAISCHD0028=3D500
CAI_ENF_OBJECT=3D/opt/uni/enf/obj
LOGNAME=3Dxxxxxxxx
CAISCHD0035=3DYes
CAISCHD0003=3DN
CAISCHD0002=3DS
MAIL=3D/var/mail//xxxxxxx
CAISCHD0019=3DYes
CAISCHD0001=3D/opt/uni/sche/bin
CAISCHD0018=3D10
CAI_CAL_REMOTEDB=3Dxxxxxxxx
LIC_ECHO=3Decho
CAISCHD0007=3D2
CALIB=3D/opt/CA/SharedComponents/lib
CAISCHD0006=3D/opt/uni/sche/log/xxxxxxx
CA_REPORT=3D/opt/uni/report/
CAISCHD0005=3Dxxxxxxx
ORACLE_SID=3Dxxxxxx
CAISCHD0200=3D/opt/uni/tmp
CAISCHD0004=3D/usr/local/apps
PS1=3Dxxxxxxxx::$PWD>$
CAISCHD0012=3D3
CAISCHD0011=3D1
CAISCHD0009=3Dbase
CAISCHD0010=3D1000
CAISCHD0008=3D/opt/uni/tmp/xxxxxxx
HOST=3Dxxxxxxx
CAISCHD0017=3DYes
CA_CAIMESSAGE=3D/opt/uni/messages/american
CAISCHD0016=3D0
CAPB_PATH=3D/opt/uni/prb/config/
CAISCHD0210=3DNormal
CAISCHD0014=3DYes
USER=3Dxxxxxxx
CAI_CONLOG=3D/opt/uni/opr/logs
ORACLE_DOC=3D/opt/app/oracle/product/9.2.0.4/doc
CAI_ENF_CONFIG=3D/opt/uni/enf/config
SHELL=3D/bin/ksh
CAI_ENF_LOG=3D/opt/uni/enf/logs
ORACLE_TERM=3Dvt220
CASHCOMP=3D/opt/CA/SharedComponents
JAVA_HOME=3D/usr/jdk1.5.0_09
LD_LIBRARY_PATH_64=3D/opt/app/oracle/product/10.2/lib
NZ_DATABASE=3Dxxxxxxx
ODBCINI=3D/usr/local/etc/odbc.ini
CA_CAILANGUAGE=3Denu
CAI_OPR_REMOTEDB=3Dxxxxxxxx
HOME=3D/export/home/xxxxxxxx
CA_OPR_RETAIN_LOGS=3D90
CAIUNIDB=3Dcaiunidb
SSH_CONNECTION=3D172.21.41.132 55590 172.21.41.137 22
SSH_CLIENT=3D172.21.41.132 55590 22
UTL_FILE_DIR=3D*
=09
LD_LIBRARY_PATH=3D/opt/app/oracle/product/10.2/lib32:/usr/lo cal/lib:/usr/=
l
ocal/nz/lib:/opt/app/oracle/product/10.2/lib:/opt/app/oracle /product/9.2
..0.4/lib:/usr/local/lib:/opt/CA/SharedComponents/lib
TERM=3Dvt100
ORACLE_HOME=3D/opt/app/oracle/product/10.2
PWD=3D
CAI_CAMSGF_OPRDIRECT=3D
TZ=3DUS/Arizona
CAI_DATEFMT=3DMMM-DD-YYYY
CAISCHD0500=3D02
NZ_USER=3Dxxxxxxxx
CA_OPRPING_TIMEOUT=3D300
PERLDB_PIDS=3D26678
OCINlsEnvironmentVariableGet(1,0,93,0,2)=3DSUCCESS
OCINlsEnvironmentVariableGet(1,0,94,0,2)=3DSUCCESS
OCINlsEnvCreate(883b50,2,0,0,0,0,0,0,1,1)=3DSUCCESS
OCIHandleAlloc(8ad358,883b54,OCI_HTYPE_ERROR,0,0)=3DSUCCESS
charsetid=3D1 ncharsetid=3D1 (csid: utf8=3D0 al32utf8=3D0)
OCIHandleAlloc(8ad358,883b58,OCI_HTYPE_SERVER,0,0)=3DSUCCESS
OCIHandleAlloc(8ad358,883b5c,OCI_HTYPE_SVCCTX,0,0)=3DSUCCESS
Thanks.
Peter