Hi,
Thanks for your time in looking this over.
I currently have DBI, DBD:Oracle running
fine talking to my 7.3.4 databases. This is on
an HP-UX 11.0 platform.
But, as everyone knows, 7.3.4 is ancient history and
the move is on toward 8.1.7 (we tend to lag behind the
times).
I installed an 8.1.7 database on another server.
I have a little script that I run that checks to
see if I can log in to a database. It's called isup.pl
and it looks like this:
------------------ isup.pl -------------------------
#!/usr/contrib/bin/perl -w
BEGIN
{
$ENV{ORACLE_HOME} = '/app/oracle/product/7.3.4';
}
use DBI;
print "trying ${ARGV[0]}\n";
$dbh = DBI->connect( "dbi:Oracle:${ARGV[0]}",$ARGV[1], $ARGV[2] );
if ( defined $dbh )
{
print "${ARGV[0]} is active\n";
exit 0;
}
else
{
exit $DBI::err;
}
--------------------end of isup.pl ---------------------------
As you can see, I still just have 7.3.4 on this machine.
I am able to run sqlplus and talk to the remote 8.1.7 database.
prompt >sqlplus user/pass@FL01
SQL*Plus: Release 3.3.4.0.0 - Production on Wed Apr 17 15:31:45 2002
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
SQL>
Fine!
But when I try to run isup.pl pointed to the remote database I get this:
prompt >isup.pl FL01 user pass
trying FL01
********** Internal heap ERROR 17112 addr=0x7f765728 *********
***** Dump of memory around addr 0x7f765728:
7F765520 7F78EED0 7F78E280 7F789770 D10DB460 D10DB468
7F78C2B0
7F765540 D10DB498 7F78F0D0 7F78C330 D10DB4A0 D10DB4B0 7F78F174 7F776898
D10DB470
7F765560 7F789C70 D10DB478 7F789CE0 D10DB488 7F789D38 D10DB490 7F789D70
7F78F258
7F765580 7F78F34C 7F78F200 D10E9DF8 D10E9E28 7F78F328 7F785EC0 D10F15D0
D10E9F08
7F7655A0 7F78F0EC D10E9F38 D10E9F70 D10E9FA0 7F78EEA0 D10E9E58 7F7866C8
D10E9E98
7F7655C0 D10E9EC8 D10E9EE8 D10E9C78 7F785318 7F77CF50 D10D5A88 D10F2320
D10E9D40
7F7655E0 7F78F0CC D10E9D80 D10E9DC0 D10DA338 7F78EF34 D10E9CA8 D10DB888
D10E9CC0
7F765600 D10E9CF8 D10E2F30 7F78EFF0 7F78F294 D10E9D20 D10DB870 7F77FD20
7F77AD38
7F765620 7F788FC0 7F78F254 7F78F1FC D10DEC68 7F78EF10 7F78F154 D10DB610
7F78F0E8
7F765640 7F789D90 7F78EF90 7F78F428 D10DEC48 7F78C398 7F78D680 7F789F90
7F788418
7F765660 7F78F0C8 D10DA3E8 D10F6B70 7F78EFEC 7F78F290 7F787170 7F77FDE0
7F78F260
7F765680 7F78F548 D10EB130 D10EB150 7F78A050 D10EB1F8 7F78F150 D10EB228
D10DB448
7F7656A0 D10EB258 D10DB450 7F78F0E4 D10EB288 D10DB458 D10EB168 D10EB190
D10EB1B8
7F7656C0 D10EB1D8 7F786050 7F78ED50 7F78F130 D10D9F58 7F78F0C4 7F779068
7F78F29C
7F7656E0 7F78EF68 7F78F25C D10EB2B8 D10EB2D8 7F78F164 7F78EAD0 D10F1578
D10EB398
7F765700 7F78F14C D10EB3C8 D10EB3F0 D10EB420 D10EB2F8 D10EB320 D10EB348
7F78EFE0
7F765720 7F78F2C0 7F78C448 D10EB370 D10DDE88 7F78ED10 7F78E9E8 00001740
7F78DD98
7F765740 7F78F12C D10F2338 7F78F0C0 7F789FB8 7F78F298 D10E2E38 7F78E1E0
7F78EFA4
7F765760 7F77FDC8 7F78F148 D10EAFE8 D10EB008 7F785698 7F78F2BC 7F788870
D10EA738
7F765780 7F77F248 D10EA768 D10E2E20 7F785D30 7F77F268 D10D25A8 D10E2E70
D10EA808
7F7657A0 7F78F128 D10EA840 D10E5F90 D10EA878 D10E5F80 7F78F0BC D10EA898
D10EA788
7F7657C0 D10EA7A8 D10EA7C8 D10EA7E8 7F78F284 7F785BA0 D10F7660 7F78F520
7F77FCA8
7F7657E0 D10EB018 7F78F438 D10EB038 D10EB0B0 7F78F144 7F78F168 7F78F480
D10EB0D8
7F765800 D10DB5C8 7F7949D0 D10F7CBC D10F7C8C D10F7D60 D10F7B00 D10F7AF0
D10F7810
7F765820 D10F7868 D10F7750 D10F776C D10F7748 D10F7728 7F78F630 7F78EC08
D10F7720
.............. snipped ........
and lots of other nasty stuff ending with
Bus error(coredump)
A 'file core' says:
core: core file from 'isup.pl' - received SIGBUS
Versions: I am running Perl 5.0 patchlevel 5 subversion 3
This is HP-UX 11.0 Note ___perl was built under 10.20.
but it has been working fine under 11.0. Rebuilding perl under
HP-UX 11.0 is something I am willing to try, but I'm mystified
as to how that would be the problem.
Oracle 7.3.4 (client side) and 8.1.7 (server side-- Linux by the
way.)
DBI version I believe is 1.13
DBD:Oracle is 1_03
I've thought about just getting all the newest stuff and starting from
scratch. But the fact that sqlplus works whereas DBI/DBD does not is
really strange.
--
Chris Howard CIS Database Administrator
Platte River Power Authority (970) 229 5248
