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

Home -> Community -> Usenet -> c.d.o.misc -> TNS Resolve SERVICE_NAME

TNS Resolve SERVICE_NAME

From: Randy Harris <randy.harris_at_nospam.net>
Date: Fri, 27 Dec 2002 22:13:46 GMT
Message-ID: <ug4P9.10353$4j5.6237705@newssvr28.news.prodigy.com> 





Would someone kindly explain how an 8i client resolves the SERVICE_NAME in
the connect descriptor?  I have multiple client systems that get this error
message:



ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor



when attempting to connect to an 8.1.7 database. If I change the connect
descriptor in tnsnames.ora from SERVICE_NAME = to SID =, then they will
connect.  What do I have wrong?


--
Randy Harris


Received on Fri Dec 27 2002 - 16:13:46 CST












Original text of this message













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