AIX RAC swap 不足.docx

AIX RAC swap 不足, 实例down --解决  HYPERLINK /mon.php?action=viewspaceop=upitemid=440330uid=471666 上一篇 /  HYPERLINK /mon.php?action=viewspaceop=nextitemid=440330uid=471666 下一篇 ?2008-09-01 11:34:35 / 个人分类： HYPERLINK /471666/spacelist-blog-itemtypeid-37571 Oracle DBA 查看( 1267 ) / 评论( 15 ) os : aix 5.3 + hacmp 5.4.1db : 10.2.0. 3  HYPERLINK javascript:; \t _self racalert.logMon Sep??1 03:49:17  HYPERLINK javascript:; \t _self 2008Process startup failed, error stack:Mon Sep??1 03:49:17 2008Errors in file /app/oracle/admin/racdb/bdump/racdb1_psp0_479298.trc:ORA-27300: OS system dependent operation:fork failed with status: 12ORA-27301: OS failure message: Not enough spaceORA-27302: failure occurred at: skgpspawn3Mon Sep??1 03:49:18 2008Process PZ96 died, see its trace filetrace.logRedo thread mounted by this instance: 1 HYPERLINK javascript:; \t _self Oracle process number: 4Unix process pid: 479298, image: oracle@racdb1 (PSP0)*** SERVICE NAMESYS$BACKGROUND) 2008-09-01 03:46:42.179*** SESSION ID553.1) 2008-09-01 03:46:42.179*** 2008-09-01 03:46:42.179Process startup failed, error stack:ORA-27300: OS system dependent operation:fork failed with status: 12ORA-27301: OS failure message: Not enough spaceORA-27302: failure occurred at: skgpspawn3*** 2008-09-01 03:47:41.144Process startup failed, error stack:ORA-27300: OS system dependent operation:fork failed with status: 12ORA-27301: OS failure message: Not enough spaceORA-27302: failure occurred at: skgpspawn3*** 2008-09-01 03:49:15.684分析:? ?1. 发现alert.log 发现很多ORA-27301: OS failure message: Not enough space 以为是 磁盘空间不足, 检查磁盘发现没有满.? ?2. 检查trace.log , 发现是process PSP0 启动不了,??process-spawner (PSP0): spawns Oracle processes , 为oracle主要后台进程.? ?3. crs_stat -t??发现 HYPERLINK javascript:; \t _self 数据库实例1已经down 掉,各个rac1资源已经offline..说明PSP0已经启动不了. 由此可知 ORA-27301: OS failure message: Not enough space 可能是由于系统内存不足的原因.? ?4. metalink 查询. Doc ID:??Note:560309.1? ?? ?正是由于ram/swap 不足导致, 建议设