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 laterInformation 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 |