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: TNS could not resolve service name problem

Re: TNS could not resolve service name problem

From: opus <opus_at_nospam.ca>
Date: Wed, 27 Oct 1999 13:18:21 -0400
Message-ID: <s1ecv3ojr0842@corp.supernews.com>


Your tnsnames.ora file on Server B has an incorrect entry for Instance B. This file is either in /etc or in $ORACLE_HOME/network/admin. No need to shut anything down on Server B or A.

Jimmy <c6635500_at_comp.polyu.edu.hk> wrote in message news:3817F03D.B2C475D8_at_comp.polyu.edu.hk...
> Hello all,
>
> Two Solaris server, A and B. Oracle 7.3 on server A.
>
> On server A, running sqlplus can connect two instances instanceA and
> instanceB. However, on server B, running sqlplus can only connect
> instanceA and an error message 'TNS could not resolve service name' was
> shown.
>
> How can I make the SQLPLUS on serverB connect to instanceB? Should I
> shutdown the Solaris server after making changes on Solaris server B?
>
> Thanks,
> Jimmy
>
Received on Wed Oct 27 1999 - 12:18:21 CDT

Original text of this message

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