RE: diagnosing db link errors
Date: Fri, 30 May 2008 11:41:11 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A902686119@usahm208.amer.corp.eds.com>
I agree in that just because you can ping a remote destination IP does
not mean that you cannot have a network (firewall) issue. The ping
could be allowed through but the port used to reach the listener or that
the listener assigns for use by your session may be blocked.
If tnsping worked yesterday but not today then a change has occurred on one side or the other. If you can verify no change to the client the the change is at the target.
- Mark D Powell --
Phone (313) 592-5148
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber
Sent: Friday, May 30, 2008 8:58 AM To: TESTAJ3_at_nationwide.com Cc: ricks12345_at_gmail.com; oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org Subject: Re: diagnosing db link errors It does sound like network troubles, I have seen firewallscreate 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'thave 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-lReceived on Fri May 30 2008 - 10:41:11 CDT