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======
分享到:
相关推荐
ebs-automatic-nvme-mapping:通过NVMe块设备将EBS卷自动映射到标准块设备路径
aws-ec2-ebs-snapshot-check-bash ####Amazon Web Services EBS 快照验证 - Bash 脚本由[Casey Labs Inc.] ( )和[Bleeding Edge Solutions] ( )撰写,联系我们以满足您的所有亚马逊网络服务咨询需求! =============...
这些 EBS SSD 支持的 AMI 可用于: us-east-1: ami-549eae3c us-west-1: ami-43947707 us-west-2: ami-f35078c3 您还可以构建 DigitalOcean Droplet 或 Rackspace OpenStack Image。 Chef 12.x 已安装。 为了构建 ...
将REX-Ray作为Docker插件docker plugin install rexray/ebs:0.11.2 EBS_ACCESSKEY=AWS_ACCESS_KEY_ID EBS_SECRETKEY=AWS_SECRET_ACCESS_KEY 创建一个AWS EBS卷aws ec2 create-volume --size 10 --region eu-central...
ebs 构建和启动应用程序 cd docker-springboot-ebsmvn clean installcd target/ebs_deploy/dist/docker build -t docker-springboot-ebs .docker run -p 8080:8080 docker-springboot-ebs 使用部署 cd docker-...
主要介绍EBS中使用adpatch时的相关概念和常见问题处理思路。
AWS EC2-EBS自动快照Powershell #### Powershell脚本,用于Amazon Web Services(AWS)EC2上的自动EBS快照和清理 由[AWS Consultants-Casey Labs Inc.]( )撰写 Casey Labs-有关您所有Amazon Web Services咨询的...
- enforce-no-public-ebs-snapshot configuration: mode: remediate version: latest 或直接将其添加到您的Terraform中: module "enforce-no-public-ebs-snapshot" { source = "git::...
带点子: > easy_install pip # if you don't already have pip installed> pip install ebs-deploy使用easy_install: > easy_install ebs-deploy用法ebs-deploy的使用采用以下模式: > ebs-deploy command ...
ORACLEEBS-OU-BG-INV-HR等组织架构介绍.pdf
ORACLEEBS-OU-BG-INV-HR等组织架构介绍(20211120083100).pdf
ERP-ORACLE-EBS-AP发票管理--操作手册
ERP-ORACLE-EBS-AP发票管理--功能流程
ERP-ORACLE-EBS-AR发票管理--功能流程
ERP-ORACLE-EBS-AR发票管理--基本概念
automatic-ebs-snapshots:用于管理自动AWS EBS快照的脚本
ORACLE ERP EBS经验整理之---月结关帐检查要点
AEBS-ACC-ESP-LDWS功能方案说明书
ERP-ORACLE-EBS-AR收款管理--功能流程基本概念
ORACLE-EBS-OU-BG-INV-HR等组织架构介绍.doc