记录一次打补丁的情况:27182006

记录依次打补丁记录:
readme.txt与实际操作有差别

[root@ykcdb04:/diaglog/patch/27182006]{20180709+0 14:28:06}# /u01/app/12.2.0/grid/OPatch/opatchauto apply /diaglog/patch/27182006 -analyze
OPatchauto session is initiated at Mon Jul  9 14:28:35 2018
System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-07-09_02-28-45PM.log.
Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-07-09_02-30-57PM.log
The id for this session is A7NV
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/db_1
Patch applicability verified successfully on home /u01/app/12.2.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1
Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Skipping SQL patch step execution on standby database : scmb
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:ykcdb04
CRS Home:/u01/app/12.2.0/gri
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /diaglog/patch/27182006/27182006
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-07-09_14-31-13PM_1.log
Host:ykcdb04
RAC Home:/u01/app/oracle/product/12.2.0/db_1
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /diaglog/patch/27182006/27182006
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-07-09_14-31-17PM_1.log
OPatchauto session completed at Mon Jul  9 14:36:43 2018
Time taken to complete the session 8 minutes, 9 seconds
[root@ykcdb04:/diaglog/patch/27182006]{20180709+0 14:36:43}#

两边同时打补丁报错,可能需要加参数

[root@ykcdb03:/diaglog]{20180709+0 14:42:19}#  /u01/app/12.2.0/grid/OPatch/opatchauto apply /diaglog/patch/27182006
OPatchauto session is initiated at Mon Jul  9 14:42:32 2018
System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-07-09_02-42-46PM.log.
Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-07-09_02-44-46PM.log
The id for this session is NGNS
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/db_1
Patch applicability verified successfully on home /u01/app/12.2.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_
Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Skipping SQL patch step execution on standby database : scmb
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/
Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/db_1
Successfully prepared home /u01/app/oracle/product/12.2.0/db_1 to bring down database service
Bringing down CRS service on home /u01/app/12.2.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/ykcdb03/crsconfig/crspatch_ykcdb03_2018-07-09_02-50-43PM.log
Failed to bring down CRS service on home /u01/app/12.2.0/grid
Execution of [GIShutDownAction] patch action failed, check log for more details. Failures:
Patch Target : ykcdb03->/u01/app/12.2.0/grid Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/12.2.0/grid, host: ykcdb03.
Command failed:  /u01/app/12.2.0/grid/perl/bin/perl -I
/u01/app/12.2.0/grid/perl/lib -I
/u01/app/12.2.0/grid/OPatch/auto/dbtmp/bootstrap_ykcdb03/patchwork/crs/install /u01/app/12.2.0/grid/OPatch/auto/dbtmp/bootstrap_ykcdb03/patchwork/crs/install/rootcrs.pl -prepatch
Command failure output: 
Using configuration parameter file: /u01/app/12.2.0/grid/OPatch/auto/dbtmp/bootstrap_ykcdb03/patchwork/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/ykcdb03/crsconfig/crspatch_ykcdb03_2018-07-09_02-50-43PM.log
Oracle Clusterware active version on the cluster is [12.2.0.1.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [448950863].
CRS-1159: The cluster cannot be set to rolling patch mode because Oracle Clusterware is not active on at least one remote node.
CRS-4000: Command Start failed, or completed with errors.
2018/07/09 14:50:58 CLSRSC-430: Failed to start rolling patch mode 
After fixing the cause of failure Run opatchauto resume with session id "NGNS"
]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.
OPatchauto session completed at Mon Jul  9 14:51:04 2018
Time taken to complete the session 8 minutes, 35 seconds
 opatchauto failed with error code 42
[root@ykcdb03:/diaglog]{20180709+0 14:51:04}#

一节点打补丁成功

[root@ykcdb04:/diaglog/patch/27182006]{20180709+0 14:38:30}# /u01/app/12.2.0/grid/OPatch/opatchauto apply /diaglog/patch/27182006
OPatchauto session is initiated at Mon Jul  9 14:38:46 2018
System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-07-09_02-38-56PM.log.
Sesson log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-07-09_02-40-20PM.log
The id for this session is CSCV
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/db_1
Patch applicability verified successfully on home /u01/app/12.2.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1
Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Skipping SQL patch step execution on standby database : scmb
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1
Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/db_1
Successfully prepared home /u01/app/oracle/product/12.2.0/db_1 to bring down database service
Bringing down CRS service on home /u01/app/12.2.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/ykcdb04/crsconfig/crspatch_ykcdb04_2018-07-09_02-46-25PM.log
CRS service brought down successfully on home /u01/app/12.2.0/grid
Performing prepatch operation on home /u01/app/oracle/product/12.2.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1
Start applying binary patch on home /u01/app/oracle/product/12.2.0/db_1
Successfully executed command: /usr/sbin/slibclean
Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1
Performing postpatch operation on home /u01/app/oracle/product/12.2.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_1
Start applying binary patch on home /u01/app/12.2.0/grid
Successfully executed command: /usr/sbin/slibclean
Binary patch applied successfully on home /u01/app/12.2.0/grid
Starting CRS service on home /u01/app/12.2.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/ykcdb04/crsconfig/crspatch_ykcdb04_2018-07-09_03-00-06PM.log
CRS service started successfully on home /u01/app/12.2.0/grid
Preparing home /u01/app/oracle/product/12.2.0/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.2.0/db_1 successfully after database service restarted
Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/db_1
Skipping SQL patch step execution on standby database : scmb
SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:ykcdb04
RAC Home:/u01/app/oracle/product/12.2.0/db_1
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /diaglog/patch/27182006/27182006
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-07-09_14-48-48PM_1.log
Host:ykcdb04
CRS Home:/u01/app/12.2.0/grid
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /diaglog/patch/27182006/27182006
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-07-09_14-50-35PM_1.log
Patching session reported following warning(s): 
[WARNING] The database instance 'db12c2' from '/u01/app/oracle/product/12.2.0/db_1', in host'ykcdb04' is not running. SQL changes, if any,  will not be applied.
To apply. the SQL changes, bring up the database instance and run the command manually from any one node (run as oracle).
Refer to the readme to get the correct steps for applying the sql changes.
[WARNING] The database instance 'fscmb2' from '/u01/app/oracle/product/12.2.0/db_1', in host'ykcdb04' is not running. SQL changes, if any,  will not be applied.
To apply. the SQL changes, bring up the database instance and run the command manually from any one node (run as oracle).
Refer to the readme to get the correct steps for applying the sql changes.
This entry was posted in oracle 12c, 学习. Bookmark the permalink.