Oracle® Enterprise Manager Configuration for Oracle Collaboration Suite 10g Release 1 (10.1.0.4) Part Number B13601-02 |
|
|
View PDF |
This chapter describes how to set up Grid Control to monitor Oracle Email components for Oracle Collaboration Suite Release 1 and Release 2.
Note:
See Chapter 2, "Configuring Mail" for information on configuring Grid Control to manage Oracle Mail components for Oracle Collaboration Suite 10g Release 1.An Oracle Email installation may be spread over dozens of machines. Enterprise Manager makes it easier to manage Oracle Email and provides a convenient grouping and dashboard summarization of Oracle Email status and performance.
The following instructions assume that Oracle Email is already installed and that the Oracle Enterprise Manager 10g Grid Control and Oracle Management Agent are already installed. Furthermore, the following instructions assume that you have detailed knowledge of how Oracle Email is configured and where the different protocol servers are running.
In this section you will create targets that represent components of your Email deployment. In addition, an Oracle Email group target will be created. The group target will include all the component Email targets.
This chapter contains the following sections:
Before you begin creating the Oracle Email targets, use the following sections to understand the types of targets you must create and some guidelines for creating those targets:
Oracle Email has several protocols and there are distinct services and servers for each type of protocol:
IMAP
SMTP Inbound
SMTP Outbound
POP
Webmail
An Oracle Email server refers to a specific process running on a specific host. As a result, the up or down metric for a server indicates whether or not the process is running. An Oracle Email service refers to the service provided by a collection of processes. For a service, the up or down metric indicates whether or not a user can make use of that service.
These Oracle Email services and servers are often spread over hosts and databases. You create the targets as follows:
One service target for each logical service
One server target for each instance of a server running on a host
One mail store target for each repository
As a result, Enterprise Manager provides the following target types to help you manage your Email installations:
Based on the target types described above, it is critical to have knowledge of the details of your Email configuration before attempting to setup the email targets and group target. Here is a checklist of information that must be gathered before the following setup is done:
Location of all mail stores
Names for email services
Test users for each email service
Location of each protocol server
Locations where beacons for Webmail must be established
LDAP info for the OID Client target setup
Oracle Email monitoring is enabled by default when you first install and configure Oracle Collaboration Suite. When Email monitoring is enabled, monitoring data is collected in the es_perf
schema.
See also "Mail Statistics Schema" in the chapter "Charting and Monitoring" of Oracle Email Administrator's Guide for Oracle Collaboration Suite Release 2 at:
http://www.oracle.com/technology/documentation/collab.html
Email monitoring must be enabled before you add or configure the Oracle Email targets. You can confirm that Oracle Email monitoring is enabled, or you can disable Oracle Email monitoring by setting the Statistics Collection Interval. When the interval is set to zero (0), monitoring is disabled.
You can set the Statistics Collection Interval once for all service targets, or you can set a different interval for each Oracle Email service type.
The following sections describe two ways to set the Statistics Collection Interval:
Using Enterprise Manager Web Site to Set the Statistics Collection Interval
Using Oracle Internet Directory Commands to Set the Statistics Collection Interval
To use Enterprise Manager Web site to set the Statistics Collection Interval for all service types:
Log in to the Enterprise Manager Web site for the Oracle Collaboration Suite installation.
The URL for the Enterprise Manager Web site is in following format:
http://<ocs_midtier_hostname>.<domain>:<port>
The port for the Enterprise Manager Web site is usually set to 1810. For example, if you have installed the Oracle Collaboration Suite middle-tier software on a host called emailhost1
in the acme.com
domain, the URL would be:
http://emailhost1.acme.com:1810
If necessary, navigate to the Application Server home page for the Oracle Collaboration Suite middle tier.
In the System Components table, click Unified Messaging.
Enterprise Manager displays the Unified Messaging home page.
Click Statistics Collection.
Enterprise Manager displays the Statistics Collection page. If the value in the Statistics Collection Interval (seconds) field is any number other than zero, Oracle Email monitoring is enabled for this middle-tier instance.
If you use Oracle Internet Directory commands to set the Statistics Collection Interval, you can set the interval individually for each Oracle Email service type. The commands for controlling the interval, as well as recommended values for the collection intervals for each component are available in the Oracle Email documentation.
See also the "Charting and Monitoring" chapter of the Oracle Email Administrator's Guide for Oracle Collaboration Suite Release 2 at:
By default, each Oracle Collaboration Suite middle-tier installation saves its monitoring data in its own mail store database. However, if you are managing mulitple Oracle Collaboration Suite installations, you may want to save all your Oracle Email monitoring data in a common database so all the monitoring statistics will be available from one location. Consolidating the data in one location will reduce the amount of work required to maintain, purge, and analyze the data.
To configure each Oracle Collaboration Suite middle-tier component to point to the same location for its monitoring data, use the Oracle Internet Directory commands to modify the orclMailAdminStoreDN
parameter of the mailProcessConfig
object in the directory.
As a result, each middle-tier instance should point to a common information store under the following directory hierarchy:
'cn=MailStores,cn=um_system,cn=EmailServerContainer,cn=Products,cn=OracleContext'
See also "Mail Statistics Schema" in the "Charting and Monitoring" chapter of Oracle Email Administrator's Guide for Oracle Collaboration Suite Release 2 at:
Before you begin creating the Oracle Email targets, you should have a complete list of the hosts and the databases where your Oracle Email components reside. For example, you should know the system identifier (SID) and password for each database.
The following sections describe how you can obtain this information using the Oracle Internet Directory for your Oracle Collaboration Suite installations:
You can identify the Oracle Email hosts by using the following ldapsearch
command for your Oracle Internet Directory:
$PROMPT> ldapsearch -h<oid_host> -p<oid_port> -Dcn=orcladmin -wwelcome1 -b 'cn=Computers,cn=OracleContext' 'objectclass=orclMailProcessConf' orclmailinstanceid
For example:
$PROMPT> ldapsearch -has15.acme.com -p4032 -Dcn=orcladmin -wx9djiks189 -b 'cn=Computers,cn=OracleContext' 'objectclass=orclMailProcessConf' orclmailinstanceid
Example 12-1 provides an example of the output you should expect from the ldapsearch
command when you are searching for Oracle Email hosts.
Note that each result that includes an orclmailinstanceid
value other than zero identifies an instance of a valid Oracle Email component.
Example 12-1 Sample Search for Oracle Email Hosts
$PROMPT> ldapsearch -has15.acme.com -p4032 -Dcn=orcladmin -wwelcome1 -b 'cn=Computers,cn=OracleContext' 'objectclass=orclMailProcessConf' orclmailinstanceid cn=mailProcessConfig,cn=EMailServer,cn=v2mid,cn=as16.acme.com,cn=Computers,cn=OracleContext cn=as16.acme.com:UM_SYSTEM:smtp_in,cn=mailProcessConfig,cn=eMailServer,cn=v2mid,cn=as16.acme.com,cn=Computers,cn=OracleContext orclmailinstanceid=0 cn=as16.acme.com:UM_SYSTEM:smtp_out,cn=mailProcessConfig,cn=eMailServer,cn=v2mid,cn=as16.acme.com,cn=Computers,cn=OracleContext orclmailinstanceid=0 . . . cn=as16.acme.com:um_system:imap:107341703136712833,cn=as16.acme.com:UM_SYSTEM:imap,cn=mailProcessConfig,cn=eMailServer,cn=v2mid,cn=as16.acme.com,cn=Computers,cn=OracleContext orclmailinstanceid=107341703136712833 cn=as16.acme.com:um_system:smtp_in:107341704879993654,cn=as16.acme.com:UM_SYSTEM:smtp_in,cn=mailProcessConfig,cn=eMailServer,cn=v2mid,cn=as16.acme.com,cn=Computers,cn=OracleContext orclmailinstanceid=107341704879993654 cn=as16.acme.com:um_system:smtp_out:107341706569741957,cn=as16.acme.com:UM_SYSTEM:smtp_out,cn=mailProcessConfig,cn=eMailServer,cn=v2mid,cn=as16.acme.com,cn=Computers,cn=OracleContext orclmailinstanceid=107341706569741957 cn=as16.acme.com:um_system:gc:107341708222696477,cn=as16.acme.com:UM_SYSTEM:gc,cn=mailProcessConfig,cn=eMailServer,cn=v2mid,cn=as16.acme.com,cn=Computers,cn=OracleContext orclmailinstanceid=107341708222696477 . . . $PROMPT>
To identify the hosts and the names of the databases where your mail stores are located, you can use the following ldapsearch
command for your Oracle Internet Directory:
$PROMPT> ldapsearch -h<oid_host> -p<oid_port> -Dcn=orcladmin -w<orcladmin_pwd> -b 'cn=EMailServerContainer,cn=Products,cn=OracleContext' 'objectclass=orclMailStores'
For example:
$PROMPT> ldapsearch -hmgthost42.acme.com -p3060 -Dcn=orcladmin -wx9djiksl89 -b 'cn=EMailServerContainer,cn=Products,cn=OracleContext' 'objectclass=orclMailStores'
Example 12-2 provides an example of the output you should expect when you are searching for Oracle Email mail stores in Oracle Internet Directory. In this example, only one mail store is found in Oracle Internet Directory. The SID of the mail store database is v2store
.
Example 12-2 Sample Search for Mail Store Hosts and Databases
$PROMPT> ldapsearch -has15.acme.com -p4032 -Dcn=orcladmin -wwelcome1 -b 'cn=EMailServerContainer,cn=Products,cn=OracleContext' 'objectclass=orclMailStores' cn=v2store.acme.com,cn=mailstores,cn=UM_SYSTEM,cn=EMailServerContainer,cn=Products,cn=OracleContext cn=v2store.acme.com objectclass=orclMailStores objectclass=top orcldbdistinguishedname=cn=v2store,cn=OracleContext orclmailstoreport=1521 orclmailstoresid=v2store orclmailstoreusername=es_mail orclpasswordattribute=welcome1 x121address=db04.acme.com $PROMPT>
To find the connection string for a mail store, so you can connect to the mail store or provide the host, port, SID, username, or password properties for the mail store:
Obtain the value of the orclDBDistinguishedName
attribute for the mail store.
You can obtain this value by searching for the mail store host and database properties, as described in "Identifying the Oracle Email Mail Stores".
For example, in Example 12-2, the value of the orclDBDistinguishedName
is:
cn=v2store,cn=OracleContext
Use the ldapsearch
command to find the orclnetdescrstring
attribute of the mail store:
$PROMPT> ldapsearch -h<oid_host> -p<oid_port> -Dcn=orcladmin -w<orcladmin_pwd> -b '<value_of_orclDBDistinguishedName>' -s base 'objectclass=*'
For example:
$PROMPT> ldapsearch -hmgthost42.acme.com -p3060 -Dcn=orcladmin -wx9djiksl89 -b 'cn=v2store,cn=OracleContext' -s base 'objectclass=*'
Example 12-3 provides an example of the output you should expect when you search for the connection string in Oracle Internet Directory. The bolded item in the sample output represents the connection string for the mail store.
Example 12-3 Sample Output When Searching for the Mail Store Connection String
$PROMPT> ldapsearch -has15.acme.com -p4032 -Dcn=orcladmi n -wwelcome1 -b 'cn=v2store,cn=OracleContext' -s base 'objectclass=*' cn=v2store,cn=OracleContext cn=v2store objectclass=top objectclass=orclService objectclass=orclDBServer objectclass=orclDBServer_92 objectclass=orclapplicationentity orclaci=access to entry by group="cn=OracleDBAdmins,cn=v2store,cn=OracleContext"(browse, add, delete) orclaci=access to attr=(*) by group="cn=OracleDBAdmins,cn=v2store,cn=OracleContext" (compare, search, read, selfwrite, write) orcldbglobalname=v2store.acme.com orclentrylevelaci=access to entry by group="cn=OracleNetAdmins,cn=OracleContext" (add) orclnetdescname=000:cn=DESCRIPTION_0 orclnetdescstring=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=db04.acme.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=v2store.acme.com))) orcloraclehome=/private/oracle/ocsv2recut/v2store orclservicetype=DB orclsid=v2store orclsystemname=db04.us.oracle orclversion=92000 $PROMPT>
This section contains the following topics:
To monitor your Oracle Email server targets, you must create one server target for each host where a protocol server runs. For example, create one SMTP IN Server target for each host where the SMTP IN Server runs.
Enterprise Manager provides the following Oracle Email server target types:
SMTP_IN
SMTP_OUT
IMAP
POP
You should configure one target for each server instance.
To create the Email server targets:
Using the Grid Control Console, navigate to the home page for the Oracle Management Agent that was installed on the Email server host.
In the Monitored Targets section of the page, select one of the Email server target types from the Add drop-down menu.
The available Email server target types include:
Enterprise Manager displays the property page for the selected server target type. Provide the required information, described in Table 12-1, Table 12-2, and Table 12-4.
Click OK to create the target.
See Also:
"Adding Targets to be Monitored and Administered by Enterprise Manager" in the Enterprise Manager online helpTable 12-1 provides a summary of the properties you must provide when creating an IMAP Server target.
Table 12-1 IMAP Server Target Properties
Property | Description |
---|---|
The hostname of the machine where the IMAP server is running. |
|
The port where the IMAP server is running. You can obtain this value by reviewing the contents of the following network administration configuration file: OCS_HOME/network/admin/listener.ora For example, the listener.ora file should contain an entry similar to the following: @ (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = imaphost1.acme.com) (PORT = 143)) (PRESENTATION = IMAP)) Typically, the IMAP Port is 143. |
|
The Email ID of a test user account that will be used for the status of the IMAP server |
|
The Email account password of a test user account that will be used for the status of the IMAP server |
|
The host name of the machine that has the database with the es_perf schema and data |
|
The port of the database with the es_perf schema and data |
|
The SID of the database with the es_perf schema and data |
|
The database user name on the database with the es_perf schema and data |
|
The password of the db user on the database with the es_perf schema and data |
Table 12-2 provides a summary of the properties you must provide when creating an SMTP IN Server target.
Table 12-2 SMTP IN Server Target Properties
Property | Description |
---|---|
The host name of the machine where the SMTP IN server is running |
|
The host name of the machine that has the database with the es_perf schema and data |
|
The port of the database with the es_perf schema and data |
|
The SID of the database with the es_perf schema and data |
|
The database user name on the database with the es_perf schema and data |
|
The password of the database user on the database with the es_perf schema and data |
Table 12-3 provides a summary of the properties you must provide when creating an SMTP OUT Server target.
Table 12-3 SMTP OUT Server Target Properties
Property | Description |
---|---|
The host name of the machine where the SMTP OUT server is running. |
|
The host name of the machine that has the database with the es_perf schema and data |
|
The port of the database with the es_perf schema and data |
|
The SID of the database with the es_perf schema and data |
|
The database user name on the database with the es_perf schema and data |
|
The password of the database user on the database with the es_perf schema and data |
Table 12-4 provides a summary of the properties you must provide when creating an POP Server target.
Table 12-4 POP Server Target Properties
Property | Description |
---|---|
The hostname of the machine where the POP server is running |
|
The Email ID of a test user account that will be used for the status of the POP server |
|
The Email account password of a test user account that will be used for the status of the POP server |
|
The host name of the machine that has the database with the es_perf schema and data |
|
The port of the database with the es_perf schema and data |
|
The SID of the database with the es_perf schema and data |
|
The database user name on the database with the es_perf schema and data |
|
The password of the database user on the database with the es_perf schema and data |
This section contains the following topics:
The service targets monitor the Email services and simulate an end-user accessing the services. Thus, it is most beneficial to locate these targets close to where the user community using the services resides. It is also possible to create multiple targets for each service in order to measure responsiveness from multiple geographical locations.
One Service target must be created for each service type. For example, an SMTP IN Service is implemented over four hosts; however, only one target is needed to monitor the overall service.
Regarding the WebMail Service, the same guidelines apply. However, for WebMail, we will use Enterprise Manager's Application Service Level Management capabilities to monitor WebMail.
Enterprise Manager 10g includes the following Email service types: SMTP_IN, SMTP_OUT, IMAP, POP. To configure service monitoring you should configure targets at points in the network close to the user communities accessing Email. Thus, having an SMTP_IN service monitoring target type in a few key geographical locations is necessary to get an overall perspective on the SMTP_IN monitoring. The naming convention suggested is to use: SMTP_IN_SERVICE_<mailstore>_<Location of observation>, for example SMTP_IN_SERVICE_EMEA_LONDONFor WebMail monitoring, you need to create a Web Application target and record an availability transaction for WebMail. This transaction must be run from beacons in key geographical locations that represent user communities.
To create the Email service targets:
Using the Grid Control Console, navigate to the Agent home page for the Oracle Management Agent that was installed on the Email service host.
In the Monitored Targets section of the page, select one of the Email service target types from the Add drop-down menu.
The available Email service target types include:
Enterprise Manager displays the property page for the selected server target type. Provide the required information, as described in Table 12-5, Table 12-6, and Table 12-8.
Click OK to create the target.
See Also:
"Adding Targets to be Monitored and Administered by Enterprise Manager" in the Enterprise Manager online helpTable 12-5 provides a summary of the properties you must provide when creating an IMAP Service target.
Table 12-5 IMAP Service Target Properties
Property | Description |
---|---|
The hostname or the IP address of the Big-IP or the machine used for accessing the IMAP service |
|
The port where the IMAP service is running |
|
The Email ID of a test user account that will be used for the status and the service availability of the IMAP service |
|
The Email account password of a test user account that will be used for the status and the service availability of the IMAP service |
Table 12-6 provides a summary of the properties you must provide when creating an SMTP IN Service target.
Table 12-6 SMTP IN Service Target Properties
Property | Description |
---|---|
The hostname or the IP address of the Big-IP or the machine used for accessing the SMTP IN service |
|
The email address of a test account used for sending an email and that will be used for the status and the service availability of the SMTP IN service |
|
The email address of a test account used for receiving an email and that will be used for the status and the service availability of the SMTP IN service |
Table 12-7 provides a summary of the properties you must provide when creating an SMTP OUT Service target.
Table 12-8 provides a summary of the properties you must provide when creating an POP Service target.
Table 12-8 POP Service Target Properties
Property | Description |
---|---|
The hostname or the IP address of the Big-IP or the machine used for accessing the POP service |
|
The email address of a test user account used for connecting to a POP service and that will be used for the status and the service availability of the POP service |
|
The password of a test user account used for connecting to a POP service and that will be used for the status and the service availability of the POP service |
To monitor your WebMail instances, you create a Web Application target for each WebMail instance. Web Application targets can be monitored for availability and performance with Application Service Level Management transactions. You can also measure the response time of pages in your Web Applications using End-User Page Performance Monitoring.
See Also:
"About Application Performance Management" in the Enterprise Manager online helpTo create a Web Application target for your WebMail instance:
Using the Grid Control Console, navigate to the Agent home page for the Oracle Management Agent that was installed on the WebMail host.
In the Monitored Targets section of the page, select Web Application from the Add drop-down menu.
Enterprise Manager displays the Create Web Application wizard, which guides you through the process of creating the Web Application.
When the wizard asks you for the Homepage URL, enter the URL for the WebMail instance. For example:
http://host1.us.oracle.com:7778/um/traffic_cop
Click Help if you need help using the Wizard.
Click OK to create the target.
Use the instructions in the online help to create some representative transactions to measure the availability and performance of the Web Application you just created.
For example, create a transaction that logs in and reads an email message.
See Also:
"Creating Transactions" in the Enterprise Manager online helpEnable End-User Page Performance Monitoring for the Web Application using the procedures for earlier versions of the Oracle Application Server described in "Configuring End-User Response Time Monitoring Using Earlier Versions of Oracle Application Server Web Cache" in Oracle Enterprise Manager Advanced Configuration.
Note:
Before you enable End-User Page Performance Monitoring to monitor your Oracle Collaboration Suite Web Application target, you must apply patch number 3040716 to the Oracle Application Server middle-tier instance. You can download this patch from OracleMetaLink:http://metalink.oracle.com/
One mail store target must be created for each mail store created for Email. It is also possible to locate these targets on any host on the network capable of accessing the mail store database. The benefit of this approach is that the target deployment becomes non-intrusive to the Oracle Email mail stores.
Enterprise Manager 10g includes one Oracle Email mail store target type. You must add and configure a mail store target for each mail store in the network. These targets must be configured on each mail store that you want to monitor.
To create an Oracle Email mail store target:
Using the Grid Control Console, navigate to the Agent home page for the Oracle Management Agent that was installed on the mail store host.
In the Monitored Targets section of the page, select Mailstore from the Add drop-down menu.
Enterprise Manager displays the property page for the mail store target type. Provide the required information, as described in Table 12-9.
Click OK to create the target.
See Also:
"Adding Targets to be Monitored and Administered by Enterprise Manager" in the Enterprise Manager online helpTable 12-9 Mail Store Target Properties
Property | Description |
---|---|
The host name of the machine that has the database with the ES_MAIL schema and data |
|
The port of the database with the ES_MAIL schema and data |
|
The SID of the database with the ES_MAIL schema and data |
|
The db user name on the database with the ES_MAIL schema and data |
|
The password of the db user on the database with the ES_MAIL schema and data |
OID Client targets are useful to measure responsiveness of the OID (Oracle Internet Directory) for Email. Thus, one such target must be created on each host where an Email server runs. The collection of such targets will give a view of OID responsiveness across all Email hosts.
To create the OID Client target:
Using the Grid Control Console, navigate to the Agent home page for the Oracle Management Agent that was installed on the OID Client host.
In the Monitored Targets section of the page, select OID Client from the Add drop-down menu.
Enterprise Manager displays the property page for the OID Client target type. Provide the required information, as described in Table 12-10.
Click OK to create the target.
See Also:
"Adding Targets to be Monitored and Administered by Enterprise Manager" in the Enterprise Manager online helpTable 12-10 OID Client Target Properties
Property | Description |
---|---|
The path of the Oracle home of the LDAP client machine. This will be used to invoke the For example, the <LDAP Client Oracle home path>/bin/ |
|
The host name of the machine where the LDAP server is running. |
|
The port where the LDAP server is running. |
|
The user name of a test user account that is needed for the "cn=emd admin,cn=oracle internet directory" |
|
The password of the test user account that is needed for the |
After all the Email targets are configured, you can create the Email group target, which provides a custom user interface for managing your Oracle Collaboration Suite environment.
The Oracle Collaboration Suite Email group home page contains the alerts table, followed by a table of rows of component targets and columns of key metrics. There is also a Performance tab where key metrics are charted for the email group. The IMAP Operations tab contains a summary of all IMAP operations in bar chart style.
To create the Email group target:
Click the Targets tab in the Grid Control.
Click All Targets.
Select Collaboration Suite Component from the Add drop-down menu and click Go.
Enterprise Manager displays the Create Collaboration Suite Component page.
Enter a name for the Email group in the Name field.
For example, enter Email Group
.
Select E-Mail from the Component Type drop-down menu.
Select the targets that you want to add to the group from the Available Targets list and add them to the Selected Targets list.
Be sure to add the following target types to the Email group:
The host targets where the Email servers reside
The database and listener targets that support the email servers
An IMAP Service and IMAP Server
An SMTP IN Service and SMTP In Server
An SMTP OUT Service and SMTP Out Server
A POP Service and POP Server
An Email mail store
An OID Client
The OracleAS Containers for J2EE (OC4J) and Oracle HTTP Server instances on the Email host
Click OK to create the group target.
Add this group to the Oracle Collaboration Suite group you created in Section 10.3.4.
In Grid Control, listeners for IMAP and POP servers have a status of Down after they are discovered.
The next two sections show how to change the Mail listener's status to Up on UNIX and Windows operating systems.
To change the status for Mail listeners on the UNIX operating system to Up in Grid Control, follow these steps:
Use the Net Merge utility to modify the listener.ora file to create one or more TCP addresses for the same listener without the presentation, that is, add the following to the end of the description list:
(description=(address=(protocol=tcp)(port=<any_available_port_above_1024>)(host=127.0.0.1)))
Note that the port can be any port above 1024 that is available on the system for the listener, such as 1522 or 1526, but it has to be different than the one with presentation.
Restart the Mail listener by performing the following steps:
Log in as root.
Check if sendmail is running by using this command:
ps -ef | grep sendmail
If it is running, kill the process.
Execute the following command, where userid
is the UNIX account that owns the Oracle software:
id userid
Issue the following command, where listener_es
is the name of the Mail listener:
tnslsnr listener_es <uid_value> -group <gid_value>
Note:
The Mail listener cannot be started usinglsnrctl
from a user shell. Since it has to listen on ports below 1024, it has to be started by the superuser on UNIX operating systems. When restarting the Mail listener following the listener.ora change, you should use the same command, with the same command line arguments, as was used to start it up initially.In Grid Control, navigate to the All Targets page and click the link for the listener_es target that shows a status of Down.
On the Listener Home page, click Monitoring Configuration. Change the Machine name property to 127.0.0.1 and change the Port number property to the port number used in the new TCP address without presentation.
To change the status for Mail listeners on the Windows operating system to Up in Grid Control, follow these steps:
In Grid Control, navigate to the All Targets page and click the link for the listener_es target that shows a status of Down.
On the Listener Home page, click Monitoring Configuration. Make sure that the Port number property is set to the port number corresponding to the port number used in the new TCP address without presentation (that is, the port number corresponding to the entry in listener.ora which has HOST=127.0.0.1
).
When you monitor your Oracle Email targets with Enterprise Manager, the Management Agent gathers monitoring data about the Oracle Email targets and uploads them to the Management Service, which loads them into the Management Repository.
However, the Oracle Email mail store itself also gathers monitoring data about your Oracle Email targets. After you start monitoring your Oracle Email targets with Enterprise Manager, the data saved in your mail store database is redundant with the information available in the Management Repository.
As a result, to save space and improve the performance of your mail store database, you can purge this redundant data from the mail store database on a regular basis. The following sections describe how to purge this data:
The first step in purging data from the mail store database is to run the es_perf_purge
PL/SQL procedure shown in Example 12-4.
To run the procedure:
Create a new file containing the PL/SQL code shown in Example 12-4.
Save the file using the following suggested path and file name in the Oracle Home for your mail store database:
$ORACLE_HOME/bin/es_perf_purge.sql
Use SQL*Plus to connect to the mail store database as the es_mail
user:
$PROMPT> cd $ORACLE_HOME/bin/sqlplus SQL> connect <username> AS es_mail
Execute the PL/SQL procedure:
SQL> @es_perf_purge.sql
Quit SQL*Plus:
SQL> quit
Example 12-4 The es_perf_purge PL/SQL Procedure
CREATE OR REPLACE PROCEDURE es_perf_purge(cutoff IN NUMBER) AS sample_index INTEGER; computed_tstamp DATE := SYSDATE; BEGIN -- Use this procedure to purge the oldest "cutoff" days worth of data. -- So if the value of 7 is passed for "cutoff" in this procedure, then -- the oldest 7 days worth of data will be deleted. -- If the oldest 14 days worth of data needs to be purged, pass in 14 -- for "cutoff" in this procedure ... -- NOTE: If the value of cutoff is large, this procedure takes a long time -- to complete. To delete all the data from the tables - es_perf_sample -- and es_perf_timestamp, use the following sql commands: -- %SQL> TRUNCATE TABLE es_perf_sample; -- %SQL> TRUNCATE TABLE es_perf_timestamp; -- %SQL> COMMIT; -- This is a faster way of deleting all the data in the es_perf_sample -- and es_perf_timestamp tables. Use the above "TRUNCATE" sql -- statements only if there is no need for the data in these tables. -- first determine the timestamp based on cutoff number of days BEGIN SELECT MIN(timestamp) + cutoff INTO computed_tstamp FROM es_perf_timestamp; EXCEPTION WHEN OTHERS THEN computed_tstamp := SYSDATE; END; -- now use the value of computed timestamp to delete data from -- es_perf_sample and es_perf_timestamp -- delete data from es_perf_sample FOR record IN ( SELECT timestamp_id FROM es_perf_timestamp WHERE timestamp <= computed_tstamp ) LOOP DELETE FROM es_perf_sample WHERE timestamp_id = record.timestamp_id; END LOOP; -- delete data from es_perf_timestamp DELETE FROM es_perf_timestamp WHERE timestamp <= computed_tstamp; COMMIT; END;
After you initially run the es_perf_purge
PL/SQL procedure, you can configure the Enterprise Manager Job system to automatically perform the purge operation on a regular basis.
To create an Enterprise Manager job to perform this action:
From the Grid Control Home page, click the Jobs tab.
From the Results section of the page, select SQL Script from the Create Job drop-down menu.
Enterprise Manager displays the Create 'SQL Script' Job page.
Enter a name and a description of the job in the Name and Description fields.
Enter the following in the SQL Script field:
EXEC es_perf_purge( <number_of_days> );
For example, to delete the past seven days of monitoring data, enter the following:
EXEC es_perf_purge ( 7 );
In the Databases section of the page, click Add.
Enterprise Manager displays the Add Targets page.
Click Search to display a list of all available databases; or, enter the name of a specific mail store database and then click Search.
Select the mail store database you want to purge and click Add.
Enterprise Manager returns you to the Create 'SQL Script' Job page; the mail store database you selected appears in the list of databases against which the job will be run.
Provide the required host and database credentials.
Optionally, use your preferred credentials to define the connection to the mail store database.
See Also:
"About Preferred Credentials" in the Enterprise Manager online helpClick Schedule to determine when the job will be run.
For example, you can schedule the job to run once a week, or every day. Click Help for information on defining a schedule for a job.
Click Submit or Submit and Save.
See Also:
"About Jobs" in the Enterprise Manager online helpPurging monitoring data from the Oracle Email mail store can take a long time to complete. Alternatively, you can delete all the monitoring data from the es_perf tables using the SQL TRUNCATE command.
Caution:
Use the TRUNCATE statement with caution. When you issue the TRUNCATE statement, a COMMIT is performed automatically. As a result, you will not be able to rollback the data you are deleting.Be sure the object name you provide for the TRUNCATE statement contains only the name of the tables described in the procedure. Use the TRUNCATE statement only if you are sure that you no longer need the data in the es_perf_sample
and es_per_timestamp
tables.
To remove all the existing monitoring data from the mail store database:
Connect to the mail store database as the es_perf
user, using SQL*Plus:
$ORACLE_HOME/bin/sqlplus SQL> connect <username> AS es_mail
Execute the following SQL commands:
SQL> TRUNCATE TABLE es_perf_sample; SQL> TRUNCATE TABLE es_perf_timestamp;
Quit SQL*Plus:
SQL> quit