9208．AIX CPU个数大于，等于64时的报错

最新推荐文章于 2024-10-17 18:58:27 发布

cprkdx1264

最新推荐文章于 2024-10-17 18:58:27 发布

阅读量104

点赞数

文章标签：数据库

环境:
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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10248702/viewspace-676700/