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 220.127.116.11 database on the Oracle 19c GoldenGate version. Oracle Bug fixed in 18.104.22.168.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 22.214.171.124.0 Production on Sat Feb 22 12:00:24 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 126.96.36.199.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;
SQL> connect gg;
SQL> exec dbms_streams_adm.set_tag (‘FF’);
PL/SQL procedure successfully completed.