Re: Service name can not be resolved

Hi,

"C Chang" <cschang_at_maxinter.net> wrote in message news:3B9ED9BA.1233_at_maxinter.net...

> I have added a new TNSNAME blcok to connect to a new server. However, I
> can use the SQL plis to connect it. But I can not connect the same
> database with the Schema Manager tool (8.1.5). It will return the error
> message -" the service cannot be resolved" What did I do wrong?
>
> C chang

you have to Oracle-Homes: One for Oracle Client, one for Oracle enterprise manager.
Both versions have their owne tnsnames.ora

You have to made your changes to both tnsnames.ora ! Hoever, in my opionion, the next possibility is better: Set the environment variable TNS_ADMIN to the path of your 'main' tnsnames.ora
i.e. TNS_ADMIN=c:\oracle\ora81\network\admin

Hth
 Thomas

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG