Hi All,
We have 3 node rac 11.2.0.3 on redhat with oracle golden gate.
Today the cluster was rebooted two times.
process failed with the below errors
Logs
------------------
2016-06-14 00:55:48 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, rep_ddl5.prm: Fatal error executing DDL replication: error [Error code [54], ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired SQL alter table UVDP.ACCT_DATA_HISTORYdrop partition P20160503 update global indexes /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
2016-06-14 00:55:48 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_ddl5.prm: PROCESS ABENDING.
2016-06-14 00:58:20 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, rep_ddl5.prm: Fatal error executing DDL replication: error [Error code [54], ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired SQL alter table UVDP.ACCT_DATA_HISTORYdrop partition P20160503 update global indexes /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
2016-06-14 00:58:20 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_ddl5.prm: PROCESS ABENDING.
2016-06-14 07:35:00 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, REP_VSCN.prm: Error mapping from ACAPT.SC_DMENT_PRO to ACAPT.SC_DMENT_PRO.
2016-06-14 07:35:00 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, REP_VSCN.prm: PROCESS ABENDING.
2016-06-14 07:37:48 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, REP_VSCN.prm: Error mapping from ACAPT.SC_DMENT_PRO to ACAPT.SC_DMENT_PRO.
2016-06-14 07:37:48 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, REP_VSCN.prm: PROCESS ABENDING.
2016-06-14 07:40:47 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, REP_VSCN.prm: Error mapping from ACAPT.SC_DMENT_PRO to ACAPT.SC_DMENT_PRO.
2016-06-14 07:40:47 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, REP_VSCN.prm: PROCESS ABENDING.
2016-06-14 07:43:50 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, REP_VSCN.prm: Error mapping from ACAPT.SC_DMENT_PRO to ACAPT.SC_DMENT_PRO.
2016-06-14 07:43:50 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, REP_VSCN.prm: PROCESS ABENDING.
2016-06-14 22:07:11 ERROR OGG-01232 Oracle GoldenGate Capture for Oracle, pmp_var.prm: Receive TCP params error: TCP/IP error 104 (Connection reset by peer), endpoint: flph551.ffdc.sbc.com:7819.
2016-06-14 22:07:11 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, pmp_var.prm: PROCESS ABENDING.
2016-06-14 22:20:51 ERROR OGG-00303 Oracle GoldenGate Collector for Oracle: TCP/IP listen error 98 (Address already in use). ( i understand this line )
2016-06-14 22:20:51 ERROR OGG-01668 Oracle GoldenGate Collector for Oracle: PROCESS ABENDING.
I couldn't understand the below lines.....
2016-06-14 00:58:20 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, rep_ddl5.prm: Fatal error executing DDL replication: error [Error code [54], ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired SQL alter table UVDP.ACCT _DATA_HISTORYdrop partition P20160503update global indexes /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
why it showing UVDP.ACCT _DATA_HISTORYdrop partition P20160503update?
Thanks,