Manage Alerts

Alerts notify you when particular events occur on your target databases and collect on the Alerts page in the Oracle Data Safe Console. Oracle Data Safe provides ways that you can investigate, monitor, and report on alerts as well as modify the types of alerts generated.

This article has the following topics:

View Alerts

You can view alerts from the Alerts page.

  1. Click the Alerts tab.
    The Alerts page is displayed and all alerts are listed in table format.
  2. To configure which columns are displayed, click the plus sign to the right of the table. In the Select Columns dialog box, select the check boxes for the columns you want to display, and click Apply. The following columns are available:
    • Alert Id
    • Alert Status (Open or Closed)
    • Alert Name
    • Target Name
    • User Name (the user who caused the alert)
    • OS User Name
    • Client Host Name
    • Client IP
    • Operation
    • Operation Status
    • Object
    • Object Type
    • Alert Severity (Critical, High, or Medium)
    • Operation Time (when the alert was generated)
  3. To view an alert summary at the top of the page, do the following:
    1. Click Summary.
      Totals are displayed across the top of the page, including the number of targets that have alerts; the number of critical, high, and medium alerts that are present; and the number of open and closed alerts.
    2. To hide the summary information, click Summary again.
  4. To view more detail about a particular alert, do the following:
    1. Click an alert Id.
      The Alert Details dialog box displays the following information:
      • Target Name
      • Target Type
      • Target Class
      • Location
      • User Name
      • OS User Name
      • Client Host Name
      • Client Program
      • Terminal
      • Operation
      • Operation Status
      • Event Name
      • Command text
      • Command Param
      • Operation Time
      • Event Fetch Time
      • Extension
    2. To view parameters that have null values, click the Show Fields With No Data check box.
    3. To close the Alert Details dialog box, click the X in the upper-right corner.
  5. To filter the alert list:
    1. At the top of the table, click Filters.
    2. From the first drop-down list, select the column name by which you want to filter (for example, Target Name).
    3. From the second drop-down, select an operator (=, !=, like, or Not like).
    4. Enter the search criteria.
    5. Click Apply.
      The table is filtered based on your criteria.
  6. To create another filter, click + Filter.
    A new filter line is added below the existing filters.
  7. To remove a filter, click the X to the right of a filter.
  8. To navigate from page to page, scroll down to the bottom of the page and click the page numbers or arrow buttons.

Change the Status of Alerts

You can change the status of an alert to Open or Closed. Setting the status helps to keep your alerts organized.

  1. Click the Alerts tab.
    The Alerts page is displayed.
  2. To change the status of one alert, select Open or Closed in the Alert Status column for the alert.
  3. To change the status of multiple alerts at the same time, select the check boxes for the alerts that you want to change. Then, from the Mark As drop-down list at the top of the page, select Open or Closed.

Create Alert Reports

You can modify the presentation of the original alert report and save it as a new alert report.

  1. Click the Alerts tab.
  2. Customize the All Alerts reports as needed, for example, by adding filters and selecting columns to display.
  3. Save your report:
    1. From the Report Definition drop-down menu, select Save As New.
    2. In the Save As dialog box, enter a report name and description (optional), select a compartment to which you want the report ot belong, and click Save As.
    The report is listed on the left side of the page under Custom Reports.
  4. To save changes to your alert report, from the Report Definition menu, select Save.
  5. To delete an alert report:
    1. On the left, click your alert report.
    2. From the Report Definition menu, select Delete.
      The Delete Report dialog box is displayed.
    3. Click OK to confirm the deletion or click Cancel.

Download Alert Reports

You can download an alert report as a PDF or XLS file. Before you can download the report, you must first generate the report.

  1. Click the Alerts tab.
  2. On the left, click All Alerts to list all the alerts that are generated.
  3. Click Generate Report.
    The Generate Report dialog box is displayed.
  4. Select PDF or XLS as the report format.
  5. (Optional) Enter a row limit. If you do not specify a row limit, 200 rows are generated by default.
  6. (Optional) Click the Targets field, and select the targets from the drop-down list.
  7. (Optional) Enter a description for your report.
  8. (Optional) Click the calendar in the Operation Start Time field and configure an event start time. Click Done.
  9. (Optional) Click the calendar in the Operation End Time field and configure an event end time. Click Done.
  10. Select a compartment to which you want the report to belong.
  11. Click Generate Report.
    When the report is generated, a message is displayed at the top of the page.
  12. Click Download Report to download the report to a desired location.

Update Alert Policies

  1. Click the Targets tab.
  2. On the left, click Audit Policies.
    The Audit and Alert Policies page is displayed.
  3. Click the target database name.
    The Edit Policies dialog box is displayed.
  4. Click the Alert Policies tab.
  5. Modify the selection of alert policies, and click Provision.