Skip to main content

Oracle EBS Lift and Shift from On-Premises to Oracle Cloud OCI using EBS Cloud Manager-Part 1 (Backup Module)

Oracle EBS Lift and Shift from On-Premises to Oracle Cloud OCI using EBS Cloud Manager-Part 1 (Backup Module)


Hello Everyone, In this post I am going to share how can we use EBS cloud Manager to do Lift and Shift from on-premises server to OCI based on my experience.


I am using my system on Virtual Box and taking it to OCI.
I will be using the public connectivity, but you can use dedicated IPSec tunnels for data transfer.

On-Prem Server:

Apps Version:12.2.10
DB Version 19c Multi tenant
DB Name: BEE
Host Name: funebs122.lab
Application and Database on same server



The on-premises servers must meet the following prerequisites:

  • NTP service configured on the on-premises application and database servers from which the backup will be taken.


  • wget library installed on the on-premises server where you plan to run the Oracle E-Business Suite Cloud Backup Module.
  • Latest Database Patch and Application Patches applied on the on-premises servers.
  • The networking team might need to allow a Swift URI or Object Storage URL on the on-premises E-Business Suite database server to push the backups to the Oracle Cloud Infrastructure Object Storage buckets.
  • Make sure ls inventory is working
  • Separate mount for or directory for Cloud Backup Tool installation
  • WLS Domain should not be locked
  • No Database Block Corruption should be there.
  • Database should in archive mode.
  • For demo purpose I have already setup and EBS Cloud Manager
  • During this process DB and application would keep running.

Steps:

1) Create stage directory and backup tool directory

Using root user
mkdir /cloudtool /backupoci /backupapp
chown oracle:dba /backupoci
chown applmgr:dba /backupapp


2) Install Cloud Backup Tool
Download  and keep the zip in /cloudtool and unzip

[root@funebs122 cloudtool]# ls -ltr
total 203348
drwxrwxrwx 3 root root        43 Dec  2  2021 33105050
-rwxrwxrwx 1 root root 208217567 Nov 29 15:53 p33105050_R12_GENERIC.zip

cd /cloudtool/33105050
chmod -R 777 33105050

3) Change to the RemoteClone directory on the backup module server, then run the EBSCloudBackup.pl script.

[applmgr@funebs122 RemoteClone]$ pwd
/cloudtool/33105050/RemoteClone
[applmgr@funebs122 RemoteClone]$ ls
3pt  cln.props    EBSCloudBackup.pl  flows         lib   ODBSOSSModule  Utils       validations
bin  ebsclone.pl  EBS-METADATA       FTMOSSModule  logs  session        Validation


Run the EBSCloudBackup.pl script using the following command.

I am running from applmgr user

$ perl EBSCloudBackup.pl


As an alternative, if the backup module server does not already have the required Perl version with the JSON module installed, you can run the script using the Perl binary provided in the Oracle E-Business Suite Cloud Backup Module patch files, with the following command.

$ 3pt/perl/bin/perl EBSCloudBackup.pl


If you are using an Oracle E-Business Suite application tier node or database tier node as the backup module server, note that you should not source the Oracle E-Business Suite environment before running the Oracle E-Business Suite Cloud Backup Module.

4) On the first screen, choose option 1, Create E-Business Suite Backup and Upload to Oracle Cloud Infrastructure.

============================================== 
 Migrate Oracle E-Business Suite - Options ============================================== 
 Migrate Oracle E-Business Suite - Enter Selection: 
1: Create E-Business Suite Backup and Upload to Oracle Cloud Infrastructure 
 2: Exit 
 Enter your choice from above list: 1



5) Next, indicate whether communication between the source database server and Oracle Cloud Infrastructure Object Storage takes place through a proxy and you need to specify the proxy details.
               ===========================================
               Enter Source Database Tier - Proxy Details
               ===========================================

[Ctrl-B: Back, Ctrl-H: Main Menu]

1: Yes
2: No

Enter your choice from above list: 2

6)  You will need to provide details for the database and application server. Also provide information related to backup. The Cloud user details has to be provide for the user with which EBS Cloud Manager is being setup.

7) A Summary would be displayed as below

=========================================
Migrate Oracle E-Business Suite - Review
=========================================
[Ctrl-B: Back, Ctrl-H: Main Menu]


Mode                           : BMCS_CDB
Source Database Details:
 Host Name                      : funebs122.lab
 OS User Name                   : oracle
 Stage Directory                : /backupoci
 Context File                   : /oraapps122/DATABASE/BEE/19c/appsutil/BEE_funebs122.xml
 OS Time Zone                   : Asia/Kolkata

Source Application Tier Details:
 Hostname                        : funebs122.lab
 OS User Name                    : applmgr
 Stage Directory                 : /backupapp
 Context File                    : /oraapps122/APPS/BEE/fs2/inst/apps/BEE_funebs122/appl/admin/BEE_funebs122.xml

OSS - Backup Details:
 Backup Identifier Tag                        : bee
 Backup Thread Count                          : 1
 Backup Archive Type                          : tgz

Oracle Cloud Infrastructure Details:
 Oracle Cloud User OCID                        : ocid1.user.oc1..aaaaaaaatofmolvlijg4azsoypgoxvnk77olmhwxn72whioof2jlws3ug2iq
 Oracle Cloud Fingerprint                      : 98:fe:1d:16:a4:e5:02:57:74:9b:f4:1e:db:a0:05:d5
 Oracle Cloud Tenancy OCID                     : ocid1.tenancy.oc1..aaaaaaaa6t2hb4hut3nde4luzi6xelomsgkksar42w7o6tydf5fdkkkz2ieq
 Oracle Cloud Region                           : ap-hyderabad-1
 Oracle Cloud Tenant Name                      : funoracleappsportal
 Oracle Cloud Compartment OCID                 : ocid1.compartment.oc1..aaaaaaaampr6y6afm3oq6cz2fzu6jfvnllwpfvqioa5md2xc5taz5h34dpfa
 Target Database Type                   : VM DB System

=============================
Proceed With Selected Action
=============================
 [Ctrl-B: Back, Ctrl-H: Main Menu]
 1: Yes
 2: No
 Enter your choice from above list: 1
 Running : ebsclone.pl -validate
Reading properties file /cloudtool/33105050/RemoteClone/cln.props
Following attributes will be encrypted [APPS_PASS, BACKUP_ENCRYPTION_PASS, OS_PASSWORD.SRC.APPS, OS_PASSWORD.SRC.DB, WLS_ADMIN_PASS]
Validation is in progress...
EBS cloud backup basic validation log is available in /cloudtool/33105050/RemoteClone/session/91D81927EAF17E028C43A6F0CE5AE538/logs/29112022192121/basicValidations.log
EBS Apps tier validation log is available in /cloudtool/33105050/RemoteClone/session/91D81927EAF17E028C43A6F0CE5AE538/logs/29112022192121/appsTierEBSValidation.log
Tue Nov 29 19:23:12 2022> Validating Application tier diskspace 
Validating Application tier diskspace  successful [Time taken: 1 Minute, 43 Seconds]
Tue Nov 29 19:24:55 2022> Validating WLS Domain Size 
Validating WLS Domain Size  successful [Time taken: 7 Seconds]
Tue Nov 29 19:25:02 2022> Validating database connection 
Validating database connection  successful [Time taken: 7 Seconds]
Tue Nov 29 19:25:09 2022> Validating Oracle Weblogic AdminServer status 
Validating Oracle Weblogic AdminServer status  successful [Time taken: 14 Seconds]
EBS DB tier validation log is available in /cloudtool/33105050/RemoteClone/session/91D81927EAF17E028C43A6F0CE5AE538/logs/29112022192121/dbTierEBSValidation.log
Tue Nov 29 19:26:35 2022> Validating Database tier diskspace 
Validating Database tier diskspace  successful [Time taken: 1 Minute]
Tue Nov 29 19:27:35 2022> Validating database connection 
Validating database connection  successful [Time taken: 7 Seconds]
Tue Nov 29 19:27:43 2022> Validating source database version
Validating source database version successful [Time taken: 5 Seconds]
Tue Nov 29 19:27:48 2022> Validating if archivelog is enabled on source DB
Validating if archivelog is enabled on source DB successful [Time taken: 5 Seconds]
Infra validation log is available in /cloudtool/33105050/RemoteClone/session/91D81927EAF17E028C43A6F0CE5AE538/logs/29112022192121/infraValidation.log
Tue Nov 29 19:28:55 2022> Validating Application tier BMCS credential 
Validating Application tier BMCS credential  successful [Time taken: 14 Seconds]
Tue Nov 29 19:29:10 2022> Validating PrivateKey and Fingerprint in sync...
Validating PrivateKey and Fingerprint in sync... successful [Time taken: 5 Seconds]
Tue Nov 29 19:29:15 2022> Validating Time Drift between objectstorage endpoint and Application tier 
Validating Time Drift between objectstorage endpoint and Application tier  successful [Time taken: 10 Seconds]
Tue Nov 29 19:29:27 2022> Validating Database tier BMCS credential 
Validating Database tier BMCS credential  successful [Time taken: 14 Seconds]
Tue Nov 29 19:29:41 2022> Validating bucket beeDB existence checking 
Validating bucket beeDB existence checking  successful [Time taken: 19 Seconds]
Tue Nov 29 19:30:00 2022> Validating PrivateKey and Fingerprint in sync...
Validating PrivateKey and Fingerprint in sync... successful [Time taken: 5 Seconds]
Tue Nov 29 19:30:06 2022> Validating bucket beeGeneric existence checking 
Validating bucket beeGeneric existence checking  successful [Time taken: 19 Seconds]
Tue Nov 29 19:30:26 2022> Validating PrivateKey and Fingerprint in sync...
Validating PrivateKey and Fingerprint in sync... successful [Time taken: 4 Seconds]
Tue Nov 29 19:30:30 2022> Validating Time Drift between objectstorage endpoint and Database tier 
Validating Time Drift between objectstorage endpoint and Database tier  successful [Time taken: 11 Seconds]
Use of uninitialized value $databaseReleaseUpdate in concatenation (.) or string at Validation/bmcs/EBSLiftBMCSCDBValidation.pm line 140.
 Running : ebsclone.pl -skipValidation
Reading properties file /cloudtool/33105050/RemoteClone/cln.props
###########################################################################################
#            Oracle E-Business Suite Release 12.2
#            Oracle E-Business Suite Cloud Backup Module Version: 21.1.1.2
# 
# Mode = BMCS_CDB
# This utility will package an Oracle E-Business Suite installation
# and transfer the backups to an Oracle Object Storage bucket.
#
###########################################################################################

it took me around 5 hrs to complete the backup and upload it to OCI object storage.

8) Once Backup is completed we can see backup on EBS Cloud Manager.



Buckets is also created where the backup data is kept.



In Next part of blog I will show how to create an instance from this backup using EBS Cloud Manager.


Reference:
https://docs.oracle.com/cd/E26401_01/doc.122/f35809/T679330T679342.htm



If you like please follow and comment
Labels:

Comments

Post a Comment

Popular posts from this blog

WebLogic migration to OCI using WDT tool

WebLogic migration to OCI using WDT tool Oracle WebLogic Deploy Tool (WDT) is an open-source project designed to simplify and streamline the management of Oracle WebLogic Server domains. With WDT, you can export configuration and application files from one WebLogic Server domain and import them into another, making it a highly effective tool for tasks like migrating on-premises WebLogic configurations to Oracle Cloud. This blog outlines a detailed step-by-step process for using WDT to migrate WebLogic resources and configurations. Supported WLS versions Why Use WDT for Migration? When moving Oracle WebLogic resources from an on-premises environment to Oracle Cloud (or another WebLogic Server), WDT provides an efficient and reliable approach to: Discover and export domain configurations and application binaries. Create reusable models and archives for deployment in a target domain. Key Pre-Requisites Source System: An Oracle WebLogic Server with pre-configured resources such as: Applica...
Post a Comment
Read more

Rename a PDB in Oracle Database Multitenant Architecture in TDE and Non TDE Environment

Rename a PDB in Oracle Database Multitenant Architecture I am sharing a step-by-step guide to help you rename a PDB. This approach uses SQL commands. Without TDE or encryption Wallet Initial Check Check the Current Database Name and Open Mode: SQL > SELECT NAME, OPEN_MODE FROM V$DATABASE; NAME OPEN_MODE --------- -------------------- BEECDB READ WRITE List Current PDBs: SQL > SHOW PDBS; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 FUAT READ WRITE NO We need to RENAME FUAT to BEE  Steps to Rename the PDB Step 1: Export ORACLE_SID Set the Oracle SID to the Container Database (CDB): export ORACLE_SID=BEECDB Step 2: Verify Target PDB Name Availability If the target PDB name is different from the current PDB name, ensure no service exists with the target PDB name. Run SQL to Check Exi...
Post a Comment
Read more

How to make flash work on IE or Edge with IE Compatibility

How to make flash work on IE or Edge with IE Compatibility With flash been ended from 1-Jan-2021, many applications using flash have stopped working the way they were built (like OEM, OBIEE, etc). The option you have to upgrade.  This method will give a workaround in IE or Edge in IE compatibility mode without upgrading. 1. Verify you have installed flash.ocx on your desktop. Typically, flash.ocx file is located in C:\Windows\System32\Macromed\Flash or C:\Windows\SysWOW64\Macromed\Flash according to your laptop OS system. 2. Edit mms.cfg from the location as a System Administrator In the case of the 64bit system, it might have mms.cfg under C:\Windows\SysWOW64\Macromed\Flash 3. Add below options into mms.cfg file. Note: AllowListUrlPattern list is an example. The URLs need to be replaced to your hosts those have Flash pages. SilentAutoUpdateEnable=0 AutoUpdateDisable=1 EOLUninstallDisable=1 EnableAllowList=1 AllowListUrlPattern=http://www.google.com/ AllowListUrlPattern=http://goo...
Post a Comment
Read more