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: Connectivity help

Re: Connectivity help

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Mon, 14 Nov 2005 09:37:01 -0600
Message-ID: <3nbhn1hu9sj8fsr1gcdk3aps041kimrss0@4ax.com>


"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

Original text of this message

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