Oracle 12c ORA-29548 报错处理

Xiaofei Huangfu

2858

3页

3次

2020-02-02

5墨值下载

Oracle 12c ORA-29548

报错处理

一、基础环境介绍

：

Red Hat Enterprise Linux Server release 6.6

：

12.1.0.2

：

12.1.0.2

PSU:12.1.0.2.180717

Opatch:12.2.0.1.14

二、处理过程

、检查操作系统

jdk

版本信息

cd $ORACLE_HOME/jdk/bin

./java –version

Java version “1.6.0_75”

Java(TM) SE Runtime Environment (build 20.75-b01,mixed mode)

、检查

OPATCH

版本

cd $ORACLE_HOME/Opatch

./opatch lsinv

、检查数据库中的

JDK

版本

SQL> select dbms_java.get_jdk_version() from dual;

ERROR at line 1:

ORA-29548: Java system class reported: release of classes.bin in the

database

（

12.1.0.2.0.1.6

）

does not match that of the oracle executable

（

12.1.0.2.180717.1.6

）

、修复数据库中的

java

对象

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

SQL> SET FEEDBACK 1

SQL> SET NUMWIDTH 10

SQL> SET LINESIZE 80

SQL> SET TRIMSPOOL ON

SQL> SET TAB OFF

SQL> SET PAGESIZE 100

SQL>

SQL> alter session set “_ORACLE_SCRIPT”=true;

Session altered.

SQL> — If Java is installed, do CJS.

SQL>

SQL> — If CJS can deal with the SROs inconsistent with the new JDK,

SQL> — the drop_sros() call here can be removed.

SQL> call initjvmaux.drop_sros();

Call completed.

SQL> create or replace java system;

2 /

Java created.

SQL> update dependency$

2 set p_timestamp=(select stime from obj$ where obj#=p_obj#)

3 where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and

4 (select type# from obj$ where obj#=p_obj#)=29 and

5 (select owner# from obj$ where obj#=p_obj#)=0;

0 rows updated.

SQL> commit;

Commit complete.

SQL>

SQL> alter session set “_ORACLE_SCRIPT”=false;

Session altered.

、验证

CDB

中可以检查数据库

jdk

版本，

pdb

中仍然报错

SQL> select dbms_java.get_jdk_version() from dual;

ERROR at line 1:

ORA-29548: Java system class reported: release of classes.bin in the

of 3

5墨值下载

oracle 12c

关注

评论