Process Deadlock

From: rjgst3 <rjgst3_at_rmu.edu>
Date: 27 Feb 2007 06:43:24 -0800
Message-ID: <1172587404.373736.207430@z35g2000cwz.googlegroups.com>

I working with Oracle 10g and consider myself as a beginner. I'm using dbms_job to run processes over a db link and I'm encountering issues with a dealock on the link. I'm trying to find some sort of error handling for this issue. Let me go into more detail.

I am using a db link to a teradata database to pull data back into Oracle 10g. I am using the following

CREATE DATABASE LINK "Teradata"

CONNECT TO "TERA_USER" IDENTIFIED BY "PSWRD" USING 'TD.WORLD' I notice that when my teradata password expires (30 days), my processes that use the db link deadlock somewhere? I don't know where. I tried dropping the db link and re-creating it, but of course that does not work. Also, I contact the DBA's for teradata to kill all sessions for the TERA_USER id and still, no luck. There appears to be an open session on my side, and not being the DBA, I can find the session that is in deadlock. However, if I can add error handling to my pl/sql, I think I could solve for the issue....help. Received on Tue Feb 27 2007 - 08:43:24 CST