ITPub博客

APPLIES TO:Oracle Database Products > Oracle Database Suite > Oracle DatabaseInformation in this document applies to any platform.***Checked for relevance on 22-Apr-2014*** PURPOSE This document is about disk group rebalance in Oracle Automatic Storage Management (ASM). The in...

1、应用psu时不要有其他界面进入sqlplus界面，升级前最好先把sqlplus / as sysdba的连接杀掉ps -ef | grep sqlplus |grep -v grep | awk '{print $2}' | xargs kill -92、应用psu时不要使用asmcmd操作，否则在升级grid...

某移动公司PMS系统 和 管信门户系统 都出现过集群无法启动的现象，通过对这两次问题的分析，总结如下：

案例背景：环境数据库版本是否rac系统版本生产库11.2.0.3两节点redhat Linux 6.5容灾备库（ADG）11.2.0.3单...

故障环境exdata X3   11.2.3.3.1database： 11.2.0.3.28 备库，主库当前版本为11.2.0.3.22系        统：Linux 5.10故障现象：    备库数据库alert日志报上面600错误（mrp进程中断），数据库处于mount状态，然后节点频繁重启，最后实...

文章转自MOS:Startup Instance Failed with ORA-27140 ORA-27300 ORA-27301 ORA-27302 and ORA-27303 on skgpwinit6 (文档 ID 1274030.1)APPLIES TO:Oracle Database - Standard Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.***Checked for relevance on 29-Mar-2...

文章转自MOS:Cannot Connect As "/ as sysdba" ORA-27140 ORA-27300 ORA-27301 ORA-27302 And ORA-27303 In Trace File (文档 ID 453959.1)APPLIES TO:Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 11.2.0.3 - Release: 10.2 to 11.2Information in this document applies to any platform.***Chec...

文章转自MOS：How to Increase CSS Misscount in single instance ASM installations (文档 ID 729878.1)APPLIES TO:Oracle Server - Enterprise Edition - Version 10.1.0.2 to 10.2.0.1 [Release 10.1 to 10.2]Information in this document applies to any platform.***Checked for relevance on 10-Mar-2011**...

文章转自MOS:Troubleshooting Shutdown Immediate/Normal Hanging Issues (文档 ID 1906014.1)In this DocumentPurposeDetails  A- SMON disabling TX Recovery ...

文章转自MOS：Behavior of Active Dataguard(ADG) When Apply Node Aborts/Crash (文档 ID 1613719.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.1.0.1 [Release 11.1 to 12.1]Information in this document applies to any platform.SYMPTOMSIn RAC Active Dataguard if ...

文章转自MOS：ORA-20011 ORA-29913 and ORA-29400 with Associated KUP-XXXXX Errors from DBMS_STATS.GATHER_STATS_JOB (文档 ID 1274653.1)APPLIES TO:Oracle Database - Standard Edition - Version 11.2.0.2 and laterOracle Database - Enterprise Edition - Version 11.2.0.2 and laterOracle Database - Pe...

文章转自：http://blog.chinaunix.net/xmlrpc.php?r=blog/article&id=4774739&uid=23284114觉得这边文章写得非常全面，转发收藏。log file sync等待时间发生在redo log从log buffer写入到log file期间。下面对log file sync做个详细的解释。何时发生日志写入：1.commit或者rollback2.每3秒...

文章转自MOS:Online Redo Logs on Physical Standby (文档 ID 740675.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.1 and laterInformation in this document applies to any platform.GOALUsage of Online Redo Logs on Physical Standby.In case you may want or need more a...

文章转自MOS：SQL: How to Find Sessions Generating Lots of Redo or Archive logs (文档 ID 167492.1)***Checked for relevance on 13-Oct-2015*** goal: How to find sessions generating lots of redofact: Oracle Server - Enterprise Edition 8fact: Oracle Server - Enterprise Edition...

文章转自MOS文档：ORA-00338, ORA-00312 Errors Reported In Alert Log (文档 ID 1377160.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.SYMPTOMSBelow errors are repeatedly reported in the alert log of one...

---这条sql可以查到会话最后一次执行的未提交的sql，比如我之前insert了两次，然后做了一次select，用下面sql可以查看第二次insert的sql信息，第一次insert是查询不到的select s.SQL_TEXT from v$sql s,v$transaction t where s.LAST_ACTIVE_TIME=t.START_DATE;如何出现下面的情况，sid=10的会话阻...

文章转自MOS文档：Find Sessions that are Blocking Other Sessions Using SQL (文档 ID 728539.1)APPLIES TO:Oracle Database - Personal Edition - Version 7.1.4.0 and laterOracle Database - Standard Edition - Version 7.0.16.0 and laterEnterprise Manager for Oracle Database - Version 8.1.7.4 and la...

前台反应应用连接不上，登录数据库发现大量 row cache lock 等待事件查看发现对应的sql为：INSERT INTO t_pdam_position  (id,   userCode,  &nbsp...

<span style="font-family:微软雅黑;font-size:16px;line-height:24px;white-space:normal;background-color:#FFFFFF;">某移动公司PMS系统 和 管信门户系统 都出现过集群无法启动的现象，通过对这两次问题的分析，总结如下：<br /><br /><div style="font-family:微软雅黑;white-space:normal;background-color:#FFFFFF;f...

文章转自MOS文档：<span style="font-family:Simsun;font-size:14.3000001907349px;font-weight:bold;line-height:normal;text-align:right;white-space:normal;widows:1;background-color:#FFFFFF;">使用 RMAN DUPLICATE...FROM ACTIVE DATABASE 创建物理备用数据库的分步指南 (文档 ID 1526160.1)</span><br /><br /><h...