ORA-00600: internal error code

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!