最近alert中发现很多的ORA-27103,客户端也无法连接,检查日志发现如下信息:
ORA-27103: internal error
Linux-x86_64 Error: 2: No such file or directory
Additional information: 101
Fri Sep 19 16:07:04 2014
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /data1/u01/app/diag/rdbms/orcl/orcl/trace/orcl_cjq0_4351.trc:
Fri Sep 19 16:07:05 2014
Errors in file /data1/u01/app/diag/rdbms/orcl/orcl/trace/orcl_j000_5205.trc:
ORA-27103: internal error
Linux-x86_64 Error: 2: No such file or directory
Additional information: 101
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /data1/u01/app/diag/rdbms/orcl/orcl/trace/orcl_cjq0_4351.trc:
Fri Sep 19 16:07:11 2014
Errors in file /data1/u01/app/diag/rdbms/orcl/orcl/trace/orcl_j000_5207.trc:
ORA-27103: internal error
Linux-x86_64 Error: 2: No such file or directory
Additional information: 101
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /data1/u01/app/diag/rdbms/orcl/orcl/trace/orcl_cjq0_4351.trc:
Fri Sep 19 16:07:12 2014
Errors in file /data1/u01/app/diag/rdbms/orcl/orcl/trace/orcl_j000_5209.trc:
ORA-27103: internal error
Linux-x86_64 Error: 2: No such file or directory
Additional information: 101
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /data1/u01/app/diag/rdbms/orcl/orcl/trace/orcl_cjq0_4351.trc:
Fri Sep 19 16:08:58 2014
Errors in file /data1/u01/app/diag/rdbms/orcl/orcl/trace/orcl_j000_5217.trc:
ORA-27103: internal error
Linux-x86_64 Error: 2: No such file or directory
Additional information: 101
Fri Sep 19 16:08:59 2014复制代码查询了一些文档,说是process小导致的,可是很奇怪这个DB只是测试的机器,没有几个人在用,连接数理论上不应该很高啊,问题的我已经将之前的100调整为150了。
这台机器还是非常强劲的,128G内存,32个cpu很奇怪,我设置的memory_target=60G 难道是这个问题?
我现在方式是设置process=300同时memory设置成50G了,正在观察,有类似经历的提供些思路,多谢!