数据库日志中出现启动JOB进程的TIMED OUT信息

在数据库的alert文件中发现了错误信息。

 

 

详细错误信息如下：

Tue Nov 17 17:02:02 2009
Timed out trying to start process J000.
Tue Nov 17 17:04:08 2009
Timed out trying to start process J000.
Tue Nov 17 17:06:14 2009
Timed out trying to start process J000.
Tue Nov 17 17:08:19 2009
Timed out trying to start process J000.
Tue Nov 17 17:10:30 2009
Timed out trying to start process J000.
Tue Nov 17 17:12:36 2009
Timed out trying to start process J000.
Tue Nov 17 17:14:42 2009
Timed out trying to start process J000.
Tue Nov 17 17:16:47 2009
Timed out trying to start process J000.
Tue Nov 17 17:18:53 2009
Timed out trying to start process J000.
Tue Nov 17 17:20:59 2009
Timed out trying to start process J000.

从上面的信息看，问题发生在启动JOB进程的时候，不过数据库没有其他任何的错误信息，无法通过其他的信息来判断是什么问题导致了这个错误的产生。

由于没有其他的信息，只好以上面的信息为关键字查询了metalink，结果也没有找到任何有价值的信息。

由于从数据库和操作系统中都没有找到导致问题的原因，本打算放弃，结果在检查其他的数据库的时候意外的发现了线索：

Tue Nov 17 17:06:13 2009
Errors in file /data/oracle/admin/jiangsu/bdump/jiangsu_j000_16007.trc:
ORA-12012: error on auto execute of job 101
ORA-12048: error encountered while refreshing materialized view "NDMAIN"."CAT_PRODUCT"
ORA-04052: error occurred when looking up remote object SELE.SYS@DATA01.US.ORACLE.COM
ORA-00604: error occurred at recursive SQL level 3
ORA-02068: following severe error from DATA01
ORA-00020: maximum number of processes (300) exceeded
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Tue Nov 17 17:08:18 2009
Errors in file /data/oracle/admin/jiangsu/bdump/jiangsu_j000_16009.trc:
ORA-12012: error on auto execute of job 101
ORA-12048: error encountered while refreshing materialized view "NDMAIN"."CAT_PRODUCT"
ORA-04052: error occurred when looking up remote object SELE.SYS@DATA01.US.ORACLE.COM
ORA-00604: error occurred at recursive SQL level 3
ORA-02068: following severe error from DATA01
ORA-00020: maximum number of processes (300) exceeded
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Tue Nov 17 17:12:18 2009
Errors in file /data/oracle/admin/jiangsu/bdump/jiangsu_j000_16017.trc:
ORA-12012: error on auto execute of job 101
ORA-12048: error encountered while refreshing materialized view "NDMAIN"."CAT_PRODUCT"
ORA-04052: error occurred when looking up remote object SELE.SYS@DATA01.US.ORACLE.COM
ORA-00604: error occurred at recursive SQL level 3
ORA-02068: following severe error from DATA01
ORA-00020: maximum number of processes (300) exceeded
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1

这个数据库通过数据库链访问的对象就是前面出错的对象，而这里可以轻易的发现导致问题的原因是由于目标数据库的启动进程已经超过了初始化参数设置。

根据这个错误的时间，可以确定，导致本机上JOB进程启动失败的原因肯定也是由于processes超过了300。

虽然目标数据库的访问很小，但是忙时进程超过300的可能性还是很大的，显然这个初始化参数的设置偏小。

没想到本机的信息都无法定位的问题，却通过其他服务器上的信息得到解决。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-621513/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-621513/