2
Post-Installation Configuration

After you have installed the Standard Management Pack, configure the components listed in the following table:

Components	Where to Find the Information
Performance Manager	"Setting Up Performance Manager"
TopSessions	"Setting Up TopSessions"

Setting Up Performance Manager

The following setup tasks are required before you use Oracle Performance Manager:

Configure the Oracle Data Gatherer to collect data

Enable disk statistics collection on Windows NT

Convert any user-defined charts you created with earlier versions of Performance Manager

The following sections describe each of these setup tasks in more detail.

Configuring Oracle Data Gatherer to Collect Data

Performance Manager requires the use of the data gathering service (also known as the Oracle Data Gatherer). For monitoring operating system data, the Oracle Data Gatherer must be installed on the same node as the operating system you are monitoring. For monitoring other service types, such as databases, the Oracle Data Gatherer can run on the same node as the service 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 Data Gatherer.

Enabling Disk Statistics Collection for Performance Manager on Windows NT

To collect disk statistics on Windows NT, enable them by typing:

diskperf  -Y 

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.

Note: Enabling disk statistics is not required. You can still monitor other operating system statistics with Performance Manager even if disk statistics are not enabled.

Converting User-Defined Charts From Previous Releases of Performance Manager

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.

Note: Release 1.5.5 of Performance Manager did not include the functionality of user-defined charts.:

Converting Performance Manager Release 1.5.0 User-Defined Charts

To convert user-defined charts created using Performance Manager Release 1.5.0 or earlier:

1. Run vmmmig.exe. This executable creates a text file named vtmusr.txt in the $ORACLE_HOME\SYSMAN\ADMIN directory. This text file contains data about the user-defined charts created using Performance Manager release 1.5.0 or earlier. When you run vmmmig.exe, specify the user name, password, and service for the Enterprise Manager repository that contains the user-defined charts that you want to convert, for example:

   vmmmig joseph/password@my_rep
   
   

   Note that my_rep in the previous command line is the service name for the Enterprise Manager repository.

2. Run vmm2vtm.exe. This executable uses the data in the vtmusr.txt file to create user-defined charts in the repository that can be used with Performance Manager release 1.6.0. When you run vmm2vtm.exe, supply a user name, password, and service for the Enterprise Manager V2.x repository and the name of the service under which you want the user-defined charts stored for Performance Manager release 1.6.0, for example:

   vmm2vtm.exe joseph/password@my_rep my_db
   
   

   Note that my_rep in the previous command line is the service 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.

Converting Performance Manager Release 1.6.0 User-Defined Charts

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.

Setting Up TopSessions

To install the features of TopSessions:

Create additional tables and views on each database you want to connect to from TopSessions

Grant certain SELECT privileges

The smptsixx.sql scripts have been provided to help automate this process. The xx in the file name identifies the version of the database against which the script should be run. The script for each database version is located in the $ORACLE_HOME\SYSMAN\ADMIN directory.

Version of the Database	Script to Run
Oracle 7.3.4	smptsi73.sql script
Oracle 8.0	smptsi80.sql script
Oracle 8.1	smptsi81.sql script

When smptsixx.sql is run, it also automatically runs the following two scripts:

• catbloxx.sql

• utlxplxx.sql

These two scripts create in the managed database some additional tables, views, and public synonyms that are required by the Oracle Advanced Events.

To set up TopSessions for a database:

1. Access SQL*Plus Worksheet from the Start menu by following the path: Start=>Programs=>ORACLE_HOME=>DBA Management Pack=>SQLPlus Worksheet.

   Note: ORACLE_HOME represents the Oracle home in which the Diagnostics Pack is installed.

2. Use the Oracle Enterprise Manager Login dialog box to connect to the managed database as SYS.

   For additional information, refer to the online help or the Oracle Enterprise Manager Administrator's Guide.

3. Grant SELECT ANY TABLE privileges to each administrator account. This step may be omitted if the account has already been granted the same privileges as SYSTEM.

   Note that when preparing to run the smptsixx.sql script on managed databases, you should log into each database as SYS, as mentioned previously.

   You can use Security Manager to grant privileges to an account. Refer to the Oracle Enterprise Manager Online Help for detailed information about how to use Security Manager.

4. Run the smptsixx.sql script for the managed database.

   If the smptsixx.sql script is not run on a managed database, you may see a "Table or View does not exist" message when you try to use TopSessions.

5. If the ALL_CATALOG view does not exist on the managed database, run the catalog.sql script on the database from the SYS account. The catalog.sql script is located in the $ORACLE_HOME\RDBMSxx\ADMIN directory.

6. If the AUDIT_ACTIONS view does not exist on the managed database, run the cataudit.sql script on the database from the SYS account. The cataudit.sql script is located in the $ORACLE_HOME\RDBMSxx\ADMIN directory.

7. Exit SQL*Plus Worksheet.

---