10 Additional Configuration Tasks

This chapter contains the following sections:

Understanding Default and Custom Data Collections
Enabling Multi-Inventory Support for Configuration Management
Manually Configuring a Database Target for Complete Monitoring
Modifying the Default Login Timeout Value

10.1 Understanding Default and Custom Data Collections

For each target you manage, Enterprise Manager sets up a default set of metrics to collect. For example, when install the Oracle Management Agent, Enterprise Manager automatically begins gathering a default set of metrics that you can use to monitor the performance and availability of the host computer. Similarly, when you add or configure a database target, you can select from three collection options. You can select Minimum, Recommended, or Complete. Each of these options enables a different set of performance metrics and default thresholds for those metrics.

See Also:

"About Thresholds" in the Enterprise Manager online help

10.1.1 How Enterprise Manager Stores Default Collection Information

Enterprise Manager stores the default collection criteria for each target in the following location on each Oracle Management Agent host:

AGENT_HOME/sysman/admin/default_collection/

For some targets, you can use the Oracle Enterprise Manager 10g Grid Control to modify the default metric collection settings. For example, you can change the level of monitoring for your database targets or modify the default thresholds for your host targets. When you make these types of modifications, Enterprise Manager creates a new default collection file in the following directory:

AGENT_HOME/sysman/emd/collection/

This collection file overrides the default collection information stored in the sysman/admin/default_collection directory.

10.1.2 Restoring Default Collection Settings

If you have made modifications to the metric thresholds for a particular target, you can restore the default metric collection settings by deleting the customized collection information in the sysman/emd/collection directory.

For example, if you want to restore the default collections for a particular database target, remove the customized collection file for that target from the sysman/emd/collection directory. Enterprise Manager will begin using the metric collection information stored in the sysman/admin/default_collection directory.

10.2 Enabling Multi-Inventory Support for Configuration Management

Every time you install an Oracle software product on a host computer, Oracle Universal Installer saves information about the software installation on your hard disk. The directories and files that contain this software configuration information are referred to as the Oracle Universal Installer inventory.

See Also:

Oracle Universal Installer Concepts Guide

When you use Enterprise Manager to monitor your Oracle software installations, Enterprise Manager takes advantage of information saved in the Universal Installer inventory.

As it gathers information about the configuration of your host computer, by default, Enterprise Manager assumes that you have one Oracle Universal Installer inventory on the host. Specifically, Enterprise Manager recognizes the inventory that Oracle Universal Installer uses when you run the Universal Installer on the host.

However, in some cases, you may have more than one inventory. For example, you may have worked with Oracle Support to clone your Oracle software installations. For those cases, you can use the following procedure to be sure that Enterprise Manager can track and manage the software information in multiple inventories on the same host.

Caution:

Enabling support for multiple inventories is optional and available only for advanced users who are familiar with the Oracle Universal Installer inventory architecture and who have previously worked with multiple inventories on a managed host. This procedure is not required for hosts where normal installations have been performed.

To set up Enterprise Manager so it can read multiple inventories on a host:

Locate the OUIinventories.add file in the following directory:
```
AGENT_HOME/sysman/config/
```
Open OUIinventories.add using a text editor.

Instructions within the file describe the format to use when identifying multiple inventories, as well other techniques for mapping Oracle Homes.
Carefully review the instructions within the file.
Add entries to the file for each additional inventory on the managed host.
Save your changes and close the file.

During its next collection of host configuration information, Enterprise Manager will start gathering software configuration information from the inventories that you identified in the OUIinventories.add file, in addition to the default inventory that Enterprise Manager normally collects.

Alternatively, to see the data gathered from the additional inventories before the next regularly-scheduled collection, navigate to the Host home page in the Grid Control, click the Configuration tab, and click the Refresh Data icon next to the page timestamp.

Note:

If there any irrecoverable problems during the collection of the default inventory (for example, if the inventory file or directory protections prevent Enterprise Manager from reading the inventory), inventories listed in OUIinventories.add file are also not collected.

If the Enterprise Manager is able to read the default inventory, but there is a problem reading an additional inventory listed in the OUIinventories.add file, Enterprise Manager issues a collection warning for those inventories, but Enterprise Manager does collect the configuration information for the other inventories.

10.3 Manually Configuring a Database Target for Complete Monitoring

When you monitor Oracle Database 10g database, no additional configuration is necessary the Grid Control requires no additional configuration required after you discover the database target.

However, when you monitor an Oracle9i database or an Oracle8i database, there is some additional configuration required if you want to monitor certain types of database performance metrics. using the Grid Control.

To monitor these additional performance metrics Enterprise Manager requires that Oracle Statspack and some additional Enterprise Manager packages be installed and configured in the database you are monitoring.

See Also:

"Using Statspack" in Oracle Database Performance Tuning Guide in the Oracle9i Documentation Library

If these additional objects are not available and configured in the database, Enterprise Manager will not be able to gather the data for the complete set of performance metrics. In addition, Enterprise Manager will not be able to gather information that otherwise could be readily available from the Database home page, such as Bad SQL and the Top SQL Report.

You can use the Configure Database wizard in the Grid Control to install the required packages into the database, or you can use the following manual procedure.

See Also:

"Modifying Target Properties" in the Enterprise Manager online help for information on configuring managed targets, including database targets.

To manually install Statspack and the other required database objects into an Oracle9i database that you are managing with Enterprise Manager, you can use SQL*Plus and the following procedure:

Log in to the database host using an account with privileges that allow you to write to the database home directory and to the Management Agent home directory.

For each of the commands in this procedure, replace AGENT_HOME with the actual path to the Oracle Management Agent home directory and replace ORACLE_HOME with the path to database home directory.
Start SQL*Plus and connect to the database using the SYS account with SYSDBA privileges.

For example:
```
$PROMPT> ./sqlplus "connect / as sysdba"
```
Enter the following command to run the Database dbmon script:
```
SQL> @AGENT_HOME/sysman/admin/scripts/db/config/dbmon
```
The script will display the following prompt:
```
Enter value for dbm_password:
```
When prompted, enter the password for the DBSNMP account.

The script performs several configuration changes and returns you to the SQL*Plus prompt.
Connect as the DBSNMP user.

For example:
```
SQL> connect DBSNMP
```

Enter the following command:

SQL> @AGENT_HOME/sysman/admin/scripts/db/config/response.plb
SQL> grant EXECUTE on dbsnmp.mgmt_response to OEM_MONITOR;

Connect as SYS enter the following command to create the PERFSTAT user:

SQL> @ORACLE_HOME/rdbms/admin/spcreate

Note:

The spcreate script will prompt you for a default tablespace and default temporary tablespace for the PERFSTAT user. Do not specify the SYSTEM tablespace as the default tablespace for the PERFSTAT user. For more information, see "Using Statspack" in the Oracle Database Performance Tuning Guide.

Connect as the PERFSTAT user.

For example:
```
SQL> connect PERFSTAT;
```

Enter the following commands from the PERFSTAT user account:

SQL> define snap_level='6';
SQL> define cinterval='1';
SQL> define cjobno='-1';
SQL> @AGENT_HOME/sysman/admin/scripts/db/config/spset

Connect as the SYS user and enter the following command:
```
SQL> grant OEM_MONITOR to dbsnmp;
```

If the database you are modifying is an Oracle8i database, also enter the following commands as the SYS user:

grant select on sys.ts$ to OEM_MONITOR;grant select on sys.seg$ to OEM_MONITOR;grant select on sys.user$ to OEM_MONITOR;grant select on sys.obj$ to OEM_MONITOR;grant select on sys.sys_objects to OEM_MONITOR;grant select on sys.file$ to OEM_MONITOR;grant select on sys.attrcol$ to OEM_MONITOR;grant select on sys.clu$ to OEM_MONITOR;grant select on sys.col$ to OEM_MONITOR;grant select on sys.ind$ to OEM_MONITOR;grant select on sys.indpart$ to OEM_MONITOR;grant select on sys.indsubpart$ to OEM_MONITOR;grant select on sys.lob$ to OEM_MONITOR;grant select on sys.lobfrag$ to OEM_MONITOR;grant select on sys.partobj$ to OEM_MONITOR;grant select on sys.tab$ to OEM_MONITOR;grant select on sys.tabpart$ to OEM_MONITOR;grant select on sys.tabsubpart$ to OEM_MONITOR;grant select on sys.undo$ to OEM_MONITOR;

For any supported database version, enter the following command from the SYS account:
```
SQL> show parameter job_queue_processes
```
If the output from the show parameter command is zero, then perform the following steps to modify the job_queue_processes initialization parameter:

If you start the database using an spfile, enter the following command:
```
SQL> alter system set job_queue_processes = 2 SCOPE=BOTH;
```
Otherwise, do the following:
1. Enter the following command:
```
SQL> alter system set job_queue_processes = 2;
```
2. Exit SQL*PLUS and update theinit.ora database configuration file with the following entry so the parameter will be applied whenever the database is restarted:
```
job_queue_processes=2
```
Exit SQL*Plus and change directory to the following directory in the home directory of the Management Agent that is monitoring the database:
```
AGENT_HOME/bin
```
Reload the agent by entering the following command:
```
$PROMPT> ./emctl agent reload
```
Using Grid Control, return to the Database home page and verify that the Bad SQL and Top SQL Report metrics are now being gathered.

10.4 Modifying the Default Login Timeout Value

To prevent unauthorized access to the Grid Control, Enterprise Manager will automatically log you out of the Grid Control when there is no activity for a predefined period of time. For example, if you leave your browser open and leave your office, this default behavior prevents unauthorized users from using your Enterprise Manager administrator account.

By default, if the system is inactive for 45 minutes or more, and then you attempt to perform an Enterprise Manager action, you will be asked to log in to the Grid Control again.

To increase or decrease the default timeout period:

Change directory to the following location in the Oracle Application Server home directory where the Management Service was deployed:
```
IAS_HOME/sysman/config/
```
Using your favorite text editor, open the emoms.properties file and add the following entry:
```
oracle.sysman.eml.maxInactiveTime=time_in_minutes
```
For example, if you want to change the default timeout period to one hour, add the following entry:
```
oracle.sysman.eml.maxInactiveTime=60
```
Save and close the emoms.properties file.

Restart the Management Service.

Note:

The default timeout value does not apply when you restart the Web server or the Oracle Management Service. In both of those cases, you will be asked to log in to the Grid Control, regardless of the default timeout value.