Upgrade Oracle Enterprise Manager (OEM) 13.3 to 13.4

In this article, we will see how we will upgrade the OEM application from 13.3 to 13.4 with repository database 12.2.0.1.

• Upgrade OEM Application

• Upgrade Agents

Prerequisites - Apply the latest DB PSU before upgrading to Enterprise Manager Cloud Control 13.4

Upgrade OEM Application

The first steps is to upgrade the OEM application. We will only be performing the application upgrade and the repository database will be of same version!

Optimizer Adaptive Features Disabling Requirements

Connect to the repository database and execute the below commands

alter system set "_optimizer_nlj_hj_adaptive_join"= FALSE scope=both sid='*';
alter system set "_optimizer_strans_adaptive_pruning" = FALSE scope=both sid='*';
alter system set "_px_adaptive_dist_method" = OFF scope=both sid='*';
alter system set "_sql_plan_directive_mgmt_control" = 0 scope=both sid='*';
alter system set "_optimizer_dsdir_usage_control" = 0 scope=both sid='*';
alter system set "_optimizer_use_feedback" = FALSE scope=both sid='*';
alter system set "_optimizer_gather_feedback" = FALSE scope=both sid='*';
alter system set "_optimizer_performance_feedback" = OFF scope=both sid='*';
alter system set "_allow_insert_with_update_check" =true scope=both;
alter system set job_queue_processes=0 scope=both;

EMKEY Copy

$OMS_HOME/bin/emctl config  emkey -copy_to_repos

OMS Backup

• Take a backup at OS level

• Take configuration backup

$OMS_HOME/bin/emctl exportconfig oms   -dir /u01/sw/dump

OMS and Agent Shutdown

$OMS_HOME/bin/emctl stop oms -all
$AGENT_HOME/bin/emctl stop agent

Now we can create one directory for the new middleware home start the installer

mkdir -p /u01/app/oracle/middleware_134

Go to the software location of OEM 13.4 and run Installer

./em13400_linux64.bin 

Once the Installer loads its file to /tmp and launch, It will as for the email address software for the software updates, click on No

Select Skip and click on Next

Make sure that all prerequisites should be succeeded and click on Next

Note: I am ignoring the warning due to a RAM crunch on my system.

Select the option Upgrade an existing EM System and click on Next

Enter the new location for the middleware home which we created earlier and click on Next

Confirm that you have backed up the Management Repository. As a prerequisite, you must back up the Management Repository before starting the upgrade process. If you have not already taken a backup, then do so immediately, and then return to the installer to continue with the upgrade.

Provide the SYS password and SYSMAN password and click on Next

Review the plug-ins and click on Next

Select the plug-ins which you want to use and click on Next

Enter the password of WebLogic username password and click on Next

As we are already using the BI Publisher in 13.3, that's why it already selected, click on Next

Click on Next

Review all the provided information and click on Upgrade

Monitor the progress and keep checking the database as well & errors in logs.

Run root.sh script from the root user and after completing the script click on the OK button in the popup

/u01/app/oracle/middleware_134/allroot.sh

Check the details for the URL and click on Close. Check the version OEM and status of OMS after login into the console. You also check the version from the command line

$OMS_HOME/bin/emctl status oms

Upgrade Agents

From the Setup menu, select Manage Cloud Control, then select Upgrade Agents

Accept the default job name, or enter a unique job name. Click Add to select the Management Agents you want to upgrade

Click Submit! and OEM agents upgrade is also done!