Showing posts with label Oracle Grid 12cR1. Show all posts
Showing posts with label Oracle Grid 12cR1. Show all posts

ORAAGENT or ORAROOTAGENT High Resource (CPU, Memory etc) Usage

Issue:


11gR2 Grid Infrastructure oraagent.bin or orarootagent.bin process uses high CPU, memory and threads. If the cluster node is up and running for very long time, it could exhaust memory and swap space which could result in node eviction or other stability issue. With OS "top" or other memory monitoring tool, we can see huge virtual memory is allocated and increasing over
time:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
7242 oracle 18 0 308g 953m 14m S 83.2 0.7 166:28.72 oraagent.bin

In above example, 308GB of virtual memory is allocated to the agent process while it's consuming 83.2% of CPU



Solution:


It's recommended to apply latest patch set or PSU. But if patches are unavailable or can not be applied, the workaround is to kill agent process during off peak hour. There should be no impact as agent will be respawned automatically.


To kill agent process with pid 7242: kill -9 7242

Grid Standalone Server with ASM on 12cR1

Step 1 :

Install Grid 12c Grid software and configure ASM Diskgroup:


[oracle@testvm grid]$ ls

install   rpm           runInstaller  stage
response  runcluvfy.sh  sshsetup      welcome.html

[oracle@testvm grid]$ ./runInstaller 

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 67846 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3074 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-07-04_03-10-49PM. Please wait ...[oracle@testvm grid]$ 




















 Step 2:

Install 12cR1 database software:

















Step 3: 

Create Database using DBCA utility.

                                      


 




Kindly share your comments... :-)