重庆思庄Oracle、Redhat认证学习论坛

标题: 12C 应用PSU报错OPATCHAUTO-72050：未能创建系统实例 [打印本页]

作者: jiawang 时间: 2018-2-2 19:31
标题: 12C 应用PSU报错OPATCHAUTO-72050：未能创建系统实例

环境说明：

OS版本：Oracle Linux 7.3

DB版本：12.2.0.1.0 64bit

数据库运行环境：RAC

psu补丁程序：27100009  （12.2.0.1.18.1.16）

错误现象：
[root@rac01 setup]# /u01/app/12.2.0/grid/OPatch/opatchauto  apply 27100009/
OPatchauto session is initiated at Fri Feb  2 17:18:34 2018
System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-02_05-18-50PM.log.

OPATCHAUTO-72050: 未能创建系统实例。
OPATCHAUTO-72050: 检索系统信息时失败。
OPATCHAUTO-72050: 请查看日志文件, 以了解更多详细信息。

OPatchauto session completed at Fri Feb  2 17:20:13 2018
Time taken to complete the session 1 minute, 40 seconds
Topology creation failed.

查看报错日志：
[grid@rac01 ~]$ more /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-02_05-18-50PM.log

2018-02-02 17:20:13,174 严重 [1] com.oracle.glcm.patch.auto.db.integration.model.productsupport.topology.TopologyCreator - Not able to retrieve system instance d
etails :: Execution failed for host rac02 due to : com.oracle.cie.remote.RemoteConnectionException: Command execution of [/u01/app/oracle/product/12.2.0/db_1//perl/
bin/perl /u01/app/oracle/product/12.2.0/db_1/OPatch/auto/database/bin/RemoteHostExecutor.pl  -GRID_HOME=/u01/app/12.2.0/grid -OBJECTLOC=/u01/app/oracle/product/12.2
.0/db_1//cfgtoollogs/opatchautodb/hostdata.obj -JVM_HANDLER=oracle/dbsysmodel/driver/sdk/productdriver/remote/RemoteDataCollector ] failed due to exit status 2.

2018-02-02 17:20:13,174 严重 [1] com.oracle.glcm.patch.auto.db.integration.model.productsupport.topology.TopologyCreator - Failure reason::null
[grid@rac01 ~]$

根据报错文件确定节点2是否存在这个文件
[oracle@rac02 ~]$ ll /u01/app/oracle/product/12.2.0/db_1/OPatch/auto/database/bin/RemoteHostExecutor.pl
ls: 无法访问/u01/app/oracle/product/12.2.0/db_1/OPatch/auto/database/bin/RemoteHostExecutor.pl: 没有那个文件或目录

[root@rac01 setup]# ll /u01/app/oracle/product/12.2.0/db_1/OPatch/auto/database/bin/RemoteHostExecutor.pl
-rwxr-x--- 1 oracle oinstall 2612 11月 16 14:53 /u01/app/oracle/product/12.2.0/db_1/OPatch/auto/database/bin/RemoteHostExecutor.pl

怀疑是因为节点2，oracle_home 和grid_home的opatch工具未升级导致的报错。

升级rac2的opatch工具：
[grid@rac02 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.12
OPatch succeeded.

[root@rac02 ~]# su - oracle
[oracle@rac02 ~]$ cd $ORACLE_HOME
[oracle@rac02 db_1]$ cd OPatch
[oracle@rac02 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.12
OPatch succeeded.

升级opatch工具后，验证节点2存在该目录文件
[root@rac02 ~]$ ll /u01/app/oracle/product/12.2.0/db_1/OPatch/auto/database/bin/RemoteHostExecutor.pl
-rwxr-x--- 1 oracle oinstall 2612 11月 16 14:53 /u01/app/oracle/product/12.2.0/db_1/OPatch/auto/database/bin/RemoteHostExecutor.pl

重新在节点1应用PSU补丁,成功。
[root@rac01 ~]# cd /setup
[root@rac01 setup]# /u01/app/12.2.0/grid/OPatch/opatchauto  apply 27100009/
OPatchauto session is initiated at Fri Feb  2 18:26:04 2018

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-02_06-26-15PM.log.
会话日志文件是/u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-02-02_06-27-53PM.log
此会话的 ID 为 YBQ2
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/oracle/product/12.2.0/db_1
Patch applicability verified successfully on home /u01/app/12.2.0/grid
Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
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/rac01/crsconfig/crspatch_rac01_2018-02-02_06-44-42PM.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
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
.....................................

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)