ORA-27492: unable to run job "string.string": scheduler unavailable

ORA-27492: unable to run job "string.string": scheduler unavailable
Cause: A job run with current session set to false can not be issued if the scheduler is not active. Check value of job_queue_processes parameter, issue dbms_ijob.set_enabled(true), database is in upgrade/migrade mode, database is in data guard mode, or scheduler attribute SCHEDULER_DISABLED is set to TRUE
Action: Run the job in the current session or activate the scheduler

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:47

ORA-27492：无法运行工作“ 字符串。字符串 ”：调度器不可用,
.原因：如果调度程序不活动，则不能发出将当前会话设置为false的作业。检查job_queue_processes参数的值，发出dbms_ijob.set_enabled（true），数据库处于升级/ migrade模式，数据库处于数据保护模式，或调度程序属性SCHEDULER_DISABLED设置为TRUE,
.操作：在当前会话中运行作业或激活调度程序,
.

aiaiDBA

13718043309

010-86462881

ORA-27492: unable to run job "string.string": scheduler unavailable

1 个回答

相似问题