Thinking Out Loud

October 30, 2016

GoldenGate 12.2 EXCLUDEUSER

Filed under: GoldenGate,oracle — mdinh @ 9:02 pm

Here’s a good reason to always use the latest version.

GoldenGate 12c Integrated EXTRACT: How To EXCLUDEUSER (Doc ID 2008420.1)


Oracle GoldenGate – Version to [Release 12.1]
Information in this document applies to any platform.


We are trying to exclude the REPLICAT user in OGG 12.1.2 capturing from Oracle bi-directional. But using EXTRACT TRANLOGOPTIONS EXCLUDEUSER to exclude a user in one of the PDBs:


EXTRACT is returning the message:

2015-03-25 15:44:27 ERROR OGG-00303 Could not find USER_ID corresponding to USERNAME ‘ZEPP01.ZE_GG’.


When using Integrated EXTRACT, EXCLUDEUSER is currently not supported in OGG V12.1.2. We have a enhancement request tracked via Bug 21891811 – Support EXCLUDEUSER in Integrated Extract (IE) for DDL records which has been implementd in OGG v12.2.0.1.

For excluding users in a 12c multitenant DB, OGG v12.1.2  has a new EXTRACT param TRANLOGOPTIONS EXCLUDETAG <nn>. This is typically used to exclude the REPLICAT user in bi-directional configurations.

Changes made by Integrated REP are tagged by default in redo as 00. So adding the EXTRACT param TRANLOGOPTIONS EXCLUDETAG 00

Would exclude those operations.

The tag can also be explicitly set in REPLICAT using:


Then in EXTRACT param:


With OGG v12.2.0.1+, you can use the earlier option of TRANLOGOPTIONS EXCLUDEUSER ZEPP01.ZE_GG


(2016, October 18). Retrieved October 30, 2016, from



  1. Could you not use TRANLOGOPTIONS EXCLUDEUSERID rather than rely on the DYNAMICRESOLUTION that is default for EXCLUDEUSER?

    Comment by John Jeffries — November 1, 2016 @ 8:56 am | Reply

    • Thanks for stopping by :=)
      I actually have your 12c Goldengate book.

      Don’t know the answer to your question since ended up using TAG options.

      Comment by mdinh — November 2, 2016 @ 10:19 pm | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Blog at

%d bloggers like this: