oracle job失效解决一例(二)
is open close it (e.g.):
ATTRIBUTE_NAME VALUE
--------------------------------- ----------------------------
CURRENT_OPEN_WINDOW WEEKNIGHT_WINDOW
SQL> exec DBMS_SCHEDULER.close_window ('WEEKNIGHT_WINDOW');
^-- Done but did not help
These are the most common causes for this behavior.
Solution
The solution ended up to be the server (machine) uptime.
Even though it was up for only 126 days, after the server was rebooted all jobs were able to execute automatically.
To implement the solution, please execute the following steps:
1. Shutdown all applications, including databases.
2. Shutdown the server (machine)
3. Restart all applications, including databases.
4. Check that jobs are executing automatically.
.
以上我用了前面几种，都还是无效，最终我是通过[ID 309945.1]解决的：
1) Login as SYS
2) Execute the following command
SQL> exec dbms_ijob.set_enabled(true);
3) Verify that kkjsre is set to 1
SQL> oradebug setmypid
Statement processed.
SQL> oradebug dumpvar sga kkjsre
word kkjsre_ [20B7480, 20B7484) = 00000001
4) Verify that jobs are now starting automatically. If not, restart the database and recheck kkjsre. It should still be equal to 1 and jobs should now execute normally.
步骤没几步，很简单。不过如果需要重启库的话，建议在业务低谷的时候操作。