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.