RE: Rookie Error?

  • From: Frits Hoogland <frits.hoogland@xxxxxxxxxxxxx>
  • To: "'mhthomas '" <qnxodba@xxxxxxxxx>, "'oracle-l-bounce@xxxxxxxxxxxxx '" <oracle-l-bounce@xxxxxxxxxxxxx>, "'Jared Still '" <jkstill@xxxxxxxxx>
  • Date: Sun, 28 Nov 2004 14:52:54 +0100

try the nmap utility from both sides. ping isn't relieable, because icmp
uses udp on a lower layer. sqlnet/oracle net uses tcp.

frits

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
To: Jared Still
Cc: Oracle-L Freelists
Sent: 28-11-2004 10:54
Subject: Re: Rookie Error?

Ping should verify your firewall is not a problem. 

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@xxxxxxxxx>
wrote:
> already tried ping with IP, hostname and FQDN.
> 
> Thanks,
> 
> Jared
--
//www.freelists.org/webpage/oracle-l

This e-mail and any attachment is for authorised use by the intended 
recipient(s) only. It may contain proprietary material, confidential 
information and/or be subject to legal privilege. It should not be copied, 
disclosed to, retained or used by, any other party. If you are not an intended 
recipient then please promptly delete this e-mail and any attachment and all 
copies and inform the sender. Thank you.
--
//www.freelists.org/webpage/oracle-l

Other related posts: