Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Connectivity help
"J.A. Cooper" <julius.cooper_at_gmail.com> wrote:
>Hans,
>
>Thanks for your insights; they got me 85% of the way there (TNSPING
>functioning on both servers, but SQL*Plus only working locally). The
>other 15% was in the SQLNET.ORA:
>
>NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
>
>Has to be this way (it was TNS/HOST/ONAMES, but that wasn't working for
>SQL connectivity).
>
>
>Regards,
>Julius
If you are just using tnsnames.ora it can be:
NAMES.DIRECTORY_PATH= (TNSNAMES) Received on Mon Nov 14 2005 - 09:37:01 CST