Re: tns: remote is fine, local hangs

I am not sure if you have an entry for "rykers" in your tnsnames.ora on your database server machine.

Make sure you have that on your server similar to one you have on other client machines.

Just a thought.

Let me know if this is what you overlooked or ignored.

I am not sure of your situation though.

let me know in any case, if that is the problem or this is not the problem and something else is the problem.

I would be interested.

In an attempt to help you out,

Manoj Jain
Certified Oracle DBA

In article <6vgvfc$auu$1_at_nnrp1.dejanews.com>,   bracher_at_my-dejanews.com wrote:
> ok,
>
> I've got an oracle 8.05 instance running, works fine. I can
> connect successfully from any machine on my network via tns
> _except_ for the machine that the instance is built on...
>
> I don't get any errors. instead, tnsping or sqlplus just hangs
> and hangs. I've got a tnsping that's been sitting at
>
> $ tnsping rykers
>
> TNS Ping Utility for Solaris: Version 8.0.5.0.0 - Production on 07-OCT-98
> 17:00:47
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> for an hour now...
>
> thoughts or suggestions?
>
> - mark
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 08 1998 - 01:47:48 CDT