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

Last updated on FEBRUARY 20, 2019

Applies to:

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

SMON process is holding locks on ggs_stick:

Checking for sessions that are holding locks on Oracle GoldenGate 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@<machine_name>

Details of locks being held:

INST_ID SID SERIAL# OBJECT_LOCKED

---------- ---------- ---------- ----------------------------------------------------------------

LOCK_TYPE

------------------------------------

2 760 1 GGS_STICK

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

	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

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