| Lesson 4 | The DBA Management Pack modules |
| Objective | Describe the modules of the DBA Management Pack. |
DBA Management Pack Modules
The DBA Management Pack supports basic database administration tasks and consists of five applications.
Each application is targeted at one specific domain, or area, of database administration. Here is a list of the applications that shows the type of tasks that can be performed with each one:
OEM application functionality
- Instance Manager: Start and stop the Oracle instance
- Storage Manager: Create tablespaces, add datafiles create redo log files, create rollback segments
- Security Manager: Create users, create roles, grant privileges to users, grant roles to users
- Schema Manager: Create tables, views, sequences, stored procedures, and synonyms
- SQLPlus Worksheet: Execute ad-hoc SQL statements using a GUI interface
If you have done a default install of Oracle Enterprise Manager, you can find these modules under
Start->Programs->Oracle - oem_home->DBA Management Pack.
Click the link below to navigate to that program group and view the icons for each module:
Navigating to DBA Management Pack icons
Navigating to DBA Management Pack Icons
- We are going to navigate through the Start menu until we find the program group containing the DBA Management Pack modules. Click Start to begin.
- With the Start menu open, click Programs to continue.
- For this simulation, we are going to assume that Oracle Enterprise Manager was installed into an Oracle Home named OraOem. Click the program group named Oracle - OraOem to continue.
- Finally, click the program group titled DBA Management Pack.
- With the DBA Management Pack group open, you can see a list of the various Enterprise Manager applications. You will get a chance to try each of these out in the next five lessons. This is the end of the simulation.
The primary database administration components of Oracle Enterprise Manager are contained in the DBA Management Pack, which is a suite of database administration tools and wizards bundled with Oracle Enterprise Manager.
This functionality can be accessed with the new DBA Studio tool or launched separately from the Oracle Enterprise Manager Console or operating system.
DBA Management Pack features can be used to perform most of your database administration tasks, and support all versions of Oracle databases. DBA Studio or individual DBA Management Pack tools can be launched by either connecting to the Oracle Management Server using Oracle Enterprise Manager's three-tier framework, or by connecting directly to a database.
DBA Management Pack includes the following functionality:
- Instance Management
- Schema Management
- Security Management
- Storage Management
- SQL*Plus Worksheet
With this functionality you can:
- Complete database administration operations quickly and conveniently using a mouse rather than manually entering SQL commands
- Concurrently perform multiple tasks in multiple Oracle Enterprise Manager windows
- Administer multiple databases simultaneously
- Perform database administration tasks from a central location for both local and remote databases running on any Oracle platform in any location worldwide
DBA Management Pack also includes wizards for assisting with such tasks as importing, exporting, loading, backing up, and recovering data.
Question: Is the "DBA Management Pack" still used with Oracle Enterprise Manager?
The DBA Management Pack for Oracle Enterprise Manager is still used by some DBAs, but it is no longer actively developed or supported by Oracle. Oracle recommends that customers migrate to the Oracle Database Management Pack for Oracle Enterprise Manager, which provides a more comprehensive and up-to-date set of features for managing Oracle databases.
The Oracle Database Management Pack includes all of the features of the DBA Management Pack, plus a number of new features and enhancements, such as:
- Support for Oracle Database 19c and later versions
- Support for Oracle Cloud Infrastructure
- Support for Oracle Real Application Testing
- Enhanced performance monitoring and diagnostics capabilities
- New features for managing Oracle Multitenant databases
If you are currently using the DBA Management Pack, it is recommended that you migrate to the Oracle Database Management Pack as soon as possible. This will ensure that you have access to the latest features and enhancements for managing Oracle databases.
To migrate from the DBA Management Pack to the Oracle Database Management Pack, you can use the Oracle Enterprise Manager Migration Assistant. The Migration Assistant will help you to migrate your existing configuration and data to the new Management Pack.
Once you have migrated to the Oracle Database Management Pack, you will be able to take advantage of all of the new features and enhancements that it has to offer. This will help you to more effectively manage your Oracle databases and ensure that they are performing at their best.
Now that you know how to find the icons, the next five lessons will show you how to start and use each of the individual modules. You will get a chance, using OEM, to look at many of the things that you created when you created the COIN database in the first course.
OEM Database - Quiz