首页 > 数据库 > Oracle > 12C RAC 打31720486补丁 后报错处理
ORA-00210: cannot open the specified control file ORA-00202: control file: '+DATA01/TZOD/CONTROLFILE/current.292.1023652595' ORA-17503: ksfdopn:2 Failed to open file +DATA01/TZOD/CONTROLFILE/current.292.1023652595 ORA-15001: diskgroup "DATA01" does not exist or is not mounted ORA-15040: diskgroup is incomplete ORA-205 signalled during: ALTER DATABASE MOUNT... 2021-04-06T21:27:53.098206+08:00 解决: 通过集群命令发现磁盘组挂载正常。 ORACLE用户: chown oracle:asmadmin $ORACLE_HOME/bin/oracle chmod 6751 $ORACLE_HOME/bin/oracle
Database Characterset is AL32UTF8 2021-04-06T21:39:37.121597+08:00 Errors in file /u01/app/oracle/diag/rdbms/tzod/tzod1/trace/tzod1_ora_229175.trc: ORA-39701: 为了 UPGRADE 或 DOWNGRADE, 数据库必须以 EXCLUSIVE 方式装载 2021-04-06T21:39:37.121782+08:00 Errors in file /u01/app/oracle/diag/rdbms/tzod/tzod1/trace/tzod1_ora_229175.trc: ORA-39701: 为了 UPGRADE 或 DOWNGRADE, 数据库必须以 EXCLUSIVE 方式装载 Error 39701 happened during db open, shutting down database Errors in file /u01/app/oracle/diag/rdbms/tzod/tzod1/trace/tzod1_ora_229175.trc (incident=572720): ORA-00603: ORACLE 服务器会话因致命错误而终止 ORA-01092: ORACLE 实例终止。强制断开连接 ORA-39701: 为了 UPGRADE 或 DOWNGRADE, 数据库必须以 EXCLUSIVE 方式装载 Incident details in: /u01/app/oracle/diag/rdbms/tzod/tzod1/incident/incdir_572720/tzod1_ora_229175_i572720.trc 2021-04-06T21:39:37.948045+08:00 opiodr aborting process unknown ospid (229175) as a result of ORA-603 2021-04-06T21:39:37.977455+08:00 ORA-603 : opitsk aborting process License high water mark = 3 2021-04-06T21:39:37.978417+08:00 USER (ospid: 229175): terminating the instance due to error 39701 2021-04-06T21:39:38.321804+08:00 opiodr aborting process unknown ospid (229117) as a result of ORA-1092 2021-04-06T21:39:38.371644+08:00 ORA-1092 : opitsk aborting process 2021-04-06T21:39:38.979781+08:00 GEN1 (ospid: 228640_228642): terminating the instance due to error 39701 2021-04-06T21:39:38.979966+08:00 解决: sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> alter system set cluster_database=false scope=spfile; $ORACLE_HOME/bin/srvctl stop database -d <dbname> sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP UPGRADE
补丁过程: ...... Validating logfiles... Patch 29774415 rollback: WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29774415/22954229/29774415_apply_TZOD_2021Apr06_21_47_46.log (errors) Error at line 694: ORA-02290: 违反检查约束条件 (SYS.JAVA_DEV_JARS_DISABLED) Patch 31668898 apply: WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/31668898/23868204/31668898_apply_TZOD_2021Apr06_21_48_14.log (errors) Error at line 357: ORA-02290: 违反检查约束条件 (SYS.JAVA_DEV_JARS_DISABLED) Please refer to MOS Note 1609718.1 and/or the invocation log /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_267912_2021_04_06_21_47_33/sqlpatch_invocation.log for information on how to resolve the above errors. ...... 告警日志: 2021-04-06T21:48:13.455185+08:00 Archived Log entry 18347 added for T-1.S-11435 ID 0xc2d35953 LAD:1 2021-04-06T21:48:14.156933+08:00 ## joxcsysnotpdb in pid 268087 caught 604 ORA-00604: 递归 SQL 级别 2 出现错误 ORA-02290: 违反检查约束条件 (SYS.JAVA_DEV_JARS_DISABLED) ALTER SESSION ENABLE LOGICAL REPLICATION invoked from session 6084.16550 at SCN 0x00007ffd482e99f4 ALTER SESSION DISABLE LOGICAL REPLICATION invoked from session 6084.16550 at SCN 0x00007ffd482e99e8 -- 2021-04-06T21:48:28.660249+08:00 Archived Log entry 18352 added for T-1.S-11440 ID 0xc2d35953 LAD:1 2021-04-06T21:48:29.476485+08:00 ## joxcsysnotpdb in pid 268087 caught 604 ORA-00604: 递归 SQL 级别 2 出现错误 原因: 这里是因为打OJVM补丁前打了个DB的psu,执行了 SQL > exec dbms_java_dev.disable 解决: SQL > exec dbms_java_dev.enable 然后在继续执行opatch apply,在继续执行后面的应用sql等。 最后再SQL > exec dbms_java_dev.disable
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/28572479/viewspace-2768015/ ,如需转载,请注明出处,否则将追究法律责任。