Differences

This shows you the differences between two versions of the page.

--- goldengate [2016/09/02 08:43] – z0hpvk
+++ goldengate [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== GoldenGate ======
+[[Work16thOct| Work for 16th October]]\\
 {{:goldengate_database_initial_setup.docx|GoldenGate Database Initial Setup}}\\
@@ Line 5: / Line 7: @@
 {{:bidirectional_replication_goldengate.docx|GoldenGate Bi-Directional Replication}}\\
 {{:goldengate:oracle_goldengate_and_rac_high_availability.docx|GoldenGate as a Clusterware Resource}}\\
+{{:goldengate_overview_for_support.docx| Checking and Diagnosing GoldenGate}}\\
+{{:removing_a_goldengate_installation.docx|Converting Bi-Directional to Uni-Directional}}\\
 {{::oracle_goldengate_best_practices_-_bi_directional_replication.pdf| GoldenGate Best Practices - Bi-Directional}}\\
@@ Line 10: / Line 14: @@
 ===== Parameter Files =====
-{{:goldengate:globals.rtf|Globals}}\\
+[[GlobalsPar|Globals]]\\
-{{:goldengate:mgr.rtf|Manager}}\\
+[[MgrPar|Manager]]\\
 ==== 10g Database ====
-{{:goldengate:extract_10g.rtf|Extract}}\\
+[[Extract10g|Extract]]\\
-{{:goldengate:data_pump_10g.rtf|Data Pump}}\\
+[[DP10g|Data Pump]]\\
-{{:goldengate:replicat_10g.rtf|Replication}}\\
+[[Replicat10g|Replicat]]\\
 ==== 12c Database ====
-{{:goldengate:extract_12c.rtf|Extract}}\\
+[[Extract12c|Extract]]\\
-{{:goldengate:data_pump_12c.rtf|Data Pump}}\\
+[[DP12c|Data Pump]]\\
-{{:goldengate:replicat_12c.rtf|Replication}}\\
+[[Replicat12c|Replicat]]\\
 ===== Sequences =====
 [[plsql_sequence|PL/SQL For the Sequences Solution]]\\
+===== Known Issues =====
+[[error_messages|Error Messages and Resolution]]\\
 ===== Exceptions =====
 [[exceptions|Exceptions Setup]]\\
-===== SQL =====
+===== Alerting Script =====
-==== Lagtime (Historic) ====
+[[alert_script| Alert/Check Script for GoldenGate]]\\
-<code>alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
-set linesize 140 pagesize 50
-select groupname, committime, local_insert_time,
-       (local_insert_time - committime)*24*60*60 as "LAG (Seconds)"
-from GGS_MON.GGS_LAGTIME
-where (local_insert_time - committime)*24*60*60 > 59
-order by 2;</code>
+===== SQL =====
 ==== Sequences Scheduled Job ====
 <code>set lines 120
@@ Line 68: / Line 69: @@
 ==== Synchronise Sequences Between Databases ====
-<code>set pages 0 feedback off linesize 160
+<code>SET PAGESIZE 0 LINESIZE 120 FEEDBACK OFF
-SELECT 'EXEC mol_sequences.mol_sequence_sync(''' || SEQUENCE_OWNER || ''',''' || SEQUENCE_NAME || ''',100);'
+spool /u07/goldengate/dirout/sequence_sync_output.sql
+SELECT 'set echo on timing on' from dual;
+SELECT 'conn ggate/ggate123' from dual;
+SELECT 'exec mol_sequences.mol_sequence_sync(''' || SEQUENCE_OWNER || ''',''' || SEQUENCE_NAME || ''',100);'
 FROM DBA_SEQUENCES
-WHERE SEQUENCE_OWNER IN ('MAILONLINE','RDRCOMMENTS','REGISTRATION','LEGAL','FBIAGENT');</code>
+WHERE SEQUENCE_OWNER in ('MAILONLINE','RDRCOMMENTS','REGISTRATION','LEGAL','FBIAGENT')
+AND   SEQUENCE_NAME not in ('HIBERNATE_SEQUENCE','HEALTHCHECK_SEQ','TN_TEST_SEQ')
+ORDER BY 1;
+spool off
+</code>
 ==== Checkpoint Table ====