Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Install same patches on new database from very long list (Madness)

edited Jun 8, 2020 10:39AM in Database Install/Upgrade/Opatch (MOSC) 5 commentsAnswered

Where do I start to make sure new database in new box has the same patches?

I guess I'm asking about where to get these sepecific interim patches in Oracle support, because some numbers repeat themselves and I don't know why.

Example of repeating number is "28790634" which is both an interim patch and a bug number.

Is there a recommended method?

Env: 11g single instance, Linux 6.

Below is patch list from Old box and New Box in other section

patch list from old box

[oracle@prod2019 ~]$ /u01/app/oracle/product/11.2.0/ora11204/OPatch/opatch lsinvOracle Interim Patch Installer version 11.2.0.3.21Copyright (c) 2020, Oracle Corporation.  All rights reserved.Oracle Home       : /u01/app/oracle/product/11.2.0/ora11204Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/11.2.0/ora11204/oraInst.locOPatch version    : 11.2.0.3.21OUI version       : 11.2.0.4.0Log file location : /u01/app/oracle/product/11.2.0/ora11204/cfgtoollogs/opatch/opatch2020-04-23_18-53-54PM_1.logLsinventory Output file location : /u01/app/oracle/product/11.2.0/ora11204/cfgtoollogs/opatch/lsinv/lsinventory2020-04-23_18-53-54PM.txt--------------------------------------------------------------------------------Local Machine Information::Hostname: prod2019.pr.xynARU platform id: 226ARU platform description:: Linux x86-64Installed Top-level Products (1): Oracle Database 11g                                                  11.2.0.4.0There are 1 products installed in this Oracle Home.Interim patches (49) :Patch  29033139     : applied on Sat Jul 27 05:12:56 BST 2019Unique Patch ID:  22629113   Created on 14 Dec 2018, 08:50:49 hrs PST8PDT   Bugs fixed:     29033139, 27097854Patch  28790634     : applied on Sat Jul 27

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center