[20160623]ora-00445.txt

[20160623]ora-00445.txt

Wed Jun 22 07:38:25 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=393754):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Incident details in: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_393754\orcl_smco_3976_i393754.trc
Wed Jun 22 07:38:27 2016
Trace dumping is performing id=[cdmp_20160622073827]
Wed Jun 22 07:40:32 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3036.trc  (incident=393722):
ORA-00445: 后台进程 "m000" 在 120 秒之后仍没有启动
Incident details in: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_393722\orcl_mmon_3036_i393722.trc
Wed Jun 22 07:40:34 2016
Trace dumping is performing id=[cdmp_20160622074034]
Wed Jun 22 07:42:38 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=393755):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Incident details in: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_393755\orcl_smco_3976_i393755.trc
Wed Jun 22 07:42:40 2016
Trace dumping is performing id=[cdmp_20160622074240]
Wed Jun 22 07:44:44 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=393818):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
Incident details in: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_393818\orcl_cjq0_968_i393818.trc
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 07:44:46 2016
Trace dumping is performing id=[cdmp_20160622074446]
Wed Jun 22 07:46:49 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3036.trc  (incident=393723):
ORA-00445: 后台进程 "m000" 在 120 秒之后仍没有启动
Incident details in: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_393723\orcl_mmon_3036_i393723.trc
Wed Jun 22 07:46:50 2016
Trace dumping is performing id=[cdmp_20160622074650]
Wed Jun 22 07:48:54 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=393819):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 07:50:59 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=393756):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 07:53:04 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=393820):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 07:55:09 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=393757):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 07:57:14 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=393821):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 07:59:19 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=393758):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:01:25 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3036.trc  (incident=393724):
ORA-00445: 后台进程 "m000" 在 120 秒之后仍没有启动
Wed Jun 22 08:03:30 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=393759):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:05:35 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3036.trc  (incident=393725):
ORA-00445: 后台进程 "m000" 在 120 秒之后仍没有启动
Wed Jun 22 08:07:41 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=393760):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:09:46 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3036.trc  (incident=393726):
ORA-00445: 后台进程 "m000" 在 120 秒之后仍没有启动
Wed Jun 22 08:11:51 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=393761):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:13:56 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3036.trc  (incident=393727):
ORA-00445: 后台进程 "m000" 在 120 秒之后仍没有启动
Wed Jun 22 08:16:02 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396802):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:18:07 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3036.trc  (incident=393728):
ORA-00445: 后台进程 "m000" 在 120 秒之后仍没有启动
Wed Jun 22 08:20:12 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396803):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:22:18 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3036.trc  (incident=393729):
ORA-00445: 后台进程 "m000" 在 120 秒之后仍没有启动
Wed Jun 22 08:24:23 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396804):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:26:28 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3036.trc  (incident=396810):
ORA-00445: 后台进程 "m000" 在 120 秒之后仍没有启动
Wed Jun 22 08:28:33 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=393822):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 08:30:38 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396805):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:32:44 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=393823):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 08:34:49 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396806):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:36:54 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=393824):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 08:38:59 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396807):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:41:04 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=393825):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 08:41:43 2016
Timed out trying to start process m000.
Wed Jun 22 08:43:48 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396808):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:45:54 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3036.trc  (incident=396811):
ORA-00445: 后台进程 "m000" 在 120 秒之后仍没有启动
Wed Jun 22 08:47:59 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=396818):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 08:50:04 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396809):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:52:09 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=396819):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 08:54:14 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396826):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 08:56:19 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=396820):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 08:58:24 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396827):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 09:00:29 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=396821):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 09:01:14 2016
Timed out trying to start process m000.
Wed Jun 22 09:03:20 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=396822):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 09:05:25 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396828):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 09:07:30 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=396823):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 09:09:35 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396829):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 09:11:40 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=396824):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 09:13:45 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396830):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动
Wed Jun 22 09:15:51 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3036.trc  (incident=396812):
ORA-00445: 后台进程 "m000" 在 120 秒之后仍没有启动
Wed Jun 22 09:17:56 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc  (incident=396825):
ORA-00445: 后台进程 "J000" 在 120 秒之后仍没有启动
kkjcre1p: unable to spawn jobq slave process
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_cjq0_968.trc:
Wed Jun 22 09:20:01 2016
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.trc  (incident=396831):
ORA-00445: 后台进程 "W000" 在 120 秒之后仍没有启动

$ oerr ora 00445
00445, 00000, "background process \"%s\" did not start after %s seconds"
// *Cause:  The specified process did not start after the specified time.
// *Action: Ensure that the background did not die and leave a trace file.

http://www.askmaclean.com/archives/11g-space-preallocation-smco-w00n.html

select * from v$version;
BANNER                                                                         
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production   
PL/SQL Release 11.2.0.1.0 - Production                                         
CORE    11.2.0.1.0    Production                                                     
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production                        
NLSRTL Version 11.2.0.1.0 - Production                                         
5 rows selected.

SYS@book> @ &r/hide _spacebg
NAME                         DESCRIPTION                                           DEFAULT_VALUE SESSION_VALUE SYSTEM_VALUE
---------------------------- ----------------------------------------------------- ------------- ------------- ------------
_enable_spacebg              enable space management background task               TRUE          TRUE          TRUE
_max_spacebg_msgs_percentage maximum space management interrupt message throttling TRUE          50            50
_max_spacebg_slaves          maximum space management background slaves            TRUE          10            10
_max_spacebg_tasks           maximum space management background tasks             TRUE          1000          1000

SYS@book> @ &r/hide _enable_space
NAME                         DESCRIPTION                                            DEFAULT_VALUE SESSION_VALUE SYSTEM_VALUE
---------------------------- ------------------------------------------------------ ------------- ------------- ------------
_enable_space_preallocation  enable space pre-allocation                            TRUE          3             3
_enable_spacebg              enable space management background task                TRUE          TRUE          TRUE

--应该是有一个表空间满了,11g支持预分配,不知道为什么不成功.也许一些资源耗尽.
--对于由于SMCO 或W00n在完成space preallocation过程中遇到的问题时，可以考虑禁用该特性，具体方法为：

SQL> alter system set "_enable_spacebg"=false;
System altered.

SQL> alter system set "_enable_space_preallocation"=0;
System altered.

--做一个记录,数据库已经重启,看看是否再出现这个问题.

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

转载于:http://blog.itpub.net/267265/viewspace-2120811/