Introduction
I recently had the opportunity to spend some time learning all about the Workato orchestration platform. After completing the Workato training paths and certifications I decided it was time to take my new found knowledge out for a spin.
In the short video at the end of this post I will demonstrate how a Workato recipe can be used to orchestrate the refresh of multiple test Oracle Databases by calling an Ansible playbook, utilising Oracle scripts and Pure Storage REST APIs all from a Slack prompt.
What is Workato ?
Workato is an Enterprise Low Code / No Code process automation and data orchestration platform. Workato provides many out-of-the box connectors for commonly used on-premises and SaaS solutions including Slack which I will be using here.
Oracle Database Environment
In my lab I have a number of test Oracle databases running on multiple VMs all using Pure Storage FlashArray block volumes. For this demo each database has its own dedicated Oracle Home ( /u01 ) and filesystems for data, redo and archive /u02 & /u03.
Oracle Database Automation
In the video below, a Slack Workbot triggers a refresh of my 6 test Oracle databases when it sees an ‘Oracle refresh database‘ request.
The Workbot prompts for an Oracle Database name, and then initiates the database refresh calling my Ansible ORCA playbook, the playbook performs the following steps:
- Dynamic creation of scripts and required Oracle directories.
- Shutdown of target database(s)
- Unmount of database filesystems
- FlashArray Protection Group Snapshot of source volumes and overwrite of target volumes using REST APIs
- Remount of database filesystems
- Startup of target database(s)
- Rename of database(s) using Oracle DBNEWID (NID)
- Rename of datafile and OS file systems
The Video
The post Automated Oracle Database Refresh with Workato appeared first on Ron Ekins' – Oracle Technology, DevOps and Kubernetes Blog.
