OEM12C web页面无法访问进入实例

80 阅读 0 评论 53 点赞

我是靠谱客的博主哭泣自行车，最近开发中收集的这篇文章主要介绍OEM12C web页面无法访问进入实例，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

客户OEM12c 12.1.0.5

现象：EM web界面可以正常登陆显示，在访问某一实例点击进去需要输入用户名密码登陆时候无反应，过一会提示超时或者页面丢失

处理：

当出现这种情况的时候后台资源库 EMREP 的alter.log日志大量出现
Thread 1 cannot allocate new log, sequence 55963
Checkpoint not complete
Private strand flush not complete

redo日志空间不够，循环写入产生竞争，如当前current 是group1 写满，正常需要切换到 goup2继续写，但是group2 还没有归档完毕。这时就出现上面的错误警告
(截图了部分)

Thread 1 advanced to log sequence 55960 (LGWR switch)
  Current log# 1 seq# 55960 mem# 0: /d01/app/oracle/oradata/EMREP/redo01.log
Thread 1 advanced to log sequence 55961 (LGWR switch)
  Current log# 2 seq# 55961 mem# 0: /d01/app/oracle/oradata/EMREP/redo02.log
Thread 1 cannot allocate new log, sequence 55962
Checkpoint not complete
  Current log# 2 seq# 55961 mem# 0: /d01/app/oracle/oradata/EMREP/redo02.log
Mon Jul 09 18:00:29 2018
Thread 1 advanced to log sequence 55962 (LGWR switch)
  Current log# 3 seq# 55962 mem# 0: /d01/app/oracle/oradata/EMREP/redo03.log
Thread 1 cannot allocate new log, sequence 55963
Checkpoint not complete
  Current log# 3 seq# 55962 mem# 0: /d01/app/oracle/oradata/EMREP/redo03.log
Mon Jul 09 18:00:46 2018
Thread 1 advanced to log sequence 55963 (LGWR switch)
  Current log# 1 seq# 55963 mem# 0: /d01/app/oracle/oradata/EMREP/redo01.log
Thread 1 cannot allocate new log, sequence 55964
Checkpoint not complete



Thread 1 advanced to log sequence 55970 (LGWR switch)
  Current log# 2 seq# 55970 mem# 0: /d01/app/oracle/oradata/EMREP/redo02.log
Mon Jul 09 21:49:33 2018
Thread 1 cannot allocate new log, sequence 55971
Private strand flush not complete

处理办法在线增加redo
alter database add logfile group 4 ‘/u01/app/oracle/oradata/EMREP/redo04.log’ size 300m;
alter database add logfile group 5 ‘/u01/app/oracle/oradata/EMREP/redo05.log’ size 300m;
alter database add logfile group 6 ‘/u01/app/oracle/oradata/EMREP/redo06.log’ size 300m;

然后
alter system switch logfile; –切换 current 在 group 4,5,6中一个
alter database checkpoint; —-日志刷盘,让group 1,2,3状态都是 INACTIVE

删除日志组
alter database drop logfile group 1；
alter database drop logfile group 2；
alter database drop logfile group 3；

OS上删除日志文件
rm /u01/app/oracle/oradata/EMREP/redo01.log’
rm /u01/app/oracle/oradata/EMREP/redo02.log’
rm /u01/app/oracle/oradata/EMREP/redo03.log’