OGG GGS_STICK getting locked during the DDL Upgrade (Doc ID 1441479.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Symptoms

 
SMON process is holding locks on ggs_stick:
 
Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...
 
The following sessions are holding 1 locks on objects owned by GGS :
 
INST_ID SID SERIAL# OS_USER USERNAME
---------- ---------- ---------- -------------------------------- ----------------------------------------
PID
------------------------------------
PROGRAM
------------------------------------------------------------------------------------------------------------------------
2 760 1 oracle
12482
oracle@acctsvcdb2.iad.expertcity
 
 
 
 
Details of locks being held:
 
INST_ID SID SERIAL# OBJECT_LOCKED
---------- ---------- ---------- ----------------------------------------------------------------
LOCK_TYPE
------------------------------------
2 760 1 GGS_STICK
TO
 
 
BEGIN
*
ERROR at line 1:
ORA-20783:
GoldenGate DDL Replication setup:
*** Disconnect all sessions that are holding locks on Oracle GoldenGate metadata tables, and retry.
ORA-06512: at line 3

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