RE: Perl coredump when using ora_dbh_share to connect to Oracle DB's
On 01.04.10 03:02 John Scoles wrote: Hard to say exatly are you sure you are connecting to oracle corretly?? use DBI; my $dsn = 'DBI:Oracle:host=localhost;port=1527;sid=XXX'; is a rather odd dsn I always the the method above, although I don't define the host and port part, since it is known in tnsnames. But the dsn part looks normal to me :) Cheers, Wesley
Re: Perl coredump when using ora_dbh_share to connect to Oracle DB's
On 2010-04-01 09:43:32 +0200, Wesley Schwengle wrote: > On 01.04.10 03:02 John Scoles wrote: >> Hard to say exatly are you sure you are connecting to oracle corretly?? >> >> use DBI; >> >> my $dsn = 'DBI:Oracle:host=localhost;port=1527;sid=XXX'; >> >> is a rather odd dsn > > I always the the method above, although I don't define the host and port part, > since it is known in tnsnames. But the dsn part looks normal to me :) If you want to use tnsnames, shouldn't that be: my $dsn = 'DBI:Oracle:XXX'; instead of my $dsn = 'DBI:Oracle:sid=XXX'; ? hp -- _ | Peter J. Holzer| Auf jedem Computer sollte der Satz Ludwigs II |_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich | | | h...@wsr.ac.at | bleiben, mir und andern." __/ | http://www.hjp.at/ |-- Wolfram Heinrich in desd signature.asc Description: Digital signature
Re: Perl coredump when using ora_dbh_share to connect to Oracle DB's
2010/4/1 Wesley Schwengle : > On 01.04.10 03:02 John Scoles wrote: > >> Hard to say exatly are you sure you are connecting to oracle corretly?? >> >> use DBI; >> >> my $dsn = 'DBI:Oracle:host=localhost;port=1527;sid=XXX'; >> >> is a rather odd dsn > > I always the the method above, although I don't define the host and port > part, > since it is known in tnsnames. But the dsn part looks normal to me :) The connect works absolutely fine when I cut off ora_dbh_share parameter. Best, Jens
Re: Perl coredump when using ora_dbh_share to connect to Oracle DB's
2010/4/1 John Scoles : >> Date: Wed, 31 Mar 2010 16:31:11 +0200 >> Subject: Perl coredump when using ora_dbh_share to connect to Oracle DB's >> From: rehs...@googlemail.com >> To: dbi-users@perl.org; pa...@pythian.com >> CC: karl.li...@lisse.it >> >> Hi all, >> >> I get a core dump when using attached script to connect to an Oracle >> DB. Anyone here having a hint what's going wrong? >> I need this (probably) to get Log::Log4perl::Appender::DBI run fine in >> a multithreaded environment. >> > Hard to say exatly are you sure you are connecting to oracle corretly?? Correct, because the list-software cut my attachments :( See http://www.netbsd.org/~sno/orathreads.pl and http://www.netbsd.org/~sno/orathreads.trace to get the files. Best regards, Jens