Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> TNS still can't resolve service name
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,
![]() |
![]() |