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

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 10 Aug 2006 16:38:03 GMT
Message-ID: <J3sJJG.I55@igsrsparc2.er.usgs.gov>

gurinder.kabbay_at_gmail.com wrote:
> 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
>

What happens when you try 'tnsping userdb'?

Have you set the TNS_ADMIN environment variable to some value?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Thu Aug 10 2006 - 11:38:03 CDT