DB: Oracle RAC 11.2.0.3.0
OS: Linux 6.8 Red Hat
Setup: Server A is RAC and its node 1 is the source, while Server B which is not part of the RAC is receiving replication data from Server A node 1. After reboot to install OS patches, goldengate stopped working on both servers. Following is the log and current status on the server A of GG. I would appreciate any help or direction. Thank You.
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT_A 00:00:00 168:07:20
EXTRACT ABENDED PMP_AB 00:00:00 189:03:42
REPLICAT ABENDED REP_B 00:00:00 189:05:47
2017-09-29 07:40:07 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: EXTRACT PMP_AB starting.
2017-09-29 07:40:07 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2017-09-29 07:40:07 INFO OGG-02696 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: NON-ANSI SQL parameter syntax is used for parameter parsing.
2017-09-29 07:40:07 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
2017-09-29 07:40:07 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: Successfully set environment variable ORACLE_HOME=/opt/oracle/product/11.2.0.
2017-09-29 07:40:07 ERROR OGG-00664 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory).
2017-09-29 07:40:07 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: PROCESS ABENDING.
2017-09-29 07:40:07 WARNING OGG-00945 Oracle GoldenGate Manager for Oracle, mgr.prm: Startup of EXTRACT PMP_AB failed (Cannot create process '/home/oracle/goldengate/extract'. Child process is no longer alive
).
2017-09-29 07:40:07 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep_b.prm: REPLICAT REP_B starting.
2017-09-29 07:40:07 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, rep_b.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2017-09-29 07:40:07 INFO OGG-02696 Oracle GoldenGate Delivery for Oracle, rep_b.prm: NON-ANSI SQL parameter syntax is used for parameter parsing.
2017-09-29 07:40:07 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_b.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
2017-09-29 07:40:07 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_b.prm: Successfully set environment variable ORACLE_HOME=/opt/oracle/product/11.2.0.
2017-09-29 07:40:07 ERROR OGG-00664 Oracle GoldenGate Delivery for Oracle, rep_b.prm: OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory).
2017-09-29 07:40:07 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_b.prm: PROCESS ABENDING.
2017-09-29 07:40:07 WARNING OGG-00945 Oracle GoldenGate Manager for Oracle, mgr.prm: Startup of REPLICAT REP_B failed (Cannot create process '/home/oracle/goldengate/replicat'. Child process is no longer alive
).
2017-09-29 07:44:07 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: EXTRACT PMP_AB starting.
2017-09-29 07:44:07 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2017-09-29 07:44:07 INFO OGG-02696 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: NON-ANSI SQL parameter syntax is used for parameter parsing.
2017-09-29 07:44:07 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
2017-09-29 07:44:07 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: Successfully set environment variable ORACLE_HOME=/opt/oracle/product/11.2.0.
2017-09-29 07:44:07 ERROR OGG-00664 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory).
2017-09-29 07:44:07 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, pmp_ab.prm: PROCESS ABENDING.
2017-09-29 07:44:07 WARNING OGG-00945 Oracle GoldenGate Manager for Oracle, mgr.prm: Startup of EXTRACT PMP_AB failed (Cannot create process '/home/oracle/goldengate/extract'. Child process is no longer alive
).
2017-09-29 07:44:07 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep_b.prm: REPLICAT REP_B starting.
2017-09-29 07:44:07 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, rep_b.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2017-09-29 07:44:07 INFO OGG-02696 Oracle GoldenGate Delivery for Oracle, rep_b.prm: NON-ANSI SQL parameter syntax is used for parameter parsing.
2017-09-29 07:44:07 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_b.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
2017-09-29 07:44:07 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_b.prm: Successfully set environment variable ORACLE_HOME=/opt/oracle/product/11.2.0.
2017-09-29 07:44:07 ERROR OGG-00664 Oracle GoldenGate Delivery for Oracle, rep_b.prm: OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory).
2017-09-29 07:44:07 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_b.prm: PROCESS ABENDING.
2017-09-29 07:44:07 WARNING OGG-00945 Oracle GoldenGate Manager for Oracle, mgr.prm: Startup of REPLICAT REP_B failed (Cannot create process '/home/oracle/goldengate/replicat'. Child process is no longer alive