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:, xx, , HASH(0x715c7c))
-> DBI->install_driver(Oracle) for solaris perl=5.008007 pid=26646
ruid= euid=
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:xx, xx, , HASH(0x715c7c))
-> DBI->install_driver(Oracle) for solaris perl=5.008007 pid=26678
ruid= euid=
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
'xx'
'xx' 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=xx
CAIGLBL0002=CACRITMON
CAI_ENF_DEBUG=0
CAIGLBL=/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: