Acquiring Management Agent Software for HPUX&AIX in the Offline Mode(离线安装EM agent)
OMS安装在OEL 6.6 ，Product DB Agent 都是在AIX, HPUX, EXADATA(linux)平台, linux平台的比较方便安装，因为OMS 自带相同平台的AGENT,其它平台需要先在OMS下载相应的AGENT支持，这里有OMS是在OFFLINE模式
Month: May 2015
RMAN-06900&RMAN-06901 RMAN-00600 [3045] ORA-19921 when rman connect target
RMAN-00571: ===========================================================
RMAN-00554: 内部恢复管理器程序包初始化失败
RMAN-00600: internal error, arguments [3045] [] [] [] []
Performance Tuning DML hang wait event ‘cursor: pin S wait on X’
年前一套数据库出现了性能问题，一周出现了两次，很多session 等待“cursor: pin S wait on X” 事件，这是一套11.2.0.4 RAC on RHEL6 的环境，下面记录一下该案例的优化方案。
Troubleshooting RMAN-00600: internal error, arguments [13205] [] [] [] []
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/11/2011 10:03:29
RMAN-00600: internal error, arguments [13205] [] [] [] []
Troubleshooting the crsd.bin and listener process terminal after eanble TCP.VALIDNODE_CHECKING in sqlnet.ora
Recently, we met several times Oracle Listener terminal case, here I will be sharing again due to configuration Listener whitelist caused, For to system hardening, we are eanble listener whitelist (TCP.VALIDNODE_CHECKING = yes) on some RAC Environment, But no more after prolonged listening terminated unexpectedly after enable VALIDNODE_CHECKING . [oracle@anbob2:/home/oracle]# ps -ef|grep lsnr oracle 5111994 … Read more
诊断一起存储链路引起的数据库性能问题案例 ORA-32701 and krsv_proc_kill: Killing 1 processes (Process by index) in alert
前几日一套库出现在性能问题，虽然最终问题不在数据库， 但是记录一下希望遇到同样问题时可以节约你的时间 ，这是11.2.0.3 RAC 2nodes on hpux (EMC存储), 问题是从16：40左右起中间件偶尔有瞬间的业务积压， 积压时数据库大多数会话都是简单的insert同一表数据
Invalid segment BIN$xxx and dba_recyclebin was empty (回收站空，释放无效的BIN$xx空间)
近来有套库空间紧张，发现有很大BIN$开头的TABLE partition,index partition 类型的段，查询确认是2个月前删除的对象，手动清空过dba_recyclebin使用purge，但都过去几天了，后来dba_recyclebin一直为空，发现对象BIN$XX还存在
Performance tuning ‘gc cr¤t grant 2-way’ event (当主机扩容cpu后)
gc cr¤t grant 2-way 是一种 grant message package 的传递，当取cr 或current block 时向block master instance 请求x或s的权限 ，当请求的block在从任何实例上的buffer cache中都没有发现, lms进程会通知FG进程从disk 读取block到local buffer cache中