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 -> ORA-12154: TNS:could not resolve service name

ORA-12154: TNS:could not resolve service name

From: <gurinder.kabbay_at_gmail.com>
Date: 10 Aug 2006 02:17:29 -0700
Message-ID: <1155201449.308816.182150@b28g2000cwb.googlegroups.com> 





Hi,


I am using Oracle 10g with windows XP. I've a service name USERDB and
the database userdb is in shared server configuration. I works fine if
I try to connect from SQL*PLUS. But when I try to connect from sqlplus
D:\Set Oracle_SID=userdb


D:\sqlplus /nolog


SQL>conn scott/tiger_at_userdb


SQL>ORA-12154: TNS:could not resolve service name.



SQL>


Anybody having some idea to resolve this....
Thanks in advance
Received on Thu Aug 10 2006 - 04:17:29 CDT












Original text of this message













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