Blog / Database Blog

Grants Are Not Replicating In Golden Gate

Ibrahim P 1 min read

Grants Are Not Replicating In Golden Gate

SYMPTOMS

Grants are not being replicated from source to target when using Integrated extract

CAUSE

Bug 30120608 : Capture skipping included grant after an excluded alter

If using OGG IE and DDL is excluded when it should be included then this bug may have been encountered.|
Issue is observed when IE encounters an excluded alter statement followed by an included grant. The Grant statement also gets excluded.

If you create a new Integrated Extract, the grants get captured.

SOLUTION

Apply fix for Bug 30120608 to address the grant issues observed

Reference: Metalink Doc ID 2609445.1

Related blogs

Database Blog

Query to Identify Initial and Latest Login Sessions in Oracle Database

Please use the query below to identify and provide the SID and Serial#.   col first_seen for a30 col last_seen for a30 SELECT MIN(sample_time) AS first_see…

Venkatesh GK 1 min read
Database Blog

Steps to Renew Default OHS Keystore Wallet in Oracle Enterprise Manager (OEM)

Please follow the below steps.   Prerequisites   Take a backup of the existing wallet. Ensure you have appropriate Oracle user privileges. Verify OMS…

Venkatesh GK 1 min read
Database Blog

How to Unlock Locked SQL Server Logins

How to Unlock Locked SQL Server Logins Introduction / Issue During day-to-day SQL Server administration, users may report that they are unable to connect to the…

SaiKumar 3 min read