Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Service name can not be resolved

Re: Service name can not be resolved

From: C Chang <cschang_at_maxinter.net>
Date: Wed, 12 Sep 2001 23:29:14 -0400
Message-ID: <3BA0280A.6F74@maxinter.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US