scheduler unavailable at SYS.DBMS_ISCHED

This is one of those scenarios where you get down in the weeds trying to fix a problem and can’t see the forest for the trees.  Sometimes I see the problem and get right intto the weeds without taking a step back and looking at a simpler view.  This is one of those problems.

Ever seen this when submitting a job (either via OEM or from the command line)?

java.sql.SQLException: ORA-27492: unable to run job “SYS.GATHERSCHEMASTATS_JOEBOB”: scheduler unavailable ORA-06512: at “SYS.DBMS_ISCHED”, line 185 ORA-06512: at “SYS.DBMS_SCHEDULER”, line 486 ORA-06512: at line 2

This was running, or trying to run, against a database I’ve had little interaction with and is more of a backend for a 3rd party appliance.  I dug and dug and was really scratching my head…. opened an SR with MOS.  It took him about two minutes to figure it out because he didn’t get down into the weeds…. the answer?

JOB_QUEUE_PROCESSES.  yep.  set to ZERO.  Not too many scheduler jobs are going to run with that setting.

Advertisements

One thought on “scheduler unavailable at SYS.DBMS_ISCHED

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s