ORACLE 12.1.2, LINUX6.8,补丁集是 20180417 版本
[root@rac21 /u01/app/12.1.2/grid/OPatch]
#./opatchauto apply /backup/soft/Psu/20180417/p27468957/27468957
OPatchauto session is initiated at Sun Apr 29 17:37:54 2018
System initialization log file is /u01/app/12.1.2/grid/cfgtoollogs/opatchautodb/systemconfig2018-04-29_05-37-57PM.log.
Session log file is /u01/app/12.1.2/grid/cfgtoollogs/opatchauto/opatchauto2018-04-29_05-38-15PM.log
The id for this session is S3G2
Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.2/grid
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/12.1.2/product/db_1
Patch applicability verified successfully on home /u01/app/oracle/12.1.2/product/db_1
Patch applicability verified successfully on home /u01/app/12.1.2/grid
Verifying SQL patch applicability on home /u01/app/oracle/12.1.2/product/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/12.1.2/product/db_1
Preparing to bring down database service on home /u01/app/oracle/12.1.2/product/db_1
Successfully prepared home /u01/app/oracle/12.1.2/product/db_1 to bring down database service
Bringing down CRS service on home /u01/app/12.1.2/grid
Prepatch operation log file location: /u01/app/12.1.2/grid/cfgtoollogs/crsconfig/crspatch_rac21_2018-04-29_05-38-46PM.log
CRS service brought down successfully on home /u01/app/12.1.2/grid
Performing prepatch operation on home /u01/app/oracle/12.1.2/product/db_1
Perpatch operation completed successfully on home /u01/app/oracle/12.1.2/product/db_1
Start applying binary patch on home /u01/app/oracle/12.1.2/product/db_1
Binary patch applied successfully on home /u01/app/oracle/12.1.2/product/db_1
Performing postpatch operation on home /u01/app/oracle/12.1.2/product/db_1
Postpatch operation completed successfully on home /u01/app/oracle/12.1.2/product/db_1
Start applying binary patch on home /u01/app/12.1.2/grid
Binary patch applied successfully on home /u01/app/12.1.2/grid
Starting CRS service on home /u01/app/12.1.2/grid
Postpatch operation log file location: /u01/app/12.1.2/grid/cfgtoollogs/crsconfig/crspatch_rac21_2018-04-29_05-48-31PM.log
CRS service started successfully on home /u01/app/12.1.2/grid
Preparing home /u01/app/oracle/12.1.2/product/db_1 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /u01/app/oracle/12.1.2/product/db_1
SQL patch applied successfully on home /u01/app/oracle/12.1.2/product/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac21
RAC Home:/u01/app/oracle/12.1.2/product/db_1
Version:12.1.0.2.0
Summary:
==Following patches were SKIPPED:
Patch: /backup/soft/Psu/20180417/p27468957/27468957/26983807
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /backup/soft/Psu/20180417/p27468957/27468957/27338013
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /backup/soft/Psu/20180417/p27468957/27468957/27338020
Log: /u01/app/oracle/12.1.2/product/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-04-29_17-40-12PM_1.log
Patch: /backup/soft/Psu/20180417/p27468957/27468957/27338041
Log: /u01/app/oracle/12.1.2/product/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-04-29_17-40-12PM_1.log
Host:rac21
CRS Home:/u01/app/12.1.2/grid
Version:12.1.0.2.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /backup/soft/Psu/20180417/p27468957/27468957/26983807
Log: /u01/app/12.1.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-04-29_17-42-05PM_1.log
Patch: /backup/soft/Psu/20180417/p27468957/27468957/27338013
Log: /u01/app/12.1.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-04-29_17-42-05PM_1.log
Patch: /backup/soft/Psu/20180417/p27468957/27468957/27338020
Log: /u01/app/12.1.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-04-29_17-42-05PM_1.log
Patch: /backup/soft/Psu/20180417/p27468957/27468957/27338041
Log: /u01/app/12.1.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-04-29_17-42-05PM_1.log
Patching session reported following warning(s):
_________________________________________________
[WARNING] The database instance 'ncdb1' from '/u01/app/oracle/12.1.2/product/db_1', in host'rac21' 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 'orcl1' from '/u01/app/oracle/12.1.2/product/db_1', in host'rac21' 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.
OPatchauto session completed at Sun Apr 29 17:53:58 2018
Time taken to complete the session 16 minutes, 4 seconds
[root@rac21 /u01/app/12.1.2/grid/OPatch]
1 The database instance 'ncdb1' from '/u01/app/oracle/12.1.2/product/db_1', in host'rac21' 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).
我理解的意思,少跑了某个脚本,但不知道是哪个脚本?到 $ORACLE_HOME 目录下查看,也没找到 SQL CHANGES 这个文件,或类似的文件。
2 Refer to the readme to get the correct steps for applying the sql changes.
看了 README, 里面没提及这点,