Enterprise Manager Functionality without the Packs

    Mar 24, 2017 10:57:00 PM by Porus Homi Havewala

    A friend asked:

    “I know we can use Oracle Enterprise Manager without the packs. However, is there any document that shows in detail what database monitoring and alerting functionality is provided by Enterprise Manager (12c version) without using any packs.”

    The answer was:

    This information is in the “Enterprise Manager Licensing Information” guide.   Chapter 10, “Base Enterprise Manager Functionality” outlines the list of features that are included with the base functionality of Oracle Enterprise Manager. 

    For the database side of things, See the “Base Database Management  Features” section in this chapter. This includes things like the following (that you can do without any pack licenses in Enterprise Manager):

    • Set up and Schedule RMAN backups
    • Set up and manage Data Guard Standby databases
    • Use Data Pump to move data
    • Manage Oracle Automatic Storage Management (ASM) and Clusterware
    • Use some Advisors such as Segment Advisor and Memory Advisor
    • Manage critical errors via Support Workbench
    • Manage database objects such as tables, indexes, views, materialized views etc.
    • Manage optimizer statistics and SQL plans
    • Set up Resource Manager for the database
    • Manage database users, roles, profiles etc. 
    • Manage control files, datafiles, tablespaces, log files etc.
    • View SQL execution history, execute SQL statements
    • Use Scheduler Central to manage jobs maintained by the database as well as Enterprise Manager
    • Get My Oracle Support (MOS) Critical Patch Recommendations
    • Perform PDB operations in Database 12c with some caveats for the free stuff, as described in an earlier blog entry here.

    The link for the full set of base database features is here. Thanks for your question, and hope you have gained an understanding of what can be done as part of the base functionality.

     

    Tags: Oracle

    Porus Homi Havewala

    Written by Porus Homi Havewala

    Porus Homi Havewala is a Double Oracle Certified Master (OCM) in 11g and 10g. He was awarded the prestigious "Oracle ACE Director" title by Oracle USA in 2008. He worked as the Strategic Program Advisor at Oracle Corporation Singapore, and is a regional SME on Oracle Enterprise Manager technology, specifically concentrating on private/hybrid Database cloud capabilities on Oracle systems. Porus has worked prominently for a number of years at the largest telecommunications company Telstra in Australia, where he personally set up and managed the first production Enterprise Manager Grid Control 10g project in the world in the early 2000s, controlling thousands of Data Center targets with multiple Administrator teams around Australia. He has 26+ years of experience in the IT industry, and 18+ years of experience with Oracle Technology, including as an Oracle Developer and Oracle Senior DBA. He is the creator and manager of the Enterprise Manager blog with Oracle Press Credentials, the Clouds and Databases blog, and the "Oracle Senior DBA" group on LinkedIn.com with 61,000+ members. Porus is the author of thirteen published technical articles and three white papers on Enterprise Manager in the Oracle Technical Network (OTN), and has authored a number of Enterprise Manager Books. He started his technical writing with a book on Microsoft Foxpro as early as 1994. His recent Enterprise Manager books are as follows: Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos published by PACKT Publishing, and the latest book Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control published by Oracle Press. Dedication: I dedicate my pen and all its output to my beloved parents in heaven, they are the ones that have taught me the good values in life. Disclaimer: My writings in blog entries, articles or books express my views and opinions in my personal capacity and not that of Oracle Corporation.