Skip to main content

12c GRID PSU Patch Apply

###################################################

GRID PSU Patch Analyze: Checks for Conflicts
=============================================


[root@server1 cfgtoollogs]# /oracrs/oracle/product/12102/OPatch/opatchauto apply /path1/patches/23273629 -analyze
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       : /oracrs/oracle/product/12102

opatchauto log file: /oracrs/oracle/product/12102/cfgtoollogs/opatchauto/23273629/opatch_gi_2016-11-25_21-57-51_analyze.log

NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system.

Parameter Validation: Successful

Configuration Validation: Successful

Patch Location: /path1/patches/23273629
Grid Infrastructure Patch(es): 21436941 23054246 23054327 23054341
DB Patch(es): 23054246 23054327

Patch Validation: Successful
Grid Infrastructure home:
/oracrs/oracle/product/12102
DB home(s):
/test/oracle/product/12102


Analyzing patch(es) on "/test/oracle/product/12102" ...
Patch "/path1/patches/23273629/23054246" successfully analyzed on "/test/oracle/product/12102" for apply.
Patch "/path1/patches/23273629/23054327" successfully analyzed on "/test/oracle/product/12102" for apply.

Analyzing patch(es) on "/oracrs/oracle/product/12102" ...
Patch "/path1/patches/23273629/21436941" successfully analyzed on "/oracrs/oracle/product/12102" for apply.
Patch "/path1/patches/23273629/23054246" successfully analyzed on "/oracrs/oracle/product/12102" for apply.
Patch "/path1/patches/23273629/23054327" successfully analyzed on "/oracrs/oracle/product/12102" for apply.
Patch "/path1/patches/23273629/23054341" successfully analyzed on "/oracrs/oracle/product/12102" for apply.

[WARNING] The local database instance 'test1' from '/test/oracle/product/12102' is not running. SQL changes, if any,  will not be analyzed. Please refer to the log file for more details.

Apply Summary:
Following patch(es) are successfully analyzed:
GI Home: /oracrs/oracle/product/12102: 21436941,23054246,23054327,23054341
DB Home: /test/oracle/product/12102: 23054246,23054327

opatchauto succeeded.
[root@server1 cfgtoollogs]#


######################################################################


GRID PSU Patch Apply:
==========================

[root@server1 cfgtoollogs]# /oracrs/oracle/product/12102/OPatch/opatchauto apply /path1/patches/23273629 -oh /oracrs/oracle/product/12102 -ocmrf /tmp/ocm.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       : /oracrs/oracle/product/12102

opatchauto log file: /oracrs/oracle/product/12102/cfgtoollogs/opatchauto/23273629/opatch_gi_2016-11-25_22-01-33_deploy.log

Parameter Validation: Successful

Configuration Validation: Successful

Patch Location: /path1/patches/23273629
Grid Infrastructure Patch(es): 21436941 23054246 23054327 23054341
DB Patch(es): 23054246 23054327

Patch Validation: Successful
User specified following Grid Infrastructure home:
/oracrs/oracle/product/12102


Performing prepatch operations on CRS Home... Successful

Applying patch(es) to "/oracrs/oracle/product/12102" ...
Patch "/path1/patches/23273629/21436941" successfully applied to "/oracrs/oracle/product/12102".
Patch "/path1/patches/23273629/23054246" successfully applied to "/oracrs/oracle/product/12102".
Patch "/path1/patches/23273629/23054327" successfully applied to "/oracrs/oracle/product/12102".
Patch "/path1/patches/23273629/23054341" successfully applied to "/oracrs/oracle/product/12102".

Performing postpatch operations on CRS Home... Successful

Apply Summary:
Following patch(es) are successfully installed:
GI Home: /oracrs/oracle/product/12102: 21436941,23054246,23054327,23054341

opatchauto succeeded.
You have new mail in /var/spool/mail/root
[root@server1 cfgtoollogs]#


#####################################################

-bash-4.1$ opatch lspatches
23054341;ACFS Patch Set Update : 12.1.0.2.160719 (23054341)
23054327;OCW Patch Set Update : 12.1.0.2.160719 (23054327)
23054246;Database Patch Set Update : 12.1.0.2.160719 (23054246)
21436941;WLM Patch Set Update: 12.1.0.2.5 (21436941)

OPatch succeeded.
-bash-4.1$

#####################################################


Comments

Post a Comment

Popular posts from this blog

CLSRSC-430: Failed to start rolling patch mode

############################################################ GRID PSU Failed on Node2: =========================== [root@server1 tmp]# /oracrs/oracle/product/12102/OPatch/opatchauto apply /path1/patches/23273629 -oh /oracrs/oracle/product/12102 -ocmrf /tmp/ocm.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       : /oracrs/oracle/product/12102 opatchauto log file: /oracrs/oracle/product/12102/cfgtoollogs/opatchauto/23273629/opatch_gi_2016-11-25_06-13-44_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location: /path1/patches/23273629 Grid Infrastructure Patch(es): 21436941 23054246 23054327 23054341 DB Patch(es): 23054246 23054327 The following patch(es) are duplicate patches with patches installed in the Oracle Home.  [ 20299023] You hav...
2 comments
Read more

SQL Plan Management [ SPM ]

============================================= SQL> SHOW parameter baselines NAME                                 TYPE        VALUE ------------------------------------ ----------- ------- optimizer_capture_sql_plan_baselines boolean     FALSE optimizer_use_sql_plan_baselines     boolean     TRUE SQL> ============================================= Connect as SPM user and create a table as follows. -------------------------------------------------- SQL> CREATE TABLE EMPLOYEE (code number,dept char(100),address char(1000)); Table created. SQL> ============================================= Populate some rows in the table =================================== declare c1 number; begin for c1 IN 1..10000 ...
Post a Comment
Read more