GOLDEN GATE开起DDL出现ORA-00060:Dead Lock问题
本帖最后由 ccton 于 2013-2-5 16:23 编辑数据库版本:
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文件见附件,请帮忙分析下
你这个系统有触发器吧？禁用触发器试试看 触发器都是安装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 你没有提供你的goldengate版本，这个问题在一些ogg版本上会出现,某些操作会触发这个bug.我曾经开过相关的SR.MOS上可以参考：
ora-60 deadlock on GGS_STICK caused by GoldenGate DDL trigger 上面写了版本的
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 我去看下
页:
[1]