TNS can't resolve service name

From: kev <kevin.porter_at_fast.no>
Date: Thu, 19 Aug 1999 17:48:16 +0100
Message-ID: <37BC3550.218E4DB9@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 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"

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=212.212.161.68)(PORT=1068)) * establish *
WWS * 0 Any ideas?

thanks,

Received on Thu Aug 19 1999 - 11:48:16 CDT