database - 无法验证或授权 DBMS_JAVA

Question

我在将 oracle 数据库 11gR2 升级到 19c 时遇到错误。
错误代码:ORA-04023:无法验证或授权对象 SYS.DBMS_JAVA。
例如:

  SQL> select dbms_java.longname('TEST') from dual;
  select dbms_java.longname('TEST') from dual
  *
  ERROR at line 1:
  ORA-04023: Object SYS.DBMS_JAVA could not be validated or authorized 

Answer 1

您需要更改 dbms_java 包。
首先以 sysdba 身份连接到数据库，然后更改包

conn / as sysdba

SQL> alter package dbms_java compile;

Package altered.

SQL> select dbms_java.longname('TEST') from dual;

DBMS_JAVA.LONGNAME('TEST')
--------------------------
TEST