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 220.127.116.11.
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;
$OMS_HOME/bin/emctl config emkey -copy_to_repos
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
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
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
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!