|Oracle Enterprise Manager Getting Started with the Oracle Diagnostics Pack
Part Number A88748-02
After you have installed the Diagnostics Pack, configure the components listed in the following table:
|Components||Where to Find the Information|
Before you use Oracle Advanced Events, do the following:
Refer to "Obtaining Trace Data for Use in Trace Data Viewer" for information on what scripts to run.
The following setup tasks are required before you use Oracle Capacity Planner or Oracle Performance Manager:
The following setup tasks are required before you use Performance Manager:
The following sections describe each of these setup tasks in more detail.
Before you can use the Performance Reporting capability in Capacity Planner on pre-Oracle 9i databases, you must first run a SQL script that defines the
OEM_MONITOR role which contains all the privileges required to use the Diagnostics Pack products. Granting the OEM_MONITOR role is the best way to ensure that a user has the correct privileges to use Capacity Planner. The
OEM_MONITOR role has been granted more privileges in the 9i version that helps to provide better functionality and performance. The script also creates views and public synonyms used in Performance Reporting and Oracle Recommended collection settings.
For 9i databases, the SQL script, catsnmp.sql, is run by default as part of the 9i database creation process. For all versions of the database prior to 9i, you must manually run a SQL script to define the OEM_MONITOR role and create the necessary views.
For versions 8.1.5, 8.1.6, and 8.1.7 of the database, you must run the script
catsnmp_8i.sql. For versions 8.0.5 and 8.0.6 of the database, you must run the script catsnmp_80.sql. For version 7.3.4 of the database, you must run script
catsnmp_734.sql. The selected script must be executed by a user with SYS privileges.
The sql files are located in the Oracle home of the Oracle Enterprise Manager installation, $ORACLE_HOME/SYSMAN/ADMIN. You must run the appropriate version of the SQL script manually on all pre-9i databases in order to use Performance Reporting in Capacity Planner.
The OEM_MONITOR role must be granted to any user wishing to use the Oracle Diagnostics Pack. Performance Manager does not require any of these new views in order to run, but if you attach to a database that does not have the views, or your process does not have the required privileges, or the OEM_MONITOR role does not exist, then an informational message displays.
Performance Manager and Capacity Planner require the use of the Intelligent Agent data gathering service. For monitoring operating system data, the Oracle Intelligent Agent must be installed on the same node as the operating system you are monitoring. For monitoring other target types, such as databases, the Oracle Intelligent Agent can run on the same node as the target you are monitoring, or it can run on a different node, depending upon your configuration.
Refer to the Oracle Intelligent Agent User's Guide for information on how to configure and start the Oracle Intelligent Agent.
To collect disk statistics on Windows NT, enable them by typing:
Disk statistics are enabled the next time the system is restarted. For more information about the DISKPERF tool, refer to the Microsoft Windows NT documentation.
If you created user-defined charts using Performance Manager release 1.5.0 or earlier and want to use them with the current Performance Manager release, you must first convert them to release 1.6.0.
Performance Manager Release 1.6.0 user-defined charts are converted to the current release when you migrate your existing performance data to the Enterprise Manager Release 2.1 repository.
For more information, refer to the following sections.
To convert user-defined charts created using Performance Manager Release 1.5.0 or earlier:
my_rep in the previous command line is the service name for the Enterprise Manager repository.
Note that my_rep in the previous command line is the target name of the Enterprise Manager V2.x repository and my_db is the name of the target service under which you want the user-defined charts stored. In other words, after the previous command is run, all the user-defined charts are converted and stored under the my_db service in the Performance Manager release 1.6.0 tree view.
If any error messages are generated when you run vmm2vtm.exe, edit the vtmusr.txt file based on the error messages. For example, the error messages may state that there is a problem with a chart or that a chart does not exist. Since the vtmusr.txt file contains a list of the charts, edit the file to remove any problematic charts.
Then, run vmm2vtm.exe again.
If you created user-defined charts with Performance Manager Release 1.6.0, you can convert those charts for use with the current release of Performance Manager. User-defined charts created with Performance Manager 1.6.0 are converted when you create a new Enterprise Manager repository and migrate your existing performance data to the new repository.
For more information about creating a new Oracle Enterprise Manager repository and migrating your existing data, see the Oracle Enterprise Manager Configuration Guide.
To use Performance Manager in a Parallel Server environment, two database instances must be started, otherwise Performance Manager does not treat the server as a Parallel Server.
There are two scenarios for using Performance Manager in an Oracle Parallel Server environment, and different configuration steps are required for each scenario.
The two scenarios and their configuration steps are:
Oracle7 does not have global V$ (GV$) tables; these files install a set of PL/SQL procedures, database links, and O$ tables that are used by Performance Manager in the absence of GV$ tables.
To obtain data to view, see the chapter, "Using Oracle Trace" in the Oracle9i Database Performance Guide and Reference for information about collecting Oracle Trace Data via the command line interface.