No question at this time
DBA Top 10
1 A. Kavsek 8900
2 B. Vroman 6600
3 M. Cadot 5000
4 T. Boles 4550
5 P. Wisse 4500
6 J. Schnackenberg 3700
7 . Lauri 1300
8 G. Lambregts 800
9 T. P 700
9 R. Pattyn 700
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48392
Total active users1527
Act. users last 24h5
Act. users last hour3
Registered user hits last week277
Registered user hits last month713
Go up

RU PATCH ON RAC ENV
Next thread: Store Oracle TDE keys in Azure Key Vault
Prev thread: impdp

Message Score Author Date
Dear Experts, We have 3 node rac for Primary a...... Jill Salalila Apr 29, 2019, 17:38
Hello Jill, from the "rules"  -a- you don't ru...... Score: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 Pts Bruno Vroman May 02, 2019, 08:25

Follow up by mail Click here


Subject: RU PATCH ON RAC ENV
Author: Jill Salalila, Philippines
Date: Apr 29, 2019, 17:38, 77 days ago
Os info: RHEL 7.2
Oracle info: 12.2
Message: Dear Experts,

We have 3 node rac for Primary
and Standby has 2 node.

We are going to apply APRIL 2019 RU Patch.
All pre req has been done but getting bit confused to perform post installation.


>> Following reference at Standby site

# cd /u01/app/12.2.0/grid/OPatch/
# ./opatchauto apply /backup/patch/29301687 -analyze



OPatchauto session is initiated at Mon Apr 29 05:55:48 2019

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-04-29_05-55-50AM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2019-04-29_05-56-14AM.log

The id for this session is 2349

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1

Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1

Patch applicability verified successfully on home /u01/app/12.2.0/grid

Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1

Skipping SQL patch step execution on standby database : stgodsdr

SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1

OPatchAuto successful.

--------------------------------Summary--------------------------------


Analysis for applying patches has completed successfully:


Host:XXXXXXXXXXXXX

RAC Home:/u01/app/oracle/product/12.2.0/dbhome_1

Version:12.2.0.1.0


==Following patches were SKIPPED:

Patch: /backup/patch/29301687/29301676

Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /backup/patch/29301687/26839277

Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /backup/patch/29301687/28566910

Reason: This patch is not applicable to this specified target type - "rac_database"

==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /backup/patch/29301687/29314424

Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-29_05-56-24AM_1.log


Patch: /backup/patch/29301687/29314339

Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-29_05-56-24AM_1.log

Host:XXXXXXXXXXXXXXXXX

CRS Home:/u01/app/12.2.0/grid

Version:12.2.0.1.0

==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /backup/patch/29301687/29314424

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-29_05-56-24AM_1.log

Patch: /backup/patch/29301687/29301676

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-29_05-56-24AM_1.log

Patch: /backup/patch/29301687/26839277

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-29_05-56-24AM_1.log

Patch: /backup/patch/29301687/28566910

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-29_05-56-24AM_1.log

Patch: /backup/patch/29301687/29314339

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-04-29_05-56-24AM_1.log

OPatchauto session completed at Mon Apr 29 05:56:49 2019

Time taken to complete the session 1 minute, 1 second

====> Questions

What could be the next step to complete the task ?

1) Do i need to execute datapatch -verbose at Primary DB ?

When i gone through readm doc, i am getting bit confused. Kindly update

Thanks in advance
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RU PATCH ON RAC ENV
Author: Bruno Vroman, Belgium
Date: May 02, 2019, 08:25, 75 days ago
Score:   Score: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 Pts
Message: Hello Jill,

from the "rules"
 -a- you don't run datapatch on a standby database, its effect is replicated when it is applied on the primary side.
 -b- if you have to run "datapatch", you don't run it before having applied the patch at software level
 -c- you apply a patch on standby side before applying it on primary side

We conclude:
1) opatchauto on standby side, will patch oracle software but not the (stby) databases
2a) opatchauto on primary side, will patch oracle software and run datapatch on primary databases, effect of datapatch being replicated to standby side
2b) or for some reasons depending of your configuration, opatchauto will only patch the software and then you apply datapatch on the primary databases "manually".

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here