Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Service name can not be resolved
Thomas Schwickert wrote:
>
> 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
Thanks both of you. Yes, I found my another tnsnames for Server Manager
version.
C Chang Received on Wed Sep 12 2001 - 22:29:14 CDT