Start, stop, or restart Autonomous Database
Using Site24x7's IT Automation framework, you can create an action profile to start, stop, or restart Autonomous Databases. You can also configure automated tasks to trigger when there's a change in the status of the monitor or in individual attributes.
Required permissions
Ensure that Site24x7's tenancy access has these partial write actions in the attached policy document so you can perform the actions:
- StopAutonomousDatabase - AUTONOMOUS_DATABASE_UPDATE
- restartAutonomousDatabase - AUTONOMOUS_DATABASE_UPDATE
- startAutonomousDatabase - AUTONOMOUS_DATABASE_UPDATE
Create an automation for Autonomous Database
- Log in to the Site24x7 web console and go to Admin > IT Automation Templates > Add Automation Templates.
- Click the Type drop-down and select the action to be performed as Autonomous Database Actions.
- Enter a Display Name.
- Select the applicable action from the Action to be Performed drop-down menu. The available options are Start Autonomous Database, Stop Autonomous Database, and Restart Autonomous Database.
- Select the databases from the Autonomous Database Actions drop-down menu.
- Max Allowed Action Execution Time: This is the maximum number of seconds Site24x7 should wait before the request times out. The execution time is set to 15 seconds by default. You can define an execution time between one and 90 seconds.
- Send the Automation Result via Email: You can choose to receive an email regarding the automation result by toggling this setting to Yes. Automation results can be shared via email to your User Alert Group configured in the Notification Profile. This email will contain parameters including the automation name, type of automation, incident reason, destination hosts, and more.
- Click Save to retain the profile.
Simulate the automation
Before mapping the action profile, you can test its functionality by invoking the operational task manually within the Site24x7 console or by using our REST APIs. This is done to check whether the appropriate write-level permissions required to execute the reboot action are in place. To test the profile, navigate back to the IT Automation Templates page (Admin > IT Automation Templates) and click the Play icon next to the appropriate template to execute a dry run.
Map the action profile
To execute the automation, map the action profile to the desired alert event. You can either map the profile to a predefined monitor-level event type, or to a custom attribute-level event type.
Related topics