Discussion:
racgimon.exe CPU usage question
(too old to reply)
GuangMei
2007-04-17 21:52:31 UTC
Permalink
Hi,

We have 2-node oracle rac db on window platform.

Oracle Clusterware was upgraded to 10.2.0.3 with "10g Release 2
(10.2.0.3) Patch Set 2 for Microsoft Windows (32-Bit)"

The problem is that while the rac db is up and running (but with no db
activities from any applications), we found racgimon.exe is taking
about
15% cpu usage, followed by ons.exe of about 10% cpu usage.

Using a tool called "Filemon", we found racgimon.exe is trying to
write to a file called F:\oracle\product\10.2.0\db_1\opmn\conf
\.formfactor.

The file isn't there and the exe just keeps trying to open it...
over..
and over..

I worked on this issue a bit more, found a workaround, but still hope
that I could resolve this issue completely.


In SOFTWARE\ORACLE\KEY_OraCr10g_home,
ORACLE_CRS_HOME C:\oracle\product\10.2.0\crs
ORACLE_HOME C:\oracle\product\10.2.0\crs

In SOFTWARE\ORACLE\KEY_OraDb10g_home,
ORACLE_HOME f:\oracle\product\10.2.0\db1

F drive is the drive that gets shared by two nodes.

To workaround the above issue, I need to do

copy each node's file C:\oracle\product\10.2.0\crs\opmn\conf
\.formfactor to F:\oracle\product\10.2.0\db_1\opmn\conf\.formfactor on
the shared F dirve,
and then I can see racgimon's CPU usuage drop to close to zero on each
node.


My guess is racgimon daemon is not taking $oracle_home as C:\oracle
\product\10.2.0\crs (which it should), but it takes F:\oracle\product
\10.2.0\db_1 as $oracle_home. I tried to change $ORACLE_HOME for css
by running

cd C:\oracle\product\10.2.0\crs

localconfigure reset "C:\oracle\product\10.2.0\crs" on devwin16, but
never succeeded.

Below is what I got:

C:\oracle\product\10.2.0\crs\BIN>
C:\oracle\product\10.2.0\crs\BIN>localconfig.bat reset "C:\oracle
\product\10.2.
0\crs"
Step 1: stopping local CSS stack
failed to stop CSS service, err(1051)
failed to delete CSS service, err(1072)
failed to delete the local CSS stack
Step 2: deleting OCR repository
Step 3: creating new OCR repository
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'crdhome\gmei', privgrp ''..
Operation successful.
Step 4: creating new CSS service
Failed to create the new CSS service, err(1072)
failed to create new CSS services


Any suggestions?
Thanks.

Guang
hpuxrac
2007-04-18 00:11:20 UTC
Permalink
Post by GuangMei
Hi,
We have 2-node oracle rac db on window platform.
Oracle Clusterware was upgraded to 10.2.0.3 with "10g Release 2
(10.2.0.3) Patch Set 2 for Microsoft Windows (32-Bit)"
The problem is that while the rac db is up and running (but with no db
activities from any applications), we found racgimon.exe is taking
about
15% cpu usage, followed by ons.exe of about 10% cpu usage.
Using a tool called "Filemon", we found racgimon.exe is trying to
write to a file called F:\oracle\product\10.2.0\db_1\opmn\conf
\.formfactor.
The file isn't there and the exe just keeps trying to open it...
over..
and over..
I worked on this issue a bit more, found a workaround, but still hope
that I could resolve this issue completely.
In SOFTWARE\ORACLE\KEY_OraCr10g_home,
ORACLE_CRS_HOME C:\oracle\product\10.2.0\crs
ORACLE_HOME C:\oracle\product\10.2.0\crs
In SOFTWARE\ORACLE\KEY_OraDb10g_home,
ORACLE_HOME f:\oracle\product\10.2.0\db1
F drive is the drive that gets shared by two nodes.
To workaround the above issue, I need to do
copy each node's file C:\oracle\product\10.2.0\crs\opmn\conf
\.formfactor to F:\oracle\product\10.2.0\db_1\opmn\conf\.formfactor on
the shared F dirve,
and then I can see racgimon's CPU usuage drop to close to zero on each
node.
My guess is racgimon daemon is not taking $oracle_home as C:\oracle
\product\10.2.0\crs (which it should), but it takes F:\oracle\product
\10.2.0\db_1 as $oracle_home. I tried to change $ORACLE_HOME for css
by running
cd C:\oracle\product\10.2.0\crs
localconfigure reset "C:\oracle\product\10.2.0\crs" on devwin16, but
never succeeded.
C:\oracle\product\10.2.0\crs\BIN>
C:\oracle\product\10.2.0\crs\BIN>localconfig.bat reset "C:\oracle
\product\10.2.
0\crs"
Step 1: stopping local CSS stack
failed to stop CSS service, err(1051)
failed to delete CSS service, err(1072)
failed to delete the local CSS stack
Step 2: deleting OCR repository
Step 3: creating new OCR repository
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'crdhome\gmei', privgrp ''..
Operation successful.
Step 4: creating new CSS service
Failed to create the new CSS service, err(1072)
failed to create new CSS services
Any suggestions?
Thanks.
Guang
I guess it shouldn't surprise me anymore how many people run rac on
windows.

My suggestion is to work this with oracle via a service request and
please keep us updated on what support support provides.

Loading...