Change remote trail location RMTTRAIL in pump in Goldengate

 Summary: This section explains the method to change REMOTE TRAIL location used in PUMP process in goldengate.

Description:

This blog is for modifying the remote trail RMTRAIL location in pump.

Case if to changing the mount point.

Location Before -/u02/app/oracle/product/19.0.0.0/gghome_1/dirdat/RPPPIA02/j2

Location After -/u03/app/oracle/product/19.0.0.0/gghome_1/dirdat/RPPPIA02/j2

Add new extract in Goldengate

Summary: Add new Extract process in GoldenGate

Description:

This blog is for adding a new extract in goldengate considering few assumptions.

1. GG manager is already configured.
2. DB level metadata, table/schema trandata is configured.
3. GG user is configured and had DBA access to datatabase