Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ An Example of GoldenGate Extract Process Hang Problem Solving     - Monitoring services are running properly and will email alert (Server)

- How to configure SNMPv3 on Ubuntu, CentOS and Cisco systems (Linux)

- Ubuntu 14.10 / 14.04 / 12.04 How to install Kodi 14.0 RC3 (Linux)

- Loop arrays in C language is not easy to find a bug (Programming)

- Linux virtual memory and physical memory (Linux)

- Learn about EditText little depth (Programming)

- shell script: MySQL startup script simple (Database)

- Java filter (Programming)

- Spring AOP for logging (Programming)

- Ubuntu Thunderbird 24.4.0 (Linux)

- Oracle11g CRS-0184 Problem Solving (Database)

- SHELL script to use anti SSH brute force and vsftpd (Linux)

- How to install the NVIDIA 358.16 driver in Ubuntu 15.10,14.04 (Linux)

- Linux security-related basics (Linux)

- Vagrant failed to start, stuck in Waiting for VM to boot solution (Linux)

- Using VMware vSphere Client Linux virtual machine installation CentOS6.4 system (Linux)

- The development environment to build Nodejs under Ubuntu 14.04 (Linux)

- ARM Linux system call (Linux)

- CentOS cross compiler core Raspberry Pi 2 (Linux)

- Java memory area and memory overflow exception (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:      
 
- Ubuntu Server security risk checks (Linux)
- Daemon under Linux (Linux)
- Implicit conversion from Java type conversion compare MySQL and Oracle (Database)
- CentOS 6.6 installation certification system based on the ftp service (Server)
- PHP interview questions of design patterns (Programming)
- Windows and Ubuntu dual system, repair of two ways UEFI boot (Linux)
- stat Usage: Get permission to file the corresponding figures (Linux)
- How to contribute code to the GNU Project (Linux)
- Using Lua implement various operations list (Programming)
- Debian 8.1 (amd64) deployed Memcached (Server)
- Ubuntu amend resolv.conf restart failure problem (Linux)
- grep search from files and display the file name (Linux)
- MongoDB upgrade to 2.6 (Database)
- Linux system package manager (rpm, yum, source packages installation) (Linux)
- Network Security: SYN attacks against under linux (Linux)
- C # Future: Tracking null reference (Programming)
- Setting CentOS firewall open port (Linux)
- Detailed installation of CentOS 6.x (Linux)
- Ubuntu prompt / lack of boot space solutions (Linux)
- TNS-03505 name could not be resolved (Database)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.