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 18.104.22.168.
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;
$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!