ORA-00600: internal error code, arguments: [ktbesc_p lugged] while running Oracle Golden Gate replicate against a plugged in (transported) tablespace
October 19, 2012 by Nakinov · Leave a Comment
It is Friday and my replicate process has failed after 24h of processing without problems. The ggserr.log looks like this:
1
2
3
4
5
6
7
|
2012-10-19 12:13:09 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle,
rprod01.prm: OCI Error ORA-00600: internal error code, arguments: [ktbesc_plugged], [], [], [], [], [], [], [], [], [], [], [] (status = 600), SQL <INSERT INTO "OWNER" . "TABLE_NAME" ( "CO_ID" , "SNCODE" , "SEQNO" , "SEQNO_PRE" ,
"BCCODE" , "PENDING_BCCODE" , "DN_ID" , "DN_BLOCK_ID" , "MAIN_DIRNUM" , "CS_STATUS" ,
"CS_ACTIV_DATE" , "CS_DEACTIV_DATE" , "CS_REQUEST" >.
2012-10-19 12:13:09 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle,
rprod01.prm: Aborted grouped transaction on 'OWNER.TABLE_NAME' , Database error
600 (OCI Error ORA-00600: internal error code, arguments: [ktbesc_plugged], [], [], [], [], [], [], [], [], [], [], [] (status = 600), SQL <INSERT INTO "OWNER" .
"TABLE_NAME" ( "CO_ID" , "SNCODE" , "SEQNO" , "SEQNO_PRE" , "BCCODE" , "PENDING_BCCODE" ,
"DN_ID" , "DN_BLOCK_ID" , "MAIN_DIRNUM" , "CS_STATUS" , "CS_ACTIV_DATE" , "CS_DEACTIV_DATE" ,
"CS_REQUEST" >).
2012-10-19 12:13:09 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle,
rprod01.prm: Repositioning to rba 88420041 in seqno 260.
2012-10-19 12:13:30 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle,
rprod01.prm: SQL error 600 mapping OWNER.TABLE_NAME to OWNER.TABLE_NAME OCI Error ORA-00600: internal error code, arguments: [ktbesc_plugged], [], [], [], [], [], [], [], [], [], [], [] (status = 600), SQL <INSERT INTO "OWNER" .
"TABLE_NAME" ( "CO_ID" , "SNCODE" , "SEQNO" , "SEQNO_PRE" , "BCCODE" , "PENDING_BCCODE" ,
"DN_ID" , "DN_BLOCK_ID" , "MAIN_DIRNUM" , "CS_STATUS" , "CS_ACTIV_DATE" , "CS_DEACTIV_DATE" ,
"CS_REQUEST" >.
2012-10-19 12:13:30 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle,
rprod01.prm: Repositioning to rba 88556003 in seqno 260.
2012-10-19 12:13:30 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle,
rprod01.prm: Error mapping from OWNER.TABLE_NAME to OWNER.TABLE_NAME. 2012-10-19 12:13:30 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle,
rprod01.prm: PROCESS ABENDING. |
On the Oracle Support I found that this is a know bug in 11.2.0.3.0 with a document that dates from 16-OCT-2012. How unlucky I am since today is 19-OCT-2012? Oh and yes, my DB is created using transportable tablespaces.
1
2
|
NB Bug Fixed Description 12919564 11.2.0.3.2, 11.2.0.3.BP04, 12.1.0.0 ORA-600 [ktbesc_plugged] executing SQL against a Plugged in (transported) tablespace
|
Solution
As a quick win and hoping that this parameter will not affect the performance is to set the value of the hidden parameter “_fastpin_enable”=0. As per document this bug is fixed in 11.2.0.3.2 patch set. After setting _fastpin_enable=0, OGG replicate process was able to continue.
1
2
3
|
2012-10-19 13:54:34 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start replicat RPROD01.
2012-10-19 13:54:35 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle,
rprod01.prm: REPLICAT RPROD01 starting. 2012-10-19 13:54:36 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle,
rprod01.prm: REPLICAT RPROD01 started. |
Related Oracle Documents
- ORA-600 [ktbesc_plugged] [ID 1380561.1]
- Bug 12919564 – ORA-600 [ktbesc_plugged] executing SQL against a Plugged in (transported) tablespace [ID 12919564.8]
Happy Oracle Golden Gating!
相关推荐
NULL 博文链接:https://gembler.iteye.com/blog/346242
Patch 8922013: ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [17059], [0X93953434]
在oracle里面运行一下,解决Exception java.sql.SQLException ORA-00600 内部错误代码
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [13], [1990],这是我自己整理的,已经试验过了
——————————————————————————– p align=”JUSTIFY”>ORA-00600:internal error code,arguments:[num],[?],[?],[?],[?] 产生原因:这种错误通常为ORACLE的内部错误,只对OSS和ORACLE...
在处理一则ORA-600 [4194]案例时,参考MOS文档:Step by step to resolve ORA-600 4194 4193 4197 on database crash (文档 ID 1428786.1) 1.对于ORA 600[4194]的解释 ...ORA-00600: internal error code,
ORA-00600:internal error code,arguments:[num],[?],[?],[?],[?]产生原因:这种错误通常为ORACLE的内部错误,只对OSS和ORACLE开发有用。ORA-600的错误经常伴随跟踪文件的状态转储(系统状态和进程状态),系统状态...
Double-clicking on a packaged function or procedure could lead to a "Function not valid" error message Logging off a session did not update the transaction status in the Window List Creating new ...
ERROR: ORA-01035: ORACLE 只允许具有 RESTRICTED SESSION 权限的用户使用 6、startup force 强制启动方式 当不能关闭数据库时,可以用startup force来完成数据库的关闭 先关闭数据库,再执行正常启动数据库命令 ...
ERROR: ORA-01035: ORACLE 只允许具有 RESTRICTED SESSION 权限的用户使用 6、startup force 强制启动方式 当不能关闭数据库时,可以用startup force来完成数据库的关闭 先关闭数据库,再执行正常启动数据库命令 ...