SQL> exec DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(grantee => 'strmrep',grant_privileges => true);
BEGIN DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(grantee => 'strmrep',grant_privileges => true); END;
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_STREAMS_AUTH", line 1211
ORA-06512: at line 1
原先做过 execute dbms_logmnr_d.set_tablespace('ts_strmrep'); 操作把logminer相关对象从sysaux表空间迁移到ts_strmrep了, 清除Streams配置的时候, 也把表空间ts_strmrep给drop了, 造成logminer相关对象都没了。
解决方法:
@?/rdbms/admin/dbmslm.sql
@?/rdbms/admin/dbmslmd.sql
@?/rdbms/admin/dbmslms.sql
@?/rdbms/admin/prvtlm.plb
@?/rdbms/admin/prvtlmd.plb
@?/rdbms/admin/prvtlmrd.plb
@?/rdbms/admin/prvtlms.plb
@?/rdbms/admin/prvtlms2.plb
@?/rdbms/admin/prvtlmc.plb
@?/rdbms/admin/catpstr.sql
BEGIN DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(grantee => 'strmrep',grant_privileges => true); END;
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_STREAMS_AUTH", line 1211
ORA-06512: at line 1
原先做过 execute dbms_logmnr_d.set_tablespace('ts_strmrep'); 操作把logminer相关对象从sysaux表空间迁移到ts_strmrep了, 清除Streams配置的时候, 也把表空间ts_strmrep给drop了, 造成logminer相关对象都没了。
解决方法:
@?/rdbms/admin/dbmslm.sql
@?/rdbms/admin/dbmslmd.sql
@?/rdbms/admin/dbmslms.sql
@?/rdbms/admin/prvtlm.plb
@?/rdbms/admin/prvtlmd.plb
@?/rdbms/admin/prvtlmrd.plb
@?/rdbms/admin/prvtlms.plb
@?/rdbms/admin/prvtlms2.plb
@?/rdbms/admin/prvtlmc.plb
@?/rdbms/admin/catpstr.sql
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/5359/viewspace-722383/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/5359/viewspace-722383/