• 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 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
upgrade oem application - 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
upgrade oracle enterprise manager oem - oms agent shutdown

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 
upgrade oracle enterprise manager - start oem 13.4 istaller

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

oracle enterprise manager cloud control 13c installation - my oracle support details

Select Skip and click on Next

oracle enterprise manager cloud control 13c installation - software updates

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

oracle enterprise manager cloud control 13c installation - oem prerequisite checks
Note: I am ignoring the warning due to a RAM crunch on my system.
oracle enterprise manager cloud control 13c installation - oem prerequisite checks warning

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

oracle enterprise manager cloud control 13c installation - upgrade an existing enterprise manager system

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

oracle enterprise manager cloud control 13c installation - middleware home location

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

oracle enterprise manager cloud control 13c installation - database connection details management repository

Review the plug-ins and click on Next

oracle enterprise manager cloud control 13c installation - OEM plug ins to upgrade

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

oracle enterprise manager cloud control 13c installation - select plug ins

Enter the password of WebLogic username password and click on Next

oracle enterprise manager cloud control 13c installation - extend weblogic server domain

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

oracle enterprise manager cloud control 13c installation - enterprise manager shared location details

Click on Next

oracle enterprise manager cloud control 13c installation- port configuration details

Review all the provided information and click on Upgrade

oracle enterprise manager cloud control 13c installation - oem installation review

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

oracle enterprise manager cloud control 13c installation - installation progress details

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

upgrade oracle enterprise manager - upgrade agents

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

upgrade oracle enterprise manager - agent upgrade console

Click Submit! and OEM agents upgrade is also done!


1,969 views

Recent Posts

See All

Oracle Database Migration to AWS Cloud

Find different ways to migrate an Oracle database from on-premises to AWS cloud using different tools available for migration. You could choose any migration method based on your environment and needs

Oracle 12c to 19c Database Upgrade

In this article, we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c. Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a d