首页 » ORACLE 9i-23ai » Oracle 11.2.0.4 SDO ORDIM XDB CATPROC XQQ invalid after install ojvm psu

Oracle 11.2.0.4 SDO ORDIM XDB CATPROC XQQ invalid after install ojvm psu

  • 2022/12/28
  • ORACLE 9i-23ai
  • 238 views
  • Oracle 11.2.0.4 SDO ORDIM XDB CATPROC XQQ invalid after install ojvm psu已关闭评论

在安装oracle 11.2.0.4后在应用OJVM PSU后错误执行了readme中的exec dbms_java_dev.disable; 后，数据库多个之前的组件都失效(INVALID), 大量invalid对象，查看dba_registry显示如下，像SDO ORDIM XDB CATPROC XQQ.

报错信息

ORA-04045: errors during recompilation/revalidation of SYS.DBMS_ISCHED
ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_ISCHED"
ORA-06512: at line 12

解决方法：
Enable the Java development in source database .
Connect to the database as a SYSDBA user

SQL> exec dbms_java_dev.enable;

SQL > @?/rdbms/admin/utlrp.sql
如果依旧失效，执行
SQL > @?/rdbms/admin/catalog.sql
SQL > @?/rdbms/admin/catproc.sql
SQL > @?/rdbms/admin/utlrp.sql

打赏

对不起，这篇文章暂时关闭评论。

上一篇：

下一篇：