Oracle GoldenGate WARNING OGG-25108 Failed to set the Oracle session tag: ORA-04060: insufficient privileges to execute DBMS_STREAMS.SET_TAG

How Problems with Oracle GoldenGate

On the Oracle GoldenGate app, you may encounter an error like below when logging in with the goldengate user.

The error I encountered occurred in the database on the Oracle 19c GoldenGate version. Oracle Bug fixed in and on later versions. Correct it by adding DBMS_STREAMS_ADM.set_tag for 11g DB. Oracle will continue to use DBMS_STREAMS.set_tag for 10g.

You can also check out the article on Oracle GoldenGate Installation.

sqlplus / as sysdba

SQL*Plus: Release Production on Sat Feb 22 12:00:24 2020

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> grant execute on dbms_streams_adm to gg;

Grant succeeded.

SQL> connect gg;
Enter password:
SQL> exec dbms_streams_adm.set_tag (‘FF’);

PL/SQL procedure successfully completed.