Oracle Enterprise Manager Upgrade from 13.4 to 13.5

Pre-requisite:

  1. Oracle recommends that you back up the Middleware Home, the Management Repository, Central inventory, Software library, Management Agent.
  2. The minimum version supported for upgrading to EM 13.5 is 13.3. If the OMS is at 12.1.0.x, 13.1 or 13.2, it is mandatory that it is first upgraded to 13.3.0.0.0 or 13.4.0.0.0.

Prepare for Upgrade:

1. The following plug-ins are obsolete and support for these plug-ins is discontinued. These plug-ins must be undeployed from the Oracle Management Agents and Oracle Management Services before proceeding with the upgrade.

  • Cloud Services Management (oracle.sysman.csm)
  • Microsoft .NET Framework (oracle.em.smdn)
  • Microsoft Active Directory (oracle.em.smad)

You can check the plugins using the below command:

oem upgrade 1

2.  If there are a large number of PropagateTarget jobs, then the Repository Upgrade can consume a very long time or stuck while executing “upgrade/post_jobtype_upgrade.sql”. Check if there are a large number of jobs that are stuck using the below query:

SELECT job_type, status, cnt
FROM (
SELECT job_type, status, count(*) as cnt
FROM MGMT_JOB_EXEC_SUMMARY join MGMT_JOB_TYPE_INFO using (job_type_id)
WHERE status NOT IN(3,4,5,8,18,19,23)
group by job_type, status
order by 3, 1, 2
)
where cnt > 10000;

oem upgrade 2

3. Disable the password_verify_function on the repository DB (if enabled):

oem upgrade 3

4.  Ensure that the database initialization parameter (_allow_insert_with_update_check) is set to true in the Oracle Database 18c or 19c:

oem upgrade 4

oem upgrade 5

5.  For improved SQL performance all the adaptive features parameters should be unset prior to the upgrade:

oem upgrade 6

6.  Prior to the upgrade, the EM KEY must be copied into the repository:

oem upgrade 7

 

Upgrade Time:

1. Stop the Order Management System (OMS) and agent.

2. Create new directory for OMS 13.5

         mkdir -p /u01/app/oracle/middleware13.5

3. Download the OEM 13.5 binaries and change the permission of the bin file and run it.

chmod +x em13500_linux64.bin

oem upgrade 8

4. Select an installation type. In this case, we will select Upgrade End-to-End.

oem upgrade 9

oem upgrade 10

5. Fix if any error during Prerequisite checks and click NEXT.

oem upgrade 11

6. Select the new location for middleware home.

oem upgrade 12

7. Enter the Repository database connection details with sys and SYSMAN password.

oem upgrade 13

8. Fix the DB prerequisite checks using Auto fix if any error and click NEXT. You can ignore warnings for now and fix them later.

oem upgrade 14

9. Verify the Plug-ins details which will upgrade to 13.5

oem upgrade 15

10. Select an additional plugin if you want to install with an upgrade or we can install it later after the upgrade.

oem upgrade 16

11. Provide WebLogic username and password with the base location.

oem upgrade 17

12. Review the info and click Upgrade.

oem upgrade 18

13. Upgrade will start and will take around 3-4 hours to complete.

oem upgrade 19

oem upgrade 20

14. Execute root script when prompt.

oem upgrade 21

15. OEM upgraded to 13.5 successfully!

oem upgrade 22

oem upgrade 23

 

Now we can upgrade Agents from 13.4 to 13.5:

1. Log in to OEM console and go to OEM (Setup -> Manage Cloud Control -> Upgrade Agents):

oem upgrade 24

2. Click ADD to select the agent which we want to upgrade and click OK to start the upgrade.

oem upgrade 25

3. After a successful agent upgrade, we will see the output like this.

oem upgrade 26

OMS and agents both Upgraded to the latest 13.5 version !!

Reference: 13.5: Checklist for Upgrading Enterprise Manager Cloud Control from Version 13.3/13.4 to 13.5 (Doc ID 2761728.1)

Share on:
Come work with the Best