GOLDEN GATE开起DDL出现ORA-00060:Dead Lock问题

ccton

数据库版本:
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
golden gate 版本:
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
报错信息
Fri Feb 01 09:09:28 2013
ORA-00060: Deadlock detected. More info in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_25655.trc.
ORA-00060: Deadlock detected. More info in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_25655.trc.
TRACE文件见附件,请帮忙分析下

lunar

你这个系统有触发器吧？禁用触发器试试看

ccton

触发器都是安装ORACLE自动生成的，并非是用户创建的，怕禁用后对数据库有影响哦
SQL> select distinct owner From dba_triggers where status='ENABLED';

OWNER
------------------------------
MDSYS
OLAPSYS
FLOWS_FILES
SYSTEM
APEX_030200
SYSMAN
XDB
SYS

8 rows selected
其实这个死锁，感觉有点看不懂，竟然是在同一个会话下产生的
Deadlock graph:
                       ---------Blocker(s)--------  ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds waits
TX-000a001d-00005463        31    1152     X             31    1152           S

newway

你没有提供你的goldengate版本，这个问题在一些ogg版本上会出现,某些操作会触发这个bug.我曾经开过相关的SR.MOS上可以参考：
ora-60 deadlock on GGS_STICK caused by GoldenGate DDL trigger [ID 1465045.1]

ccton

上面写了版本的
golden gate 版本:
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
谢谢 @newway 我去看下