Replicat Abend With OGG-00662 OCI Error Allocating Error Handle (Doc ID 2564510.1)

Last updated on JANUARY 23, 2021

Applies to:

Symptoms

Replicat is abended with the following errors:

2019-07-03 12:51:32 ERROR OGG-00662 OCI Error allocating error handle (status = -2).
2019-07-03 12:51:32 ERROR OGG-01668 PROCESS ABENDING.

And also 10046 trace level 12 tracing at the database level and it confirmed replicat succeeds

in login to the database but fails with:

=====================
PARSING IN CURSOR #139938847214272 len=44 dep=0 uid=80 oct=47 lid=80
tim=1565088702040310 hv=1645658849 ad='576a11900' sqlid='gty9tr5j1dhr1'
begin dbms_xstream_gg.set_gg_session(); end;
END OF STMT
PARSE
#139938847214272:c=206,e=205,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=1565
088702040309
WAIT #139938847013848: nam='rdbms ipc reply' ela= 78 from_process=30
timeout=2147483647 p3=0 obj#=-1 tim=1565088702040643
=====================
EXEC
#139938847214272:c=20251,e=21197,p=0,cr=56,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim
=1565088702061542
ERROR #139938847214272:err=1031 tim=1565088702061552
=====================

01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
//         without the appropriate privilege. This error also occurs if
//         attempting to install a database without the necessary operating
//         system privileges.
//         When Trusted Oracle is configure in DBMS MAC, this error may occur
//         if the user was granted the necessary privilege at a higher label
//         than the current login.

Cause

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