Use Autonomous AI Database Events
You can use Oracle Cloud Infrastructure Events to subscribe to and be notified of Autonomous AI Database events. The Oracle Cloud Infrastructure Events allow you to create automation and to receive notifications based on state changes for resources.
- About Events Based Notification and Automation on Autonomous AI Database
You can subscribe to Oracle Cloud Infrastructure Events. - Critical Events on Autonomous AI Database
Critical events on Autonomous AI Database are issues that cause disruption to the database. - Information Events on Autonomous AI Database
Information events provide important details about database lifecycle events, workload capture and reply events, and some other non-critical events on Autonomous AI Database. - Autonomous AI Database Lifecycle Events
Provides a list of Autonomous AI Database lifecycle events. - Get Notified of Autonomous AI Database Events
Using Oracle Cloud Infrastructure Events you can subscribe to Autonomous AI Database events individually or in two categories, Critical and Information events.
Parent topic: Manage the Service
About Events Based Notification and Automation on Autonomous AI Database
An event could be a resource life cycle state change or a system event impacting a resource. For example, an event is emitted on Autonomous AI Database when maintenance begins and ends. Subscribing to events allows you to receive notifications or to perform other types of automation for events.
You can subscribe to Autonomous AI Database events as follows:
- Critical Events: See Critical Events on Autonomous AI Database for details on the events in the Critical event category.
- Information Events: See Information Events on Autonomous AI Database for details on the events in the Information event category.
-
Lifecycle Management Events. See Autonomous AI Database Lifecycle Events for the list of Autonomous AI Database events.
-
Autonomous Data Guard Events. See Events and Notifications for a Standby Database for the list of Autonomous Data Guard events.
Critical events and Information events include an event category attribute
(in the eventCategory
field). Optionally you can subscribe to events
and add an event category to receive notifications about events in a category, or to
perform other types of automation for events by event type and event category.
The event categories are:
- Incident: Database incident events
- Maintenance: Database maintenance events
- Performance: Database performance events
- Security: Database security events
- Other: Other events
See Overview of Events for complete information on Oracle Cloud Infrastructure Events.
See Get Notified of Autonomous AI Database Events for information on creating event rules.
Parent topic: Use Autonomous AI Database Events
Critical Events on Autonomous AI Database
Critical events on Autonomous AI Database are issues that cause disruption to the database.
Event | Event Category | Description |
---|---|---|
AdminPasswordWarning |
Security |
Provides a message that the Autonomous AI Database ADMIN password is expiring within 30 days or is expired.
|
AutomaticFailoverBegin |
Incident |
When an automatic failover begins for the Autonomous AI Database and
the database is unavailable an
The event will only be triggered if you are using Autonomous Data Guard. |
AutomaticFailoverEnd |
Incident |
When an automatic failover that was triggered is complete
and the database is now available an
The event will only be triggered if you are using Autonomous Data Guard. |
DatabaseDownBegin |
Incident |
The Autonomous AI Database instance cannot be opened, or the services such as high, low, medium, tp, or tpurgent are not started or available. The following conditions do not trigger
This event will not be triggered if you are using Autonomous Data Guard and the standby database is not available due to any of these conditions. |
DatabaseDownEnd |
Incident |
The database is recovered from the down state, meaning
the Autonomous AI Database
instance is opened with its services, following a
The following conditions do not trigger
If you are using Autonomous Data
Guard
and the primary database goes down, this triggers a
|
DatabaseInaccessibleBegin |
Incident |
The Autonomous AI Database instance is using customer-managed keys and the database becomes inaccessible (state shows Inaccessible). The following conditions trigger
|
DatabaseInaccessibleEnd |
Incident |
If the Autonomous AI Database instance recovers from the Inaccessible
state that generated a |
DatabaseUserPasswordWarning |
Security |
Provides a message that the Autonomous AI Database user password is expiring within the specified grace period (default 30 days) or has already expired.
The |
FailedLoginWarning |
Security |
If the number of failed login attempts reaches 3 *
number of total users in the last three (3) hours, the
database triggers a Failed login attempts could be due to a user entering an invalid username or password, or due to a connection timeout. The event is triggered when the failed login attempts threshold is exceeded within the monitored time period (the last three hours). |
InstanceRelocateBegin |
Incident |
If an Autonomous AI Database is relocated to another Exadata infrastructure due
to server maintenance, hardware refresh, a hardware issue, or as
part of a resource scale up, the
|
InstanceRelocateEnd |
Incident |
If an Autonomous AI Database is relocated to another Exadata infrastructure due
to server maintenance, hardware refresh, a hardware issue, or as
part of a resource scale up, the
|
ScheduledUpgradeBegin |
Other |
When a scheduled upgrade begins for the Autonomous AI Database and
the database is unavailable a |
ScheduledUpgradeEnd |
Other |
When a scheduled upgrade ends for the Autonomous AI Database and
the database is now available a |
ScheduledUpgradeFailed |
Other |
When a scheduled upgrade fails for the Autonomous AI Database and
the database is now available a
|
WalletExpirationWarning |
Security |
This event is generated when Autonomous AI Database determines that a wallet is due to expire in less than six (6) weeks. This event is reported at most once per week. This event is triggered when there is a connection that uses the wallet that is due to expire. |
Use the event type Autonomous AI Database - Critical to specify critical events in Event rules.
Parent topic: Use Autonomous AI Database Events
Information Events on Autonomous AI Database
Information events provide important details about database lifecycle events, workload capture and reply events, and some other non-critical events on Autonomous AI Database.
The times shown with information events are in UTC.
Event | Event Category | Description |
---|---|---|
|
Performance |
This event is generated when an Autonomous AI JSON Database has exceeded the maximum storage limit of 20GB of data stored outside of SODA collections. This limit does not apply to data stored in SODA collections or objects associated with SODA collections, such as indexes or materialized views. In addition to this event, an email is sent to the account owner. You must either reduce your usage of non-SODA-related data to below the 20GB limit or promote the Autonomous AI JSON Database to Autonomous AI Transaction Processing. See Promote to Autonomous Transaction Processing for more information. |
|
Incident |
This event is generated when you are using Oracle APEX and a new release becomes available. |
|
Incident |
This event is generated when you are using Oracle APEX and your Autonomous AI Database instance begins an upgrade to a new Oracle APEX release or begins to apply an Oracle APEX Patch Set Bundle. |
|
Incident |
This event is generated when you are using Oracle APEX and your Autonomous AI Database instance completes an upgrade to a new Oracle APEX release or completes the installation of an Oracle APEX Patch Set Bundle. |
|
Incident |
This event is generated when the scheduled Automatic Refresh completes. See Edit Automatic Refresh Policy for Refreshable Clone for more information. |
|
Incident |
This event is generated when the scheduled Automatic Refresh fails. See Edit Automatic Refresh Policy for Refreshable Clone for more information. |
|
Security |
This event is generated if a connection is made to database from a new IP address (the connection has not been made from the specified IP address in the last 30 days). |
|
Security |
This event is generated when the number of inactive database connections detected is above a certain ratio compared to all database connections for the Autonomous AI Database instance. Subscribing to this event can help you keep track of unused connections. This event is generated once per day, when the following is true:
Use the following query to report detailed information on sessions that have been inactive for more than 24 hours:
|
LongPendingTransaction |
Incident |
This event is generated when a transaction is open for longer than 24 hours. Only one event is generated per transaction. The generated event includes the transaction id, address, and session address. |
|
Maintenance |
This event is triggered when the maintenance starts and provides the start timestamp for the maintenance (this event does not provide the scheduled start time). This event is also triggered when the maintenance starts for a local Autonomous Data Guard standby. |
|
Maintenance |
This event is triggered when the maintenance ends and provides the end timestamp for the maintenance (this event does not provide the scheduled end time). This event is also triggered when the maintenance ends for a local Autonomous Data Guard standby. |
|
Maintenance |
This event is generated when the maintenance date is updated and the new date is shown on the Oracle Cloud Infrastructure Console. This event is also triggered when the maintenance date is updated and the new date is shown for a local Autonomous Data Guard standby. When the Java version will be updated, the event
|
|
Security |
This event is triggered when the average incoming network traffic to your Autonomous AI Database for TCP or HTTP database connections in the last 24 hours has exceeded 50% of the average incoming traffic observed a day before. When the trigger conditions for this event are met, the
|
|
Security |
This event is triggered when the average outgoing network traffic from your Autonomous AI Database for TCP or HTTP database connections in the last 24 hours has exceeded 50% of the average outgoing traffic observed a day before. When the trigger conditions for this event are met, the
|
OperatorAccess |
Other |
This event is triggered when operator access is detected
for the database. You can query the access details from the
The |
|
Performance |
This event is triggered when the average elapsed time of a query has exceeded ten times its average elapsed time over the past seven (7) days. The
When the trigger conditions for this event are met, the
|
|
Performance |
This event is triggered for the following metrics, when certain thresholds are exceeded:
For the CPU and Sessions metrics, the event is only eligible to be generated when:
When the trigger conditions for this event are met, the Note: TheResourceUtilizationWarning event is not generated when:
|
|
Maintenance |
This event is generated when the instance is 24 hours from a scheduled maintenance and again when the instance is 1 hour (60 minutes) from the scheduled maintenance. This event is also triggered when a local Autonomous Data Guard standby is 24 hours from a scheduled maintenance and again when the local Autonomous Data Guard standby is 1 hour (60 minutes) from the scheduled maintenance. When the Java version will be updated, the event
|
|
Incident |
If a SQL parse error occurs several times in a certain
time window, for example 200 times or more in an hour, this
generates This event is generated at most once per day. This means there can be a delay of up to 24 hours before the event is generated. |
|
Maintenance |
This event is generated when an instance requires an unplanned maintenance due to a critical security fix, a regression, or a failure during planned maintenance. This event informs you when the maintenance required for urgent and unplanned situations is initiated. |
|
Maintenance |
This event is generated when an instance requires an unplanned maintenance due to a critical security fix, a regression, or a failure during planned maintenance. This event informs you when the maintenance required for urgent and unplanned situations is completed successfully. |
WorkloadCaptureBegin |
Incident |
This event is triggered when a workload capture is initiated. |
WorkloadCaptureEnd |
Incident |
This event is triggered when a workload capture completes successfully. This generates a pre-authenticated (PAR) URL to download the capture reports. This URL is contained in the
|
WorkloadReplayBegin |
Incident |
This event is triggered when a workload replay is initiated. |
WorkloadReplayEnd |
Incident |
This event is triggered when a workload replay completes successfully. This generates a pre-authenticated (PAR) URL to download the replay reports. This URL is contained in the
|
Note:
When Autonomous Data Guard is enabled, any of these events that occur on the standby database do not trigger an Information event.Use the event type Autonomous AI Database - Information to specify information events in Event rules.
See View Patch and Maintenance Window Information, Set the Patch Level for information on maintenance windows.
Parent topic: Use Autonomous AI Database Events
Autonomous AI Database Lifecycle Events
Provides a list of Autonomous AI Database lifecycle events.
Friendly Name | Event Type |
---|---|
Autonomous AI Database - Access Control Lists Update Begin |
com.oraclecloud.databaseservice.updateautonomousdatabaseacl.begin |
Autonomous AI Database - Access Control Lists Update End | com.oraclecloud.databaseservice.updateautonomousdatabaseacl.end |
Autonomous AI Database - Auto Scaling Disabled | com.oraclecloud.databaseservice.autonomousdatabaseautoscaledisabled |
Autonomous AI Database - Auto Scaling Enabled | com.oraclecloud.databaseservice.autonomousdatabaseautoscaleenabled |
Autonomous AI Database - Automatic Backup Begin | com.oraclecloud.databaseservice.automaticbackupautonomousdatabase.begin |
Autonomous AI Database - Automatic Backup End | com.oraclecloud.databaseservice.automaticbackupautonomousdatabase.end |
Autonomous AI Database - Change Compartment Begin | com.oraclecloud.databaseservice.changeautonomousdatabasecompartment.begin |
Autonomous AI Database - Change Compartment End | com.oraclecloud.databaseservice.changeautonomousdatabasecompartment.end |
Autonomous AI Database - Change Database Name Begin | com.oraclecloud.databaseservice.changeautonomousdatabasename.begin |
Autonomous AI Database - Change Database Name End | com.oraclecloud.databaseservice.changeautonomousdatabasename.end |
Autonomous AI Database - Create Backup Begin | com.oraclecloud.databaseservice.autonomous.database.backup.begin |
Autonomous AI Database - Create Backup End | com.oraclecloud.databaseservice.autonomous.database.backup.end |
Autonomous AI Database - Create Begin | com.oraclecloud.databaseservice.autonomous.database.instance.create.begin |
Autonomous AI Database - Create End | com.oraclecloud.databaseservice.autonomous.database.instance.create.end |
Autonomous AI Database - Critical
See Critical Events on Autonomous AI Database for more information. |
com.oraclecloud.databaseservice.autonomous.database.critical |
Autonomous AI Database - Deregister Autonomous Database with Data Safe Begin | com.oraclecloud.databaseservice.deregisterautonomousdatabasedatasafe.begin |
Autonomous AI Database - Deregister Autonomous Database with Data Safe End | com.oraclecloud.databaseservice.deregisterautonomousdatabasedatasafe.end |
Autonomous AI Database - Disable Data Guard Begin | com.oraclecloud.databaseservice.disableautonomousdataguard.begin |
Autonomous AI Database - Disable Data Guard End | com.oraclecloud.databaseservice.disableautonomousdataguard.end |
Autonomous AI Database - Disconnect Refreshable Clone from Source Database Begin | com.oraclecloud.databaseservice.disconnectrefreshableautonomousdatabaseclonefromsource.begin |
Autonomous AI Database - Disconnect Refreshable Clone from Source Database End | com.oraclecloud.databaseservice.disconnectrefreshableautonomousdatabaseclonefromsource.end |
Autonomous AI Database - Enable Data Guard Begin | com.oraclecloud.databaseservice.enableautonomousdataguard.begin |
Autonomous AI Database - Enable Data Guard End | com.oraclecloud.databaseservice.enableautonomousdataguard.end |
Autonomous AI Database - Free Database Automatic Stop Reminder
This event is emitted 48 hours prior to database stop. |
com.oraclecloud.databaseservice.freeautonomousdatabasestopreminder |
Autonomous AI Database - Free Database Automatically Stopped | com.oraclecloud.databaseservice.freeautonomousdatabasestopped |
Autonomous AI Database - Free Database Automatic Termination Reminder.
This event is emitted 48 hours prior to database termination. |
com.oraclecloud.databaseservice.freeautonomousdatabaseterminationreminder |
Autonomous AI Database - Free Database Automatically Terminated | com.oraclecloud.databaseservice.freeautonomousdatabaseterminated |
Autonomous AI Database - Generate Wallet | com.oraclecloud.databaseservice.generateautonomousdatabasewallet |
Autonomous AI Database - Information
See Information Events on Autonomous AI Database for more information. |
com.oraclecloud.databaseservice.autonomous.database.information |
Autonomous AI Database - Long term backup ended
This event is triggered when a long term backup completes. |
|
Autonomous AI Database - Long term backup schedule disabled
This event is triggered when a long term backup schedule is disabled. |
|
Autonomous AI Database - Long term backup schedule enabled / updated
This event is triggered when a long term backup schedule is either enabled or updated. |
|
Autonomous AI Database - Long term backup started
This event is triggered when a long term backup starts. |
|
Autonomous AI Database - Manual Failover Begin | com.oraclecloud.databaseservice.failoverautonomousdatabase.begin |
Autonomous AI Database - Manual Failover End
This event is emitted after failover completes successfully or unsuccessfully. Unsuccessful manual failovers may result in data loss. Check the Autonomous AI Database details page in the Oracle Cloud Infrastructure Console for additional information in the event of an unsuccessful manual failover.) |
com.oraclecloud.databaseservice.failoverautonomousdatabase.end |
Autonomous AI Database - Manual Refresh Begin
The "Manual Refresh" events are used for Autonomous AI Database refreshable clones. |
com.oraclecloud.databaseservice.manualrefresh.begin |
Autonomous AI Database - Manual Refresh End | com.oraclecloud.databaseservice.manualrefresh.end |
Autonomous AI Database - Deregister Autonomous AI Database with Data Safe Begin | com.oraclecloud.databaseservice.deregisterautonomousdatabasedatasafe.begin |
Autonomous AI Database - Deregister Autonomous AI Database with Data Safe End | com.oraclecloud.databaseservice.deregisterautonomousdatabasedatasafe.end |
Autonomous AI Database - Register Autonomous AI Database with Data Safe Begin | com.oraclecloud.databaseservice.registerautonomousdatabasedatasafe.begin |
Autonomous AI Database - Register Autonomous AI Database with Data Safe End | com.oraclecloud.databaseservice.registerautonomousdatabasedatasafe.end |
Autonomous AI Database - Restart Begin | com.oraclecloud.databaseservice.restartautonomousdatabase.begin |
Autonomous AI Database - Restart End | com.oraclecloud.databaseservice.restartautonomousdatabase.end |
Autonomous AI Database - Restore Begin | com.oraclecloud.databaseservice.autonomous.database.restore.begin |
Autonomous AI Database - Restore End | com.oraclecloud.databaseservice.autonomous.database.restore.end |
Autonomous AI Database - Rotate Encryption Key Begin | com.oraclecloud.databaseservice.rotateautonomousdatabaseencryptionkey.begin |
Autonomous AI Database - Rotate Encryption Key End | com.oraclecloud.databaseservice.rotateautonomousdatabaseencryptionkey.end |
Autonomous AI Database - Start Begin | com.oraclecloud.databaseservice.startautonomousdatabase.begin |
Autonomous AI Database - Start End | com.oraclecloud.databaseservice.startautonomousdatabase.end |
Autonomous AI Database - Stop Begin | com.oraclecloud.databaseservice.stopautonomousdatabase.begin |
Autonomous AI Database - Stop End | com.oraclecloud.databaseservice.stopautonomousdatabase.end |
Autonomous AI Database - Switchover Begin | com.oraclecloud.databaseservice.switchoverautonomousdatabase.begin |
Autonomous AI Database - Switchover End
This event is emitted after switchover completes successfully or unsuccessfully. Unsuccessful switchovers may result in data loss. Check the Autonomous AI Database details page in the Oracle Cloud Infrastructure Console for additional information in the event of an unsuccessful switchover. |
com.oraclecloud.databaseservice.switchoverautonomousdatabase.end |
Autonomous AI Database - Terminate Begin | com.oraclecloud.databaseservice.deleteautonomousdatabase.begin |
Autonomous AI Database - Terminate End | com.oraclecloud.databaseservice.deleteautonomousdatabase.end |
Autonomous AI Database - Update Begin | com.oraclecloud.databaseservice.updateautonomousdatabase.begin |
Autonomous AI Database - Update End | com.oraclecloud.databaseservice.updateautonomousdatabase.end |
Autonomous AI Database - Update Open Mode Begin | com.oraclecloud.databaseservice.updateautonomousdatabaseopenmode.begin |
Autonomous AI Database - Update Open Mode End | com.oraclecloud.databaseservice.updateautonomousdatabaseopenmode.end |
Autonomous AI Database - Upgrade Database Version Begin | com.oraclecloud.databaseservice.upgradeautonomousdatabasedbversion.begin |
Autonomous AI Database - Upgrade Database Version End | com.oraclecloud.databaseservice.upgradeautonomousdatabasedbversion.end |
Parent topic: Use Autonomous AI Database Events
Get Notified of Autonomous AI Database Events
Using Oracle Cloud Infrastructure Events you can subscribe to Autonomous AI Database events individually or in two categories, Critical and Information events.
Note:
When you subscribe to an event category, either Critical or Information, you are notified when any events in the category occur. For example, to get notified when the database goes down, subscribe to the Autonomous AI Database Critical event type.If you want to subscribe to Critical or Information events:
-
To subscribe to Critical events, create an event rule using the Autonomous AI Database - Critical event type.
-
To subscribe to Information events, create an event rule using the Autonomous AI Database - Information event type.
If you want to subscribe to one or more individual Critical or
Information events, create an event rule and add conditions. For example, to
create an event rule that only applies for the
AdminPasswordWarning
Critical event, create a rule as
follows:
Critical events and Information events include an event category
attribute (in the eventCategory
field). Optionally you can
subscribe to events by event type and include an event category to receive
notifications about events in that category, or to perform other types of
automation for events.
The event categories are:
- Incident: Database incident events
- Maintenance: Database maintenance events
- Performance: Database performance events
- Security: Database security events
- Other: Other events
For example, if you want to subscribe Critical events with the event
category Security
, create an event rule as shown, and in Step
7, select the eventCategory
attribute and enter a value.
The result would look like this:
MATCH event WHERE (
eventType EQUALS ANY OF (
com.oraclecloud.databaseservice.autonomous.database.critical
)
AND (
eventCategory MATCHES ANY OF (
Security
)
)
)
See Getting Started with Events for information on using Oracle Cloud Infrastructure Events, creating event rules, and for information on configuring actions for notifications.
Parent topic: Use Autonomous AI Database Events