Oracle 19c rac PSU安装及问题 - CRS-6706: Oracle Clusterware Release patch level ('nnn') does not match

最新推荐文章于 2023-08-16 19:01:34 发布
最新推荐文章于 2023-08-16 19:01:34 发布
阅读量2.5k 收藏
点赞数
分类专栏： Patches
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xxzhaobb/article/details/105863140
版权

-- 19c rac 19.3.0.0 安装PSU  19.7.0.0.200414
/stage 下的补丁文件夹的属性是grid:oinstall

--GI用户下

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30869156
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30894985
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30869304
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30898856


[root@node19c01 stage]# su - grid
Last login: Thu Apr 30 10:29:45 CST 2020 on pts/0
[grid@node19c01 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30869156
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.0.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2020-04-30_10-31-05AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@node19c01 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30894985
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.0.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2020-04-30_10-31-24AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@node19c01 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30869304
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.0.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2020-04-30_10-31-40AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@node19c01 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.0.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2020-04-30_10-31-54AM_1.log

This command doesn't support System Patch.

OPatch failed with error code 21
[grid@node19c01 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30898856
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/19.0.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.0.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.0.0/grid/cfgtoollogs/opatch/opatch2020-04-30_10-32-15AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@node19c01 ~]$

-- oracle用户下

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30869156
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30894985

[root@node19c01 stage]# su - oracle
Last login: Thu Apr 30 10:26:17 CST 2020 on pts/1
[oracle@node19c01 ~]$ 
[oracle@node19c01 ~]$ 
[oracle@node19c01 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30869156
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2020-04-30_10-33-45AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@node19c01 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30894985
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2020-04-30_10-33-57AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@node19c01 ~]$

-- gi下 ,不做了 。。。 主要是检查$ORACLE_HOME系统空间 。空间充足

cat /tmp/patch_list_gihome.txt

/stage/30899722/30869156
/stage/30899722/30894985
/stage/30899722/30869304
/stage/30899722/
/stage/30899722/30898856

$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt

-- ora下，不做了，空间充足

cat /tmp/patch_list_dbhome.txt
/stage/30899722/30869156
/stage/30899722/30894985

$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

-- 分析冲突
-- 分析冲突 ,GI_HOME路径下 ，在root下 ，会把GI_HOME和DB_HOME都分析。

GRID_HOME/OPatch/opatchauto apply /stage/30899722 -analyze

[root@node19c01 grid]# $ORACLE_HOME/OPatch/opatchauto apply /stage/30899722 -analyze

OPatchauto session is initiated at Thu Apr 30 10:39:59 2020

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-04-30_10-40-07AM.log.

Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2020-04-30_10-41-44AM.log
The id for this session is NJJN

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/db_1

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1

Patch applicability verified successfully on home /u01/app/19.0.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:node19c01
RAC Home:/u01/app/oracle/product/19.0.0/db_1
Version:19.0.0.0.0


==Following patches were SKIPPED:

Patch: /stage/30899722/30869304
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /stage/30899722/30898856
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /stage/30899722/30894985
Log: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_10-42-21AM_1.log

Patch: /stage/30899722/30869156
Log: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_10-42-21AM_1.log


Host:node19c01
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /stage/30899722/30894985
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_10-42-20AM_1.log

Patch: /stage/30899722/30869304
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_10-42-20AM_1.log

Patch: /stage/30899722/30898856
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_10-42-20AM_1.log

Patch: /stage/30899722/30869156
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_10-42-20AM_1.log



OPatchauto session completed at Thu Apr 30 10:43:40 2020
Time taken to complete the session 3 minutes, 42 seconds
[root@node19c01 grid]#

-- OPatch auto 进行安装，在第一个节点上。

[root@asm19c OPatch]# ./opatchauto apply /stage/30899722
opatchauto apply /stage/30899722

[grid@node19c01 ~]$ su root
Password: 
[root@node19c01 grid]# cd $ORACLE_HOME/OPatch
[root@node19c01 OPatch]# ./opatchauto apply /stage/30899722

OPatchauto session is initiated at Thu Apr 30 10:47:56 2020

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-04-30_10-48-03AM.log.

Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2020-04-30_10-49-40AM.log
The id for this session is EXYR

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/db_1

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1

Patch applicability verified successfully on home /u01/app/19.0.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1


Preparing to bring down database service on home /u01/app/oracle/product/19.0.0/db_1
Successfully prepared home /u01/app/oracle/product/19.0.0/db_1 to bring down database service


Bringing down CRS service on home /u01/app/19.0.0/grid
CRS service brought down successfully on home /u01/app/19.0.0/grid


Performing prepatch operation on home /u01/app/oracle/product/19.0.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/19.0.0/db_1


Start applying binary patch on home /u01/app/oracle/product/19.0.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/19.0.0/db_1


Performing postpatch operation on home /u01/app/oracle/product/19.0.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19.0.0/db_1


Start applying binary patch on home /u01/app/19.0.0/grid
Binary patch applied successfully on home /u01/app/19.0.0/grid


Starting CRS service on home /u01/app/19.0.0/grid
CRS service started successfully on home /u01/app/19.0.0/grid


Preparing home /u01/app/oracle/product/19.0.0/db_1 after database service restarted
No step execution required.........
 

Trying to apply SQL patch on home /u01/app/oracle/product/19.0.0/db_1
SQL patch applied successfully on home /u01/app/oracle/product/19.0.0/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:node19c01
RAC Home:/u01/app/oracle/product/19.0.0/db_1
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /stage/30899722/30869304
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /stage/30899722/30898856
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /stage/30899722/30869156
Log: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_10-55-58AM_1.log

Patch: /stage/30899722/30894985
Log: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_10-55-58AM_1.log


Host:node19c01
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /stage/30899722/30869156
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_11-02-45AM_1.log

Patch: /stage/30899722/30869304
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_11-02-45AM_1.log

Patch: /stage/30899722/30894985
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_11-02-45AM_1.log

Patch: /stage/30899722/30898856
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_11-02-45AM_1.log



OPatchauto session completed at Thu Apr 30 11:24:39 2020
Time taken to complete the session 36 minutes, 44 seconds
[root@node19c01 OPatch]#

-- 节点2  ，在节点2上安装的时候，出现错误。

[root@node19c02 grid]# cd $ORACLE_HOME/OPatch
[root@node19c02 OPatch]# ./opatchauto apply /stage/30899722

OPatchauto session is initiated at Thu Apr 30 11:42:12 2020

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-04-30_11-42-19AM.log.

Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2020-04-30_11-43-53AM.log
The id for this session is H3TY

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1

Patch applicability verified successfully on home /u01/app/19.0.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1


Preparing to bring down database service on home /u01/app/oracle/product/19.0.0/db_1
Successfully prepared home /u01/app/oracle/product/19.0.0/db_1 to bring down database service


Bringing down CRS service on home /u01/app/19.0.0/grid
CRS service brought down successfully on home /u01/app/19.0.0/grid


Performing prepatch operation on home /u01/app/oracle/product/19.0.0/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/19.0.0/db_1


Start applying binary patch on home /u01/app/oracle/product/19.0.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/19.0.0/db_1


Performing postpatch operation on home /u01/app/oracle/product/19.0.0/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19.0.0/db_1


Start applying binary patch on home /u01/app/19.0.0/grid
Failed while applying binary patches on home /u01/app/19.0.0/grid

Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : node19c02->/u01/app/19.0.0/grid Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/19.0.0/grid, host: node19c02.
Command failed:  /u01/app/19.0.0/grid/OPatch/opatchauto  apply /stage/30899722 -oh /u01/app/19.0.0/grid -target_type cluster -binary -invPtrLoc /u01/app/19.0.0/grid/oraInst.loc -jre /u01/app/19.0.0/grid/OPatch/jre -persistresult /u01/app/19.0.0/grid/opatchautocfg/db/sessioninfo/sessionresult_node19c02_crs.ser -analyzedresult /u01/app/19.0.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_node19c02_crs.ser
Command failure output: 
==Following patches FAILED in apply:

Patch: /stage/30899722/30869156
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-30_13-34-42PM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: ApplySession failed in system modification phase... 'ApplySession::apply failed: java.io.IOException: oracle.sysman.oui.patch.PatchException: java.io.FileNotFoundException: /u01/app/oraInventory/ContentsXML/oui-patch.xml (Permission denied)' 

After fixing the cause of failure Run opatchauto resume

]
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 Thu Apr 30 13:42:06 2020
Time taken to complete the session 119 minutes, 54 seconds

 opatchauto failed with error code 42

-- 查询这个xml文件的权限，在节点1上是 oracle:oinstall,在节点2上是grid:oinstall

[root@node19c01 ~]# ls -l /u01/app/oraInventory/ContentsXML/oui-patch.xml
-rw-rw---- 1 grid oinstall 174 Apr 30 11:14 /u01/app/oraInventory/ContentsXML/oui-patch.xml
[root@node19c01 ~]#

[root@node19c02 OPatch]# ls -l /u01/app/oraInventory/ContentsXML/oui-patch.xml
-rw-r--r-- 1 oracle oinstall 174 Apr 30 13:34 /u01/app/oraInventory/ContentsXML/oui-patch.xml
[root@node19c02 OPatch]#

--启动节点2上的crs，出现错误，启动不了。提示 CRS-6706: Oracle Clusterware Release patch level ('nnn') does not match Software patch level ('mmm')
-- 参考MOS文档处理
CRS-6706: Oracle Clusterware Release patch level ('nnn') does not match Software patch level ('mmm') (文档 ID 1639285.1)
Patching 12.2.0.1 Grid Infrastructure gives error CRS-6706: Oracle Clusterware Release Patch Level ('748994161') Does Not Match Software Patch Level (文档 ID 2348013.1)    -- 实际参考这个文档

[root@node19c02 bin]# ./clscfg -localpatch
clscfg: EXISTING configuration version 0 detected.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
[root@node19c02 bin]# ./rootcrs.sh -lock
-bash: ./rootcrs.sh: No such file or directory
[root@node19c02 bin]# ls -l rootcrs*
ls: cannot access rootcrs*: No such file or directory
[root@node19c02 bin]# 
[root@node19c02 bin]# 
[root@node19c02 bin]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@node19c02 bin]#

-- 进行回滚，回滚失败
-- 再次对补丁进行分析，提示补丁已经安装上了 。
-- 再次分析

[root@node19c02 grid]# $ORACLE_HOME/OPatch/opatchauto apply /stage/30899722 -analyze

OPatchauto session is initiated at Thu Apr 30 14:32:08 2020

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-04-30_02-32-16PM.log.

Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2020-04-30_02-33-48PM.log
The id for this session is 7D8X

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0/db_1
Patch applicability verified successfully on home /u01/app/19.0.0/grid

Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Analysis for applying patches has failed:

Host:node19c02
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Analysis for patches has failed.


==Following patches FAILED in analysis for apply:

Patch: /stage/30899722/30894985
Log: 
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
   ORACLE_HOME/inventory/oneoffs/30869156 is corrupted. PatchObject constructor: Input file "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/actions" or "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/inventory" does not exist.


Patch: /stage/30899722/30869304
Log: 
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
   ORACLE_HOME/inventory/oneoffs/30869156 is corrupted. PatchObject constructor: Input file "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/actions" or "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/inventory" does not exist.


Patch: /stage/30899722/30898856
Log: 
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
   ORACLE_HOME/inventory/oneoffs/30869156 is corrupted. PatchObject constructor: Input file "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/actions" or "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/inventory" does not exist.


Patch: /stage/30899722/30869156
Log: 
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
   ORACLE_HOME/inventory/oneoffs/30869156 is corrupted. PatchObject constructor: Input file "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/actions" or "/u01/app/19.0.0/grid/inventory/oneoffs/30869156/etc/config/inventory" does not exist.



Host:node19c02
RAC Home:/u01/app/oracle/product/19.0.0/db_1
Version:19.0.0.0.0


==Following patches were SKIPPED:

Patch: /stage/30899722/30869304
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /stage/30899722/30898856
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /stage/30899722/30894985
Reason: This patch is already been applied, so not going to apply again.

Patch: /stage/30899722/30869156
Reason: This patch is already been applied, so not going to apply again.


OPATCHAUTO-72053: Analysis for the patches failed.
OPATCHAUTO-72053: Command execution failed.
OPATCHAUTO-72053: Please check the summary for more details.

OPatchauto session completed at Thu Apr 30 14:36:11 2020
Time taken to complete the session 4 minutes, 3 seconds
[root@node19c02 grid]#

-- 应用补丁，在任意一个节点上执行即可。在节点2上执行。

[oracle@node19c02 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.7.0.0.0 Production on Thu Apr 30 14:50:40 2020
Copyright (c) 2012, 2020, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_128176_2020_04_30_14_50_40/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.7.0.0.0 Release_Update 200404035018: Installed
  SQL registry:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 25-APR-20 07.48.43.498000 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  Patch 30869156 (Database Release Update : 19.7.0.0.200414 (30869156)):
    Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.7.0.0.0 Release_Update 200404035018
  No interim patches need to be applied

Installing patches...
Patch installation complete.  Total patches installed: 1

Validating logfiles...done
Patch 30869156 apply: SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30869156/23493838/30869156_apply_TEST_2020Apr30_14_51_46.log (no errors)
SQL Patching tool complete on Thu Apr 30 15:09:18 2020
[oracle@node19c02 OPatch]$

-- 查看结果，patch level 不一样。看MOS上介绍，属于正常情况 。

[oracle@node19c02 ~]$ su - grid
Password: 
Last login: Thu Apr 30 15:04:20 CST 2020
[grid@node19c02 ~]$ crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[grid@node19c02 ~]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [19.0.0.0.0]
[grid@node19c02 ~]$ crsctl query has releasepatch
Oracle Clusterware release patch level is [3578971238] and the complete list of patches [29401763 29517242 29517247 29585399 30869156 ] have been applied on the local node. The release patch string is [19.7.0.0.0].
[grid@node19c02 ~]$ crsctl query has softwarepatch
Oracle Clusterware patch level on node node19c02 is [3578971238].
[grid@node19c02 ~]$ 

[grid@node19c01 ~]$ crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[grid@node19c01 ~]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [19.0.0.0.0]
[grid@node19c01 ~]$ crsctl query has releasepatch
Oracle Clusterware release patch level is [3633918477] and the complete list of patches [30869156 30869304 30894985 30898856 ] have been applied on the local node. The release patch string is [19.7.0.0.0].
[grid@node19c01 ~]$ crsctl query has softwarepatch
Oracle Clusterware patch level on node node19c01 is [3633918477].
[grid@node19c01~]$                                                                                                                                                                      
[grid@node19c01 ~]$ kfod op=patches
---------------
List of Patches
===============
30869156
30869304
30894985
30898856
[grid@node19c01 ~]$ kfod op=patchlvl
-------------------
Current Patch level
===================
3633918477
[grid@node19c01 ~]$

[grid@node19c02 ~]$ kfod op=patches
---------------
List of Patches
===============
29401763
29517242
29517247
29585399
30869156
[grid@node19c02 ~]$ kfod op=patchlvl
-------------------
Current Patch level
===================
3578971238
[grid@node19c02 ~]$

-- SQL查看补丁应用情况

SQL> select * from dba_registry_history;

ACTION_TIME                                                                      ACTION                         NAMESPACE                      VERSION                                ID COMMENTS                                                                         BUNDLE_SERIES
-------------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ ---------- -------------------------------------------------------------------------------- ------------------------------
                                                                                 BOOTSTRAP                      DATAPATCH                      19                                        RDBMS_19.7.0.0.0DBRU_LINUX.X64_200403                                            
25-4月 -20 07.48.35.401548 下午                                                  RU_APPLY                       SERVER                         19.0.0.0.0                                Patch applied on 19.3.0.0.0: Release_Update - 190410122720                       
30-4月 -20 03.08.00.173440 下午                                                  RU_APPLY                       SERVER                         19.0.0.0.0                                Patch applied from 19.3.0.0.0 to 19.7.0.0.0: Release_Update - 200404035018       

SQL> select * from dba_registry_sqlpatch;

INSTALL_ID   PATCH_ID  PATCH_UID PATCH_TYPE ACTION          STATUS                    ACTION_TIME                                                                      DESCRIPTION                                                                      LOGFILE                                                                          RU_LOGFILE                                                                       FLAGS      PATCH_DESCRIPTOR                                                                 PATCH_DIRECTORY SOURCE_VERSION  SOURCE_BUILD_DESCRIPTION                                                         SOURCE_BUILD_TIMESTAMP                                                           TARGET_VERSION  TARGET_BUILD_DESCRIPTION                                                         TARGET_BUILD_TIMESTAMP
---------- ---------- ---------- ---------- --------------- ------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------- --------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
         1   29517242   22862832 RU         APPLY           SUCCESS                   25-4月 -20 07.48.43.498000 下午                                                  Database Release Update : 19.3.0.0.190416 (29517242)                             /u01/app/oracle/cfgtoollogs/sqlpatch/29517242/22862832/29517242_apply_TEST_2020A /u01/app/oracle/cfgtoollogs/sqlpatch/29517242/22862832/29517242_ru_apply_TEST_20 N          <?xml version="1.0" encoding="GBK"?>                                             <BLOB>          19.1.0.0.0      Feature Release                                                                                                                                                   19.3.0.0.0      Release_Update                                                                   10-4月 -19 12.27.20.000000 下午
                                                                                                                                                                                                                                                                                                                                                                                                                                     <sqlPatch ID="29517242" uniquePatchID="228                                                                                                                                                                                                                                                                                                                                          
         2   30869156   23493838 RU         APPLY           SUCCESS                   30-4月 -20 03.09.14.886411 下午                                                  Database Release Update : 19.7.0.0.200414 (30869156)                             /u01/app/oracle/cfgtoollogs/sqlpatch/30869156/23493838/30869156_apply_TEST_2020A /u01/app/oracle/cfgtoollogs/sqlpatch/30869156/23493838/30869156_ru_apply_TEST_20 N          <?xml version="1.0" encoding="GBK"?>                                             <BLOB>          19.3.0.0.0      Release_Update                                                                   10-4月 -19 12.27.20.000000 下午                                                  19.7.0.0.0      Release_Update                                                                   04-4月 -20 03.50.18.000000 上午
                                                                                                                                                                                                                                                                                                                                                                                                                                     <sqlPatch ID="30869156" uniquePatchID="234                                                                                                                                                                                                                                                                                                                                          

SQL>

END

 

-- 补充一点

2020-04-30 PM 5:00 补充

在没有安装PSU的时候，多次关闭节点2的集群的时候，发现卡在那里。甚至无法关闭。日志中没有什么可参考的信息。

安装了psu以后，关闭集群，发现很快就关闭了。

19c rac的初始版本，感觉还是不是很稳定，还是需要安装最新的PSU。

END

 

文档搬运工
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
下载错对应OS平台的OPatch工具后运行opatch version会有提示
msdnchina的专栏@JiNan,ShanDong
05-07 462
[root@localhost dbhome_1]# cd OPatch [root@localhost OPatch]# ./OPatch version -bash: ./OPatch: No such file or directory [root@localhost OPatch]# ./opatch version Error: This Java instance does not support a 64-bit JVM. Please install the desired version.
oracle opatch没反应,Oracle OPatch 执行 返回 This command doesn't support System Patch. 解决方法...
weixin_33737167的博客
04-10 909
执行Oracle 19.6 的RU 升级，按官方文档的Readme，进行空间检查操作。https://www.cndba.cn/dave/article/4074https://www.cndba.cn/dave/article/4074readme 文档给的步骤：1.创建/tmp/patch_list_gihome.txt 文件，并添加如下内容：[[email protected] ~]$ ca...
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法.pdf
07-16
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法
ORACLE 19C RAC 搭建部署（全网最详细）
03-07
ORACLE 19C RAC 搭建部署（全网最详细）
oracle 19c rac安装手册 基于centos 7.9安装oracle 19c rac，并升级补丁至19.17
11-25
本oracle 19c rac安装手册为本人一步一验证、一步一截图一字一句完成的。里面包含了基于oracle linux 7.9 安装oracle 19c rac的详细步骤和部分踩坑记录。可以说是全网最完善的安装手册。可以作为新手学习，老师讲课的完整文档。这里提供pdf版本，如需要可以编辑的md文档可以联系本人获取。
AIX7.1环境打补丁缺少bash OPATCHAUTO-72049
weixin_30920597的博客
07-27 1295
DB：12.1.0.2.0 RAC OS：AIX 7.1 【To patch only the GI home】su - rootexport UNZIPPED_PATCH_LOCATION=/oracle/data_dump/12c/27726478export GI_HOME=/oracle/app/12.1.0/gridexport PATH=$PATH:$GI_HOME/OPa...
oracle 19c打补丁遭遇OPATCHAUTO-72043&OPATCHAUTO-68061
www_xue_xi的博客
07-31 929
最近，在AIX上的新装oracle 19C数据库基础版本，使用opatchauto打PSU补丁集35037840时遇到了OPATCHAUTO-72043报错，无法正常应用GI补丁。关于autopatch GI打补丁报错OPATCHAUTO-72043，清除掉OPatch目录，重新解压最新的opatch工具并赋权后，重新使用opatchauto打补丁能够执行。关于autopatch GI打补丁报错OPATCHAUTO-68061，oracle 官网文档12202307.9中提到可能是已知问题。
RAC 12c R1 安装PSU出现 CRS-6706: 错误
文档搬运工
05-13 2430
RAC 12cR1 ，在安装PSU的时候，出现CRS-6706的错误 。[grid@host02 ~]$ su root crsctl start crs Password: CRS-6706: Oracle Clusterware Release patch level ('4143651057') does not match Software patch level ('0'). Orac...
CRS-6706 & CRS-4000
喝醉酒的小白
05-31 1010
问题 打补丁打到一半电脑断网了，，， crsctl start crs CRS-6706：Oracle Clusterware Release patch level ('xxx') does not match Software patch level ('xxx'), Oracle Clusterware cannot be started. CRS-4000：Command start failed，or completed with errors. 原因 本地patch level与集群pat
OPatch failed with error code 2
乡下人
07-30 1199
在检查补丁冲突时报错code 2 [oracle@DBMONITOR01 ~]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2018, Oracle Corporation. All rights ...
阿里云ECS环境下CentOS-linux 7.6系统Oracle 19C RAC双节点集群安装部署-优化-维护手册.pdf
12-17
基于阿里云ECS环境及CentOS-linux 7.6系统环境下，安装部署Oracle 19C RAC双节点集群，每一步都很详细的说明了配置的方法和原因，白话文表述，小白也能轻松按照文档部署完成；
RHEL 8.4 安装Oracle 19c RAC+RU 19.13 文档.docx
11-25
文档主要记录Red Hat Enterprise Linux Server release 8.4上安装19c RAC + RU 19.13 步骤
oracle 19c rac 应用19.19 PSU补丁实施方案
最新发布
weixin_61212661的博客
08-16 1100
19c rac打19.19补丁详解
用OPatch给Oracle打补丁，小白踩坑以及解决办法全纪录
热门推荐
qq2598607965的博客
09-18 1万+
用OPatch给Oracle打补丁，小白踩坑以及解决办法全纪录初衷OPatch介绍打补丁之前的准备工作一：查看OPatch版本问题1：显示"Oracle Home is not set. OPatch cannot proceed!"打补丁之前的准备工作二：关闭所有的Oracle服务开始打补丁问题2：:出现'%ORACLE_HOME%不是内部或外部命令，也不是可运行的程序或批处理文件'问题3：出现"ZOP-51: The patch location is not valid for apply, beca
mopatch oracle_12c新特性-OPatch Automation Tool(opatchauto)
weixin_39526546的博客
12-19 555
集群GRID/RAC环境下，从12c开始我们可以通过root用户使用opatchauto命令安装patch。opatchauto参数：$ cd $ORACLE_HOME/OPatch$ opatchauto -helpOPatch Automation ToolCopyright (c) 2015, OracleCorporation. All rights reserved.Usage: opa...
oracle19c-rac打补丁-19.19补丁遇到的问题
kevinyu998的博客
08-01 546
临时被要求给19.3 rac环境打补丁，客户已放到机器中，现在把遇到的问题汇总。处理办法如下：执行命令前先切换到根目录下。1、报错执行目录不对。
CRS-6706: Oracle Clusterware Release patch level ('3329448500') does not match Software patch level
sqlora的专栏
11-15 2751
oracle19.3.0.0 rac+centos7.6 补丁为19.5.0.0 启动crs报错如下： [root@rac2 ~]# /oracle/app/19c/grid/bin/crsctl start crsCRS-6706: Oracle Clusterware Release patch level ('3329448500') does not match Software p...
Oracle RAC19.3 update 19.7 gi+database+ojvm
06-23 356
升级OPATCH oracle用户更新OPatch 节点1 [root@rac19c21 ~]# su - oracle [oracle@rac19c21 db_1]$cd $ORACLE_HOME [oracle@rac19c21 db_1]$ mv OPatch/ OPatch_bak20191213 [oracle@rac19c21 db_1]$unzip /u01/install/opatch/p6880880_190000_Linux-x86-64.zip -d $O...
Oracle 12.1.0.1这个版本真有点坑
文档搬运工
08-09 5085
发现这个版本真有点坑。显示不只是Linux7（12.0.0.2支持） 后发现12.1.0.1的PSU到2016年八月就没有了。 然后是支持日期，现在已经停止支持了。好短命。 END...
阿里云ecs环境下centos-linux 7.6系统oracle 19c rac双节点集群安装部署-优化-维
05-12
阿里云ECS环境下CentOS-Linux 7.6系统Oracle 19c RAC双节点集群安装部署-优化-维护，是一项比较复杂的任务。首先需要准备好两台ECS服务器，保证服务器硬件条件足够好，配置需要满足Oracle 19c的要求。其次，需要为Oracle 19c RAC双节点集群配置好网络，使用VIP地址或DNS名解释来实现负载均衡和故障转移。 在安装部署的过程中，可以参考Oracle官方文档进行操作。需要注意的是，Oracle 19c RAC安装有很多步骤，需要按照顺序执行，并根据实际情况进行适当的调整。为了保证系统的稳定性和性能，必须仔细设置每个参数，并选择最优的配置方案。在完成Oracle 19c RAC的安装后，需要对系统进行优化，包括调整内存、CPU、磁盘和网络等方面的参数。 在维护过程中，需要定期进行备份和恢复操作，以确保系统数据的安全性。同时要对系统进行监控和性能测试，及时发现问题并解决。维护过程中还需要遵循最佳实践，更新补丁和安全更新，以提高系统的稳定性和安全性。 总之，阿里云ECS环境下CentOS-Linux 7.6系统Oracle 19c RAC双节点集群的安装部署-优化-维护，需要具备丰富的实际经验和技巧。只有熟练掌握Oracle 19c RAC的安装和维护技术，才能够保障系统的稳定性和可靠性。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值