check target of sqlplus..probably you have two or more versions of sqlplus
<gurinder.kabbay_at_gmail.com> wrote in message
news:1155201449.308816.182150_at_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 Fri Aug 11 2006 - 01:59:46 CDT
