Sunday, 26 March 2023

Applying RU 13.5.0.13 on Enterprise Manager 13c R5

 

OS Version                    :  OEL 8.4 64 bit

OEM Version                 :  Oracle Enterprise Manager Cloud Control 13c Release 5 (13.5.0.0.0)

This document covers    :  Applying RU 13.5.0.13 on OEM 13.5.0.0.

-----------------------------------------------------------------------------------------------------------------------------


Overview of the Enterprise Manager Proactive Patch Program (Doc ID 822485.1)


Patch 34824614: Oracle Enterprise Manager 13c Release 5 Update 13 (13.5.0.13) for Oracle Management Agent

Patch 34824609: Oracle Enterprise Manager 13c Release 5 Update 13 (13.5.0.13) for Oracle Management Service


Additional Patches Needed to Upgrade OMSPatcher & AgentPatcher.

● Patch 19999993: Enterprise Manager Base Platform 13.3.0.0.0 for Generic Platform - OMSPatcher patch

● Patch 33355570: AgentPatcher release for Enterprise Manager 13.5 How to Upgrade AgentPatcher to the Latest Version (Doc ID 2810322.1)

-----------------------------------------------------------------------------------------------------------------------------

Presteps on Repository Database: -

  • GRANT SELECT ON SYS.SYSAUTH$ TO SYSMAN;
  • GRANT SELECT ON SYS.USER$ TO SYSMAN;
  • GRANT SELECT ON SYS.USER$ TO SYSMAN;
  • GRANT SELECT ON SYS.DEFROLE$ TO SYSMAN;
-----------------------------------------------------------------------------------------------------------------------------
  • AS per README of Patch 34824609 it is advised for 19.18 version of database an additional patch needs to be applied.

----------------------------------------------------------------------------------------------------------------------------

If the repository is a RAC database, it is advised to keep only node active.

-----------------------------------------------------------------------------------------------------------------------------

APPLY OMS PATCH

Let’s Gather some Pre-Information before Applying Patches.

export ORACLE_HOME=/u01/app/oracle/middleware
cd bin>emctl getversion oms

emctl status oms -details


$ORACLE_HOME/OPatch/opatch lspatches | grep applied


$ORACLE_HOME/OMSPatcher lspatches



-----------------------------------------------------------------------------------------------------------------------------


Update OMSPATCHER

export ORACLE_HOME=u01/app/oracle/middleware

export PATH=$ORACLE_HOME/OMSPatcher:$PATH

omspatcher version

Cd $ORACLE_HOME

mv OMSPatcher OMSPatcher_OLD

Unzip the patch Patch 19999993 and move the OMSPatcher folder from patch extraction to

$ORACLE_HOME.



-----------------------------------------------------------------------------------------------------------------------------

Analyze the OMS Patch,

Unzip the patch 34824609

Patch Location - /u01/Software/patches/34824609

export ORACLE_HOME=u01/app/oracle/middleware

export PATH=$ORACLE_HOME/OMSPatcher:$PATH

cd /u01/Software/patches/34824609

omspatcher apply -analyze



Make sure the analyze patch goes through successfully.

Apply OMS Patch

emctl stop oms

ompatcher apply


Usually the OMSPatcher should go smooth. But we faced an issue – our Putty session got freezed. So, in this scenario the OMS patch was not updating the logs – not proceeding further – also it was not in failed state. We attempted a restart to the repository database – no luck.  Finally, we aborted the session and did a rollback to the patch and applied again.

-----------------------------------------------------------------------------------------------------------------------------

Make sure you are able to repository database from OEM server

Rollback the patches/sub patches applied in previous OMSPatcher session

The below command will provide list of patches applied.

<MIDDLEWARE_HOME>/OMSPatcher/omspatcher lspatches | grep 34824609 | sed

's/oracle.sysman.top.oms/1/' | sort | tr -s ' '| cut -d ' ' -f 4 | paste -sd ","


cd /u01/app/oracle/middleware/OMSPatcher

omspatcher lspatches | grep 34824609 | sed 's/oracle.sysman.top.oms/1/' | sort | tr -s ' '| cut -d ' ' -f 4 |

paste -sd ","


omspatcher rollback -id 34819122,34601404,34819137,34819126,34819254,34819225

-----------------------------------------------------------------------------------------------------------------------------

Forcibly Stop all Services and Start only ADMIN Server

emctl stop oms -all -force

./emctl start oms -admin_only

omspatcher apply -analyze

omspatcher apply


This time OMSPatcher went through successfully. It took about 2 hours to complete the OMSPatcher.

$ORACLE_HOME/OMSPatcher lspatches

$ORACLE_HOME/OPatch/opatch lspatches | grep applied

emctl status oms -details

-----------------------------------------------------------------------------------------------------------------------------

APPLY AGENT PATCH

Open a new terminal of Putty,

Set the environment pointing to AGENT HOME

export ORACLE_HOME=/u01/app/oracle/agent/agent_13.5.0.0

cd $ORACLE_HOME

ls -ltr


Since this is a new installation – you will not find AgentPatcher directory here.


● Patch 33355570: AgentPatcher release for Enterprise Manager 13.5. How to Upgrade AgentPatcher to the Latest Version (Doc ID 2810322.1)

Unzip Patch 33355570 to get the latest release of AgentPatcher. 

Once Unzipped copy to AGENT Oracle Home.



Copy the AgentPatcher directory to /u01/app/oracle/agent/agent_13.5.0.0

Set PATH Variable

export ORACLE_HOME==/u01/app/oracle/agent/agent_13.5.0.0

export PATH=$ORACLE_HOME/AgentPatcher:$PATH




-----------------------------------------------------------------------------------------------------------------------------

Unzip the Patch 34824614 and run patch analyzer

cd /u01/Software/Patches/34824614

export ORACLE_HOME=/u01/app/oracle/agent/agent_13.5.0.0

export PATH=$ORACLE_HOME/AgentPatcher:$PATH

agentpatcher apply -analyze








Apply the Patch

agentpatcher lspatches


agentpatcher apply










        ------------------------------------------------------------------------------------------------------------

         

                

No comments:

Post a Comment