My Oracle Support Banner

IE is not capturing 'GRANT' DDL after changing ogg user password (Doc ID 2598288.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.3.0.1.2 and later
Information in this document applies to any platform.

Symptoms



Integrated Extract doesn't capture 'GRANT' DDL after changing ogg user password.


SQL> alter user ogguser identified by ogguser;

User altered.

aLTER CREDENTIALSTORE add USER ogguser PASSWORD ogguser1 ALIAS gg_ogguser
aLTER CREDENTIALSTORE REPLACE USER ogguser PASSWORD ogguser ALIAS gg_ogguser


Start the extract.


SQL> drop table hshi.test222;

Table dropped.

SQL> create table hshi.test222 (id int);

Table created.

SQL> grant select on hshi.test222 to scott;

Grant succeeded.

SQL> grant select on hshi.test222 to scott;

Grant succeeded.

SQL>  drop table hshi.test222;

Table dropped.

SQL> create table hshi.test222 (id int);

Table created.

SQL>  grant select on hshi.test222 to scott;

Grant succeeded.

SQL> /


GGSCI (OGG123) 64> view params extract2

extract extract2
userid ogguser password ogguser1
exttrail ./dirdat/ie
ddl include mapped, objname hshi.*
ddloptions report
table hshi.*;
table vishnu.*;

 

GSCI (OGG123) 63> stats extract2

Sending STATS request to EXTRACT EXTRACT2 ...

No active extraction maps.
DDL replication statistics (for all trails):

*** Total statistics since extract started     ***
       Operations                                         4.00                      <<<<<<<<< only 4 DDLs are captured.
       Mapped operations                                  4.00
       Unmapped operations                                0.00
       Other operations                                   0.00
       Excluded operations                                0.00




Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.