OEM 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 below command:



         2.  If there are a large number of PropagateTarget jobs, then the Repository Upgrade can consume very long time or stuck while executing "upgrade/post_jobtype_upgrade.sql". Check if there are large number of jobs that are stuck using 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;


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





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




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


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


Upgrade Time:

1.       Stop the 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 bin file and run it.

                           chmod +x em13500_linux64.bin



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




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


             6.       Select the new location for middleware home.



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



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

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


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



11.       Provide WebLogic username and password with base location.



12.       Review the info and click Upgrade.



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




14.       Execute root script when prompt.



15.       OEM upgraded to 13.5 successfully!




Now we can upgrade Agents from 13.4 to 13.5:

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


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



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


OMS and agents both Upgraded to 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)

Analyze Invoices with Oracle Analytics and AI Document Understanding

OCI Document Understanding is an AI service that enables developers to extract text, tables, and other key data from document files through...