oracle psu补丁sql脚本,打上12.1.2的最新PSU补丁集(20180417),打完后发现没跑脚本,如何补救?...

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, 里面没提及这点,

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值