EBS adpatch的时候报ORA-03113: end-of-file on communication channel

解决EBSadpatch时报ORA-03113错误的方法

最新推荐文章于 2024-12-29 17:40:42 发布

最新推荐文章于 2024-12-29 17:40:42 发布 · 81 阅读

文章标签：

#php #数据库

本文详细介绍了在使用EBSadpatch时遇到ORA-03113错误的排查步骤及解决方案。通过检查RDBMSalert_<SID>.log文件并调整initparameterfile中的_disable_logging参数，最终成功解决了问题。

EBS adpatch的时候报ORA-03113: end-of-file on communication channel

从adpatch的日志中看到

================adpatch.log======================================
Running utl_recomp.recomp_parallel(4), if it exists


OWNER			       NUM_INVALID
------------------------------ -----------
SERVICES				24
PROJMFG 				24
PSBEXCEL				 1
DLD					 4
RE					 1
MOBILEADMIN				 4
CA					 2
DGRAY					24
MJORDAN 				 1
PSTOCKMAN				 1
PUBLIC				      1102
RALFRED 				 1
HERMAN					 1
APPS				      5132
FEDERAL 				 1
JPALMER 				 1
FLOWS_010500				 2

17 rows selected.

Elapsed: 00:00:00.15

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.01

STATUS_MESSAGE
------------------------------------------------------------------------------
Running UTL_RECOMP.RECOMP_PARALLEL...

declare
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


ERROR:
ORA-03114: not connected to ORACLE
================adpatch.log======================================

根据NOTE:1125213.1的说法需要查看<RDBMS ORACLE_HOME>/admin/<SID_HOST>/diag/rdbms/prod/<SID>/trace/alert_<SID>.log

The first recommended action to take when investigating these errors is to check the RDBMS alert_<SID>.log. This log will help to identify if the problem is with the RDBMS or with something else, such as the application code. Open the alert<SID>.log, possible locations of that log file are:

R12 on 11g database: <RDBMS ORACLE_HOME>/admin/<SID_HOST>/diag/rdbms/prod/<SID>/trace/alert_<SID>.log

===============alert_instance.log==============================
Errors in file /u01/oracle/mc3yd213/db/tech_st/11.1.0/admin/mc3yd213_bej301441/diag/rdbms/mc3yd213/mc3yd213/trace/mc3yd213_pmon_13565.trc:
ORA-00470: LGWR process terminated with error
PMON (ospid: 13565): terminating the instance due to error 470
===============alert_instance.log==============================

关于ORA-00470: LGWR process terminated with error，根据 http://www.itpub.net/thread-502105-1-1.html
需要edit the init parameter file in the database(Using 11gR1 follow doc.761570.1)，

/d01/oracle/VIS/db/tech_st/11.1.0/dbs/initVIS.ora

增加

_disable_logging=false

重启数据库

addbctl.sh stop
addbctl.sh start

sqlplus / as sysdba

SQL> show parameter _disable_logging

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_disable_logging                     boolean     FALSE

再重新打patch就没有问题了