Acquiring Management Agent Software for HPUX&AIX in the Offline Mode(离线安装EM agent)

  • 2015/05/30
  • Cloud, ORACLE 9i-23ai
  • 952 views
  • 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

  • 2015/05/24
  • ORACLE 9i-23ai
  • 926 views
  • 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’

  • 2015/05/24
  • ORACLE 9i-23ai
  • 2,305 views
  • 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] [] [] [] []

  • 2015/05/24
  • ORACLE 9i-23ai
  • 587 views
  • 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

  • 2015/05/21
  • ORACLE 9i-23ai
  • 1,765 views
  • 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

  • 2015/05/18
  • ORACLE 9i-23ai
  • 3,434 views
  • 诊断一起存储链路引起的数据库性能问题案例 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空间)

  • 2015/05/14
  • ORACLE 9i-23ai
  • 572 views
  • 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后)

  • 2015/05/11
  • ORACLE 9i-23ai
  • 1,608 views
  • 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中

阅读全文