请问如果下面这段话,我应该怎么处理呢,我如何知道具体创建这个包体的脚本在哪里呢?
看了篇帖子说 $ORACLE_HOME/rdbms/admin下面有些脚本,不过我用
cai *.* | grep xxxxxx搜索不到。
应该怎么搜索呢?
o e m 里 测试一个表空间备份 ,出错.
The job submission has failed for the following reason
ORA-04063: package body "SYSMAN.MGMT_CREDENTIAL" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYSMAN.MGMT_CREDENTIAL" ORA-06512: at line 1
执行了下utlrp.sql ,(没出错),可执行备份表空间还是出错。我怀疑oracle了。
有人在oracle oem(web)方式下成功执行过备份,恢复吗?
ORA-04063: package body "SYSMAN.MGMT_CREDENTIAL" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYSMAN.MGMT_CREDENTIAL" ORA-06512: at line 1
原来是sys权限不够,以前执行了这些脚本
REVOKE EXECUTE ON utl_tcp FROM PUBLIC;
REVOKE EXECUTE ON utl_smtp FROM PUBLIC;
REVOKE EXECUTE ON utl_http FROM PUBLIC;
REVOKE EXECUTE ON utl_file FROM PUBLIC;
REVOKE EXECUTE ON dbms_obfuscation_toolkit
FROM PUBLIC;
REVOKE EXECUTE ON dbms_crypto FROM PUBLIC;