Hello !
A rather difficult setup:
A 64 bit Oracle 9i Solaris 8 installation, runs with Sun cc
compiled 32 bit Perl 5.8/DBI-1.32/DBD:Oracle-1.12 against
32 bit library path $ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32.
Complicated, but works (have a small script showing Table names
to test this) !
Now I want to access the same database on the Sun from Tru64 (Alpha):
Installed same Oracle software only (64bit only). Have an 64 bit Tru64
cc compiled perl 5.6(see output below)/DBI-1.32/DBD:Oracle-1.12,
library path $ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib (64bit).
I try with the same test script and get the following error:
"DBI connect('xxSUNhostxx','yyyy',...) failed: ORA-12514: TNS:listener could not
resolve SERVICE_NAME given in connect descriptor (DBD ERROR: OCIServerAttach)
at dbi_test.pl line 3 " (minor edits ;-)
This is the connect line:
#!/usr/bin/perl -w
use DBI;
$dbh = DBI->connect("DBI:Oracle:xxSUNhostxx",'yyyy', 'zzpasszz',
{RaiseError => 1});
What's wrong here ? Is it a BigEndian(Sun) <--> little Endian(Alpha)
problem (how to deal with this) ? Or is it the older perl version?
Thanks for any help !
PS: Here's the perl 5.6 -V output on the Alpha:
-------------------
Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration:
Platform:
osname=dec_osf, osvers=5.1, archname=alpha-dec_osf
uname='osf1 himalaya x5.1 987 alpha '
config_args='-des -Dlibpth=/usr/shlib /usr/lib /usr/ccs/lib
-Dusemymalloc=no -Dprefix=/usr/lib/perl-5.6.0
-Dman1dir=/usr/share/doclib/annex/man/man1
-Dman3dir=/usr/share/doclib/annex/man/man3 -Dccflags=-fprm d -ieee
-Doptimize=-O4 -Dhostcat=cat /etc/hosts -Dmyhostname=localhost -Umydomain=
-Dcf_by=perlhelp -Dcf_email=root@localhost'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define
use64bitint=define use64bitall=define uselongdouble=undef usesocks=undef
Compiler:
cc='cc', optimize='-O4', gccversion=
cppflags='-ieee -std -DLANGUAGE_C'
ccflags ='-fprm d -ieee -std -DLANGUAGE_C'
stdchar='unsigned char', d_stdstdio=define, usevfork=false
intsize=4, longsize=8, ptrsize=8, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='ld', ldflags =''
libpth=/usr/shlib /usr/lib /usr/ccs/lib
libs=-ldbm -ldb -lm -liconv
libc=/usr/shlib/libc.so, so=so, useshrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='
-Wl,-rpath,/usr/lib/perl-5.6.0/lib/5.6.0/alpha-dec_osf/CORE'
cccdlflags=' ', lddlflags='-shared -expect_unresolved "*" -O4 -msym -std -s'
Characteristics of this binary (from libperl):
Compile-time options: USE_64_BIT_INT USE_64_BIT_ALL USE_LARGE_FILES
Built under dec_osf
Compiled at Oct 31 2000 12:57:11
@INC:
/usr/lib/perl-5.6.0/lib/5.6.0/alpha-dec_osf
/usr/lib/perl-5.6.0/lib/5.6.0
/usr/lib/perl-5.6.0/lib/site_perl/5.6.0/alpha-dec_osf
/usr/lib/perl-5.6.0/lib/site_perl/5.6.0
/usr/lib/perl-5.6.0/lib/site_perl
.
--
Dr. Udo Grabowski email: [EMAIL PROTECTED]
Institut f. Meteorologie und Klimaforschung II, Forschungszentrum Karslruhe
Postfach 3640, D-76021 Karlsruhe, Germany Tel: (+49) 7247 82-6026
http://www.fzk.de/imk/imk2/ame/grabowski/ Fax: " -6141
