Download - Exachk and oem12c - IOUG C15LV
![Page 1: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/1.jpg)
Exachk and Oracle Enterprise Manager 12c:
Keeping up with Exadata
IOUG Collaborate 2015
Session: 746
Date: 4/13/2015 @ 12 pm
Room: Banyan D
![Page 2: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/2.jpg)
@dbasolved
http://dbasolved.com
Work: [email protected]
Personal: [email protected]
Bobby CurtisDouglasville, Georgia
Infrastructure Principle
IOUG (RACSIG/DI SIG), RMOUG, GAOUG
![Page 3: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/3.jpg)
Part of Accenture’s Infrastructure Services:
- 52,000 Oracle professionals
- 17,000 Infrastructure Services professionals
Oracle Database & Engineered Systems Solutions:
- Database Migrations
- Oracle Applications on Engineered Systems
- Cloud-based solutions leveraging Engineered Systems
Oracle “Specialized” in the following areas:
- Oracle Database, Oracle Database Security, Oracle Real Application Cluster (RAC),
Oracle Data Warehouse, Oracle Database Performance Turning, Oracle Linux
- Egineered Systems: Oracle Exadata, Oracle Exalogic, Oracle Exalytics
Accenture Enkitec Group
![Page 4: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/4.jpg)
Accenture Enkitec Group• Our Accenture Enkitec Group resources are members of several Oracle
Database groups such as Oak Table, Oracle ACE, etc and speak frequently
at events across the globe (Oracle Use Groups (OUG), Oracle Open World
(OOW), etc..
• Our team have authored several widely used books specific to Oracle
Database topics ranging from Exadata, performance & tuning to best
practices.
![Page 5: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/5.jpg)
Accenture EnkitecGroupE4The only conference with a focus on the Oracle Exadata platform
REGISTER TODAYJune 1–2, 2015Dallas, Texaswww.enkitec.com/e4/register
![Page 6: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/6.jpg)
Agenda
Oracle Exachk
- Exachk Tool
- Exachk Outputs
Oracle EM 12c Approach
- Prerequisites
- Environment Info
- Daemon
- Plug-In/Agent Interaction
- EM Outputs
![Page 7: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/7.jpg)
ExaChk Tool
Where to get it:MOS Note ID: 1070954.1 – Exachk or Healthcheck
Current release: 12.1.0.2.3_20150305
When to run:
On a regular basis (30 days)
After corrective actions performed on a failure
![Page 8: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/8.jpg)
ExaChk Tool
Run ExaChk:
$ cd <exachk unzip location>
$ ./exachk –a
Note: Follow the prompts and provide passwords
![Page 9: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/9.jpg)
Exachk Outputs
![Page 10: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/10.jpg)
Enterprise Manager 12c
Approach
![Page 11: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/11.jpg)
Prerequisites
Note: 757552.1 - Oracle Exadata Best Practices
Note: 1110675.1 – Oracle Database Machine Monitoring Best Practices
Oracle Exadata Configured and Monitored
Oracle Engineered System Healthchecks Plug-In (12.1.0.5.0)
Oracle Enterprise Manager 12c (12.1.0.2, 12.1.0.3, or 12.1.0.4)
![Page 12: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/12.jpg)
Environment Info
RAT_COPY_EM_XML_FILES : Enables copying of result files on
all the cluster
export RAT_COPY_EM_XML_FILES = 1
RAT_OUTPUT : Output path for the exachk output
export RAT_OUTPUT = /U01/ORACLE/EXACHK_RPT
NOTE: RAT = RAC Assurance Team
![Page 13: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/13.jpg)
DaemonExachk daemon makes it possible to run the ALL (-a) option of the
Exachk tool in silent mode.
Start the daemon as the Oracle user (follow the prompts)
./exachk –d start
Run Exachk by using the daemon
./exachk –daemon –a
Note: Same process can be used to run Exachk on Exalogic
![Page 14: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/14.jpg)
Daemon (Cluster)
Run the daemon as the Oracle user with cluster support
./exachk –clusternodes [node1,[node N]] –d start
Run Exachk by using the daemon
./exachk –daemon –a
Note: Now exachk can run across all nodes in the exadata (if needed)
![Page 15: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/15.jpg)
Plug-InCheck for any new plug-ins
Setup -> Extensibility -> Self Update -> Plug-Ins
Search for HealthChecks
Apply to OMS and Target Agents
![Page 16: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/16.jpg)
Agent Interaction
Results are placed in the metric: ExadataResults
Force the agent to collect Exadata metrics
./emctl control agent runCollection
<targetName>:oracle_exadata_hc ExadataResults
Note: <targetName> = Target in OEM12c
![Page 17: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/17.jpg)
EM OutputReports:
All Targets -> Engineered Systems -> Oracle
Engineered System Healthchecks
Can be saved as CSV files
Key Areas: Summary, Incidents & Problems, Result Summary
![Page 18: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/18.jpg)
EM OutputAlerts:
Default via Plug-In (15 total)
1.Verify Disk Cache Policy on DB Server
2.Verify DB Server Disk Controllers use
writeback cache
3. Verify RAID Controller Battery Condition
and Temperature
...
13. Exachk not running
14. Results and Exception file(s) missing
15. Metric Parsing Failed
Note: Unwanted alerts can be disabled with monitoring templates
![Page 19: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/19.jpg)
![Page 20: Exachk and oem12c - IOUG C15LV](https://reader031.vdocuments.us/reader031/viewer/2022020208/55a782611a28ab333e8b47dc/html5/thumbnails/20.jpg)
Reference material
Http://dbasolved.com/2014/01/23/configure-oem12c-to-perform-
checkups-on-exadata-exachk/
Oracle Enterprise Manager System Monitoring Plug-In Installation
Guide for Oracle Engineered System Healthchecks
(http://docs.oracle.com/cd/E24628_01/install.121/e27420/toc.htm#P
ICHK113)