Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: TNS could not resolve service name problem
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