Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> TNS still can't resolve service name

TNS still can't resolve service name

From: kev <kevin.porter_at_fast.no>
Date: Fri, 20 Aug 1999 11:15:55 +0100
Message-ID: <37BD2ADB.D49BAEBB@fast.no>


Hi,

I've been connecting to an Oracle DB through a Perl script quite happily for ages, but now I've changed my .ora files (I've created another DB called WWS), the script can't connect. It _has_ connected since the change, so I'm at a loss to explain why it won't any more, I guess I must have inadvertently changed something.
I get the following error message in the Perl script:

"DBI->connect failed: ORA-12154: TNS:could not resolve service name (DBD ERROR: OCIServerAttach) at /home/baldrick/demo/baldrick0.2.pl line 176"

BTW I _have_ changed my tnsnames.ora file accordingly.

Here's an entry from the tns log file:

19-AUG-99 17:45:59 *
(CONNECT_DATA=(SID=WWS)(CID=(PROGRAM=)(HOST=<domain>)(USER=<user>))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=<ip>)(PORT=1068)) * establish *
WWS * 0 Any ideas?

thanks,

Received on Fri Aug 20 1999 - 05:15:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US