Oracle 11g Active DataGuard(ADG) 优化及 duplicate hang 诊断案例

  • 2016/04/24
  • ORACLE 9i-23ai
  • 2,336 views
  • Oracle 11g Active DataGuard(ADG) 优化及 duplicate hang 诊断案例已关闭评论

该环境是主备两套11.2.0.3 2-NODES RAC ON EXADATA Machine ，存储在ASM， 数据库70TB 大小， 闲时每天1T归档日志， 忙时每天可达4T+归档， 之前朋友重建DG一直使用主机上一个shell 放后台，我查看了该shell 确实不算复杂，但是duplicate 一直hang在开始

阅读全文

Run root102.sh Node reboot when install10205 CRS PATCH & OUI-10021 & Oracle CRS stack is already configured

  • 2016/04/24
  • ORACLE 9i-23ai
  • 672 views
  • Run root102.sh Node reboot when install10205 CRS PATCH & OUI-10021 & Oracle CRS stack is already configured已关闭评论

10.2.0.4 2nodes Oracle RAC ON HPUX 平台的环境， 计划升级到10.2.0.5， 前期升级clusterware 软件非常顺序，可是在跑root102.sh时还没跑完主机突然reboot， 尝试启crs 报错：The clusterware daemons are running from . But you are patching /oracle/product/10.2.0/crs10g

阅读全文

ORA-20011 ORA-12801 ORA-01722 when gather table statistics

  • 2016/04/24
  • ORACLE 9i-23ai
  • 2,312 views
  • ORA-20011 ORA-12801 ORA-01722 when gather table statistics已关闭评论

在做一个普通的分区表（HEAP TABLE）收集统计信息时进程报错意外终止，后台日志未出现ora-600等内部错误，这是一套11.2.0.3.7 oracle RAC 2-nodes on HPUX-ia 11.31的运行环境，这里简单的记录一下排查过程。

SQL> exec DBMS_STATS.GATHER_TABLE_STATS (ownname => ‘ANBOB’ , tabname => ‘TAB_ERROR’ , cascade => true, estimate_percent => dbms_stats.auto_sample_size,method_opt=>’FOR TABLE FOR ALL COLUMNS SIZE REPEAT’, degree => 8,no_invalidate=>false);

*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-12801: error signaled in parallel query server P001, instance qdim1:im1 (1)
ORA-01722: invalid number

阅读全文

ora-7445 [LpxFSMSaxSE()+449] [SIGSEGV] when query with xmltype

  • 2016/04/24
  • ORACLE 9i-23ai
  • 849 views
  • ora-7445 [LpxFSMSaxSE()+449] [SIGSEGV] when query with xmltype已关闭评论

ORA-07445: exception encountered: core dump [LpxFSMSaxSE()+449] [SIGSEGV] [ADDR:0xFD26CFB5] [PC:0x400000001117F881] [Address not mapped to object] []
—– Current SQL Statement for this session (sql_id=6qt1f1pg1dkzs) —–
SELECT UPPER(XMLType(CHR(60) || CHR(58) || CHR(113) || CHR(120) ||

,

阅读全文