Re: TNS can't resolve service name

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 19 Aug 1999 19:28:21 +0200
Message-ID: <935083724.4065.0.pluto.d4ee154e@news.demon.nl>

Your tnsnames.ora is not longer correct. You need to change it to refer to the SID WWS.

Hth,

Sybrand Bakker, Oracle DBA

kev <kevin.porter_at_fast.no> wrote in message news:37BC3550.218E4DB9_at_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,
>
> - Kev
>
Received on Thu Aug 19 1999 - 12:28:21 CDT