Migrating JD Edwards EnterpriseOne Release 9.2 to Oracle Cloud for Linux

Purpose

This tutorial provides instructions for migrating your JD Edwards EnterpriseOne data from an on-premises system with Oracle database on Linux to Oracle Cloud.

Time to Complete

1-2 Hours

Note that this estimate completion time is not the elapsed time. That is, it does not account for machine runtime functions.

Background

Currently, the Oracle Cloud Migration Utility only supports the migration of a single pathcode from your on-premise environment to the Compute Service instance environment. You can only run this process a single time from end to end.   However, you do have the option to import from one on-premise pathcode to a different pathcode on the Compute Service instance.  For example:  you can export your on-premise PD920 environment and import to DV920 on the Compute Service instance.  The utility has scripts packaged within the database migration that will synchronize the database records accordingly. 

Before starting the Migration process, make sure all traditional objects are checked in for the pathcode you plan to migrate.  Project information will not be migrated to the Compute Service instance. User Defined Objects (UDOs) that are reserved to a real project, will be moved to the users default project at the end of the migration process.

The Oracle Cloud Migration Utility can only be used if the on-premise environment is running at least tools release 9.2.0.1 with applications 9.2 and higher.   Once the migration is complete, your cloud compute instance will be running the same applications release as your on premise environment.

Supported on-premise environment:

• Enterprise One Applications release 9.2 and higher

• Enterprise One Tools 9.2.0.1

Note: It is recommended that you load the media objects to the database by setting up and running R98MODAT prior to running the migration export for tools releases 9.2.1 and higher. For tools releases prior to 9.2.1, you need to downgrade the Oracle Cloud environment to the same release as the on-premise tools release and reset F00942T for the applicable path codes prior to running the import part of the migration. See Uploading Media Object Files to Database in the JD Edwards EnterpriseOne Tools Runtime Administration Guide.

• Oracle database on Linux

The Deployment Server migration will be performed by the Oracle Cloud Migration Utility and database scripts. The Oracle Cloud Migration Utility is deployed using Change Assistant. The migration has the following two parts:

1. Export – execution on the on-premise Deployment Server and Database Server.
2. Import – execution on the Deployment Server and Database Server on the Compute Service instance.
   

The Oracle Cloud Migration Utility export process exports system table data and pathcode folders (Solution Explorer, media objects, source, include, res, java). While the database scripts export Business Data and Shared Data (for example: Object Librarian and Data Dictionary).

The import process imports the system table data as Append Only and F9860W, F9861W data as Replace Table along with Business Data and pathcode folder structures on the Deployment Server.

The current deliverable is called JDE_9.2_Migration_Utility_3.1_for_Linux (JDE_OPC_Migration_3.0.par) and can be downloaded from the Oracle JD Edwards EnterpriseOne Update Center. To locate this deliverable in the Update Center, select JD Edwards EnterpriseOne from the Type field in the Search tab, and then enter the name of the migration utility in the Search for Name field.

In this tutorial you will:

• Execute Oracle Cloud Migration Utility on on-premise Deployment Server.
• Run export script on the on-premise Database Server.
• Execute Oracle Cloud Migration Utility on the Deployment Server on the Compute Service instance.
• Run import script on the Database Server on the Compute Service instance.
  

What Do You Need?

To perform the steps in this tutorial, you must have:

• A subscription to Oracle Cloud. You must be a user with the Compute Operations role. For more information, see How to Begin with Oracle Compute Cloud Service Subscriptions in Using Oracle Compute Cloud Service.
• Verified the database size on the Compute Service instance is large enough for the import and that database configuration / parameters are validated or tuned for your business needs (for example: max extend and extend size parameters).
• Created a JD Edwards EnterpriseOne Multi Tier Deployment on Oracle Compute Cloud Instances. See the Multi Tier or One-Click Provisioning OBEs for more information.
• Installed the latest Change Assistant on the on-premise Deployment Server and the Deployment Server on the Compute Service instance.
• Downloaded the JDE_OPC_Migration_3.0.par from the Oracle JD Edwards EnterpriseOne Update Center.

• TLOPCV3_20_99.par (Move this file to the on-premise Deployment Server.)
• Export folder with export scripts (Move this folder to the on-premise Database Server.)
• Import folder with import scripts (Move this folder to the Database Server on the Compute Service instance.)
• Verified you can execute the following command on the source and destination machines;<dbuser>/<dbpass>@<netname> .
  

The Deployment Server migration migrates pathcode files (source, include, res, java, Solution Explorer,and media objects) from the on-premise Deployment Server to the Deployment Server on the Compute Service instance.

1. Start Change Assistant on the on-premise Deployment Server.
2. Expand the Work with Packages tree node and select Downloads.
3. Select Cloud Migration Utility (TLOPCV3_20_99.par) from within Change Assistant.
4. Select New Batch Deploy.
5. Verify the Batch Information dialog box and click OK.
6. Sign in to the JDEPLAN environment.

After initialization, Cloud Migration Utility – Export displays, indicating what actions are performed.

7. After reviewing the actions, click Next.

8. On Object Path Search & Select, select a pathcode to export.
9. On Deployment Synchronization Warning, select Synchronize CNC Data Now (R9840C/XJDE0002).

10. Verify the Copy System/Plan Information Report (R9840C/XJDE0002) has Completed Normally in the Result column.

11. On Work With Environment Data Sources, select the environment to copy from and click Add.
12. Select Include Pathcode Files and Include System Data, and then click Next.
    

13. Review the reports generated during the export of the system tables and ensure they were successful.

14. The Save & Exit, Export dialog box signals the end of the export process for the On-premise Deployment Server. Review the listed tasks and click Save and Exit.
    

15. On the Confirm dialog box, click Yes.
    

Note: At this point a batch has been created in Change Assistant.

16. Return to Change Assistant, select the Work with Batches tree node.
17. Select your batch and click Export to jar.
18. Indicate a name and location to save the .jar file, and click Save.
19. On the Select Deployment Location dialog box, click Cancel.
20. Transfer the .jar file to the Deployment Server on the Compute Service instance.
21. Exit Change Assistant.

The export.sh script exports data from the on-premise database into dump files, which can be moved to the Database Server on the Compute Service instance.

1. Navigate to where you downloaded the export files on the on-premise Database Server (for example: /u01/scripts).
2. Edit the exp_set file with your information.



 


Field	Description
PATHCODE_PREFIX	The pathcode to export. Valid values are:PY, PD, DV, and PS.
PATHCODE_RELEASE	The patchode to export. Valid values are: 920 and above.
SHARED	Export data dictionary and object librarian schemas. YES, must be used for migration.
DUMP_DEST	The full path where you want the database dump files created. *Ensure the directory exists*
DBUSER	The database user with privileges to the tablespaces being exported (for example:system).
DBPASS	The password for the DBUSER.
NETNAME	The TNS name for the database (for example: orcl).

3. Save and close exp_set.
4. Run export.sh.
5. Verify “successfully completed” is found in all generated log files and .dmp files were successfully created in the specified location.
6. Transfer the .dmp files to a folder on the Database Server on the Compute Service instance for importing in a later step.

Import the .jar file with Change Assistant on the Deployment Server on the Compute Service instance.

Note: Verify that the ActivConsole is not running.

1. Create a new folder on the Deployment Server on the Compute Service instance (for example: /Change Assistant/downloads/ new folder)
2. Access Change Assistant from the Deployment Server on the Compute Service instance.
3. In Change Assistant, select the Work with Batches tree node.
4. On the tool bar click the Import from jar button.
5. In the Import Batch From dialog box, navigate to your jar file and then click Open.
6. On the Import Batch To dialog box, navigate to the Change Assistant downloads directory on the Deployment Server on the Compute Service instance, and then click Open.

6. Verify the Batch Information dialog box and click OK.
7. Sign in to the JDEPLAN environment.
8. On the Save & Exit, Export dialog box, click Next.
9. On Deployment Server Import, read the tasks that will be performed by the import and then click Next.

   

10. On Object Path Search & Select, select the pathcode to import to. If the release of the selected pathcode does not match the release of the on-premise instance, you will get the following error:

    

11. On Deployment Synchronization Warning, de-select Synchronize CNC Data Now (R9840C/XJDE0002) and Work with Environment Data Sources? (GH9611/P98503)?* then click Next.

12. On Backup Options select Include Pathcode files and Include System Data, and then click Next.
13. Review the backup reports for success.

14. On Import Options select to Include Pathcode files and Include System Data, and then click Next.
15. Review the import reports for success.

Note: If you are importing to a 9.2.0.x tools release, there may be "Open XML failed" messages in the reports for tables F00942T and F98MODAT, as they do not exist prior to the 9.2.1.x tools release.

16. Review the Cloud Server Tasks, and then click Next.

    

17. On Deployment Succeeded click Finish.
    

The import.sh script imports data from the dump files generated by the export script into the Database Server on the Compute Cloud service.

1. Run R98403A on the Deployment Server on the Compute Cloud service to copy ESU tables (F9670, F9671, and F9672) with the following values:
• Data Selection Values: F9670, F9671, and F9672

• Processing Options:

2. Apply the latest planner ESU on the Deployment Server on the Compute Cloud service.

3. Build and deploy a new full package to your target environment.
4. Run Work with User Defined Objects (P98220U) to re-share One View Reports (OVR), if you have an OVR server configured on the Oracle Cloud.
1. Select Shared for User Defined Object Status.
2. Select One View Reports for User Defined Object Type.
3. Click Find.
4. Select the applicable objects and click Approve / Share on the Row menu.
   When the process completes the selected objects will be available on the BI Publisher Server.
   
   Note: Only shared OVRs are migrated, if you need personal OVRs migrated please reference the My Oracle Support Document ID: 2158173.1
   
   
5. Run R98222UDO on the html Server to add User Defined Objects (UDO) to default projects.
   
   Note: After the Oracle Cloud Migration Utility and Database Import, Personal and Reserved UDOs need to be placed on the user's default project. Since the OMW project data was not migrated, the default projects do not exist. R98222UDO creates the default project and adds the user's Personal or Reserved UDOs.
   
   

• Oracle Cloud Home Page

• How to Begin with Oracle Compute Cloud Service Subscriptions in Using Oracle Compute Cloud Service