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 18.104.22.168 database on the Oracle 19c GoldenGate version. Oracle Bug fixed in 22.214.171.124.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 126.96.36.199.0 Production on Sat Feb 22 12:00:24 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 188.8.131.52.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.