PSU/CPU Patch Analysis for July 2018 for Production

-
PSU/CPU Patch Analysis for July 2018 for Production :
------------------------------------

Follow below sequence to apply patches.

1] Patch 27967747: GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.180717 
2] Patch 27923320: OJVM PATCH SET UPDATE 12.1.0.2.180717
3] Patch 27919943: WLS PATCH SET UPDATE 12.1.3.0.180717






Below are step to do anaylisys :

Grid Patch:----------------------------------------------------------------------------------------------------------------

From Oracle Home as oracle user:-[Both Oracle Home]
/db/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch lsinventory -detail -oh /db/app/oracle/product/12.1.0/dbhome_1    //node1

/db/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch lsinventory -detail -oh /db/app/oracle/product/12.1.0/dbhome_1    //node2


From Grid Home as grid user:-
/db/app/12.1.0/grid_1/OPatch/opatch lsinventory -detail -oh /db/app/12.1.0/grid_1/            //node1
/db/app/12.1.0/grid_1/OPatch/opatch lsinventory -detail -oh /db/app/12.1.0/grid_1/            //node2



As root user:-
/db/app/12.1.0/grid_1/OPatch/opatchauto apply /dblogbackup1/July18CPU/27967747 -analyze      //for prerequsite check before applying patch Node1
/db/app/12.1.0/grid_1/OPatch/opatchauto apply /dblogbackup1/July18CPU/27967747 -analyze       //for prerequsite check before applying patch Node2


#####################################################Node1##################################################################################

[root@srdhprod1-db1p ~]# /db/app/12.1.0/grid_1/OPatch/opatchauto apply /dblogbackup1/July18CPU/27967747 -analyze

OPatchauto session is initiated at Tue Aug 14 08:51:34 2018

System initialization log file is /db/app/12.1.0/grid_1/cfgtoollogs/opatchautodb/systemconfig2018-08-14_08-51-36AM.log.

Session log file is /db/app/12.1.0/grid_1/cfgtoollogs/opatchauto/opatchauto2018-08-14_08-52-10AM.log
The id for this session is QS3P

Executing OPatch prereq operations to verify patch applicability on home /db/app/12.1.0/grid_1

Executing OPatch prereq operations to verify patch applicability on home /db/app/oracle/product/12.1.0/dbhome_1
Patch applicability verified successfully on home /db/app/oracle/product/12.1.0/dbhome_1

Patch applicability verified successfully on home /db/app/12.1.0/grid_1


Verifying SQL patch applicability on home /db/app/oracle/product/12.1.0/dbhome_1
SQL patch applicability verified successfully on home /db/app/oracle/product/12.1.0/dbhome_1

OPatchAuto successful.

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

Analysis for applying patches has completed successfully:

Host:srdhprod1-db1p
RAC Home:/db/app/oracle/product/12.1.0/dbhome_1
Version:12.1.0.2.0


==Following patches were SKIPPED:

Patch: /dblogbackup1/July18CPU/27967747/26983807
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /dblogbackup1/July18CPU/27967747/27762277
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /dblogbackup1/July18CPU/27967747/27547329
Log: /db/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-14_08-52-25AM_1.log

Patch: /dblogbackup1/July18CPU/27967747/27762253
Log: /db/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-14_08-52-25AM_1.log


Host:srdhprod1-db1p
CRS Home:/db/app/12.1.0/grid_1
Version:12.1.0.2.0


==Following patches were SKIPPED:

Patch: /dblogbackup1/July18CPU/27967747/26983807
Reason: This patch is already been applied, so not going to apply again.


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /dblogbackup1/July18CPU/27967747/27547329
Log: /db/app/12.1.0/grid_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-14_08-52-24AM_1.log

Patch: /dblogbackup1/July18CPU/27967747/27762253
Log: /db/app/12.1.0/grid_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-14_08-52-24AM_1.log

Patch: /dblogbackup1/July18CPU/27967747/27762277
Log: /db/app/12.1.0/grid_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-14_08-52-24AM_1.log



OPatchauto session completed at Tue Aug 14 08:53:08 2018
Time taken to complete the session 1 minute, 34 seconds
[root@srdhprod1-db1p ~]#

############Node2#######################################################

[root@srdhprod2-db2p ~]# /db/app/12.1.0/grid_1/OPatch/opatchauto apply /dblogbackup1/July18CPU/27967747 -analyze

OPatchauto session is initiated at Tue Aug 14 08:55:48 2018

System initialization log file is /db/app/12.1.0/grid_1/cfgtoollogs/opatchautodb/systemconfig2018-08-14_08-55-51AM.log.

Session log file is /db/app/12.1.0/grid_1/cfgtoollogs/opatchauto/opatchauto2018-08-14_08-56-25AM.log
The id for this session is LY6N

Executing OPatch prereq operations to verify patch applicability on home /db/app/oracle/product/12.1.0/dbhome_1

Executing OPatch prereq operations to verify patch applicability on home /db/app/12.1.0/grid_1
Patch applicability verified successfully on home /db/app/oracle/product/12.1.0/dbhome_1

Patch applicability verified successfully on home /db/app/12.1.0/grid_1


Verifying SQL patch applicability on home /db/app/oracle/product/12.1.0/dbhome_1
SQL patch applicability verified successfully on home /db/app/oracle/product/12.1.0/dbhome_1

OPatchAuto successful.

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

Analysis for applying patches has completed successfully:

Host:srdhprod2-db2p
RAC Home:/db/app/oracle/product/12.1.0/dbhome_1
Version:12.1.0.2.0


==Following patches were SKIPPED:

Patch: /dblogbackup1/July18CPU/27967747/26983807
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /dblogbackup1/July18CPU/27967747/27762277
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /dblogbackup1/July18CPU/27967747/27547329
Log: /db/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-14_08-56-40AM_1.log

Patch: /dblogbackup1/July18CPU/27967747/27762253
Log: /db/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-14_08-56-40AM_1.log


Host:srdhprod2-db2p
CRS Home:/db/app/12.1.0/grid_1
Version:12.1.0.2.0


==Following patches were SKIPPED:

Patch: /dblogbackup1/July18CPU/27967747/26983807
Reason: This patch is already been applied, so not going to apply again.


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /dblogbackup1/July18CPU/27967747/27547329
Log: /db/app/12.1.0/grid_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-14_08-56-40AM_1.log

Patch: /dblogbackup1/July18CPU/27967747/27762253
Log: /db/app/12.1.0/grid_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-14_08-56-40AM_1.log

Patch: /dblogbackup1/July18CPU/27967747/27762277
Log: /db/app/12.1.0/grid_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-08-14_08-56-40AM_1.log



OPatchauto session completed at Tue Aug 14 08:57:23 2018
Time taken to complete the session 1 minute, 35 seconds

#######################OJVM Patch Prerequsite check#########################################

Node1:
--------


[oracle@srdhprod1-db1p:/dblogbackup1/July18CPU/27923320] opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /db/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /db/app/oraInventory
   from           : /db/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.14
OUI version       : 12.1.0.2.0
Log file location : /db/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2018-08-14_13-19-19PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@srdhprod1-db1p:/dblogbackup1/July18CPU/27923320]

Node2:
----------


[oracle@srdhprod2-db2p 27923320]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /db/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /db/app/oraInventory
   from           : /db/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.14
OUI version       : 12.1.0.2.0
Log file location : /db/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2018-08-14_13-22-41PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@srdhprod2-db2p 27923320]$


################################################WeblogicPatchPrerequsites##############################################################


export ORACLE_HOME=/edq/Oracle/Middleware/FMW12c
export PATH=/edq/Oracle/Middleware/FMW12c/OPatch:$PATH
./opatch lsinventory -jre /usr/java/jdk1.7.0_75/jre






oracle@srdhprod1-app2v OPatch]$ ./opatch lsinventory -jre /usr/java/jdk1.7.0_75/jre
Oracle Interim Patch Installer version 13.2.0.0.0
Copyright (c) 2014, Oracle Corporation.  All rights reserved.


Oracle Home       : /edq/Oracle/Middleware/FMW12c
Central Inventory : /home/oracle/oraInventory
   from           : /edq/Oracle/Middleware/FMW12c/oraInst.loc
OPatch version    : 13.2.0.0.0
OUI version       : 13.2.0.0.0
Log file location : /edq/Oracle/Middleware/FMW12c/cfgtoollogs/opatch/opatch2018-08-14_15-46-39PM_1.log


OPatch detects the Middleware Home as "/edq/Oracle/Middleware/FMW12c"

Aug 14, 2018 3:46:48 PM oracle.sysman.oii.oiii.OiiiInstallAreaControl initAreaControl
INFO: Install area Control created with access level  0
Lsinventory Output file location : /edq/Oracle/Middleware/FMW12c/cfgtoollogs/opatch/lsinv/lsinventory2018-08-14_15-46-39PM.txt

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

Interim patches (1) :

Patch  27419391     : applied on Sun Jul 01 04:13:42 IST 2018
Unique Patch ID:  21927259
Patch description:  "WLS PATCH SET UPDATE 12.1.3.0.180417"
   Created on 21 Feb 2018, 15:58:59 hrs PST8PDT
   Bugs fixed:
     18538501, 18746515, 17394051, 19668883, 18376812, 21746415, 20333386
     20720853, 22498352, 14236278, 21081720, 20585084, 21522926, 23099318
     22910817, 23063611, 19472793, 20692185, 22749253, 22107941, 24802574
     19175526, 25029531, 21347054, 25695948, 18854885, 24469063, 25720769
     22690676, 20952741, 26985581, 19730967, 18727635, 18305935, 18428696
     18722098, 19080525, 19556868, 20266379, 19973098, 18082758, 19917893
     19705162, 21069524, 20613957, 18945422, 20229977, 22175246, 19467894
     18144979, 20226151, 18559995, 23640078, 22900750, 22836462, 23099223
     23342794, 20430490, 26144830, 25590885, 25955347, 22746640, 25439226
     26885274, 26769768, 18276961, 19533331, 18922324, 19942900, 18485034
     19339238, 19500276, 19234430, 20205647, 19585666, 20169972, 19917991
     20906638, 19828316, 19879223, 19212729, 22247869, 20758488, 22200449
     22200491, 22200594, 20246732, 19463153, 22249331, 21964759, 22486599
     22860104, 21549018, 19150123, 24305841, 23103220, 24750930, 20717353
     18597348, 21562338, 18387934, 23304470, 26806438, 26439373, 19287842
     18589879, 19907066, 18718889, 18753794, 19988824, 19265688, 18289179
     19883023, 21107126, 19576633, 20323632, 19351700, 21169554, 19874466
     19703527, 21252292, 21516492, 21615827, 22339918, 20786128, 20672949
     20907322, 22574362, 21836275, 21519519, 18123824, 19775778, 22586217
     21647599, 22550116, 22987229, 20157787, 21119215, 23326877, 25164167
     24341200, 25059150, 24837293, 20774032, 25205507, 26596622, 25917709
     26044754, 26632886, 26608537, 27565682, 19033547, 19459949, 18671042
     18729264, 19170125, 20162146, 19852007, 19268444, 19299358, 19425078
     20062321, 21039390, 21083766, 20197139, 19689036, 21545042, 21294990
     21225816, 22829635, 22383225, 22850769, 19150684, 18974055, 21189073
     23555480, 22261241, 24399682, 19549507, 20207088, 21562704, 25577947
     24618043, 24376591, 18746053, 21270142, 26038824, 19763916, 27111664
     19066738, 20206879, 20080751, 20814890, 18836900, 19953516, 20969389
     19565095, 20952475, 20721340, 19477196, 22200523, 21129379, 16815912
     21603584, 20419243, 20080046, 20311530, 20128089, 20739167, 23107300
     20736912, 20193085, 22901740, 22950801, 22541225, 22378134, 23735210
     24522430, 23733891, 22836557, 23004029, 23223461, 25192229, 21158132
     16956849, 25497443, 25118289, 21902034, 26589850, 26797049, 26861216
     24818026, 26547016, 18968900, 18859387, 19287874, 20523619, 18432174
     18481239, 18912482, 17889922, 18466848, 19001915, 20758863, 19928803
     17702917, 21561271, 20087183, 19263075, 19986568, 20044804, 22599178
     22097019, 20629733, 22540656, 21834255, 18438079, 23732201, 25317743
     26144926, 25534314, 24533963, 21652727, 19926398, 21241854, 20047315
     25743005, 25174732, 25750303, 27117282, 26835012, 23049601, 18691894
     17012341, 18964349, 17721032, 18806464, 16562029, 19422493, 19297004
     20798352, 20471785, 20985893, 19936917, 21756751, 19865550, 21495475
     19790693, 17968606, 21947902, 22248079, 22049932, 20432957, 22100830
     20220959, 19947189, 20783846, 20551651, 22999996, 22666897, 20671165
     22759067, 20256190, 19721047, 24828619, 22083678, 24817968, 25743025
     25823774, 21748022, 25375968, 25522149, 25355394, 26563889, 25987400



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

OPatch succeeded.
[oracle@srdhprod1-app2v OPatch]$



cd /edq/patches/July18CPU_PATCH/27919943
opatch prereq CheckConflictAgainstOHWithDetail -ph ./


[oracle@srdhprod1-app2v 27919943]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 13.2.0.0.0
Copyright (c) 2014, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /edq/Oracle/Middleware/FMW12c
Central Inventory : /home/oracle/oraInventory
   from           : /edq/Oracle/Middleware/FMW12c/oraInst.loc
OPatch version    : 13.2.0.0.0
OUI version       : 13.2.0.0.0
Log file location : /edq/Oracle/Middleware/FMW12c/cfgtoollogs/opatch/opatch2018-08-14_15-41-31PM_1.log


OPatch detects the Middleware Home as "/edq/Oracle/Middleware/FMW12c"

Aug 14, 2018 3:41:44 PM oracle.sysman.oii.oiii.OiiiInstallAreaControl initAreaControl
INFO: Install area Control created with access level  0
Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@srdhprod1-app2v 27919943]$




 
 



Comments

Post a Comment

Popular posts from this blog

Compression Tools in Linux[TAR,gzip]

-
Compression Tools: tar: to compress files compress files: ``````````````` syn: tar -cvf <tarfilename> <file(s)> ex: tar -cvf files.tar hello.txt hi.txt raj.txt -c: create -v: verbose -f: tar file name Uncompress files: ````````````````` syn: tar -xvf files.tar tar with GZIP feature: `````````````````````` compress: tar -czvf files.tar.gz file1 file2 file3 file4 uncompress: tar -xzvf files.tar.gz -------------------------------------------------------------------------- gzip & gunzip: gzip: to compress file(s) ex: gzip hello.txt gunzip: to uncompress the file(s) ex: gunzip hello.txt.gz ----------------------------------------------------------------------- Storing and Analysing Logs: What is a log file: A log file is that which have information about all activities done on a linux serer. By default log files will be available under /var/log/ folder. Files: messages: Contains most of the information about different activites secure : contains securi...
Read more

All about DataInstaller & Hrglobal.drv in Oracle Applications R12

-
All about DataInstaller & Hrglobal.drv in Oracle Applications All about DataInstaller & Hrglobal.drv in Oracle Applications This posts covers what is datainstaller & hrglobal.drv and when do we need to run them. DataInstaller and hrglobal.drv are used for installing legislative data into Oracle Applications,For example a company operates in multiple counntries and payroll and HR practices are different in each countires, So they need to have all the legislative regulations (Taxation and HR rules and regulations) of the all the countries they run their business. To achive this Oracle provides a set of patches, which need to applied to the Oracle applications. These patches are country specific, The patch matrix can be found from Latest Oracle HRMS Legislative Data Patch Available (HR Global / hrglobal) [ID 145837.1] To Install the legislative data please follow the below 4 steps: 1) PER & PAY modules need to be licenced ( This is madantory requirement) ...
Read more

PSU Patching step by step on RAC

-
OPatch utility version 12.1.0.1.7 or later to apply this patch. Grid Patch:---------------------------------------------------------------------------------------------------------------- From Oracle Home as oracle user:- /o001/home/oracle/product/12.1.0/db_1/OPatch/opatch lsinventory -detail -oh /o001/home/oracle/product/12.1.0/db_1 From Grid Home as grid user:- /o001/home/12.1.0/grid/OPatch/opatch lsinventory -detail -oh /o001/home/12.1.0/grid As root user:- /o001/home/12.1.0/grid/OPatch/opatchauto apply /o002/Oct_PSU_Patch/26635815 -analyze export PATH=/o001/home/12.1.0/grid/OPatch:$PATH opatchauto apply <UNZIPPED_PATCH_LOCATION>/27010872 Check Oracle permission $ORACLE_HOME/lib/libsqlplus.so --- Should be 644 From both oracle and grid users:- opatch lsinventory col ACTION_TIME for a30 col BUNDLE_SERIES for a15 select ACTION_TIME,PATCH_ID,PATCH_UID,VERSION,ACTION,STATUS,BUNDLE_SERIES,BUNDLE_ID from dba_registry_sqlpatch; ###################################Amar Jadhav ######...
Read more