How to ORA-27492: unable to run job: scheduler unavailable

ORA-27492
Found error ORA-27492 when executed a tuning job.

SQL > call dbms_scheduler.run_job('TEST_JOB');

Error at line 2
ORA-27492: unable to run job "TEST"."TEST_JOB": scheduler unavailable
ORA-06512: in "SYS.DBMS_ISCHED", line 163
ORA-06512: in "SYS.DBMS_SCHEDULER", line 346
ORA-06512: in line 1

Solutions by Oracle

Description ORA-27492: unable to run job “string”.“string”: scheduler

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

Let’s see the number of job_queue_processes that the database can run.

SQL> show parameter job 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     0

there’s none.

Let’s start some job process for the database.

SQL>  alter system set job_queue_processes = 10 ; 

System altered.

SQL> show parameter job_queue_processes 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     10

Let’s running the job again

SQL> begin 
  2   dbms_scheduler.run_job('TEST_JOB'); 
  3  end ; 
  4  /
PL/SQL procedure successfully completed.