Downloading Oracle Patches Using wget: A Practical Guide

Overview

Oracle database patches are critical updates that provide bug fixes, security updates, and performance improvements. This guide focuses on downloading Oracle patches efficiently using the wget command-line utility.

What You'll Learn:

• ✓ How to use wget for downloading Oracle patches
• ✓ Proper authentication with Oracle Support
• ✓ Verifying successful downloads
• ✓ Best practices for patch management

Prerequisites:

• Access to Oracle Support account
• Linux/Unix environment with wget installed
• Basic command-line knowledge
• Sufficient disk space for patches

⏱️ Estimated Time: 10-15 minutes

In this guide, I'll demonstrate how to download Oracle patches using wget command with authentication. This example shows downloading patch p35643107 for Oracle 19c on Linux x86-64 platform.

Initial Directory Status

[root@srv1 ~]# ls -lrth
total 24K
-rw-------. 1 root root 2.1K Jun 30 2020 anaconda-ks.cfg
-rw-r--r--. 1 root root 2.2K Jun 30 2020 initial-setup-ks.cfg
drwxr-xr-x. 2 root root 6 Jun 30 2020 Videos
drwxr-xr-x. 2 root root 6 Jun 30 2020 Templates
drwxr-xr-x. 2 root root 6 Jun 30 2020 Public
drwxr-xr-x. 2 root root 6 Jun 30 2020 Pictures
drwxr-xr-x. 2 root root 6 Jun 30 2020 Music
drwxr-xr-x. 2 root root 6 Jun 30 2020 Downloads
drwxr-xr-x. 2 root root 6 Jun 30 2020 Documents
drwxr-xr-x. 2 root root 40 Jun 30 2020 Desktop

Download Command

[root@srv1 ~]# wget --http-user="oracledbasecrets@dba.com" --http-password="dbasecrets@1234" https://updates.oracle.com/Orion/Services/download/p35643107_190000_Linux-x86-64.zip

--2024-10-12 23:25:43-- https://updates.oracle.com/Orion/Services/download/p35643107_190000_Linux-x86-64.zip
Resolving updates.oracle.com (updates.oracle.com)... 104.85.146.188, 2600:140f:1e00:4ad::4425, 2600:140f:1e00:499::4425
Connecting to updates.oracle.com (updates.oracle.com)|104.85.146.188|:443... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Reusing existing connection to updates.oracle.com:443.
HTTP request sent, awaiting response... 200 OK
Length: 118 [text/plain]
Saving to: 'p35643107_190000_Linux-x86-64.zip'

100%[==================================================>] 118 --.-K/s in 0s
2024-10-12 23:26:02 (1.07 MB/s) - 'p35643107_190000_Linux-x86-64.zip' saved [118/118]

Verifying Downloaded Files

[root@srv1 ~]# ls -lrth
total 24K
-rw-------. 1 root root 2.1K Jun 30 2020 anaconda-ks.cfg
-rw-r--r--. 1 root root 2.2K Jun 30 2020 initial-setup-ks.cfg
drwxr-xr-x. 2 root root 6 Jun 30 2020 Videos
drwxr-xr-x. 2 root root 6 Jun 30 2020 Templates
drwxr-xr-x. 2 root root 6 Jun 30 2020 Public
drwxr-xr-x. 2 root root 6 Jun 30 2020 Pictures
drwxr-xr-x. 2 root root 6 Jun 30 2020 Music
drwxr-xr-x. 2 root root 6 Jun 30 2020 Downloads
drwxr-xr-x. 2 root root 6 Jun 30 2020 Documents
drwxr-xr-x. 2 root root 40 Jun 30 2020 Desktop
-rw-r--r--. 1 root root 2.3K Oct 12 23:10 patch_download.sh
-rw-r--r--. 1 root root 1.6K Oct 12 23:12 wgetlog-10-12-24-23:10.log
-rw-r--r--. 1 root root 1.6K Oct 12 23:21 wgetlog-10-12-24-23:12.log
-rw-r--r--. 1 root root 118 Oct 12 23:26 p35643107_190000_Linux-x86-64.zip

Important Notes:

• Make sure you have valid Oracle Support credentials
• The --http-user and --http-password parameters are required for authentication
• Always verify the downloaded file size matches the expected size
• For security reasons, avoid using credentials in clear text in production environments

The download process involves authentication with Oracle Support credentials, and upon successful authentication, the patch file is downloaded to the current directory. The ls command confirms the successful download of the patch file.

Please feel free to ask. thank you 🙂
Toufique Khan