Automation using Oracle Enterprise Manager 13c

The IT evangelists predict the growth of IT footprints at the rate of knots in the coming years as the propensity of data consumption propagates endlessly in today’s information age. The result is an exponential increase in the storage capacities of the database servers; distributed across the IT spectrum either on-premise or cloud to satisfy the computing power of various applications hankering for immediate data availability. With so many database servers on multiple hardware platforms, driven by multiple versions of operating systems, version control and update run of patches become a mundane and a laborious task for a database administrator. Furthermore, to add to the enormity of the repetitiveness of this exercise are the number of sub-steps in each database patching like locating and downloading the appropriate patch in My Oracle Support (MOS), transferring it to each of the target servers, upgrading the OPATCH facility in each Oracle Home, shutting down the Databases and Listeners running from that Home and applying the patch.

This is where the Oracle Enterprise Manager 13c shines with its various automation capabilities. For instance, the provisioning and patching automation pack’s Oracle Enterprise Manager Cloud Control enables the creation and execution of scheduled scripts at the OS and database levels. The user-friendly GUI of the Enterprise Manager cater to offline patching and shows patches from Oracle support with a detailed description of the bugs it fixes. A patch plan can be created to bundle a collection of patches that can be applied to multiple targets via setup wizards thereby removing the need to run the manual steps.

The Oracle Enterprise Manager 13c has played a major role in standardizing security within the Department of Defense servers, networks and database by ensuring the IT landscape is protected by STIG (security technical implementation guide) parameters. The monitoring is made easy by associating the STIG to the database target and automatically evaluating the compliance each target fulfils. The results are shown in a graphical format highlighting the targets failed to meet the criteria, which can be further drilled down to see what standard is non-compliant.
The corrective action feature of the Oracle Enterprise Manager 13c allows automating an action based on a metric alert. The IT stakeholders have a choice to either get notified of the alert right away or wait until the corrective action has failed. It’s prudent to set the warnings at a low threshold as a preemptive measure to have ample time to remediate the issue, in-case the warning becomes critical.
OEM has become an integral part in managing and monitoring task and activities in an enterprise environment. The EM environment should be managed, configured and updated regularly by well- trained IT staff to continuously provide a high level of Monitoring, Automation, and Administration capabilities.



Leave a Reply

eighteen − seventeen =