A couple have folks have suggested tnsnames.ora problems.
Go back and read the original post and you will see that it
cannot be tnsnames.ora.
No weird settings in the other files. They are all manipulated
directly via netmgr. There is no protocol.ora.
Jared
On Sun, 28 Nov 2004 04:54:00 -0500, mhthomas <qnxodba@(protected) > wrote:
>
> If you can ping then make sure you are parsing the correct
> tnsnames.ora file with the alias you expect. Also, check the other
> .ora files for any wierd settings.
>
> I create dummy aliases with odd names to verify which tnsnames.ora is
> actually being used. I change an alias on-the-fly just to make sure it
> works & doesn 't work as expected, e.g. dupe an entry as foo to connect
> locally successfully, then change the entry to foo2 and try foo to
> make sure it fails. Then, try your remote connection test.
>
> Good luck.
>
> Regards,
>
> Mike
>
>
>
>
> On Sun, 28 Nov 2004 00:27:25 -0800, Jared Still <jkstill@(protected) > wrote:
> > already tried ping with IP, hostname and FQDN.
> >
> > Thanks,
> >
> > Jared
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
