4.3.3.1 ALTER ALERT

This command creates or alters an Oracle alert.

Syntax

ALTER ALERT
   { RECIPIENTS='recipients'
     FROMNAME='from_name'
     FROMEMAIL=from_email
     SMTPHOST=smtp_host
     [ SSL=uses_ssl ]
     [ PORT=smtp_port ]
   | SNMPHOST=snmp_host
     [ PORT=snmp_port ]
     [ COMMUNITY=snmp_community ]
   | ASRHOST=asr_host
     CONTACT=asr_contact
     EMAIL=asr_email
     MOSACCOUNT=asr_mos_account
     [ PROXYHOST=asr_proxy_host ]
     [ PROXYPORT=asr_proxy_port ]
     [ PROXYUSER=asr_proxy_user ] 
   | [ EMAIL=ocm_email ]
     [ HUBHOST=ocm_hub_host ]
     [ HUBUSER=ocm_hub_user ]
     [ PROXYHOST=ocm_proxy_host ]
     [ PROXYPORT=ocm_proxy_port ]
     [ PROXYUSER=ocm_proxy_user ]
   | EMBASE=em_base
     [ OMSHOST=oms_host ]
     PORT=oms_port }
WHERE
   { ID=alert_id |
     TYPE=alert_type |
     HOSTNAME=host_name TYPE=alert_type |
     CLUSTERNUMBER=cluster_number TYPE=alert_type |
     CLUSTERNAME=cluster_name TYPE=alert_type |
     CLUSTERID=cluster_id TYPE=alert_type }

Arguments

You can specify various attributes according to the alert type.

• For SMTP alerts:

  • RECIPIENTS : Specifies a list of email addresses. The list entries are separated by a space or a comma and the list is surrounded by single quotation marks

  • FROMNAME : Specifies the name of the email sending user, surrounded by single quotation marks

  • FROMEMAIL : Specifies the email address of the email sending user

  • SMTPHOST : Specifies the hostname of the SMTP email server

  • SSL : Optionally, set to true to use SSL. Default value is false.

  • PORT : Optionally, specifies the SMTP email server port. Default value is 25.

• For SNMP alerts:

  • SNMPHOST : Specifies the hostname of the SNMP server

  • PORT : Optionally, specifies the SNMP server port. Default value is 162.

  • COMMUNITY : Optionally, specifies the SNMP community value. Default value is public.

• For Oracle Auto Service Request (ASR) alerts:

  • ASRHOST : Specifies the hostname of the ASR server

  • CONTACT : Specifies the ASR contact name

  • EMAIL : Specifies the ASR email address

  • MOSACCOUNT : Specifies the ASR My Oracle Support (MOS) email address

  • PROXYHOST : Optionally, specifies the proxy hostname for connectivity to the ASR server

  • PROXYPORT : Optionally, specifies the proxy port for connectivity to the ASR server

  • PROXYUSER : Optionally, specifies the proxy username for connectivity to the ASR server

• For Oracle Configuration Manager (OCM) alerts:

  • EMAIL : Specifies the OCM email address

  • HUBHOST : Specifies the hostname of the OCM hub

  • HUBUSER : Specifies the OCM hub user name

  • PROXYHOST : Optionally, specifies the proxy hostname for connectivity to the OCM hub

  • PROXYPORT : Optionally, specifies the proxy port for connectivity to the OCM hub

  • PROXYUSER : Optionally, specifies the proxy username for connectivity to the OCM hub

• For Oracle Enterprise Manager (EM) alerts:

  • EMBASE : Optionally, specifies the EM base directory. Default value is /u01/app/oracle/product/EMbase.

  • OMSHOST : Specifies the hostname of the Oracle Management Server (OMS)

  • PORT : Optionally, specifies the OMS server port. Default value is 4900.

The following arguments are available in the WHERE clause:

• ID : Specifies the es.xml ID for an existing alert

• TYPE : Specifies the alert type: SNMP, SMTP, ASR, OCM, or EM

• HOSTNAME : Specifies the target server hostname

• CLUSTERNUMBER : Specifies the cluster number in the es.xml, starting at 1

• CLUSTERNAME : Specifies the name of the cluster

• CLUSTERID : Specifies the es.xml ID of the cluster