Re: Sol 10 X64 AMD Cannot connect using simple DBI->connect() (tnsping works)
- From: "Gerard" <GerardHoran@xxxxxxxxx>
- Date: 13 Jul 2006 13:42:10 -0700
This is an Oracle bug!!!!
Since DBD:Oracel uses Oracle libs , no joy
ACTION PLAN
===========
Hi,
Good news , SUN Microsystems opened a tar today with exact problem
They happen to have Oracle make file
$ make -f demo_rdbms32.mk build EXE=CTest
OBJS=CTest.o
cc -Kpic -c -I/oracle/oracle/product/10.2.0/db_1/rdbms/demo
-I/oracle/oracle/product/10.2.0/db_1/rdbms/public
-I/oracle/oracle/product/10.2.0/db_1/plsql/public
-I/oracle/oracle/product/10.2.0/db_1/network/public
-I/oracle/oracle/product/10.2.0/db_1/precomp/public CTest.c
"CTest.c", line 55: warning: old-style declaration or incorrect type
for:
main
cc -L/oracle/oracle/product/10.2.0/db_1/lib32/
-L/oracle/oracle/product/10.2.0/db_1/rdbms/lib32/
-o CTest CTest.o -lclntsh `cat
/oracle/oracle/product/10.2.0/db_1/lib/sysliblist`
-R/oracle/oracle/product/10.2.0/db_1/lib -laio -lposix4 -lkstat -lm
-lpthread
$ file CTest
CTest: ELF 32-bit LSB executable 80386 Version 1, dynamically linked,
not
stripped
$ ./CTest
Setting up environment and connecting...
Error - ORA-12154: TNS:could not resolve the connect identifier
specified
With above findings I filed bug5389730 regarding the issue.
Bug5389730: - 10.2.0.1 32BIT OCI EXECUTABLES FAIL WITH ORA-12154 ON
SOLARIS 10 X86-64(AMD64)
So now waiting on development
Gerard wrote:
my $dbh = DBI->connect("dbi:Oracle:$dbsid", $dbuser, $dbpwd,
{'RaiseError' => 1})
FAILS
my $dbh = DBI->connect('dbi:Oracle:',
q{opwv_test/opwv@(DESCRIPTION=(ADDRESS=(P
ROTOCOL=TCP)(HOST= localhost)(PORT=1521)) (CONNECT_DATA=(SID=orcl)))},
"")
SUCCEEDS
I turned on trace and see that OCISvrAttach fails. By using truss I see
that the OCI lib seems to look for intchg.ora and tnsnav.ora NOT
tnsnames.ora.
I am suspecting some kind of 32 bit lib problem.
When I installed from CPAN and I had to remove a -xarch=amd64 from the
link line since it was trying to creat a 64 bit lib.
DBI Version 1.51 DBD-Oracle 1.17
ultraman# perl -V
Summary of my perl5 (revision 5 version 8 subversion 4) configuration:
Platform:
osname=solaris, osvers=2.10, archname=i86pc-solaris-64int
uname='sunos localhost 5.10 i86pc i386 i86pc'
config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=unde
f
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=define use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-D_TS_ERRNO',
optimize='-xO3 -xspace -xildoff',
cppflags=''
ccversion='Sun WorkShop', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long long', ivsize=8, nvtype='double', nvsize=8,
Off_t='off_t', lsee
ksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='cc', ldflags =''
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc
perllibs=-lsocket -lnsl -ldl -lm -lc
libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R
/usr/perl5/5.8.
4/lib/i86pc-solaris-64int/CORE'
cccdlflags='-KPIC', lddlflags='-G'
Characteristics of this binary (from libperl):
Compile-time options: USE_64_BIT_INT USE_LARGE_FILES
Locally applied patches:
22667 The optree builder was looping when constructing the ops
...
22715 Upgrade to FileCache 1.04
22733 Missing copyright in the README.
22746 fix a coredump caused by rv2gv not fully converting a PV
...
22755 Fix 29149 - another UTF8 cache bug hit by substr.
22774 [perl #28938] split could leave an array without ...
22775 [perl #29127] scalar delete of empty slice returned
garbage
22776 [perl #28986] perl -e "open m" crashes Perl
22777 add test for change #22776 ("open m" crashes Perl)
22778 add test for change #22746 ([perl #29102] Crash on assign
...
22781 [perl #29340] Bizarre copy of ARRAY make sure a pad op's
...
22796 [perl #29346] Double warning for int(undef) and
abs(undef) ...
22818 BOM-marked and (BOMless) UTF-16 scripts not working
22823 [perl #29581] glob() misses a lot of matches
22827 Smoke [5.9.2] 22818 FAIL(F) MSWin32 WinXP/.Net SP1 (x86/1
cpu)
22830 [perl #29637] Thread creation time is hypersensitive
22831 improve hashing algorithm for ptr tables in perl_clone:
...
22839 [perl #29790] Optimization busted: '@a = "b", sort @a'
...
22850 [PATCH] 'perl -v' fails if local_patches contains code
snippets
22852 TEST needs to ignore SCM files
22886 Pod::Find should ignore SCM files and dirs
22888 Remove redundant %SIG assignments from FileCache
23006 [perl #30509] use encoding and "eq" cause memory leak
23074 Segfault using HTML::Entities
23106 Numeric comparison operators mustn't compare addresses of
...
23320 [perl #30066] Memory leak in nested shared data
structures ...
23321 [perl #31459] Bug in read()
Built under solaris
Compiled at Jan 21 2005 15:48:11
@INC:
/usr/perl5/5.8.4/lib/i86pc-solaris-64int
/usr/perl5/5.8.4/lib
/usr/perl5/site_perl/5.8.4/i86pc-solaris-64int
/usr/perl5/site_perl/5.8.4
/usr/perl5/site_perl
/usr/perl5/vendor_perl/5.8.4/i86pc-solaris-64int
/usr/perl5/vendor_perl/5.8.4
/usr/perl5/vendor_perl
.
ultraman#
.
- References:
- Prev by Date: RE: Problem on AIX
- Next by Date: mysql installation problems
- Previous by thread: Sol 10 X64 AMD Cannot connect using simple DBI->connect() (tnsping works)
- Next by thread: No Read or Write between INSERT and UPDATE
- Index(es):
Relevant Pages
|
|
