59 积分	0 好友	0 主题

发消息

ORA 各种报错

1^#

发表于 2012-3-13 09:05:59 | 查看: 7068| 回复: 5

hi maclean,

2 节点RAC 数据库的节点2 报如下错误。
Errors in file /app/oracle/diag/rdbms/atmpdb/atmpdb2/trace/atmpdb2_psp0_19660890.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Process m001 died, see its trace file
Process startup failed, error stack:
Errors in file /app/oracle/diag/rdbms/atmpdb/atmpdb2/trace/atmpdb2_psp0_19660890.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Errors in file /app/oracle/diag/rdbms/atmpdb/atmpdb2/trace/atmpdb2_lgwr_14680218.trc:
ORA-00340: IO error processing online log 4 of thread 2
ORA-00345: redo log write error block 179 count 1
ORA-00312: online log 4 thread 2: '+REDODG/atmpdb/onlinelog/group_4.260.769050205'
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk
LGWR (ospid: 14680218): terminating the instance due to error 340

服务器是AIX,16G内存，数据库SGA 9G ，swap 分区是24G 。
配置了RAC到单实例的DG。
日志见附件。有空帮忙看看。

另外一件重要的事情：
Happy Wedding to you ~~

log.rar

55.89 KB, 下载次数: 1015

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2012-3-13 14:33:02

谢谢！:)

Sat Mar 10 02:57:51 2012
System state dump requested by (instance=2, osid=14680218 (LGWR)), summary=[abnormal instance termination].
System State dumped to trace file /app/oracle/diag/rdbms/atmpdb/atmpdb2/trace/atmpdb2_diag_14417946.trc
Dumping diagnostic data in directory=[cdmp_20120310025751], requested by (instance=2, osid=14680218 (LGWR)), summary=[abnormal instance termination].
Sat Mar 10 02:57:54 2012
ORA-1092 : opitsk aborting process
Sat Mar 10 02:57:54 2012
ORA-1092 : opitsk aborting process

*** 2012-03-10 02:48:15.793
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3

*** 2012-03-10 02:51:31.584
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3

问题起始于 2012-03-10 02:48:15.793  终止于 Sat Mar 10 02:57:51 2012，你发的截图的参考意义不大

上传  这个时段的AWR ，压缩打包上传

/app/oracle/diag/rdbms/atmpdb/atmpdb2/trace/atmpdb2_diag_14417946.trc
/app/oracle/diag/rdbms/atmpdb/atmpdb2/trace/atmpdb2_lgwr_14680218.trc

以上2个文件，  这2个文件是判断问题的主要依据

回复只看该作者道具举报