How to download the latest OPatch with a wget command?

First place to start is MOS Oracle Support Document 274526.1 

https://support.oracle.com/epmos/faces/DocumentDisplay?id=274526.1

Go to patch 6880880 that brings you to the download page.

There is no wget.sh script to download, so that is what we will create ourselves.

Select the correct version to download, and then Right-click the download button and copy the hyperlink.

Paste the hyperlink in a fresh notepad, and enclose it with quotation marks:

"<link>"

Add the following in front, to make your command:

wget --http-user=<MOS-user> --http-password=<MOS-password> --no-check-certificate --output-document=latestopatch.zip "<link>"

Paste this in your Linux session and your opatch is downloading.

 

Upgrade Database System to Linux 8 on OCI using console

When upgrading to Linux 8 of your Database System (Oracle Base Database), using the console, you will lose some settings that you have made manually.

https://docs.oracle.com/en/cloud/paas/base-database/upgrade-dbs/index.html#GUID-32241D49-BA5B-42D3-90B6-83D0A50480C9

What will you CERTAINLY lose:

* changes in /etc/fstab LOST

* extra directory in /opt/ LOST

* all stuff in /home/oracle  (scripts, changes in .bash_profile)

* extra mounted Filesystems. If they are external, you will need to put them back in /etc/fstab and remount.

* /etc/cron.allow is gone

* crontab of user oracle is gone (probably all crontabs!)

* contents of database directory objects if they are not on /u01, /u02, /u03!!

What goes ok:

• extra stuff stored in /u01 /u02 /u03  (if you use Filesystem storage)
• extra entries in tnsnames.ora  (which is in $ORACLE_HOME on u01)
• The external /mnt to a filesystem is gone, but the filesystem itself is ok. Just remount it.

MAKE SURE TO BACKUP ALL BEFORE YOU START UPGRADE

Update your Oracle database - there is more

*updated post 2024-Jan-16

When you want to keep your Oracle database fully up-to-date, you may think that the quarterly patches are perfect:

Update quarterly CPU   https://www.oracle.com/security-alerts/#CriticalPatchUpdates

But the following are not automatically included in the CPU:

+ Monthly Recommended Patches (MRPs)   Primary Note for Database Proactive Patch Program (Doc ID 888.1)

+ JDK patches JDK and PERL Patches for Oracle Database Home and Grid Home (Doc ID 2584628.1)

+ OPatch update How To Download And Install The Latest OPatch(6880880) Version (Doc ID 274526.1)

+ Update Datapump bundle patch Data Pump Recommended Proactive Patches For 19.10 and Above (Doc ID 2819284.1)

+ Update preupgrade.jar  How to Download and Run Oracle's Database Pre-Upgrade Utility (Doc ID 884522.1)

+ Update Apex  https://www.oracle.com/tools/downloads/apex-downloads/

+ Update AHF/TFA  Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAchk (Doc ID 2550798.1)

So.... a lot of updates!

How to upgrade/patch Oracle Enterprise Manager Cloud Control

In this post, I'd like to give you the main lines of upgrading and patching Cloud Control

UPGRADING

Of course, your situation may be different. But if you have a simple Cloud Control setup, you may work with the following guidelines.

You should be working with Cloud Control 13c, specifically with 13.5

If you are on a lower version, first upgrade it to 13.5. I would suggest that 13.4 is fine as well, but an upgrade could be made nevertheless. 

If you need to upgrade, download the 13.5 version via edelivery (wget is preferred to do so).

When you start it up, you will get the option to upgrade. An example of the steps is on:

https://eclipsys.ca/oracle-enterprise-manager-upgrade-from-13-4-to-13-5/

This will create a whole new tree structure for gc_inst and OMS-home folders. So you need a lot of space.

You can follow all steps in the upgrade guide:

https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/emupg/introduction-upgrading-enterprise-manager-system-13c.html

After the installation, you can remove the old directory structures, but be careful with that.

https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.4/emupg/deleting-old-oms-home.html

After the upgrade, you will need to upgrade all the agents. 

Start with the Central Agent (on the OMS host itself). You can easily upgrade agents with the cloud control option under Setup>Manage Cloud Control>Upgrade Agents

After the central agent, you need to upgrade all target agents. You can do a few/some/a lot in one go.

Note that upgrade agents requires a root.sh script to be run. 

Note that after the upgrade of the agent you should run post-agent-upgrade steps (which cleans the old agent home).

Upgrading agents is a very smooth process that will not require any downtime (just briefly of the agent itself).

PATCHING

Now the patch áfter the 13.5 upgrade. Because you now have 13.5.0.0.0 installed on OMS and all the agents. 

There is a monthly patch, which can patch the OMS to 13.5.0.10.0 for example. This fixes a lot of bugs and issues.

You can find the patch in:

https://support.oracle.com/epmos/faces/DocumentDisplay?id=2902989.1

After downloading the latest patch (wget preferred), you should also download the latest OMSPatcher tool (follow the readme of OMS patch).

And you should also create a property file, which helps you installing the patch.

With the property file created and OMSPatcher tool upgraded, you can now 

omspatcher -apply -analyze -property_file /pathto/mypropertyfile.txt

emctl stop oms

omspatcher -apply -property_file /pathto/mypropertyfile.txt

The patch is in-place and gets you to OMS 13.5.0.x.0 (last patch).

Hope this helps you in your patching. Always follow the steps in Oracle Support documents!