[FIXED] Migration From On-Premise To Cloud Failed While Restoring Control File

This blog post covers the Restore CONTROLFILE issue & fix which I have encountered while creating EBS R12 Instance on OCI from the On-premise backup using EBS Cloud Manager which is a required step for performing the Lift & Shift to Oracle Cloud Infrastructure.

• To know more about migrating On-Premise Oracle E-Business Suite R12 To Oracle Cloud Infrastructure (OCI), check here.
• If you don’t have the idea of what is EBS Cloud Manager, then check here
• To know more about Migration To Cloud please refer to these blogs Oracle Database Migration to Cloud & Oracle Zero Downtime Migration
• To know more about the latest version of EBS Cloud Manager, check here

Background/Cause

To do Migration from On-premise to Cloud you first need to install the Database Backup Module On-premise then there are few steps you need to follow:

1. EBS Clone for Cloud Migration needs to be configured on the Source side (On-Premises Instance).
2. Then you need to take the backup.
3. Finally, using EBS Cloud Manager you need to restore the backup.

While doing the Lift & Shift of Oracle EBS R12 on OCI, Successfully taken the backup of On-Premise EBS to OCI. Now, next is to create the EBS from the Backup which we have taken.

Do Check: Our Blog Post on Provision EBS R12 On OCI

Once entered all the details, submit it & the Installation will Start

After a few minutes, we were hitting an error and the installation got failed.

Issue Encountered

10.0.83.18 ================================================================================
10.0.83.18 Error executing action `run` on resource ‘execute[20200218_14-01-49 : Restore CONTROLFILE from source backup : exit]’
10.0.83.18 ================================================================================
10.0.83.18
10.0.83.18 Mixlib::ShellOut::ShellCommandFailed
10.0.83.18 ————————————
10.0.83.18 Expected process to exit with [0], but received ‘1’
10.0.83.18 —- Begin output of status=$(cat /u01/install/APPS/scripts/out/20200218_14-01-49.status) ; rm /u01/install/APPS/scripts/out/20200218_14-01-49.status ; exit $status —-
10.0.83.18 —- End output of status=$(cat /u01/install/APPS/scripts/out/20200218_14-01-49.status) ; rm /u01/install/APPS/scripts/out/20200218_14-01-49.status ; exit $status —-
10.0.83.18 Ran status=$(cat /u01/install/APPS/scripts/out/20200218_14-01-49.status) ; rm /u01/install/APPS/scripts/out/20200218_14-01-49.status ; exit $status returned 1

Fix: Upgrade EBS Cloud Manager

For this issue, we raised an SR with Oracle Support and by checking the logs, they asked us to update the version of EBS Cloud Manager to the lastest one (20.1.1) as we had taken the backup from the EBS Cloud Manager(19.3.1) which was the older version. Below are the steps to upgrade EBSCM.

Steps To Upgrade EBSCM

1) Upgrade to the latest EBS Cloud Manager version, Run the Self Update Utility

To use the Self Update utility, perform the following steps:

1. Connect to the Oracle E-Business Suite Cloud Manager VM via SSH and switch from the opc user to the oracle user:

sudo su – oracle

2. Run the Self Update utility as follows:

cd /u01/install/APPS/apps-unlimited-ebs/bin

perl selfUpdate.pl

2) Now, to ensure all the services are up & running run

configure.pl

After upgrading the version, we are able to successfully create the EBS using the on-premise backup.

To know what all hands-on guides we cover in our Build, Manage & Migrate EBS (R12) On Oracle Cloud (OCI) training Program, click here.

I hope you find the post useful in troubleshooting  “Error Occurred While Creating EBS R12 Instance From backup taken On-premise Using EBSCM“. if you like the post don’t forget to share with your friends and colleague and post your doubts in the comment section.

Related/Further Readings

If you are just a beginner to Oracle cloud, then check our below posts to start your journey:

• Creating a Backup of an On-Premises Oracle E-Business Suite Instance on Oracle Cloud Infrastructure
• 2434500.1  Deploying Oracle E-Business Suite Cloud Manager on Oracle Cloud Infrastructure
• [Video] Oracle EBS R12 on Cloud For Beginners: 7 Things You Must Know
• April 2019 EBS Cloud Manager Updates(19.1.1)
• Oracle EBS (R12) on Cloud (OCI) Beginners: 15 Things Apps DBAs Must Know
• [Video] Role of Oracle Apps DBA (EBS) R12 On Cloud
• Oracle EBS Cloud Manager: New Release (20.1.1) Is Now Available

Next Task For You

Join our FREE Masterclass on Build, manage & Migrate EBS R12 to Cloud For Beginners. Click on the image below to register for FREE