Solved

Oracle 12c patching

Posted on 2016-11-08
1
61 Views
Last Modified: 2016-11-28
Hi, I need to patch my 12c dbs (standalone & 2 nodes RAC cluster), they are asking to only patch db, but got to check grid, oem & oem agents too.

Please do share/advise, what should be the starting point/course of action, I think need to check first what's already there and then will proceed accordingly.

Please guide or direct some best practices doc.

Thanks in advance.
MK
0
Comment
Question by:mkhandba
1 Comment
 
LVL 4

Accepted Solution

by:
Abhimanyu Suri earned 500 total points
ID: 41881309
1# Download Readme of given patch
     
      a. Go through the instructions thoroughly.
      b. Check what is required to be down.
           Only rdbms services  or entire CRS stack
      c. Check Readme for any special instructions like unlock or locking lib pre/post patch

2# opatch version ###### Make sure you have required version as mentioned in patch Readme

3# opatch lsinventory -detail > prepatch.txt

4# Conflict check
      opatch prereq CheckConflictAgainstOHWithDetail ## see opatch instructions for complete command
      opatch prereq CheckConflictAmongPatchesWithDetail
         
     opatch prereq -help ==> For more prereq checks

5# If no conflict, bring down services as required

6# Follow instructions to patch << I prefer opatch apply -local >> but solely your choice if you want to go rolling fashion for RAC
      Make sure you do pre/post steps if any.

Once detailed steps are drafted, I would recommend to post then on Oracle Service Request for final confirmation.
And to make sure your understanding of steps are correct

7# opatch lsinventory -detail > postpatch.txt

PLEASE NOTE : These are high level generic steps and Oracle must be consulted.

Thanks,
Suri
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Using init script with Systemd: need help crafting unit file 11 81
data lookup in Oracle - need suggestions 55 104
Queries 15 34
linux redhat 7.2 10 47
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now