Oracle DBA Tips and Techniques

By Arjun Raja

OPATCH FOR MEMORY SPIKE ON CLOUD CONTROL 12c OMS SERVER

Posted by Arjun Raja on May 14, 2013

Patch to stop the memory spike on the OMS server – caused by the 12c agent.

Bugs Fixed by This Patch
————————-
The following are the bugs fixed by this patch:

–         16273498 – AIX SERVER 5.3 CRASHED :EMDPROCSTATS.PL CONSUMES 10GIG MEM

Installation Procedure
———————-

Download and apply Patch 16273498  (p16273498_121020_Generic.zip)

1) Download the patch  to /u01/oracle/stage

$ cd /u01/oracle/stage

$unzip p16273498_121020_Generic.zip

$ cd /u01/oracle/stage/16273498

2) Stop agent and apply the patch

$ export ORACLE_HOME=/u01/oracle/agent12c/core/12.1.0.2.0

opatch lsinventory – confirm inventory is of the agent home – Oracle Home: /u01/oracle/agent12c/core/12.1.0.2.0

$ $ORACLE_HOME/bin/emctl stop agent

$ cd /u01/oracle/stage/16273498

emrep:/u01/oracle/stage/16273498> opatch lsinventory -detail |grep 16273498

Patch not applied so proceed.

emrep:/u01/oracle/stage/16273498> opatch apply
Oracle Interim Patch Installer version 11.1.0.9.8
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/agent12c/core/12.1.0.2.0
Central Inventory : /u01/oracle/oraInventory
from           : /u01/oracle/agent12c/core/12.1.0.2.0/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/oracle/agent12c/core/12.1.0.2.0/cfgtoollogs/opatch/16273498_May_14_2013_08_02_41/apply2013-05-14_08-02-41AM_1.log

Applying interim patch ‘16273498’ to OH ‘/u01/oracle/agent12c/core/12.1.0.2.0’
Verifying environment and performing prerequisite checks…
All checks passed.
Backing up files…

Patching component oracle.sysman.top.agent, 12.1.0.2.0…

Verifying the update…
Patch 16273498 successfully applied
Log file location: /u01/oracle/agent12c/core/12.1.0.2.0/cfgtoollogs/opatch/16273498_May_14_2013_08_02_41/apply2013-05-14_08-02-41AM_1.log

OPatch succeeded.
emrep:/u01/oracle/stage/16273498>

emrep:/u01/oracle/stage/16273498> opatch lsinventory -detail |grep 16273498
Patch  16273498     : applied on Tue May 14 08:02:46 WST 2013
16273498
emdprocesschars.pl –> ORACLE_HOME/16273498/files/sysman/admin/scripts/emdprocesschars.pl
emdprocstats.pl –> ORACLE_HOME/16273498/files/sysman/admin/scripts/emdprocstats.pl
/u01/oracle/agent12c/core/12.1.0.2.0/inventory/oneoffs/16273498
/u01/oracle/agent12c/core/12.1.0.2.0/.patch_storage/16273498_Mar_4_2013_01_36_13
emrep:/u01/oracle/stage/16273498>

emrep:/u01/oracle/stage/16273498> cd $ORACLE_HOME/bin

emrep:/u01/oracle/agent12c/core/12.1.0.2.0/bin> ./emctl start agent
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Starting agent …………………….. started.

emrep:/u01/oracle/agent12c/core/12.1.0.2.0/bin> ./emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
—————————————————————
Agent Version     : 12.1.0.2.0
OMS Version       : 12.1.0.2.0
Protocol Version  : 12.1.0.1.0
Agent Home        : /u01/oracle/agent12c/agent_inst
Agent Binaries    : /u01/oracle/agent12c/core/12.1.0.2.0
Agent Process ID  : 23462106
Parent Process ID : 28377322
Agent URL         : https://xxxxxx.yyyyyyy.com:3872/emd/main/
Repository URL    : https://xxxxxx.yyyyy.com:4900/empbs/upload
Started at        : 2013-05-14 08:04:08
Started by user   : oracle
Last Reload       : (none)
Last successful upload                       : 2013-05-14 08:04:29
Last attempted upload                        : 2013-05-14 08:04:29
Total Megabytes of XML files uploaded so far : 0.01
Number of XML files pending upload           : 5
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 58.74%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2013-05-14 08:04:23
Last successful heartbeat to OMS             : 2013-05-14 08:04:23
Next scheduled heartbeat to OMS              : 2013-05-14 08:05:27

—————————————————————
Agent is Running and Ready
emrep:/u01/oracle/agent12c/core/12.1.0.2.0/bin>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: