• Arun Kumar

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.



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 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!


1,136 views

Recent Posts

See All

OEM 13c Software Library

Oracle Software Library (Software Library) is one of the core features offered by Enterprise Manager Cloud Control. It is a repository that stores software entities such as software patches, virtual