【故障-ORACLE】GGS_STICK出來大量鎖的問題

Applies to:

Oracle GoldenGate - Version: 11.1.1.1.3 and later [Release: 11.1.1.1 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

GGS_STICK is locked by SMON

Solution

We have reported a bug #13825904, where there is an enhancement that will allow the ddl_setup to run without checking the locks. This feature would be added in the latest versions from OGG V11.2.

As a workaround, please modify the params.sql (found in the OGG install location) and include the below, then redo the process of DDL upgrade.

define _skip_lock_check = 'SMON'

define _skip_create_objects = 'TRUE'

** Bouncing the database can also be one of the options to let the locks to be cleared out on source, if this is acceptable.