oracle並行程式的ORA-27090故障的解決

eric0435發表於2013-05-06
Oracle並行行程
RAC資料庫出現ORA-27090錯誤
/u01/app/oracle/admin/yyjm/bdump/yyjm2_p000_6379.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name: Linux
Node name: node6
Release: 2.6.18-92.el5
Version: #1 SMP Tue Apr 29 13:16:15 EDT 2008
Machine: x86_64
Instance name: yyjm2
Redo thread mounted by this instance: 2
Oracle process number: 42
Unix process pid: 6379, image: oracle@node6 (P000)

*** SERVICE NAME:(SYS$BACKGROUND) 2013-05-04 07:19:48.850
*** SESSION ID:(716.11196) 2013-05-04 07:19:48.850
*** 2013-05-04 07:19:48.850
Start recovery for domain 0, valid = 0, flags = 0x1
*** 2013-05-04 07:19:49.082
KCRP: blocks claimed = 10, eliminated = 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 4194304
Longest hash chain = 1
Average hash chain = 10/10 = 1.0
Max compares per lookup = 0
Avg compares per lookup = 0/10 = 0.0
----------------------------------------------
ORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA
Linux-x86_64 Error: 4: Interrupted system call
Additional information: 3
Additional information: 128
Additional information: 65536
----- Recovery Hash Table Statistics ---------
Hash table buckets = 4194304
Longest hash chain = 1
Average hash chain = 10/10 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 33/33 = 1.0
----------------------------------------------
該問題是發生在RAC一個節點崩潰後，所有的錯誤都發生在並行程式PNNN上。MOS上說這個問題是由於系統引數配置不當所致：ORA-27090: MESSAGE 27090 NOT FOUND; [ID 579108.1]。

核心引數的值：aio-max-nr設定太低，推薦設定為fs.aio-max-nr= 3145728。修改引數使用/sbin/sysctl -p重新載入引數後，重啟資料庫即可。
下面是OTN上對該問題的討論

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26015009/viewspace-759854/，如需轉載，請註明出處，否則將追究法律責任。

相關文章