Ora-2080 Database Link Is In Use - Closing a Database Link When Using TG4DB2 From a PRO*C Program (Doc ID 392335.1)

Last updated on JANUARY 19, 2017

Applies to:

Precompilers - Version 8.0.3.0 to 10.2.0.4
Oracle Database Gateway for DB2 - Version 8.0 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 07-Apr-2008***
***Checked for relevance on02-Jan-2014***
Oracle Transparent Gateway for DB2 - Version: 8.0 to 10.2


Symptoms

 

Error ora-2080 is raised when closing a Database link to a DB2 database from a PRO*C program using Transparent Gateway for DB2 (TG4DB2) :

    ERROR:
    ORA-02080: database link is in use

COMMIT/ROLLBACK statement was executed successfully. 
V$OPEN_CURSOR shows cursors open after commit.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms