RE: racgimon.exe CPU usage question

From: Guang Mei <GuangMei_at_crd.com>
Date: Tue, 17 Apr 2007 10:20:37 -0400
Message-ID: <BB2F960B8F4F7C40A09F44F50CF40A7805BC10@mail3.crd.com>

I posted a question last week and got one reply.

To recap:
Oracle 10gR2, Rac
Winracdb has two nodes: devwin16 and devwin15 (both windows-XP box) When winrac db is started, we found racgimon would take about about between 10% to 15% CPU on one node (or both nodes). The root cause of this issue is racgimon process is trying to write to file

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

I tried Vasu's method, and it did not work in my situation. I found that there are two $ORACLE_HOME in registry on my rac machines:

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

Run db_control.bat (from devwin15 or devwin16) to start winrac db
From devwin15, copy file C:\oracle\product\10.2.0\crs\opmn\conf\.formfactor to F dirve, and rename it as .formfactor_from_devwin15
From devwin16, copy file C:\oracle\product\10.2.0\crs\opmn\conf\.formfactor to F dirve, and rename it as .formfactor_from_devwin16
Now go to F:\oracle\product\10.2.0\db_1\opmn\conf, do

copy .formfactor_from_devwin15 .formfact

You should see racgimon's CPU usuage should drop to close to zero on devwin16

Then do
copy .formfactor_from_devwin16 .formfact

You should see racgimon's CPU usuage should drop to close to zero on devwin15

Note: the above process would be needed each time the rac db is bounced.

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

-----Original Message-----
From: Vasu Balla [mailto:appsdba_at_gmail.com] Sent: Monday, April 09, 2007 10:55 PM
To: Guang Mei
Cc: oracle-l_at_freelists.org
Subject: Re: racgimon.exe CPU usage question

Guang,

we faced this issue on a 10.2.0.2 RAC on RHEL4, fix is to add allowgroup=true in ons.config of CRS home

this entry will create .formfactor file, which will stop spinning of rgi Guang Mei wrote:

and also make sure crs owner and db oh owner have same os group as primary , i guess this point is not applicable for windows

vasu

>
> 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..

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 17 2007 - 09:20:37 CDT