Oracle 12.1.0.1 GI + DATABASE hitting PSU

Oracle 12.1.0.1 GI + DATABASE hitting PSU
12.1.0.1 Patch Set Update 12.1.0.1.9 (Oct2015) machine: Two OLE6.5 machines, and the RAC preparation of 12.1.0.1 installed: Download The p6880880_121010_Linux-x86-64 (OPATCH Toolkit ), p21551666_121010_Linux-x86-64 (PSU for GI and DATABASE) implementation process: first upgrade the GI software OPATCH tool su-grid -- My p6880880_121010_Linux-x86-64 is placed under the/u01/app/opatch/directory cd/u01/app/opatch/unzip p6880880_121010_Linux-x86-64 [grid @ rac1 opatch] $ which crs_stat/u01/app/grid/12.1.0.1/bin/crs_stat -- back up the original OPatch tool su-cd/u01/app/grid/12.1.0.1/mv OPatch/OPatch_bak --- copy the decompressed OPatch to/u01/app/grid/12.1.0.1/For opatch upgrade mv/u01/app/opatch/OPatch // u01/app/grid/12.1.0.1 su-grid [grid @ rac1 OPatch] $. /opatch versionOPatch Version: 12.1.0.1.9 OPatch succeeded. -- database software opatch upgrade su-oracle cd/u01/app/opatch/-- same ORACLE user to unzip OPatch tool unzip p6880880_121010_Linux-x86-64 [oracle @ rac1 opatch] $ which sqlplus/u01 /app/oracle/12.1.0/db_1/bin/sqlplus mv/u01/app/oracle/12.1.0/db_1/OPatch/u01/app/oracle/12.1.0/db_1/OPatch_bak mv/u01 /app/opatch/OPatch // u01/app/oracle/12.1.0/db_1 cd/u01/app/oracle/12.1.0/db_1/OPatch [oracle @ rac1 OPatch] $. /opatch versionOPatch Version: 12.1.0.1.9 OPatch succeeded. the above OPatch tool must be upgraded on both nodes. Before the GI upgrade, you can back up the GI software, su-crsctl stop crs, and then tar the GI software, even if the patch fails. rollback cd/u01/app/grid/12.1.0.1/OPatch/ocm/bin/[grid @ rac1 bin] $ chmod u + x emocmrsp [grid @ rac1 bin] $. /emocmrspOCM Installation Response Generator 10.3.7.0.0-ProductionCopyright (c) 2005,201 2, Oracle and/or its affiliates. all rights reserved. provide your email address to be informed of security issues, install andinitiate Oracle Configuration Manager. easier for you if you use your MyOracle 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]: yThe OCM configuration response file (ocm. rsp) was successfully created. [grid @ rac1 bin] $ [grid @ rac1 bin] $ [grid @ rac1 bin] $ ls-ltotal 16-rwxr-x --- 1 grid oinstall 9063 Nov 27 2009 emocmrsp-rw-r -- r -- 1 grid oinstall 621 Oct 28 ocm. rsp [oracle @ rac1 OPatch] $ cd/u01/app/oracle/12.1.0/db_1/OPatch [oracle @ rac1 bin] $ ls-ltotal 12-rwxr-x --- 1 oracle oinstall 9063 Nov 27 2009 emocmrsp [oracle @ rac1 bin] $ chmod u + x emocmrsp [oracle @ rac1 bin] $ ls-ltotal 12-rwxr-x --- 1 oracle oinstall 9063 Nov 27 2009 emocmrsp [oracle @ rac1 bin] $. /emocmrsp OCM Installation Response Generator 10.3.7.0.0-ProductionCopyright (c) 2005,201 2, Oracle and/or its affiliates. all rights reserved. provide your email address to be informed of security issues, install andinitiate Oracle Configuration Manager. easier for you if you use your MyOracle 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]: yThe OCM configuration response file (ocm. rsp) was successfully created. ---- check the inventory information consistency of each database. /U01/app/grid/12.1.0.1/OPatch/opatch lsinventory-detail-oh/u01/app/grid/12.1.0.1/u01/app/oracle/12.1.0/db_1/OPatch/opatch lsinventory -detail-oh/u01/app/oracle/12.1.0/db_1/u01/app/grid/12.1.0.1/OPatch/opatchauto apply/u01/app/patch/21551666-ocmrf/u01/ app/grid/12.1.0.1/OPatch/ocm/bin/ocm. rsp -- start to upgrade GI and database (I am playing psu together with GI + DATABASE, you can also separate them) [root @ rac1 ~] #/U01/app/grid/12.1.0.2/OPatch/opatchauto apply/u01/app/patches/21551666-ocmrf/u01/app/grid/12.1.0.2/OPatch/ocm/bin/ocm. rsp OPatch Automation ToolCopyright (c) 2014, Oracle Corporation. all rights reserved. OPatchauto Version: 12.1.0.1.9OUI Version: 12.1.0.1.0Running from:/u01/app/grid/12.1.0.2 opatchauto log file:/u01/app/grid/12.1.0.2/export toollogs/opatchauto/21551666/opatch_gi_2015-10-28_15- 21-23_deploy.log Parameter Validation: Successful Configuration Validation: Successful Patch Location:/u01/app/patch/21551666 Grid Infrastructure Patch (es): 17077442 17303297 21352619 DB Patch (es ): 17077442 21352619 Patch Validation: SuccessfulGrid Infrastructure home:/u01/app/grid/12.1.0.2DB home (s ): /u01/app/oracle/12.1.0/db_1 padding Ming prepatch operations on CRS Home... successful Applying patc H (es) to "/u01/app/oracle/12.1.0/db_1 "... patch "/u01/app/patch/21551666/17077442" successfully applied to "/u01/app/oracle/12.1.0/db_1 ". patch "/u01/app/patch/21551666/21352619" successfully applied to "/u01/app/oracle/12.1.0/db_1 ". applying patch (es) to "/u01/app/grid/12.1.0.2 "... patch "/u01/app/patch/21551666/17077442" successfully applied to "/u01/app/grid/12.1.0.2 ". patch "/u01/app/patch/21551 666/17303297 "successfully applied to"/u01/app/grid/12.1.0.2 ". patch "/u01/app/patch/21551666/21352619" successfully applied to "/u01/app/grid/12.1.0.2 ". deming postpatch operations on CRS Home... successful SQL changes, if any, are applied successfully on the following database (s): rac Apply Summary: Following patch (es) are successfully installed: GI Home: /u01/app/grid/12.1.0.2: 17077442,17303 297,213 52619DB Home:/u01/app/oracle/12.1.0/db_1: 17077442,41552619 opatchauto succeeded. --- the preceding steps must be performed on both machines. -- After the upgrade, you need to apply the database. RAC only needs to run on one of the instances to run su-oracle cd $ ORACLE_HOME/OPatch. /datapatch-verbose cd $ ORACLE_HOME/rdbms/admin sqlplus/as sysdba SQL> @ utlrp. SQL set line 200col COMMENTS for a20col ACTION_TIME for a30 SELECT * FROM dba_registry_history; ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS ---------------------------- too many ----------------------------------------------------------------------------------------- -Parallel ---------- parallel segment 16-SEP-15 parallel am apply server 12.1.0.1 0 PSU Patchset 12.1.0.0.028-OCT-15 parallel pm apply server 12.1.0.1 9 PSU 12.1.0.1.928-OCT-15 parallel pm apply server 12.1.0.1 9 PSU 12.1.0.1.928-OCT-15 pm apply server 12.1.0.1 9 PSU 12.1.0.1.928-OCT-15 04.55. 50.409272 pm apply server 12.1.0.1 9 PSU 12.1.0.1.9 -- the query result shows that the database has applied patches.