LogoLogo
  • Welcome
  • Overview
    • Architecture
      • API Server
      • Sizing
    • Dashboard Overview
    • Monitoring Concepts
      • Application Performance Management
        • Availability Monitoring
        • Performance Intelligence
        • Service Level Management
        • Synthetic Transaction Management
        • Alerts Management
        • Reporting & Analytics
      • Infrastructure Monitoring
      • Unified Monitoring
    • Automation Concepts
      • Definition of Terms
      • Infrastructure as Code
        • Project Structure and Organization
        • Setting Up IaC Environment
        • Infrastructure Provisioning
        • Configuration Management
      • SAP Basis Automation
      • Automated Migration
  • User Guide
    • Onboarding
    • Setup
      • Gateway Setup
        • Gateway Network Setup
        • IT-Conductor Gateway Setup on Windows
        • IT-Conductor Gateway Setup on Linux
        • IT-Conductor Gateway Setup on AWS
        • IT-Conductor Gateway Setup on Azure
        • IT-Conductor Gateway Setup for SAP Secure Network Communications (SNC)
      • API Server Setup
      • MSP Tenant Setup
      • SSO Setup
        • Azure ADFS Identity Provider
        • Azure Active Directory (AAD) App Gallery
    • Monitoring
      • General
        • Maintenance Mode
          • Manual Maintenance
          • Scheduled Maintenance
        • Central Syslog Server Monitoring
        • URL Monitoring Locations
      • Cloud Monitoring
        • AWS Monitoring
        • Microsoft Azure Monitoring
      • Database Monitoring
        • IBM DB2 Database Monitoring
        • Microsoft SQL Server Monitoring
        • Oracle Database Monitoring
        • SAP HANA System Monitoring
          • SAP HANA Scale-Out Monitoring
          • SAP HANA Overview Dashboard
          • SAP HANA Alert Management
        • SAP ASE Database Monitoring
        • SAP MaxDB Monitoring
        • HA/DR Monitoring
      • Infrastructure Monitoring
        • File Server Monitoring
          • File Watcher Monitoring
        • Git Server
        • OS Monitoring
          • Unix/Linux System Monitoring
            • Linux Network Interface Monitoring
            • OS Printer Monitoring
          • Windows System Monitoring
            • WinRM Adapter Configuration
              • WinRM Services Configuration
              • Domain User Access
              • WMI Namespace Access
              • Windows Service Configuration
        • VMWare vCenter Monitoring
      • SAP Monitoring
        • Business Process Monitoring
          • Business Process Composer
          • BDoc Monitoring
          • IDoc Monitoring
        • SAP BusinessObjects Monitoring
          • SAP BO Data Services Monitoring
        • SAP Cloud Connector Monitoring
        • SAP Host Agent Monitoring
        • SAP NetWeaver Monitoring
          • SAP ABAP System Monitoring
            • SAP Transports
            • Security Role Import
            • SAP ABAP Overview Dashboard
            • SAP CCMS Alert Monitoring
            • SAP Batch Jobs Monitoring
              • SAP Batch Job Monitoring for CCMS Alerts
              • Advanced SAP Batch Job Monitoring
            • SAP SLT & RFC Connection Monitoring
            • Print Spooler Monitoring
            • Workload Monitoring
              • Transaction Code Monitoring
              • SAP Workload Monitoring
          • SAP J2EE System Monitoring
            • SAP J2EE Monitoring Role
            • Keystore Views and Certificates Monitoring
            • SAP PO Application Monitoring
          • SAP Systems Administrator Panel
        • SAP Web Dispatcher Monitoring
        • LMDB Discovery
        • Team-Based Central SAP Download Manager
    • Automation
      • Migration
        • Oracle to AWS Migration
        • Oracle to ASE Migration
        • SAP on MSSQL to AWS Migration
        • S/4HANA to Cloud Migration
      • E2E System Refresh Automation
        • Frequently Asked Questions
      • Age-based HANA Backup Automation
      • Inbound/Outbound Queue Restart Automation
      • OS File System Cleanup Automation
      • OS Linux Pacemaker Cluster Error Management
      • OS Printer Queue Restart Automation
      • OS Linux Kernel Patching using ChAI
      • OS Linux System Reboot using ChAI
      • SAP Batch Job Restart on Error
      • SAP Kernel Update using ChAI
      • SAP HANA Account Activation using ChAI
      • SAP Transports using ChAI
        • Frequently Asked Questions
      • SAP User Unlock and Password Reset Automation
      • Start/Stop Automation
    • Reporting
      • Available Reports
      • Creating Reports
        • Service Health KPI Report
      • Scheduling Reports
        • Automated HANA Reports
      • Report Elements
      • Archived Alerts Reporting
    • Account Administration
      • Invite Users
      • Create Robot Users
      • Update Linux System Account Password After Expiration
    • Notifications
      • Alerts
      • Threshold Overrides
        • Threshold Overrides Variables
      • Notification Targets
      • Distribution Lists
      • Subscriptions
      • Custom SMTP Notification Providers
      • Integration Providers
        • Derdack EA Integration
        • ilert Integration
        • Jira Service Desk Integration
        • Microsoft Teams Integration
        • PagerDuty Integration
        • Slack Integration
      • On-Call Scheduling
      • Calendar Events
    • Diagnostics
      • Gateway Communication Dump Debug Mode
      • Running IT-Conductor Gateway from CLI
      • SAP CCMS Missing Data
    • IT-Conductor FLUX
    • SID-Refresh
      • Product Overview
      • Getting Started
      • Documentation
      • Release Notes
      • Frequently Asked Questions
      • Troubleshooting Guide
        • Component CRM_MIDDLEWA_CRM - CRM Middleware Configuration
        • Failure to Start the Java-based GUI
        • Inconsistencies found in the table TADIR
        • Java-based GUI Runs with Pixelated Fonts
        • No email message is created after sending an email in SO01
        • Program Run as root
        • SICF Wrong Credentials
        • SU01: Error in user management
        • External Resources
      • Pricing
  • Release Notes
    • Gateway
  • References
    • Open-Source Software
    • Support
Powered by GitBook
On this page
  • Process Definition
  • Video
  1. User Guide
  2. Automation
  3. Migration

Oracle to AWS Migration

PreviousMigrationNextOracle to ASE Migration

Last updated 8 months ago

Migrating Oracle databases to the AWS cloud through IT-Conductor can be accomplished using a process definition. This automation feature in the platform simplifies the migration process from the provisioning of virtual machines (VMs) in the cloud environment to the installation of the application server on AWS.

Process Definition

To access the process definition developed for this demo scenario, navigate to the Tenant Service Grid → Process Definitions → Migrate Oracle to AWS.

Also, we used our tenant called “OZSoft” but the process can be cloned and applied to any customer after being onboarded to IT-Conductor as a tenant. IT-Conductor creates and clones the Git repository for each tenant who needs to leverage these types of automation runbooks.

Now, let's look into each step/activity of this process definition in detail.

Provision AWS VM

In this activity, a VM will be provisioned in AWS via Terraform script. Below is a sample terraform script.

module "common_infrastructure" {
  source              = "./modules/common_infrastructure"
  infrastructure      = var.infrastructure
  vms                 = var.vms

}


module "vms" {
  source              = "./modules/vms"
  infrastructure      = var.infrastructure
  vms                 = var.vms
  subnet_mgmt         = module.common_infrastructure.subnet_mgmt
  sshkey              = var.sshkey

}

# Generate output files
module "output_files" {
  source              = "./modules/output_files"
  infrastructure      = var.infrastructure
  vms                 = var.vms
  aws_instances       = module.vms.aws_instances
  sshkey              = var.sshkey
  
}

In the execution log below, you can see that the following resources are created:

  • local_file

  • aws_ebs_volume

  • aws_instance

  • aws_volume_attachment

Once the VM is deployed, we need to update the IP address (of the newly deployed VM) in the /oracle_hosts.yml file.

Prepare Oracle VM

In this activity, the Oracle database files required for the migration will be installed and configured.

Below are the tasks that will be performed upon execution:

  • Ensure Storage Management software is installed

  • Create disk Partitions

  • Create or extend Volume Groups

  • Create Logical Volumes

  • Create File Systems

  • Mount and make fstab entries

  • Update host files

  • Stop/disable firewalld

  • Enable ssh access through password

  • Restart SSHD

  • Mount network share

  • Update sysctl.conf

  • Run sysctl command

  • Deploy 99-sap.conf file

  • Deploy inifile.ora_user.params file

  • Start SWPM

  • Make /oracle/OOO/121 directory

  • Make /oracle/stage/121 directory

  • Create Symbolic link

  • Deploy db_OOO.rsp file

  • Change permission for /oracle

Install Oracle

In this activity, Oracle SAR files will be extracted, the environment for DB_SID will be set, and Oracle RDBMS will be installed.

Patch Oracle

After installing Oracle RDBMS, the MOPatch needs to be updated.

In this activity, the following tasks will be performed:

  • Set env OHRDBMS

  • Set env IHRDBMS

  • Set env SBPFUSER

  • Move OPatch

  • Unzip OPatch

  • Unzip sapbundle

  • Move MOPatch

  • Apply MOPatch

Primary Server Setup (On-prem)

In this activity, the log mode will be checked.

SELECT log_mode FROM v$database

If the database is in the archive log mode, then it will get log_size from v$log.

Otherwise, it will first switch to the archive log mode and then initialize the parameter.

During the task Modify Initialize Parameters, the SET STANDBY_FILE_MANAGEMENT will be set into AUTO.

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;

Standby Server Setup

In this activity, the Standby DB server will be set up. Below are the tasks that will be performed upon execution:

  • Make DBS directory

  • Make parameter file

  • Update param file

  • copy listener.ora

  • copy tnsnames.ora

  • Stop DB

  • Start DB

  • Check with tnsping ozooo with command

  • Check with tnsping ozooo-dg with command

  • Make password file

Enable Broker (AWS)

In this activity, the enable_broker.sh file will be deployed using the following command:

sudo su - oraooo -c 'sh /tmp/enable_broker.sh

Enable Broker SQL (On-prem)

In this activity, the following SQL command will be used to enable the broker on the source on-prem server:

ALTER SYSTEM SET dg_broker_start=true;

Enable Broker Data Guard (On-prem)

In this activity, the data guard broker configuration will be removed by running a shell script that can be executed by ora<sid> user.

---

- hosts: vms-linux
  gather_facts: false
  become: true
  become_user: root
  roles:
    - role: on-prem/remove-broker

Remove Broker (AWS)

In this activity, the broker will be removed from the AWS server.

---

- hosts: vms-linux
  gather_facts: false
  become: true
  become_user: root
  roles:
    - role: remove-broker

Remove Broker Data Guard (On-prem)

In this activity, the broker data guard will be removed from the on-prem server.

---

- hosts: vms-linux
  gather_facts: false
  become: true
  become_user: root
  roles:
    - role: on-prem/enable-broker

Remove Broker SQL (On-prem)

In this activity, a SQL command will be used to remove brokers on the on-prem server.

alter system set dg_broker_start=false scope=both;

alter database drop standby logfile group 10;
alter database drop standby logfile group 11;
alter database drop standby logfile group 12;
alter database drop standby logfile group 13;

Install App Server (AWS)

In the final activity, the application servers will be installed.

Below are the tasks that will be performed upon execution:

  • Stop DB

  • Delete listener.ora

  • Delete tnsnames.ora

  • Copy initOOO

  • Copy spfileOOO

  • Deploy change_db_role.sh file

  • Run change DB role query

  • Install SAP APP Instance

End

Video

Figure 1: Migrate Oracle to AWS Process Definition (Initial State)
Figure 2: Provision VM Execution Log
Figure 3: Prepare Oracle VM Execution Log
Figure 4: Install Oracle Execution Log
Figure 5: Patch Oracle Execution Log
Figure 6: Primary Server Setup Subprocess
Figure 7: Standby Server Setup Execution Log
Figure 8: Enable Broker (AWS) Execution Log
Figure 9: Enable Broker SQL Execution Log
Figure 10: Remove Broker (AWS) Execution Log
Figure 11: Remove Broker SQL Execution Log
Figure 12: Migrate Oracle to AWS Process Definition (End State)