Oracle DBA Tips and Techniques

By Arjun Raja

Archive for May, 2013

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>

Posted in EM Grid Control | Tagged: , | Leave a Comment »