ORA-29548: Java system class reported

This post is also available at: Português

Error ORA
Error ORA

When trying to view the Java version, using a query in the database, the error ORA-29548 is reported.
Here’s how to quickly solve this problem.

SQL> select dbms_java.get_jdk_version() from dual;
select dbms_java.get_jdk_version() from dual
                                        *
ERROR at line 1:
ORA-29548: Java system class reported: release of Java system classes in the
database (19.0.0.0.210420 1.8) does not match that of the oracle executable
(19.0.0.0.0 1.8)
SQL

To resolve error ORA-29548:

SQL> @?/javavm/install/update_javavm_db.sql
SQL

Once the configuration is complete, we can run the select again.

SQL> select dbms_java.get_jdk_version() from dual;
DBMS_JAVA.GET_JDK_VERSION()
--------------------------------------------------------------------------------
1.8.0_201
1 row selected.
SQL
Previous Article

ORA-01623

Next Article

ORA-01400: cannot insert NULL into

Write a Comment

Leave a Comment

Your email address will not be published. Required fields are marked *