My Oracle Support Banner

After DB upgrade to 11.2.0.4, Database Link (DBLink) Target is dumping multiple *.aud files when DBLink is used (Doc ID 2745786.1)

Last updated on JANUARY 21, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Net Services - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.


*NOTE: All values in this SR are fictitious and do not represent any actual or existing environments.

Symptoms

Two databases were upgraded from 11.2.0.3 (this example on Solaris 10 container) to 11.2.0.4.
The TNS Listeners servicing these databases were also upgraded to 11204.

After this, the two Databases were involved in an overnight "ETL job" which used an existing Database Link (DBLink) but this was now taking an extremely long time to run.
A job that used to take ~4 min to run now runs for over 10 hrs and then fails.

In addition, there are constant *.aud files being dumped under $ORACLE_BASE/admin//adump in the TARGET Database for the dblink from the start of the ETL until death.
In this case, around 0.5 Million audit files were created over the 10 hour period.


Audit files are small but numerous, and contain information as below:




Changes

 This was an upgrade of a single set of Databases from 11.2.0.3 to 11.2.0.4 which were using legacy DBLinks for ETL jobs.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.