Monthly Archives: January 2019

关于Oracle的44951事件

Posted on January 31, 2019 by Alfred Zhao

最近有同事遇到某客户数据库产生大量阻塞，等待事件为：enq HW – contention，最开始采用不断杀会话的方式，效果不好，问题一直高频反复。进一步确认SQL是大量的insert，且插入的表中含有LOB字段.. Continue reading →

Posted in Oracle最佳实践 | Tagged , , | Comments Off on 关于Oracle的44951事件

ACFS-9459: ADVM/ACFS is not supported on this OS version

Posted on January 23, 2019 by Alfred Zhao

**环境：**RHEL 7.3 + Oracle 12.2.0.1 RAC
**现象：**acfs资源状态不正常，asmca图形也没有acfs相关内容，无法使用acfs。 Continue reading →

Posted in Oracle补丁应用 | Tagged , , | Comments Off on ACFS-9459: ADVM/ACFS is not supported on this OS version

Asianux 7.3安装Oracle 11.2.0.4单实例体验

Posted on January 19, 2019 by Alfred Zhao

该报错完全匹配MOS文档，且有解决方案：error in invoking target ‘agent nmhs’ of make file ins_emagent.mk while installing Oracle 11.2.0.4 on Linux (文档 ID 2299494.1) Continue reading →

Posted in Oracle安装部署 | Tagged , , | Comments Off on Asianux 7.3安装Oracle 11.2.0.4单实例体验