R: TNS could not resolve service name problem

From: C.A.M. <marcello.cremente_at_sysdata.it>
Date: Thu, 28 Oct 1999 11:31:24 +0200
Message-ID: <7v955c$29sq$1@stargate1.inet.it>

Check if the TNSNAMES.ORA file on serverB has an entry for the instanceB. If not you should not be able to access the service from ServerB.

iHiH (I Hope it Helps) :o)

Jimmy <c6635500_at_comp.polyu.edu.hk> wrote in message 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 Thu Oct 28 1999 - 04:31:24 CDT