Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ An Example of GoldenGate Extract Process Hang Problem Solving     - Linux Powerful IDE - Geany configuration instructions (Linux)

- To solve the Mac in question invalid BASH under configuration environment variable (Linux)

- How do you change the default browser and Email Client in Ubuntu (Linux)

- MongoDB query statistics grouping remove duplicate records (Database)

- Tab set to four spaces in Vim (Linux)

- HTML5 Application Cache (Programming)

- The security configuration of Linux (Linux)

- Linux system boot process detail (Linux)

- Use OpenSSL to generate a certificate detailed process (Linux)

- 4 lvcreate example commonly used commands (Linux)

- ARP Linux-related operations (Linux)

- Linux Getting Started tutorial: GNU C and Vim will fight the C / C ++ IDE semi-automatic (Linux)

- Security Features Linux and Unix operating system, programming (Linux)

- Android determine the device network connection status, and determine the connection (Programming)

- Use $ BASH ENV variable to mention the right way under Linux (Linux)

- How to use the process on the desktop xkill end Linux (Linux)

- Print Linux system error codes (Linux)

- Compile and install Ubuntu Linux 4.0.5 kernel, network and fix vmware kernel module compilation error (Linux)

- Oracle Client Easy Connection error ORA-12154, TNS-03505 (Database)

- Oracle 10g in the unique and index problems (Database)

 
         
  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:      
 
- Oracle 11g em start newspaper site's security certificate has a solution to the problem (Database)
- Database start listening TNS-12537, TNS-12560 error (Database)
- Linux iptables firewall settings (Linux)
- How to allow users to access only a specific database (MSSQL) (Database)
- The basic principles of AIX system security (Linux)
- DRBD switchover (Server)
- Linux 6 use UDEV binding shared storage (Linux)
- Learning the Linux powerful network management capabilities (Linux)
- SpringMVC the use of interceptors (Programming)
- CentOS 6.5 Telnet SecureCRT use management tools (Linux)
- HBase Application Development Review and Summary of Series (Database)
- Java is simple to read and write HDFS Demo (Programming)
- The development environment to build Nodejs under Ubuntu 14.04 (Linux)
- Use the Find command to help you find those files that need to be cleaned (Linux)
- MariaDB 10.1 and MySQL 5.7 in general performance on commodity hardware (Database)
- A brief introduction to some important Docker commands (Server)
- Linux_Logo - output color ANSI Linux distributions logo command-line tool (Linux)
- Basic Java JNI (Programming)
- Redis is installed in Ubuntu 14.04 (Database)
- Linux memory Cache Analysis (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.