MPatcher

Mike's Patcher

Databases

Oracle

Oracle DB Lifecycle

Oracle Patch

TODO

MPatcher aims to automate Oracle patching (Release Updates). This page includes a reference for the various scripts that make up the tool.

Install

Patcher should be installed in /u01/dba/patcher.

It relies on the following variables from .profile/.bash_profile...

P_OS

PTAR

..and expects the following alias script to be called...

. /u01/dba/patcher/.alias

Add aliases to /u01/dba/patcher/.alias to quickly switch between ORACLE_SIDs on the same server (if necessary)... Examples called ORCL1, ORCL2, ORCL3 and ORCL4 are included for reference. E.g.

alias ORCL1='. /home/oracle/.bash_profile.ORCL1'

Create missing patch variable files in /u01/dba/patcher/var.

The following lines should be in /etc/sudoers...

## Allow oracle to run /u01/dba/patcher/perms.sh as root

oracle localhost = (root) NOPASSWD: /u01/dba/patcher/perms.sh

.profile

Patch Variables

sudo

Command Reference

checkreg

Queries patch information from registry$patch.

checkreg

ACTION_TIME PATCH_ID DESCRIPTION

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

27-APR-20 13.53.23.280012 30805580 OJVM RELEASE UPDATE 12.2.0.1.200414

27-APR-20 13.53.26.453299 30886680 DATABASE APR 2020 RELEASE UPDATE 12.2.0.1.200414

27-APR-20 16.11.55.612517 30805580 OJVM RELEASE UPDATE 12.2.0.1.200414

27-APR-20 16.11.59.149423 30886680 DATABASE APR 2020 RELEASE UPDATE 12.2.0.1.200414

pvars [set]

Prints patch variables used by Patcher.

pvars

Target Version: 122010

Combo Patch#: 30783641

DB Release Update#: 30886680

JVM Release Update#: 30805580

If you run pvars with the "set" argument it reads from the latest file matching the Target version in /u01/dba/patcher/var and sets the variables.