9208.AIX CPU個數大於,等於64時的報錯

gdutllf2006發表於2010-10-25

環境:
OS: AIX5.3
DB: Oracle9208

在關閉資料庫時報如下錯誤
SQL> shutdown immediate
Database closed.
Database dismounted.
ORA-00600: internal error code, arguments: [504], [0x700000000072740], [160], [7], [shared pool], [4], [0], [0x700000000072470]

大概原因是.在9208上.CPU個數大於,等於64時報錯.

SQL> @./script/showparameter
Enter value for name: cpu
old   1: select name, value, issys_modifiable from v$parameter where name like '%&name%'
new   1: select name, value, issys_modifiable from v$parameter where name like '%cpu%'

NAME                 VALUE                ISSYS_MODIFIABL
-------------------- -------------------- ---------------
cpu_count            2                    FALSE
parallel_threads_per 2                    IMMEDIATE
_cpu


將cpu_count改成小於64或打補丁.

alter system set cpu_count=32 scope=spfile;

或改隱含引數:_kgl_latch_count


alter system set _kgl_latch_count=31 scope=spfile;


都可解決問題.

建議打補丁.

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

相關文章