Oracle 11gR2 taking 100% CPU utilization
Firts of all, this can have an array of explanations, but I just wanted to share one of them and its solution. (Here's a related problem.)
Oracle has a "Provisioning Daemon" that runs jobs that are pre-populated in the oracle install. Now, apparently, if there is a mismatch in date settings (say, from having the wrong time settings when setting up Oracle) this job template will always be in the past, and consequently, the daemon will try to start a new job, until it consumes 100% and croaks. Fixing the time issue and restarting the server won't help, as the 'bad' jobs are still waiting there when the server comes up.
The solution is to
- Stop the console
- Run
create table mgmt_job_bad as select * from sysman.mgmt_job where job_name = 'PROVISIONING DAEMON';
delete from sysman.mgmt_job where job_name = 'PROVISIONING DAEMON';
commit; - Restart the installation.
- Review the mgmt_job_bad to see what needs to be done.
Caveat: Those jobs were put there for a reason - you should get to know exactly what went wrong before doing this in a production environment.