This note describes the procedure used to upgrade Oracle Enterprise Manager Cloud Control 13c Release 3 to Oracle Enterprise Manager Cloud Control 13c Release 5 on a Linux platform.
Edit /etc/security/limits.conf file
[root@oemprod~]# vi /etc/security/limits.conf oracle soft nofile 30000
Set the following parameters on the OEM Repository database
alter system reset "_optimizer_strans_adaptive_pruning" scope=both sid='*'; alter system reset "_px_adaptive_dist_method" scope=both sid='*'; alter system reset "_sql_plan_directive_mgmt_control" scope=both sid='*'; alter system reset "_optimizer_dsdir_usage_control" scope=both sid='*'; alter system reset "_optimizer_use_feedback" scope=both sid='*'; alter system reset "_optimizer_gather_feedback" scope=both sid='*'; alter system reset "_optimizer_performance_feedback" scope=both sid='*'; alter system set "_allow_insert_with_update_check"=true scope=both;
Temporarily set job_queue_processes parameter to 0 and also disable the automatic gathering of statistics. We will enable both later.
grant execute on dbms_random to dbsnmp; alter system set job_queue_processes =0 scope=both; BEGIN DBMS_AUTO_TASK_ADMIN.DISABLE( client_name => 'auto optimizer stats collection', operation => NULL, window_name => NULL); END; /
Download the Oracle Enterprise Manager 13c Release 5 software
https://www.oracle.com/enterprise-manager/downloads/linux-x86-64-13c-rel5-downloads.html
[oracle@oemprodoem_stage]$ ./em13500_linux64.bin -J-Djava.io.tmpdir=/u01/oem_stage
Select the option Upgrade to an existing Enterprise Manager system
Enter the new location for the 13.5 OMS Middleware home.
Provide the necessary details to connect to the Repository Database.
Stop the OMS as well as the central management agent via emctl.
[oracle@oemprod~]$ cd /u01/app/oracle/middleware/bin [oracle@oemprodbin]$ ./emctl stop oms -all Oracle Enterprise Manager Cloud Control 13c Release 3 Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved. Stopping Oracle Management Server... WebTier Successfully Stopped Oracle Management Server Successfully Stopped Oracle Management Server is Down JVMD Engine is Down BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command Stopping BI Publisher Server... BI Publisher Server Already Stopped BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command AdminServer Successfully Stopped BI Publisher Server is Down BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command [oracle@oemprodbin]$ pwd /u01/app/oracle/middleware/bin [oracle@oemprodbin]$ cd ../.. [oracle@oemprodoracle]$ ls admin agent audit cfgtoollogs checkpoints diag gc_inst middleware product softlib_stage software [oracle@oemprodoracle]$ cd agent/ [oracle@oemprodagent]$ ls agent_13.3.0.0.0 agent_inst agentInstall.rsp [oracle@oemprodagent]$ cd agent_13.3.0.0.0/bin [oracle@oemprodbin]$ ./emctl stop agent Oracle Enterprise Manager Cloud Control 13c Release 3 Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved. Stopping agent ... stopped. [oracle@oemprodbin]$
Provide the existing weblogic username and password.Also provide the new location for the OMS instance base.
Upgrade Agents
