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...
Received on Thu Aug 10 2006 - 05:31:04 CDT
