Hello 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-solaris/DBI.pm:1
237):
1237: _new_handle($app_class, $drh, $attr, $imp_data, $imp_class);
DB<3>
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=5.008007 pid=26646
ruid=xxxx euid=xxxx
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)= 1 at Oracle.pm line 61
<- install_driver= DBI::dr=HASH(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=5.008007 pid=26678
ruid=xxxx euid=xxxx
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='', id=undef)
dbih_setup_handle(DBI::dr=HASH(0x81a3c8)=>DBI::dr=HASH(0x81a2c0),
DBD::Oracle::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::Oracle::dr, 108, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x81a2c0), Err, Null!)
SCALAR(0x8364d0) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x81a2c0), State, Null!)
SCALAR(0x433024) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x81a2c0), Errstr, Null!)
SCALAR(0x836500) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x81a2c0), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x81a2c0), FetchHashKeyName, Null!)
'NAME' (already defined)
>> STORE DISPATCH (DBI::dr=HASH(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=HASH(0x81a3c8)~0x81a2c0 'ShowErrorStatement' 1)
STORE DBI::dr=HASH(0x81a2c0) 'ShowErrorStatement' => 1
<- STORE= 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= DBI::dr=HASH(0x81a3c8)
>> connect DISPATCH (DBI::dr=HASH(0x81a3c8) rc2/3 @5 g0 ima8001
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=HASH(0x81a3c8)~0x81a2c0
'xxxxxx'
'xxxxxx' **** HASH(0x39978c))
New 'DBI::db' (for DBD::Oracle::db, parent=DBI::dr=HASH(0x81a2c0),
id=undef)
dbih_setup_handle(DBI::db=HASH(0x814a14)=>DBI::db=HASH(0x814930),
DBD::Oracle::db, 4333b4, Null!)
dbih_make_com(DBI::dr=HASH(0x81a2c0), 6edb40, DBD::Oracle::db, 132,
0) thr#0
dbih_setup_attrib(DBI::db=HASH(0x814930), Err,
DBI::dr=HASH(0x81a2c0))
SCALAR(0x43d35c) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x814930), State,
DBI::dr=HASH(0x81a2c0)) SCALAR(0x43d3d4) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x814930), Errstr,
DBI::dr=HASH(0x81a2c0)) SCALAR(0x43d398) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x814930), TraceLevel,
DBI::dr=HASH(0x81a2c0)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x814930), FetchHashKeyName,
DBI::dr=HASH(0x81a2c0)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x814930), HandleSetErr,
DBI::dr=HASH(0x81a2c0)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x814930), HandleError,
DBI::dr=HASH(0x81a2c0)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x814930), ReadOnly,
DBI::dr=HASH(0x81a2c0)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x814930), Profile,
DBI::dr=HASH(0x81a2c0)) undef (not defined) Environment variables:
_=./testrun.pl
CA_OPR_WRITE_MSGACK=Y
MANPATH=:/opt/sas913/utilities/man:/usr/share/man
NZ_HOST=xxxxxx
CAIGLBL0002=CACRITMON
CAI_ENF_DEBUG=0
CAIGLBL0000=/opt/uni
CAIGLBL0006=CASNMPMGR
SSH_TTY=/dev/pts/6
CAISCHD0042=0
CAI_ENF_PROGRAM=/opt/uni/enf/bin
PATH=/opt/app/oracle/product/10.2/bin:/opt/CA/SharedComponents/dmscript/
bin:/usr/bin:/usr/bin:/opt/app/oracle/product/9.2.0.4/bin:/usr/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=No
DMS_PATH=/opt/CA/SharedComponents/dmscript
CA_DB=
TK2_PRINT_STATUS=echo
CAI_ENF_LIBRARY=/opt/uni/enf/lib/5.9
CAISCHD0023=30
CAISCHD0022=REMOTE
CAISCHD0021=NORMAL
CAISCHD0020=anything
CAISCHD0027=500
CAISCHD0026=500
CATALINA_HOME=/usr/local/tomcat/apache-tomcat-5.5.20
CAISCHD0025=500
CAISCHD0220=N
CAISCHD0024=3
EDITOR=vi
CAISCHD0032=5
CAISCHD0029=5
CAISCHD0030=20
CAISCHD0028=500
CAI_ENF_OBJECT=/opt/uni/enf/obj
LOGNAME=xxxxxxxx
CAISCHD0035=Yes
CAISCHD0003=N
CAISCHD0002=S
MAIL=/var/mail//xxxxxxx
CAISCHD0019=Yes
CAISCHD0001=/opt/uni/sche/bin
CAISCHD0018=10
CAI_CAL_REMOTEDB=xxxxxxxx
LIC_ECHO=echo
CAISCHD0007=2
CALIB=/opt/CA/SharedComponents/lib
CAISCHD0006=/opt/uni/sche/log/xxxxxxx
CA_REPORT=/opt/uni/report/
CAISCHD0005=xxxxxxx
ORACLE_SID=xxxxxx
CAISCHD0200=/opt/uni/tmp
CAISCHD0004=/usr/local/apps
PS1=xxxxxxxx::$PWD>$
CAISCHD0012=3
CAISCHD0011=1
CAISCHD0009=base
CAISCHD0010=1000
CAISCHD0008=/opt/uni/tmp/xxxxxxx
HOST=xxxxxxx
CAISCHD0017=Yes
CA_CAIMESSAGE=/opt/uni/messages/american
CAISCHD0016=0
CAPB_PATH=/opt/uni/prb/config/
CAISCHD0210=Normal
CAISCHD0014=Yes
USER=xxxxxxx
CAI_CONLOG=/opt/uni/opr/logs
ORACLE_DOC=/opt/app/oracle/product/9.2.0.4/doc
CAI_ENF_CONFIG=/opt/uni/enf/config
SHELL=/bin/ksh
CAI_ENF_LOG=/opt/uni/enf/logs
ORACLE_TERM=vt220
CASHCOMP=/opt/CA/SharedComponents
JAVA_HOME=/usr/jdk1.5.0_09
LD_LIBRARY_PATH_64=/opt/app/oracle/product/10.2/lib
NZ_DATABASE=xxxxxxx
ODBCINI=/usr/local/etc/odbc.ini
CA_CAILANGUAGE=enu
CAI_OPR_REMOTEDB=xxxxxxxx
HOME=/export/home/xxxxxxxx
CA_OPR_RETAIN_LOGS=90
CAIUNIDB=caiunidb
SSH_CONNECTION=172.21.41.132 55590 172.21.41.137 22
SSH_CLIENT=172.21.41.132 55590 22
UTL_FILE_DIR=*
LD_LIBRARY_PATH=/opt/app/oracle/product/10.2/lib32:/usr/local/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=vt100
ORACLE_HOME=/opt/app/oracle/product/10.2
PWD=
CAI_CAMSGF_OPRDIRECT=
TZ=US/Arizona
CAI_DATEFMT=MMM-DD-YYYY
CAISCHD0500=02
NZ_USER=xxxxxxxx
CA_OPRPING_TIMEOUT=300
PERLDB_PIDS=26678
OCINlsEnvironmentVariableGet(1,0,93,0,2)=SUCCESS
OCINlsEnvironmentVariableGet(1,0,94,0,2)=SUCCESS
OCINlsEnvCreate(883b50,2,0,0,0,0,0,0,1,1)=SUCCESS
OCIHandleAlloc(8ad358,883b54,OCI_HTYPE_ERROR,0,0)=SUCCESS
charsetid=1 ncharsetid=1 (csid: utf8=0 al32utf8=0)
OCIHandleAlloc(8ad358,883b58,OCI_HTYPE_SERVER,0,0)=SUCCESS
OCIHandleAlloc(8ad358,883b5c,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
Thanks.
Peter
