[Translated from mos] When will the OGG extraction process obtain data from the database ?, Mosdatabase
For oracle databases, when will the OGG extraction process obtain data from the database?
Reference Original:
When GoldenGate Fetches Data From The Database On Extraction For Oracle (Doc ID 1059583.1)
Applicable:
Oracle GoldenGate-Version 4.0.0 and later
Information in this document applies to any platform.
Solution:
Problem:
What triggers the OGG extraction process to obtain data from the database?
Answer:
Only a specific data type will result in obtaining data from the database:
UDT 100% of the time GoldenGate fetches data from the database.
LONG,
Long raw,
CLOB,
BLOB Only if the row is chained. Otherwise, the data is captured from the redo log.
You can use the statoptions reportfetch parameter to track when the extraction process retrieves data from the database.
Key Words
Oracle, fetch, STATOPTIONS, REPORTFETCH, UDT, CLOB, BLOB, LOB, LONG
Create database link for oracle DATABASE connection Creation
Name of the network service that is successfully tested? How to test it? Try using the tool. Can I log in?
Copy the configuration in tnsnames to using.
Add (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = ip) (PORT = PORT) (CONNECT_DATA = (SERVICE_NAME = Database Name) in the semicolon )))
Try again?