Amazon books

Thursday, November 11, 2010

ORA-23616: Failure in executing block 4 for script dbms_streams_adm

Error:

###########################################
ORA-23616: Failure in executing block 4 for script 94CDB67BB22F03BFE0400A0A710A1FF7 with
ORA-26723: user "DBMS_STR_USER" requires the role "DBA"
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 659
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 682
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 2422
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2975
###########################################

Find more info using view below:

SQL> select * from dba_recoverable_script_errors;

SCRIPT_ID BLOCK_NUM ERROR_NUMBER ERROR_MESSAGE ERROR_CREATION_TIME
-------------------------------- ---------- ------------ -------------------------------------------------------------------------------- -------------------
94CDA13FFD84CDE6E0400A0A710A1D8F 4 -26723 ORA-26723: user "DBMS_STR_USER" requires the role "DBA" 11/11/2010 19:31:16


################

Grant DBA to user.

test again.

Best Regards,
Paulo Portugal

1 comment:

  1. I granted my strmadmin user teh DBA role, and retried, I still get the same error.

    ReplyDelete