Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ An Example of GoldenGate Extract Process Hang Problem Solving     - Ubuntu install perfectly handsome terminal Guake 0.8.1 (Linux)

- Java Adapter Mode (Programming)

- How to install Visual Studio Code on Ubuntu (Linux)

- Method under Linux GCC Compiler shared library function export control (Programming)

- Linux Security Setup Guide (Linux)

- Analysis of Java reflection mechanism (Programming)

- OpenDJ installed on RHEL6 (Linux)

- Analysis of native Java keywords (Programming)

- shellinabox: one uses AJAX Web-based terminal emulator (Linux)

- How to download apk file from the Google Play store on Linux (Linux)

- Role Object of registerNatives () method (Programming)

- Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU installation summary (Database)

- Linux - Common process the command (Linux)

- Graphic Git (Linux)

- How apt-get limited use IPv4 or IPv6 protocol to download (Linux)

- Using a proxy method under Linux terminal (Linux)

- IP Security Policy is to learn how to prevent Ping and closed ports (Linux)

- Oracle 11g tracking and monitoring system-level triggers to drop misuse (Database)

- Protect against network attacks using Linux system firewall (Linux)

- Binary tree to the next node (Programming)

 
         
  An Example of GoldenGate Extract Process Hang Problem Solving
     
  Add Date : 2017-08-31      
         
       
         
  Has been running the normal extract process suddenly hang live, at first suspected is not found due to archiving, but a careful examination of the next, extract the required archives are still, but the log did not report any wrong. But will extract the process stopped, but also normal, without any mistakes or warning:

// ggserr.log
2015-05-25 11:03:27 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, elis.prm: Positioning to (Thread 1) Sequence 5824, RBA 290544656, SCN 1415.2504802626.
2005-05-25 11:03:27 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, elis.prm: Positioned to (Thread 1) Sequence 5824, RBA 290544656, SCN 1415.2504802626, May 20, 2015 4:50:25 PM.
2015-05-25 11:03:27 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, elis.prm: Positioning to (Thread 2) Sequence 4798, RBA 18781712, SCN 1415.2504799356.
2005-05-25 11:03:27 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, elis.prm: Positioned to (Thread 2) Sequence 4798, RBA 18781712, SCN 1415.2504799356, May 20, 2015 4:50:19 PM.
2015-05-25 11:03:27 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, elis.prm: EXTRACT ELIS started.

// extract rpt file of the process
2015-05-25 11:03:27 INFO OGG-00546 Default thread stack size: 196608.

2015-05-25 11:03:27 INFO OGG-00547 Increasing thread stack size from 196608 to 1048576.

2015-05-25 11:03:27 INFO OGG-01513 Positioning to (Thread 1) Sequence 5824, RBA 290544656, SCN 1415.2504802626.

2015-05-25 11:03:27 INFO OGG-01516 Positioned to (Thread 1) Sequence 5824, RBA 290544656, SCN 1415.2504802626, May 20, 2015 4:50:25 PM.

2015-05-25 11:03:27 INFO OGG-01513 Positioning to (Thread 2) Sequence 4798, RBA 18781712, SCN 1415.2504799356.

2015-05-25 11:03:27 INFO OGG-01516 Positioned to (Thread 2) Sequence 4798, RBA 18781712, SCN 1415.2504799356, May 20, 2015 4:50:19 PM.

2015-05-25 11:03:27 INFO OGG-01517 Position of first record processed for Thread 1, Sequence 5824, RBA 290544656, SCN 1415.2504802623, May 20, 2015 4:50:25 PM.

2015-05-25 11:03:27 INFO OGG-01644 BOUNDED RECOVERY: COMPLETE: for object pool 1: p33619994_Redo Thread 1 at SeqNo: 5824, RBA: 290545168, SCN: 1415.2504802626 (6079883526466), Thread:

2015-05-25 11:03:27 INFO OGG-01055 Recovery initialization completed for target file / ogg / ggate / data / dirext / lis / ea002534, at RBA 1109.

2015-05-25 11:03:27 INFO OGG-01478 Output file / ogg / ggate / data / dirext / lis / ea is using format RELEASE 11.2.

2015-05-25 11:03:27 INFO OGG-01517 Position of first record processed for Thread 2, Sequence 4798, RBA 18781712, SCN 1415.2504799356, May 20, 2015 4:50:19 PM.

2015-05-25 11:03:27 INFO OGG-01026 Rolling over remote file / ogg / ggate / data / dirext / lis / ea002534.

2015-05-25 11:03:27 INFO OGG-01053 Recovery completed for target file / ogg / ggate / data / dirext / lis / ea002535, at RBA 1109.

2015-05-25 11:03:27 INFO OGG-01057 Recovery completed for all targets.
From the log, extract process is no problem, but the extract process is actually not running properly:


GGSCI (hxddlis01) 8> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
JAGENT RUNNING
EXTRACT RUNNING ELIS 96:14:58 00:00:04
EXTRACT RUNNING PL2IS 00:00:00 00:00:00
EXTRACT RUNNING PLIS 00:00:00 00:00:09
Extract the process of growing lag, and the trail file is no longer growing. This is really people confused. Let's take a look at the current system operating environment:


GoldenGate: 11.2.1.0.27
Database: 11.2.0.3 Two-node RAC with ASM
OS: AIX 6.1
Then search Oracle Support to find an article 1432994.1, and the situation is somewhat similar. In our environment is the use of DBLOGREADER, but the difference is DBLOGREADERBUFSIZE has been configured to 1M:


...
TRANLOGOPTIONS BUFSIZE 1048576
TRANLOGOPTIONS DBLOGREADER, DBLOGREADERBUFSIZE 1048576
--TRANLOGOPTIONS _NOREADAHEAD ANY
EXTTRAIL / ogg / ggate / data / dirext / lis / ea
...
This is the maximum configuration under AIX. Is the value is too big reason? So try to change the value of the 512K:


...
TRANLOGOPTIONS BUFSIZE 1048576
TRANLOGOPTIONS DBLOGREADER, DBLOGREADERBUFSIZE 524288
--TRANLOGOPTIONS _NOREADAHEAD ANY
EXTTRAIL / ogg / ggate / data / dirext / lis / ea
...
Then restart the extract process, the result is normal. Estimated use DBLOGREADER still have a lot of bugs.
     
         
       
         
  More:      
 
- Use regular expressions to check whether the input box to enter a URL (Programming)
- CentOS 6.4 installation environment to build Scrapy 0.22 (Linux)
- CentOS 7 update source - the use of domestic sources 163 yum (Linux)
- To build a private Docker registry (Server)
- How to use the ftp tool to transfer files between Windows and Linux (Linux)
- Oracle 11g new features of the collection of multi-column statistics (Database)
- Via Twitter how open source library to be used anywhere Emoji emoticons (Linux)
- Unix system security configuration (Linux)
- 20+ Best Practices article MySQL Performance Optimization (Database)
- Ubuntu 12.04 configure NVIDIA CUDA 5.5 Record (Linux)
- Samhain: Powerful intrusion detection system under Linux (Linux)
- Why did not Oracle privileges can also log in with sysdba (Database)
- To install file manager Nautilus 3.12.2 under ubuntu (Linux)
- Tmux Getting Start (Linux)
- Linux instructions and examples GPG encryption and decryption (Linux)
- Android Send HTTP POST requests (Programming)
- Linux terminal program running in the background (Linux)
- Java memory area Explanation (Programming)
- Install apr support for Tomcat on Linux (Server)
- Java concurrent programming using the synchronized keyword ReentrantLock alternative primitive (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.