Migrating Oracle DB from On-Premise to OCI

Overview

Covid-19 has caused many, if not most, of technology professionals and organizations to work remotely to avoid any further spread of the virus. As a result, technology departments of organizations are looking to develop solutions and services to effectively manage teleworkers by using insights into location, availability, contracts, reasons, and distribution data by geography, by work status, by the department, by job code and more. Database-as-a-Service (DBaaS) describes a cloud-based, self-service model for deploying databases and database applications to end users without requiring a considerable amount of effort from IT staff, DBA, or an Application team to deploy or manage the database instances.

Benefits of Oracle Database Cloud Service

Enterprises are demanding the simplicity, flexibility, elimination of duplication, and agility of the cloud while keeping their options open on where to run the workloads. The same goes for databases; they want the cloud operational simplicity of service without restricting their platform choices.

DB as service includes diverse data management, user and role management, styles, localization, and more.

Key Benefits

• Make changes in minutes not months
• Save up to 80% over traditional contact center solutions
• Easily scale to meet unpredictable demand
• Flexibility and agility
• “Only pay for what you use”

Database Services Available

DbaaS on VM

Basing a DBaaS reference architecture on VMware versus Realize Automation gives robust architecture for running a DBaaS solution. This accelerates the deployment and management of applications and computes services, thereby improving business agility and operational efficiency.

Automation on Cloud with DbaaS

DbaaS creates and runs as many tasks as possible to ensure everything is working properly for both pre-shift and post-shift. Also, making sure certain tasks continue to run regularly in order to identify the steps taken while monitoring them and quickly discovering if anything has broken previous work completed.

Elasticity

DBaaS combines cloud orchestration and automation with turnkey DBA services delivering a secure, performance-rich, multi-cloud experience with high availability and on-demand scale with high scalability.

Backup

Backing up your Database Cloud Service (DBaaS) instances can protect the instance software, configuration and database against loss if a failure occurs. When restoring an instance from a backup, you can restore the instance software, configuration, and database to its original state at the time of the backup.

Auto backups can be enabled from OCI console and the backups will be taken and stored into OCI object storage, please refer to the visual below:

Self-Service Provisioning

Database Self Service Portal, users can select a service template that closely resembles their requirements which identifies the size and configuration of the database to be created.

Patching:

From the OCI Console, select the database to be patched and click on database node name and patching can be done using on click from OCI Console. Patching is done after performing the pre-check and finally clicking on the Patching button

Minimum Requirements for PeopleSoft Cloud Manager

Listed below are the minimum requirements for installing PeopleSoft Cloud Manager.

• The minimum Apps version is 9.2.
• The minimum PeopleTools version is 8.55.12. For provisioning COBOL and Elasticsearch, the minimum tools version is 8.55.13.
• The minimum shape of the Cloud Manager is oc1m.
• The minimum file server capacity is 250 GB.

Migration Options and Approach

When Migrating to Oracle Cloud Infrastructure there are several distinct strategies that you can consider as high-level strategies for planning migration and requirements.

Details listed below will explain the migration option and approach you want to take.

Conclusion

As you can see, the benefits of using the Cloud Manager enables time-saving and cost-saving options.

• Provision PeopleSoft environments on Oracle Compute Cloud and Oracle Database Cloud Services.
• Orchestrated deployment of PeopleSoft 9.2 Applications on Oracle Cloud.
• Subscription model to auto-download application PIs and PRPs.
• Automated migration of on-premise environment to Oracle Cloud.
• Create repeatable deployment templates.
• Self-service provisioning of PeopleSoft environments.
• Fully automated deployment which is immune to manual errors and process delays.
• Manage multiple environments from a single page.
• Perform on-demand health checks on environments.
• Enable application life-cycle management in Oracle Cloud.
• Clone environments by creating templates from running instances.
• Access to log files through UI for easy troubleshooting.

Ready to get started with planning your journey to OCI? Schedule a meeting with an Astute team member.