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模式

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 […]

,

诊断一起存储链路引起的数据库性能问题案例 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&current grant 2-way’ event (当主机扩容cpu后)

gc cr&current grant 2-way 是一种 grant message package 的传递,当取cr 或current block 时向block master instance 请求x或s的权限 ,当请求的block在从任何实例上的buffer cache中都没有发现, lms进程会通知FG进程从disk 读取block到local buffer cache中