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就没有问题了
相关的文章
http://msutic.blogspot.jp/2009/03/be-aware-of-disablelogging-true.html
http://kevinclosson.wordpress.com/2007/07/21/manly-men-only-use-solid-state-disk-for-redo-logging-lgwr-io-is-simple-but-not-lgwr-processing/
转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7612482
======EOF======