首页 » 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

在安装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

打赏

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