Applying PSU Patch On 12c RAC In Solaris
Patching steps are different for different Operating systems. Below are the steps for applying PSU patch on 12C RAC in Solaris.
The patch can be downloaded from OTN . After downloading the patch, copy it to your both the nodes and unzip there.
Here i have unzipped to the location – /softdump/12C_GRIDSOFT/PATCH
1. Generate a response file for GRID_HOME[ FROM ROOT]
$GRID_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /softdump/12C_GRIDSOFT/PATCH/grid.rsp
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
The OCM configuration response file (/softdump/12C_GRIDSOFT/PATCH/grid.rsp) was successfully created.
2. Analyze the patch from GRID_HOME[ FROM ROOT]
--- go to Opatch location
cd $GRID_HOME/OPatch
-- run analyzer
./opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -analyze -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.10
OUI Version : 12.1.0.2.0
Running from : /crsapp/app/oracle/product/grid12c
opatchauto log file: /crsapp/app/oracle/product/grid12c/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-04-06_19-00-43_analyze.log
NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system.
OCM RSP file has been ignored in analyze mode.
Parameter Validation: Successful
Configuration Validation: Successful
Patch Location: /softdump/12C_GRIDSOFT/PATCH/22191349
Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
DB Patch(es): 21948344 21948354
Patch Validation: Successful
Grid Infrastructure home:
/crsapp/app/oracle/product/grid12c
DB home(s):
/oracle/app/oracle/product/12.1.0.2/dbhome_1
Analyzing patch(es) on "/oracle/app/oracle/product/12.1.0.2/dbhome_1" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully analyzed on "/oracle/app/oracle/product/12.1.0.2/dbhome_1" for apply.
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully analyzed on "/oracle/app/oracle/product/12.1.0.2/dbhome_1" for apply.
Analyzing patch(es) on "/crsapp/app/oracle/product/grid12c" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21436941" successfully analyzed on "/crsapp/app/oracle/product/grid12c" for apply.
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948341" successfully analyzed on "/crsapp/app/oracle/product/grid12c" for apply.
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully analyzed on "/crsapp/app/oracle/product/grid12c" for apply.
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully analyzed on "/crsapp/app/oracle/product/grid12c" for apply.
SQL changes, if any, are analyzed successfully on the following database(s): ULAPROD
Apply Summary:
Following patch(es) are successfully analyzed:
GI Home: /crsapp/app/oracle/product/grid12c: 21436941,21948341,21948344,21948354
DB Home: /oracle/app/oracle/product/12.1.0.2/dbhome_1: 21948344,21948354
opatchauto succeeded.
3. Run autopatch on node 1
This autopatch need to be applied on all the nodes of the rac
--- set ORACLE_HOME
export ORACLE_HOME=/crsapp/app/oracle/product/grid12c
cd $ORACLE_HOME/OPatch
-- run opatchauto utility
./opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.10
OUI Version : 12.1.0.2.0
Running from : /crsapp/app/oracle/product/grid12c
opatchauto log file: /crsapp/app/oracle/product/grid12c/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-04-07_09-17-04_deploy.log
Parameter Validation: Successful
Configuration Validation: Successful
Patch Location: /softdump/12C_GRIDSOFT/PATCH/22191349
Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
DB Patch(es): 21948344 21948354
Patch Validation: Successful
Grid Infrastructure home:
/crsapp/app/oracle/product/grid12c
DB home(s):
/oracle/app/oracle/product/12.1.0.2/dbhome_1
Performing prepatch operations on CRS Home... Successful
Applying patch(es) to "/oracle/app/oracle/product/12.1.0.2/dbhome_1" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully applied to "/oracle/app/oracle/product/12.1.0.2/dbhome_1".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully applied to "/oracle/app/oracle/product/12.1.0.2/dbhome_1".
Applying patch(es) to "/crsapp/app/oracle/product/grid12c" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21436941" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948341" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully applied to "/crsapp/app/oracle/product/grid12c".
Performing postpatch operations on CRS Home... Successful
SQL changes, if any, are applied successfully on the following database(s): ULAPROD
Apply Summary:
Following patch(es) are successfully installed:
GI Home: /crsapp/app/oracle/product/grid12c: 21436941,21948341,21948344,21948354
DB Home: /oracle/app/oracle/product/12.1.0.2/dbhome_1: 21948344,21948354
opatchauto succeeded.
4. Run autopatch on node 2
./opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.10
OUI Version : 12.1.0.2.0
Running from : /crsapp/app/oracle/product/grid12c
opatchauto log file: /crsapp/app/oracle/product/grid12c/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-04-07_09-47-28_deploy.log
Parameter Validation: Successful
Configuration Validation: Successful
Patch Location: /softdump/12C_GRIDSOFT/PATCH/22191349
Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
DB Patch(es): 21948344 21948354
Patch Validation: Successful
Grid Infrastructure home:
/crsapp/app/oracle/product/grid12c
DB home(s):
/oracle/app/oracle/product/12.1.0.2/dbhome_1
Performing prepatch operations on CRS Home... Successful
Applying patch(es) to "/oracle/app/oracle/product/12.1.0.2/dbhome_1" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully applied to "/oracle/app/oracle/product/12.1.0.2/dbhome_1".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully applied to "/oracle/app/oracle/product/12.1.0.2/dbhome_1".
Applying patch(es) to "/crsapp/app/oracle/product/grid12c" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21436941" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948341" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully applied to "/crsapp/app/oracle/product/grid12c".
Performing postpatch operations on CRS Home... Successful
SQL changes, if any, are applied successfully on the following database(s): ULAPROD
Apply Summary:
Following patch(es) are successfully installed:
GI Home: /crsapp/app/oracle/product/grid12c: 21436941,21948341,21948344,21948354
DB Home: /oracle/app/oracle/product/12.1.0.2/dbhome_1: 21948344,21948354
opatchauto succeeded.
5. Now check the status of CRS , and start them if not started.
SEE ALSO:
Applying JVM patch on RAC 12c
PATCH
ORACLE RAC
Profile photo of Admin
About Admin
View all posts by Admin →
Related Articles
How to move spfile from file system to ASM in RAC
How to change spfile in Oracle RAC.
Oracle local registry(OLR) in RAC
OLSNODES COMMANDS IN RAC
How to create ACFS file system in RAC using command line:
Create password files for database in ASM diskgroup
ASM_POWER_LIMIT in oracle ASM
OPATCHAUTO-72046: No wallet option provided
4 thoughts on “Applying PSU patch on 12c RAC in solaris”
shankar
MAY 26, 2017 AT 8:16 AM
Hi ,
can you just post the steps after the Patch to GRID 12C/11G Pls . it’s very good explanation . but once after completion the patch . does patch set will propogate to second node ( ROLLING PATCH concept) . or we want to move the patch manually ?
REPLY
Profile photo of AdminAdmin
MAY 26, 2017 AT 8:35 AM
Dear Shankar,
As I have mentioned in the beginning of the article, that, we need to copy the patch set software to both the nodes and unzip there.
And that opatchauto command, you need to apply the both the nodes, one after another. The Opatchauto will apply the patch to both grid and rdbms binary of the node automatically and do the post patch activities if any.
Regards
DBACLASS SUPPORT
REPLY
Prashant
NOVEMBER 17, 2017 AT 5:46 AM
Hello,
can you please let us know from which user do we need to apply patch , because some blog I saw patch applied to root user and above document seems patch applied through grid user.
REPLY
Profile photo of AdminAdmin
NOVEMBER 19, 2017 AT 10:39 AM
Hi Prashant,
Grid patch need to be applied from root user only . And in this article, also patch was applied from root user.
Regards
Admin
Patching steps are different for different Operating systems. Below are the steps for applying PSU patch on 12C RAC in Solaris.
The patch can be downloaded from OTN . After downloading the patch, copy it to your both the nodes and unzip there.
Here i have unzipped to the location – /softdump/12C_GRIDSOFT/PATCH
1. Generate a response file for GRID_HOME[ FROM ROOT]
$GRID_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /softdump/12C_GRIDSOFT/PATCH/grid.rsp
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
The OCM configuration response file (/softdump/12C_GRIDSOFT/PATCH/grid.rsp) was successfully created.
2. Analyze the patch from GRID_HOME[ FROM ROOT]
--- go to Opatch location
cd $GRID_HOME/OPatch
-- run analyzer
./opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -analyze -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.10
OUI Version : 12.1.0.2.0
Running from : /crsapp/app/oracle/product/grid12c
opatchauto log file: /crsapp/app/oracle/product/grid12c/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-04-06_19-00-43_analyze.log
NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system.
OCM RSP file has been ignored in analyze mode.
Parameter Validation: Successful
Configuration Validation: Successful
Patch Location: /softdump/12C_GRIDSOFT/PATCH/22191349
Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
DB Patch(es): 21948344 21948354
Patch Validation: Successful
Grid Infrastructure home:
/crsapp/app/oracle/product/grid12c
DB home(s):
/oracle/app/oracle/product/12.1.0.2/dbhome_1
Analyzing patch(es) on "/oracle/app/oracle/product/12.1.0.2/dbhome_1" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully analyzed on "/oracle/app/oracle/product/12.1.0.2/dbhome_1" for apply.
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully analyzed on "/oracle/app/oracle/product/12.1.0.2/dbhome_1" for apply.
Analyzing patch(es) on "/crsapp/app/oracle/product/grid12c" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21436941" successfully analyzed on "/crsapp/app/oracle/product/grid12c" for apply.
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948341" successfully analyzed on "/crsapp/app/oracle/product/grid12c" for apply.
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully analyzed on "/crsapp/app/oracle/product/grid12c" for apply.
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully analyzed on "/crsapp/app/oracle/product/grid12c" for apply.
SQL changes, if any, are analyzed successfully on the following database(s): ULAPROD
Apply Summary:
Following patch(es) are successfully analyzed:
GI Home: /crsapp/app/oracle/product/grid12c: 21436941,21948341,21948344,21948354
DB Home: /oracle/app/oracle/product/12.1.0.2/dbhome_1: 21948344,21948354
opatchauto succeeded.
3. Run autopatch on node 1
This autopatch need to be applied on all the nodes of the rac
--- set ORACLE_HOME
export ORACLE_HOME=/crsapp/app/oracle/product/grid12c
cd $ORACLE_HOME/OPatch
-- run opatchauto utility
./opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.10
OUI Version : 12.1.0.2.0
Running from : /crsapp/app/oracle/product/grid12c
opatchauto log file: /crsapp/app/oracle/product/grid12c/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-04-07_09-17-04_deploy.log
Parameter Validation: Successful
Configuration Validation: Successful
Patch Location: /softdump/12C_GRIDSOFT/PATCH/22191349
Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
DB Patch(es): 21948344 21948354
Patch Validation: Successful
Grid Infrastructure home:
/crsapp/app/oracle/product/grid12c
DB home(s):
/oracle/app/oracle/product/12.1.0.2/dbhome_1
Performing prepatch operations on CRS Home... Successful
Applying patch(es) to "/oracle/app/oracle/product/12.1.0.2/dbhome_1" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully applied to "/oracle/app/oracle/product/12.1.0.2/dbhome_1".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully applied to "/oracle/app/oracle/product/12.1.0.2/dbhome_1".
Applying patch(es) to "/crsapp/app/oracle/product/grid12c" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21436941" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948341" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully applied to "/crsapp/app/oracle/product/grid12c".
Performing postpatch operations on CRS Home... Successful
SQL changes, if any, are applied successfully on the following database(s): ULAPROD
Apply Summary:
Following patch(es) are successfully installed:
GI Home: /crsapp/app/oracle/product/grid12c: 21436941,21948341,21948344,21948354
DB Home: /oracle/app/oracle/product/12.1.0.2/dbhome_1: 21948344,21948354
opatchauto succeeded.
4. Run autopatch on node 2
./opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.10
OUI Version : 12.1.0.2.0
Running from : /crsapp/app/oracle/product/grid12c
opatchauto log file: /crsapp/app/oracle/product/grid12c/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-04-07_09-47-28_deploy.log
Parameter Validation: Successful
Configuration Validation: Successful
Patch Location: /softdump/12C_GRIDSOFT/PATCH/22191349
Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
DB Patch(es): 21948344 21948354
Patch Validation: Successful
Grid Infrastructure home:
/crsapp/app/oracle/product/grid12c
DB home(s):
/oracle/app/oracle/product/12.1.0.2/dbhome_1
Performing prepatch operations on CRS Home... Successful
Applying patch(es) to "/oracle/app/oracle/product/12.1.0.2/dbhome_1" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully applied to "/oracle/app/oracle/product/12.1.0.2/dbhome_1".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully applied to "/oracle/app/oracle/product/12.1.0.2/dbhome_1".
Applying patch(es) to "/crsapp/app/oracle/product/grid12c" ...
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21436941" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948341" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948344" successfully applied to "/crsapp/app/oracle/product/grid12c".
Patch "/softdump/12C_GRIDSOFT/PATCH/22191349/21948354" successfully applied to "/crsapp/app/oracle/product/grid12c".
Performing postpatch operations on CRS Home... Successful
SQL changes, if any, are applied successfully on the following database(s): ULAPROD
Apply Summary:
Following patch(es) are successfully installed:
GI Home: /crsapp/app/oracle/product/grid12c: 21436941,21948341,21948344,21948354
DB Home: /oracle/app/oracle/product/12.1.0.2/dbhome_1: 21948344,21948354
opatchauto succeeded.
5. Now check the status of CRS , and start them if not started.
SEE ALSO:
Applying JVM patch on RAC 12c
PATCH
ORACLE RAC
Profile photo of Admin
About Admin
View all posts by Admin →
Related Articles
How to move spfile from file system to ASM in RAC
How to change spfile in Oracle RAC.
Oracle local registry(OLR) in RAC
OLSNODES COMMANDS IN RAC
How to create ACFS file system in RAC using command line:
Create password files for database in ASM diskgroup
ASM_POWER_LIMIT in oracle ASM
OPATCHAUTO-72046: No wallet option provided
4 thoughts on “Applying PSU patch on 12c RAC in solaris”
shankar
MAY 26, 2017 AT 8:16 AM
Hi ,
can you just post the steps after the Patch to GRID 12C/11G Pls . it’s very good explanation . but once after completion the patch . does patch set will propogate to second node ( ROLLING PATCH concept) . or we want to move the patch manually ?
REPLY
Profile photo of AdminAdmin
MAY 26, 2017 AT 8:35 AM
Dear Shankar,
As I have mentioned in the beginning of the article, that, we need to copy the patch set software to both the nodes and unzip there.
And that opatchauto command, you need to apply the both the nodes, one after another. The Opatchauto will apply the patch to both grid and rdbms binary of the node automatically and do the post patch activities if any.
Regards
DBACLASS SUPPORT
REPLY
Prashant
NOVEMBER 17, 2017 AT 5:46 AM
Hello,
can you please let us know from which user do we need to apply patch , because some blog I saw patch applied to root user and above document seems patch applied through grid user.
REPLY
Profile photo of AdminAdmin
NOVEMBER 19, 2017 AT 10:39 AM
Hi Prashant,
Grid patch need to be applied from root user only . And in this article, also patch was applied from root user.
Regards
Admin
No comments:
Post a Comment