date:20071019

FW: trace.log

2007-10-19 Thread Loo, Peter # PHX

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:

Re: DBD::CSV: make test fails

2007-10-19 Thread Robert Roggenbuck


Jeff Zucker schrieb:
> My guess is that you are either missing some prerequisites or that the
> older linux perl has some old copies of them.  Try to first install the
> latest DBD-File, SQL::Statement, and Text::CSV_XS.  If you still get
> errors, please let me know what versions of those modules you have.

I had some forwarding and mail folder filter problem with one of my 
mailboxes, so I read this mail just yesterday. Even if my problem seems 
solved I woun't let Your response without an answer. Indeed there is a 
very old perl installation besides my privat one. But there is no DBI, 
nor SQL::Satatement or Text::CSV_XS in it's @INC.


$> /usr/bin/perl -V

Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
  Platform:
osname=linux, osvers=2.2.14, archname=i586-linux
uname='linux apollonius 2.2.14 #1 mon nov 8 15:51:29 cet 1999 i686 
unknown '

hint=recommended, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
  Compiler:
cc='cc', optimize='-O2 -pipe', gccversion=2.95.2 19991024 (release)
cppflags='-Dbool=char -DHAS_BOOL -I/usr/local/include'
ccflags ='-Dbool=char -DHAS_BOOL -I/usr/local/include'
stdchar='char', d_stdstdio=undef, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
alignbytes=4, usemymalloc=n, prototype=define
  Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lndbm -lgdbm -ldb -ldl -lm -lc -lposix -lcrypt
libc=, so=so, useshrplib=false, libperl=libperl.a
  Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'


Characteristics of this binary (from libperl):
  Built under linux
  Compiled at Mar 11 2000 08:03:12
  @INC:
/usr/lib/perl5/5.00503/i586-linux
/usr/lib/perl5/5.00503
/usr/lib/perl5/site_perl/5.005/i586-linux
/usr/lib/perl5/site_perl/5.005
.

And in my private installation I have the most recent versions:

$> perl -e 'use SQL::Statement; print "$SQL::Statement::VERSION\n"'
1.15
$> perl -e 'use Text::CSV_XS; print "$Text::CSV_XS::VERSION\n"'
0.31
$> perl -e 'use DBI; print "$DBI::VERSION\n"'
1.59
$> perl -e 'use DBD::CSV; print "$DBD::CSV::VERSION\n"'
0.22

Best regards

Robert

DBD::Oracle - Connection Failed - out of memory

2007-10-19 Thread dario borsotti

at the moment I'm going crazy with the same problem just
analyzed here: http://www.mail-archive.com/dbi-users@perl.org/msg25602.html

here again the problem:
I'm trying to test the connection betwwen my Sun SPARC 64bit  - Solaris 10
and a remote Oracle DB.

--
#!/usr/bin/perl
use DBI;
$dbh = DBI->connect("dbi:Oracle:host=...;sid=...;port=...","user","pwd");

--
And the result is:

Out of memory!
Callback called exit.
END failed--call queue aborted.


I'm using the Oracle instantclient.

I noted that a possible solution is to install full client instead of
instant client, but in this case this is not possible, because of IT guys
:-(

Someone could suggest me a possible solution?
thanks


~~~
Computers are useless. They can only give you answers.
Pablo Picasso
~

FW: trace.log

Re: DBD::CSV: make test fails

DBD::Oracle - Connection Failed - out of memory

3 matches

Site Navigation

Mail list logo

Footer information