SID SERIAL# USERNAME Term Resource Type TAB OWNER ID1 ID2 Lock Held Lock Req. CTIME
------- ------- ---------- ------ -------------------- ---------- -------- -------- -------- -------------- --------------
2592 5045 TRFF_APP CHINA- TOSystem GGS_STICK GGS 106853 1 Row Exclusive 171689
808CF6 99E
2538 16209 SYS pts/0 TOSystem GGS_STICK GGS 106853 1 Row Exclusive 1097
2569 45087 YWXT_USER unknow TOSystem GGS_STICK GGS 106853 1 Row Exclusive 92038 n
2538 16209 SYS pts/0 TOSystem GGS_BF_CAC GGS 106815 1 Row Exclusive 1094 HE
2712 135 YWXT_USER unknow TOSystem GGS_STICK GGS 106853 1 Row Exclusive 88323 n
2517 19239 TRFF_APP unknow TOSystem GGS_STICK GGS 106853 1 Row Exclusive 68628 n
解释:在metalink上有文章“OGG GGS_STICK getting locked during the DDL Upgrade [ID 1441479.1]”专门处理了这个问题。
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.
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
GGS_STICK is locked by SMON
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.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11088128/viewspace-722701/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11088128/viewspace-722701/