Hello all!
Having this error? Probably something like this:
ORA-00600: internal error code, arguments: [17147], [0x7F0315C53788], [], [], [], [], [], [], [], [], [], []
This is a known error. The best match on MOS is GoldenGate 12c IntRep Crash W/ ORA-600 [kghfrmrg:nxt] ;ORA-600[kghfrh:ds]; ORA 600 [17114]; [17147] (Doc ID 1666909.1)
This error is caused by GGate Bug as per described in:
– Bug 18270073 : OGG INTEGRATED REPLICAT ORA-600 [17147] , ORA-600 [KGHFRMRG:NXT]
– Bug 18155575 : AFTER APPLYING PATCH 17451407, OGG-2544, ORA-26753 ON INTEGRATED REPLICAT
The known solution is apply GoldenGate patch 18155575.
Below my trace to comparison with your investigation:
Trace file /u01/app/oracle/diag/rdbms/proddb/PRODDB1/trace/PRODDB1_as01_21424.trc Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security, OLAP, Advanced Analytics and Real Application Testing options ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1 System name: Linux Node name: oracledbserver Release: 3.8.13-118.4.2.el7uek.x86_64 Version: #2 SMP Tue Mar 22 20:46:48 PDT 2016 Machine: x86_64 Instance name: PRODDB1 Redo thread mounted by this instance: 1 Oracle process number: 227 Unix process pid: 21424, image: oracle@oracledbserver (AS01) *** 2017-03-22 06:15:49.695 *** SESSION ID:(9166.65484) 2017-03-22 06:15:49.695 *** CLIENT ID:() 2017-03-22 06:15:49.695 *** SERVICE NAME:(SYS$USERS) 2017-03-22 06:15:49.695 *** MODULE NAME:(GoldenGate) 2017-03-22 06:15:49.695 *** CLIENT DRIVER:() 2017-03-22 06:15:49.695 *** ACTION NAME:(OGG$RCLA1 - Apply Reader) 2017-03-22 06:15:49.695 Incident 4038988 created, dump file: /u01/app/oracle/diag/rdbms/proddb/PRODDB1/incident/incdir_4038988/PRODDB1_as01_21424_i4038988.trc ORA-00600: internal error code, arguments: [17147], [0x7F0315C53788], [], [], [], [], [], [], [], [], [], [] *** 2017-03-22 06:17:56.718 Incident 4038989 created, dump file: /u01/app/oracle/diag/rdbms/proddb/PRODDB1/incident/incdir_4038989/PRODDB1_as01_21424_i4038989.trc ORA-00600: internal error code, arguments: [17147], [0x7F0315C53788], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [17147], [0x7F0315C53788], [], [], [], [], [], [], [], [], [], [] *** 2017-03-22 06:18:00.620 ORA-00600: internal error code, arguments: [17147], [0x7F0315C53788], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [17147], [0x7F0315C53788], [], [], [], [], [], [], [], [], [], [] OPIRIP: Uncaught error 447. Error stack: ORA-00447: fatal error in background process ORA-00600: internal error code, arguments: [17147], [0x7F0315C53788], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [17147], [0x7F0315C53788], [], [], [], [], [], [], [], [], [], []
See you next week!