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.