My Oracle Support Banner

Failed to disable TRANDATA for table due to Database error 54 (ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired) (Doc ID 2304078.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

Oracle GoldenGate - Version 11.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

 

Goldengate was considering all coloumns for capture even though primary key was there as supplemental logging was enabled for all columns

When customer tried to change supplemental logging by deleting trandata for that table , GG gave below error

ggsci > delete trandata schemaname.tablename

Failed to disable TRANDATA for table due to Database error 54 (ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired)

 

 

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
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.