ORA-26723: user "STR_TARGET" requires the role "DV_STREAMS_ADMIN"

If you face the error message below while configuring Oracle Streams:

ORA-26723: user "STR_TARGET" requires the role "DV_STREAMS_ADMIN"
ORA-06512: at "SYS.DBMS_STREAMS_ADM_UTL_INVOK", line 349
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 439
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 397
ORA-06512: at line 2


Just run the grant as follows and COMMIT after:
SQL> execute dbms_streams_auth.grant_admin_privilege('STR_SOURCE');

PL/SQL procedure successfully completed

SQL> commit;


Don't forget to COMMIT!

If it didn't work, then disable Database Vault before configuring Streams and enable it after. I use the following command to disable it in Oracle Binaries Files:

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_off ioracle

ATTENTION: This should not be done if you don't know who and why Database Vault is enabled in this database.

Best regards,
Paulo Portugal