GoldenGate

You are asking two questions, right?

Can you copy the error as displayed by the ggsci> register command?

There is a logdump reference

https://docs.oracle.com/goldengate/1212/gg-winux/GLOGD.pdf

Some useful commands are

open <trail file>

next (next record, can also do next 30, display 30 records)

gdhr on  (turn on gg header)

details data (turn on data in the trail record)

count detail  (count records from whatever position you are, so POS 0 should be done before doing this)

help (show all commands available)

exit (exit logdump)

Logdump is safe to experiment, it is a reader so there is no harm.

Cheers

Kee Gan

Could you please mentioned OGG Version and DB Version ?

Also would like to see exatct Error message you got ?

Hope you are talking about Trail File .. Logdump utility used to see inside of trailfile and normally required to investigate when GG processes abended with specific errors..

If you have access to Oracle Support - you can see FAQ related to logdump

Oracle GoldenGate Logdump Complete Reference FAQ (Doc ID 1446672.1)

Regards,

Chirag

I am attempting to see into the ggserr.log to determine why the attempt to register an extract fails.

I do not have a trail file to view, because the error happens when attempting to register an extract.

-

Dan

Here is the original error message

The userid that you use to login via ggsci does not have the required privileges.      

Do these for the ogg user:

create user GGSUSER identified by password;

grant sysdba to GGSUSER;

grant connect, resource to ggsuser;

grant select any dictionary to ggsuser;

-- Can grant selectively if you wish (see installation guide)

GRANT All PRIVILEGES  TO ggsuser;

exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('ggsuser');

exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('ggsuser','capture');

If this is a container DB just substitute ggsuser with a root use c##ggadmin for container=all.

Cheers

Kee Gan

This is a privileges issue. Some privilege is missing for the Oracle GoldenGate admin user. Kindly grant the respective privileges and then try to register the extract process.

Please check the below documentation for the list of privileges.,

https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/user_assignment.htm#GIORA552

4.1.4 Granting the Appropriate User Privileges

Regards,

Veera