Oracle 11g Consume 100% of the CPU Cycles

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geoff - 06 Oct 2008 17:06 GMT

I have a Windows XP machine that never had Oracle on it before.

I installed Oracle 11g and everything appeared to be going smoothly except
towards the end, it could not start the DBConsole.

After the install was complete, 'oracle.exe' was taking 100% of the CPU
cycles.

I searched the web but it appears no one knows what is going on. Some of
the responses included:
- Maybe insufficient hardware, not enough memory, etc.
- If the machine had Oracle before, perhaps it has a lot of jobs to run.
- The machine rebooted before the install completed.

. . . on my machine, the MS loopback connector is installed and working, and
the machine has plenty of resources.

Appreciate any info.

--g

Reply to this Message

Steve Howard - 06 Oct 2008 17:41 GMT

> I have a Windows XP machine that never had Oracle on it before.
>
[quoted text clipped - 16 lines]
>
> --g

Hi Geoff,

Assuming you are running this on your laptop for learning purposes,
run the following at a DOS prompt and post the output.

cd %oracle_home%\rdbms\admin
sqlplus / as sysdba
@addmrpt
select the range of the last three or four snapshots and enter the
ID's.
Take the text file output default name, and post the output

(this may take a while if it is as saturated as you note)

HTH,

Steve

Reply to this Message

Lars Tetzlaff - 06 Oct 2008 19:21 GMT

geoff schrieb:

> I have a Windows XP machine that never had Oracle on it before.
>
[quoted text clipped - 16 lines]
>
> --g

Don't know if this is the same problem as with linux, but I found the
following advice that helped me on linux:

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!

I don't know what tool to execute the packages where used by the
original poster, but for me sqlplus worked.

Lars

Reply to this Message

newhorizon - 07 Oct 2008 15:14 GMT

It is a bug of 11g.
There is a patch for it on the metalink.

Reply to this Message

Peter Müller - 19 Oct 2008 18:56 GMT

I have the same problem. I have no support identifier and I don't have
the possibility to get one (I can not invent one). Is there another way
to get the patch?

Reply to this Message

Palooka - 19 Oct 2008 19:58 GMT

> I have the same problem. I have no support identifier and I don't have
> the possibility to get one (I can not invent one). Is there another way
> to get the patch?

You could steal one, beg for one or pirate one.

Alternatively, you could join the honest community, and either get a
paid-for support contract, or take advantage of Oracle's very generous
free download licensing terms, and do without Metalink and patching for
the purposes of trial, home learning and so forth.

Palooka

Reply to this Message

DA Morgan - 19 Oct 2008 20:23 GMT

> I have the same problem. I have no support identifier and I don't have
> the possibility to get one (I can not invent one). Is there another way
> to get the patch?

What is preventing you from purchasing a support contract?

http://oraclestore.oracle.com/OA_HTML/ibeCZzpHome.jsp?minisite=10021&respid=2237
2&grp=STORE&language=US

Standard Edition One
Named User Plus Perpetual
$180.00 x 5 = $900
Surely your employer can afford it.

Signature

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Reply to this Message

Peter Müller - 25 Oct 2008 19:33 GMT

It was a while a go that I downloaded Oracle. So I thought I have
installed the express version. Now I installed the 10g express version
which is OK for learning Oracle.

Reply to this Message