迁移报错处理案例（1）RAC to RAC ORA-29548 java程序调用报错

环境概述

DG迁移
源端 linux 11.2.0.4 RAC 数据库集群均无补丁
目标端 linux 11.2.0.4 RAC 集群无补丁，数据库、OJVM应用最新202010补丁

迁移完成后，测试应用出现报错

调用java报错ORA-29548: Java system class reported: could not identify release specified in classes.bin
ORA-06512: SYS.DBMS_JAVA", line 139

检查OJVM组件状态是否有效

SELECT comp_name,VERSION, STATUS from dba_registry ;

通过MOS文章 2149046.1

补丁安装或回滚会出现此故障1) The Oracle JVM component became invalid after applying or rolling back an OJVM PSU patch to the database
2) Running “select dbms_java.longname(‘TEST’) from dual;” throws one of the following errors.
解决办法
These errors can be resolved by running the post installation or post de-installation (in the case of a rollback) steps as detailed in the readme of the respective patch.

对比两端发现，源库无补丁，备库补丁打上。切换后主库未执行OJVM补丁脚本。

--对于 Oracle RAC 环境，请使用以下命令在其中一个节点上重新加载软件包。确保远程节点上没有数据库的其他实例。

cd $ORACLE_HOME/sqlpatch/31668908
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> alter system set cluster_database=false scope=spfile;
SQL> SHUTDOWN
SQL> STARTUP UPGRADE
SQL> @postinstall.sql
SQL> alter system set cluster_database=true scope=spfile;
SQL> SHUTDOWN
SQL> STARTUP 
--安装修补程序的 SQL 部分后，某些软件包可能会变为无效。这将在访问时重新编译，或者您可以运行以使它们恢复为 VALID 状态。utlrp.sql

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

执行dbms.java测试

select dbms_java.longname(‘1’) from dual;