Re: ORA-12154: TNS:could not resolve service name

Frank van Bortel wrote:
> gurinder.kabbay_at_gmail.com schreef:
> > 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
> >
> Almost correct:
> SQL>conn scott/tiger
> should do the trick.
>
> No need for a listener, as a bequeath connection is used.
> @userdb requires a userdb entry in tnsnames.ora
> in your network directory (%ORACLE_HOME\network\admin).
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

Thanks for reply.
userdb is there in tnsnames.ora that's why i able to connect from sql*plus or isqlplus using connection string userdb(user/password_at_userdb from sql*plus or isqlplus) but the problem exists only when i try to connect from sqlplus Regards,
Harcharan Received on Thu Aug 10 2006 - 11:23:33 CDT