Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle GoldenGate log files

3182379Nov 30 2017 — edited Dec 1 2017

I am very new to OGG. I am experiencing an "OGG-01755" error when attempting to register an extract, with the OCI SQL Error 1, which is a unique constraint error.

I am attempting to view the log file in the logdump utility, but I am having difficulty with navigating the log file. The Oracle documents I have found online describe navigating the trail files, but I cannot find documents on how to navigate and read log files.

Any help is much appreciated.

Comments

K.Gan

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

CSShah

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

3182379

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

3182379

gg_err_msg.PNG

Here is the original error message

K.Gan

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

Veera-Oracle

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

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 29 2017
Added on Nov 30 2017
6 comments
1,524 views