Month: April 2016

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

在做一个普通的分区表（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