ORACLE EM DBA

Problems, Solutions, Test Cases from my professional and personal experience in technologies like Oracle Enterprise Manager 13 c,Oracle Enterprise Manager 12c, Oracle Configuration Manager and some other stuff.

Month: May 2015

OPATCH FOR Oracle Agent 12cR2 HIGH CPU UTILIZATION

Hi All,

In this blog of mine I have discussed the remedy for HIGH CPU utilization of Oracle 12cR2 agent. I faced this Issue on most of my Linux servers, where all of a sudden the Oracle Agent used to start utilizing CPU at very high rate.

Again list most of the old Issue this one as well was reported as BUG with MOS.  So If you have Oracle Agent 12cR2 on your Linux machine and you are experiencing Agent High CPU utilization you can get it resolved by applying the patch 13583799.

Listed below are the steps you have to perform in order to apply the patch.

OPATCH FOR HIGH CPU UTILIZATION

{apply patch 13583799 on 12cR2 Agent on Linux}

S.N Status Task
1 Done export ORACLE_HOME=/app/oracle/product/agent12c/core/12.1.0.2.0
2 Done  cd OPatch

./opatch lsinv -details |grep -i jdbc

make sure client Oracle JDBC/OCI Instant Client  is                                   11.1.0.7.0

3 Done using patch 13583799’s 11.1.0.7.0  version  check perl -v > 5.5
4 Done  ./emctl stop agent
5 Done make sure no process run under agent 12c

ps -ef |grep TMMain

ps -ef |grep emagent |grep -v grep

6 Done cd /install_media/ORACLE/OEM/OEM12C/patch/13583799

(for 13583799,cd /install_media/ORACLE/OEM/OEM12C/patch/13583799)

7 Done  opatch apply
8 Done check any error in opatch log  /app/oracle/product/agent12c/core/12.1.0.2.0/cfgtoollogs/opatch/opatch2013-01-07_08-03-49AM.log
9 Done start agent and check status

This will bring down your un-necessary Agent’s CPU utilization.

Thanks

Deepak

Creating Generic Service using “ATS Transactions” in OEM

Hi Everyone,

In this post, I help you out how we can create Generic Service using “ATS Transactions” in OEM 12c. Well This situation came across me when to monitor one of my application I created a “Generic Service” which use Web Transaction.

The test was created successfully, the only issue was the for every repetition it was occupying one license was not not releasing it at the Logout Step, which ideally it should do. Yes one of the applications in my company acquire one license every time when any user logs into. This license is released only when the user logs out.

So this Web Transaction method started Blocking my licenses for Application Login. I reported this case to Support but they closed it in one day itself telling me that “Web Transaction” method has become obsolete and they do not recommend to use it. MOS suggested me to use OATS {Oracle Application Testing Suite}

I created Service Test using the ATS Transaction Method, created a Service Test and it resolved my Issue of blocking Licenses.

I will show you how create Service Test using ATS Transaction. Follow the below mentioned Steps.

  • Make sure you have Oracle Application Testing Suite, you can install it on you local computer as well.
  • You can download from “http://www.oracle.com/technetwork/oem/app-test/etest-101273.html” link
  • Follow the guidelines in the installation manual and get it installed on your system.
  • Once installed start the Open Script.

Image1

  • Mentioned below is the main page of “Open Script”

Image2

  • Click on “File” in the menu bar and select “New”.

Image3

  • “New Project” wizard will open. Under “Load Testing” select “WebHTTP”

Image4

  • Save you Project under your Repository. Give a name to your project and click on “Finish”.

Image5

  • Once you click on “Finish”, your new project window will open where you can record your Transaction.

Image6

  • Click on highlighted recording button shown in previous screenshot. It will open a recording Toolbar and recording window where you can enter the URL of Application which you want to test.

Image7

  • Perform all the steps which you want to include in your test {Transaction}
  • Once all the steps are included, click on “Stop” button in the Recording Toolbar.
  • It will show the Hierarchy of all the steps which are included in your transaction test.

Image8

  • Save your Project under the “File Menu” and then export the Project Zip file as show in screenshot.

Image9

Image10

  • Save File on you local laptop, in order to upload it at creation time of ATS transaction.
  • Now Login to your EM12c Console and Navigate to “Services” as shown in the screenshot.

Image11

  • Now Click on “Create” button and select “Generic Service – Test Based”

Image12

  • It will navigate  you to the First page, enter the required details like “NAME” & “Time Zone” and Click on “Next”.

Image13

  • Under Test Type, select “ATS Transaction” and enter name for your Service Test. Also enter the Collection Frequency at which you want the test to be executed again n again.

Image14

  • Now Add the saved ZIP file of the transaction recorded using “Oracle Application Testing Suite”.

Image15

  • Once you upload the ZIP file, it will automatically fetch all the details from the file and load it in the Service Test.

Image16

  • Next step is to add a Beacon for your Service Test which will perform Service Test from Geographical location. Beacon Actually help us to know availability of Application from different locations. You can select more than one beacon as well for Service Test.

Image17

  • Final Review of “Generic Service”, review all the details to make sure something wrong did not happen and then click “Finish”.

Image18

Your Service Test is created successfully. You can now monitor you Application without any Issue.

Hope this post will help you out in one or other way.

Will keep posting new Issue & Resolutions.

Regards

Deepak Sharma

How to FIX “Metric Collection Error” {Agent Status not UP in Console}

A Common Issue which everyone usually faces, while new installation of Agent on any server.  Agent is up and running but still status is not up in EM Console show “METRIC COLLECTION ERROR”.

Check on the server and perform following steps to resolve this Issue.

D:\oracle\product\agent12c\agent_inst\bin>emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
—————————————————————
Agent Version : 12.1.0.4.0
OMS Version : 12.1.0.4.0
Protocol Version : 12.1.0.1.0
Agent Home : D:/oracle/product/agent12c/agent_inst
Agent Log Directory : D:/oracle/product/agent12c/agent_inst\sysman\log
Agent Binaries : D:\oracle\product\agent12c\core\12.1.0.4.0
Agent Process ID : 5632
Parent Process ID : 10516
Agent URL : https://HANXXX.TEST.com:3872/emd/main/
Local Agent URL in NAT : https://HANXXX.TEST.com:3872/emd/main/
Repository URL : https://HANXXX.TEST.com:4904/empbs/upload

Started at : 2015-05-13 18:35:17
Started by user : HANXXX3$
Operating System : Windows version 6.1 (amd64)
Last Reload : (none)
Last successful upload : 2015-05-13 18:35:45
Last attempted upload : 2015-05-13 18:35:45
Total Megabytes of XML files uploaded so far : 0
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 50.84%
Collection Status : Collections enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2015-05-14 14:17:49
Last successful heartbeat to OMS : 2015-05-14 14:17:49
Next scheduled heartbeat to OMS : 2015-05-14 14:18:49

—————————————————————
Agent is Running and Ready

D:\oracle\product\agent12c\agent_inst\bin>emctl upload agent
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
—————————————————————
EMD upload completed successfully

D:\oracle\product\agent12c\agent_inst\bin>emctl verifykey
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.

—————————————————–
verifykey: Successfully Completed communication with agent
EMD pingOMS completed successfully

—————————————————–

======================================================
But Still Agent Status was not showing UP in Console.
=====================================================

d:\oracle\product\agent12c\agent_inst\bin>emctl stop agent
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
The Oracleagent12c1Agent service is stopping………….
The Oracleagent12c1Agent service was stopped successfully.

Deleted files from $ORACLE_HOME/sysman/emd/state and $ORACLE_HOME/sysman/emd/upload
D:\oracle\product\agent12c\agent_inst\bin>emctl clearstate agent
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
EMD clearstate completed successfully

———————————————

D:\oracle\product\agent12c\agent_inst\bin>emctl secure agent
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
Agent successfully stopped… Done.
Securing agent… Started.
Enter Agent Registration Password :
Agent successfully restarted… Done.
Securing agent… Successful.

——————————————-
D:\oracle\product\agent12c\agent_inst\bin>emctl config agent addinternaltargets
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.

——————————————-
D:\oracle\product\agent12c\agent_inst\bin>emctl config agent listtargets
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
[agent12c1_2_HANXXX.TEST.com, oracle_home]
[HANXXX.TEST.com, host]
[HANXXX.TEST.com:3872, oracle_emd]

——————————————-
D:\oracle\product\agent12c\agent_inst\bin>emctl upload agent
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
—————————————————————
EMD upload completed successfully

———————————————
D:\oracle\product\agent12c\agent_inst\bin>emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
—————————————————————
Agent Version : 12.1.0.4.0
OMS Version : 12.1.0.4.0
Protocol Version : 12.1.0.1.0
Agent Home : D:/oracle/product/agent12c/agent_inst
Agent Log Directory : D:/oracle/product/agent12c/agent_inst\sysman\log
Agent Binaries : D:\oracle\product\agent12c\core\12.1.0.4.0
Agent Process ID : 7188
Parent Process ID : 3536
Agent URL : https://HANXXX.TEST.com:3872/emd/main/
Local Agent URL in NAT : https://HANXXX.TEST.com:3872/emd/main/
Repository URL : https://HANXXX.TEST.com:4904/empbs/upload

Started at : 2015-05-14 15:27:47
Started by user : HANXXX3$
Operating System : Windows version 6.1 (amd64)
Last Reload : (none)
Last successful upload : 2015-05-14 15:32:38
Last attempted upload : 2015-05-14 15:32:38
Total Megabytes of XML files uploaded so far : 0.12
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 50.81%
Collection Status : Collections enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2015-05-14 15:34:56
Last successful heartbeat to OMS : 2015-05-14 15:34:56
Next scheduled heartbeat to OMS : 2015-05-14 15:35:56

—————————————————————
Agent is Running and Ready

D:\oracle\product\agent12c\agent_inst\bin>

Finally The Agent was having Status up in Console.

Thanks

Deepak

© 2017 ORACLE EM DBA

Theme by Anders NorenUp ↑