100% CPU Usage Overhead running EM DBConsole 11g on Debian sid

Submitted by hswong3i on Wed, 2008/07/09 - 01:36

Oracle
Tips

My Oracle 11gR1 gone crazy with 100% CPU loading when working with Debian sid. This page provide a functional solution:

Shutdown OEM, login as SYSMAN user and restart the provisioning daemon by executing the two packaged procedures

SYSMAN> execute MGMT_PAF_UTL.STOP_DAEMON

PL/SQL procedure successfully completed.

SYSMAN> execute MGMT_PAF_UTL.START_DAEMON

PL/SQL procedure successfully completed.

Start OEM again and the problem is gone.

WARNING: You must take this on your own responsibility!

So here is my detail procedures. For shutdown OEM (login as user oracle where Oracle 11gR1 installed in /u01/app/oracle/product/11.1.0/db_1/bin):

su - oracle
cd /u01/app/oracle/product/11.1.0/db_1/bin
./emctl stop dbconsole

./sqlplus SYSMAN

Then execute the following PL/SQL commands:

SQL> execute MGMT_PAF_UTL.STOP_DAEMON
SQL> execute MGMT_PAF_UTL.START_DAEMON

Restart OEM:

./emctl start dbconsole

Check the CPU loading and it should be fine now :-)

Bookmark/Search this post with:

Permanent fix?

Submitted by Anonymous (not verified) on Thu, 2008/08/14 - 05:56.

Is this a permanent fix, or will I have to do this any time oracle is restarted?

You just need to do it once

Submitted by hswong3i on Thu, 2008/08/14 - 13:14.

You just need to do it once and Oracle will not be crazy anymore :-)

----------------------------------------
Edison Wong

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <h1> <h2> <h3> <h4> <h5> <h6> <em> <strong> <code> <del> <blockquote> <q> <sub> <p> <br> <ul> <ol> <li> <dl> <dt> <dd> <a> <b> <u> <i> <sup> <acronym> <pre> <img>
Lines and paragraphs break automatically.
You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
Images can be added to this post.

More information about formatting options

CAPTCHA

This question is for testing whether you are a human visitor and to prevent automated spam submissions.