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

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 11.2.0.4 database on the Oracle 19c GoldenGate version. Oracle Bug fixed in 12.1.2.1.0 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 11.2.0.4.0 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 11.2.0.4.0 – 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:
Connected.
SQL> exec dbms_streams_adm.set_tag (‘FF’);

PL/SQL procedure successfully completed.