|Oracle® Enterprise Manager Advanced Configuration
10g Release 1 (10.1)
Part Number B12013-01
This chapter contains the following sections:
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
Enterprise Manager stores the default collection criteria for each target in the following location on each Oracle Management Agent host:
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:
This collection file overrides the default collection information stored in the
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
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
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.
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:
OUIinventories.add file in the following directory:
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
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.
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.
$PROMPT> ./sqlplus "connect / as sysdba"
Enter the following command to run the Database dbmon script:
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.
SQL> connect DBSNMP
Enter the following command:
Connect as SYS enter the following command to create the PERFSTAT user:
Connect as the PERFSTAT user.
SQL> connect PERFSTAT;
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:
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:
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:
Enter the following command:
SQL> alter system set job_queue_processes = 2;
Exit SQL*PLUS and update the
init.ora database configuration file with the following entry so the parameter will be applied whenever the database is restarted:
Exit SQL*Plus and change directory to the following directory in the home directory of the Management Agent that is monitoring the database:
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.
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:
For example, if you want to change the default timeout period to one hour, add the following entry:
Save and close the
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.