> -----Original Message----- > From: Udo Grabowski [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2003 13:51 > To: [EMAIL PROTECTED] > Subject: DBD:Oracle : TNS:listener could not resolve SERVICE_NAME > > > 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 ! > >>snip > -- > 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 >
This is an oracle/environmental problem not a perl/DBI one. Does SQL plus work with the same environment? Is ORACLE_HOME set correctly. Basically the error states that the xxSUNhostxx cannot be resovled using the TNS method. (Usually a tnsnames.ora file in $ORACLE_HOME/network/admin directory but your environment may be different. (Also I don't know about Oracle 9) Ken.
