10 Additional Configuration Tasks

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.

AGENT_HOME/sysman/admin/default_collection/

AGENT_HOME/sysman/emd/collection/

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.

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.

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

1. Locate the OUIinventories.add file in the following directory:

   AGENT_HOME/sysman/config/
   
   

2. 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.

3. Carefully review the instructions within the file.

4. Add entries to the file for each additional inventory on the managed host.

5. 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.

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.

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.

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:

1. 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.

2. Start SQL*Plus and connect to the database using the SYS account with SYSDBA privileges.

   For example:

   $PROMPT> ./sqlplus "connect / as sysdba"
   
   

3. 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:
   
   

4. When prompted, enter the password for the DBSNMP account.

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

5. Connect as the DBSNMP user.

   For example:

   SQL> connect DBSNMP
   
   

6. Enter the following command:

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

7. 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.

   
   

8. Connect as the PERFSTAT user.

   For example:

   SQL> connect PERFSTAT;
   
   

9. 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
   
   

10. Connect as the SYS user and enter the following command:

    SQL> grant OEM_MONITOR to dbsnmp;
    
    

11. 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;
    
    

12. 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
       
       

13. 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
    
    

14. Reload the agent by entering the following command:

    $PROMPT> ./emctl agent reload
    
    

15. 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:

1. Change directory to the following location in the Oracle Application Server home directory where the Management Service was deployed:

   IAS_HOME/sysman/config/
   
   

2. Using your favorite text editor, open the emoms.properties file and add the following entry:

   oracle.sysman.eml.maxInactiveTime=time_in_minutes
   
   

3. For example, if you want to change the default timeout period to one hour, add the following entry:

   oracle.sysman.eml.maxInactiveTime=60
   
   

4. Save and close the emoms.properties file.

5. 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.