ORA 各种报错

oracle_bin

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 ~~

oracle_bin

trace 文件

Maclean Liu(刘相兵

运行一下 一下命令：

/usr/sbin/mount

并贴出输出

Maclean Liu(刘相兵

在trace 目录下 找 哪个时段的 dbrm 进程的trace文件
/app/oracle/diag/rdbms/atmpdb/atmpdb2/trace/

最好也能上传

oracle_bin

没有那个时间段的awr,有trc文件

Maclean Liu(刘相兵

谢谢！:)



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个文件是 判断问题的主要依据