数据库日志中出现问题求指点

piaoliuguo

查看数据库日志，发现日志中报错，还请各位指点下。谢谢！


Mon Jul 30 14:28:45 2012
WARNING: inbound connection timed out (ORA-3136)
Mon Jul 30 14:56:51 2012
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Mon Jul 30 14:57:02 2012
Process P147 died, see its trace file
Process P147 died, see its trace file
Mon Jul 30 14:57:26 2012
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Process P147 died, see its trace file
Mon Jul 30 14:57:37 2012
Process P147 died, see its trace file
Process P147 died, see its trace file
Mon Jul 30 14:59:27 2012
Process J000 died, see its trace file
Mon Jul 30 14:59:27 2012
kkjcre1p: unable to spawn jobq slave process
Mon Jul 30 14:59:27 2012
Errors in file xxxx/bims_cjq0_2927.trc:

Process J000 died, see its trace file
Mon Jul 30 14:59:33 2012
kkjcre1p: unable to spawn jobq slave process
Mon Jul 30 14:59:33 2012
Errors in file xxxx/bims_cjq0_2927.trc:

Mon Jul 30 15:00:23 2012
Process m000 died, see its trace file
Mon Jul 30 15:00:23 2012
ksvcreate: Process(m000) creation failed
Mon Jul 30 15:01:24 2012
Process m000 died, see its trace file
Mon Jul 30 15:01:24 2012
ksvcreate: Process(m000) creation failed
Mon Jul 30 15:02:36 2012
Process m001 died, see its trace file
Mon Jul 30 15:02:36 2012
ksvcreate: Process(m001) creation failed
Mon Jul 30 15:20:59 2012
Process P156 died, see its trace file
Process P156 died, see its trace file
Process P156 died, see its trace file
Process P156 died, see its trace file
Process P156 died, see its trace file
Process P156 died, see its trace file
Process P156 died, see its trace file
Process P156 died, see its trace file
Mon Jul 30 15:21:10 2012
Process P156 died, see its trace file
Process P156 died, see its trace file
Mon Jul 30 15:55:25 2012
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Mon Jul 30 15:55:36 2012
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Mon Jul 30 15:55:47 2012
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Mon Jul 30 15:55:57 2012
Process P170 died, see its trace file
Process P170 died, see its trace file
Mon Jul 30 15:56:19 2012
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Process P170 died, see its trace file
Mon Jul 30 15:56:30 2012
Process P170 died, see its trace file
Process P170 died, see its trace file
Mon Jul 30 16:00:28 2012
Process m000 died, see its trace file
Mon Jul 30 16:00:28 2012
ksvcreate: Process(m000) creation failed
Mon Jul 30 16:00:50 2012
Process J000 died, see its trace file
Mon Jul 30 16:00:50 2012
kkjcre1p: unable to spawn jobq slave process
Mon Jul 30 16:00:50 2012
Errors in file xxxx/bims_cjq0_2927.trc:

Process J000 died, see its trace file
Mon Jul 30 16:00:55 2012
kkjcre1p: unable to spawn jobq slave process
Mon Jul 30 16:00:55 2012
Errors in file xxxx/bims_cjq0_2927.trc:

Mon Jul 30 16:01:10 2012
Process J000 died, see its trace file
Mon Jul 30 16:01:10 2012
kkjcre1p: unable to spawn jobq slave process
Mon Jul 30 16:01:10 2012
Errors in file xxxx/bims_cjq0_2927.trc:

Mon Jul 30 16:01:29 2012
Process m000 died, see its trace file
Mon Jul 30 16:01:29 2012
ksvcreate: Process(m000) creation failed

bzcat

数据库版本?看着像bug

piaoliuguo

回复 2# bzcat


Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Solaris: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

   

bzcat

升级到10.2.0.5吧，10.2.0.1的bug太多

Minsic

这个warning是个BUG：WARNING: inbound connection timed out (ORA-3136)，印象中修改sqlnet.ora中的几个参数可以屏蔽掉
不过这个不像是引起后来进程启动失败的原因，看后来的进程一个个死掉，像是某些系统资源被耗尽引起的，内存的原因居多，也许是实例的内存参数设置不合理引起的。

Minsic

那个warning MOS文档465043.1有描述，楼主遇到的应该可以按照那个文档的方法来解决。

piaoliuguo

回复 5# Minsic


    那可能是哪个参数设置不合理引起的呢？

Minsic

piaoliuguo 发表于 2012-08-02 16:38
回复 5# Minsic

比如sga_target+pga_target过大