Re: TNS can't resolve service name

I've already changed the tnsnames.ora and listener.ora It _has_ connected OK once, what else could be wrong?

thanks,

• Kev

Sybrand Bakker wrote in message
<935083724.4065.0.pluto.d4ee154e_at_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:58:56 CDT