系统环境:Oracle817+win2000 server
设置了JOB但无法自动运行(手工可以,绝无问题),已查看show parameter job, 发现job_queue_processes=0, 而后使用alter system set job_queue_processes=5, 转而去看alert发现如下记录:
ALTER SYSTEM SET job_queue_processes=5;
Tue Mar 29 15:17:09 2005
Restarting dead background process SNP0
SNP0 started with pid=40
Tue Mar 29 15:17:09 2005
Restarting dead background process SNP1
SNP1 started with pid=41
Tue Mar 29 15:17:10 2005
Restarting dead background process SNP2
SNP2 started with pid=42
Tue Mar 29 15:17:10 2005
Restarting dead background process SNP3
SNP3 started with pid=43
Tue Mar 29 15:17:10 2005
Restarting dead background process SNP4
SNP4 started with pid=44
Tue Mar 29 15:17:12 2005
Errors in file D:\oracle\admin\CIM64\bdump\cim64SNP0.TRC:
ORA-12012: error on auto execute of job 21
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00439: feature not enabled: Database resource manager
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1118
ORA-06512: at "SYS.DBMS_SQL", line 316
ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 315
ORA-06512: at line 1
以下是我的oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
请各位帮忙看看这是什么问题。
19[/SIZE]
|