Re: diagnosing db link errors

It does sound like network troubles, I have seen firewalls create this kind of problem also. If you are confident of your local client, then the problem is that the destination listener isnt available, for whatever reason, be it not started, new firewall installed, network down, or server down,

On Fri, May 30, 2008 at 7:43 AM, <TESTAJ3_at_nationwide.com> wrote:

>
> can u ping the server?(making an assumption here that they allow ping), if
> that works, its not a network issue.
>
> I have seen that error when implementing IP address allow/deny parm in
> protocol.ora (now in sqlnet.ora).
>
>
> Thanks, Joe
>
> ---------------------------------------
> You can have it: Fast, Right or Cheap, pick 2 of the 3.
> Fast + Right is Expensive
> Fast + Cheap will be incorrect.
> Right + Cheap will take a while.
>
>
> *"Rick Ricky" <ricks12345_at_gmail.com>*
>
> *Sent by:** **oracle-l-bounce_at_freelists.org*
>
>
>
>
> *05/30/2008 08:36 AM*
> Please respond to ricks12345_at_gmail.com From
> *"Rick Ricky" <ricks12345_at_gmail.com>*
> To
> oracle-l_at_freelists.org cc
> Subject
> diagnosing db link errors
>
>
>
>
> Yesterday I have no problem using a database link. Today I am getting tns
> errors. I have no access to the DB server (its owned by a different vendor).
> I have to go through channels to contact them. Is there anything I can do to
> diagnose whether its a network issue or the database/server is down. This is
> the oracle error I got.
>
> ERROR at line 1:
> ORA-12560: TNS:protocol adapter error
>
> tried tnsping and I could not reach the box. I don't have alot to go on,
> but I don't want to sit around and wait for a response.
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l