Extract Abends With ORA-01031 Insufficient Privileges (Doc ID 2879052.1)

Last updated on APRIL 17, 2023

Applies to:

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

Extract is abended with below errors:

2022-05-30 01:51:49 ERROR OGG-00303 OCI Error ORA (status = 1031-ORA-01031: insufficient privileges).

As per DB event trace file, while executing below select query 'ORA-01031: insufficient privileges' error is reported:

SELECT userid FROM TABLE (system.logmnr$user_gg_tabf_public( :sid, :mdh, :scn, NULL, :username))

	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

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