数据库日志中出现问题求指点
本帖最后由 piaoliuguo 于 2012-07-31 16:08 编辑查看数据库日志,发现日志中报错,还请各位指点下。谢谢!
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 数据库版本?看着像bug 回复 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
升级到10.2.0.5吧,10.2.0.1的bug太多 这个warning是个BUG:WARNING: inbound connection timed out (ORA-3136),印象中修改sqlnet.ora中的几个参数可以屏蔽掉
不过这个不像是引起后来进程启动失败的原因,看后来的进程一个个死掉,像是某些系统资源被耗尽引起的,内存的原因居多,也许是实例的内存参数设置不合理引起的。 那个warning MOS文档465043.1有描述,楼主遇到的应该可以按照那个文档的方法来解决。 回复 5# Minsic
那可能是哪个参数设置不合理引起的呢? piaoliuguo 发表于 2012-08-02 16:38 static/image/common/back.gif
回复 5# Minsic
比如sga_target+pga_target过大
页:
[1]