diagnosing db link errors

From: Rick Ricky <ricks12345_at_gmail.com>
Date: Fri, 30 May 2008 08:36:50 -0400
Message-ID: <81f4c0700805300536s791752fbm635a04e260102eb9@mail.gmail.com>

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.

Received on Fri May 30 2008 - 07:36:50 CDT

Original text of this message