Oracle rac oraInventory更新

最新推荐文章于 2021-04-12 08:48:14 发布
最新推荐文章于 2021-04-12 08:48:14 发布
阅读量311 收藏
点赞数
文章标签： 数据库

执行前确认配置：

[root@rac1 ContentsXML]# cat inventory.xml 

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.1.0/grid" TYPE="O" IDX="1" CRS="true">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

[root@rac2 ContentsXML]# cat inventory.xml 

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.1.0/grid" TYPE="O" IDX="1" CRS="true">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>


节点1执行

[grid@rac1 bin]$ ./detachHome.sh 

Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 1986 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

'DetachHome' was successful.

确认配置：

[root@rac1 ContentsXML]# cat inventory.xml 

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.1.0/grid" TYPE="O" IDX="1" REMOVED="T"/>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

[root@rac2 ContentsXML]# cat inventory.xml 

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.1.0/grid" TYPE="O" IDX="1" REMOVED="T"/>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>


节点1执行：

[grid@rac1 bin]$ ./attachHome.sh 

Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 1975 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

'AttachHome' was successful.

确认配置：

[root@rac1 ContentsXML]# cat inventory.xml 

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.1.0/grid" TYPE="O" IDX="1"/>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

[root@rac2 ContentsXML]# cat inventory.xml 

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.1.0/grid" TYPE="O" IDX="1" REMOVED="T"/>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>


节点1执行：

./runInstaller -updateNodeList ORACLE_HOME=/u01/app/12.1.0/grid "CLUSTER_NODES=rac1,rac2" CRS=TRUE -silent


Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 1980 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

SEVERE:Remote 'UpdateNodeList' failed on nodes: 'rac2'. Refer to '/u01/app/oraInventory/logs/UpdateNodeList2017-05-09_08-19-46PM.log' for details.

It is recommended that the following command needs to be manually run on the failed nodes: 

 /u01/app/12.1.0/grid/oui/bin/runInstaller -updateNodeList -noClusterEnabled ORACLE_HOME=/u01/app/12.1.0/grid CLUSTER_NODES=rac1,rac2 CRS=true  "INVENTORY_LOCATION=/u01/app/oraInventory" LOCAL_NODE=<node on which command is to be run>. 

Please refer 'UpdateNodeList' logs under central inventory of remote nodes where failure occurred for more details.

'UpdateNodeList' failed.

确认配置：

[root@rac1 ContentsXML]# cat inventory.xml 

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.1.0/grid" TYPE="O" IDX="1" CRS="true">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

[root@rac2 ContentsXML]# cat inventory.xml 

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.1.0/grid" TYPE="O" IDX="1" REMOVED="T"/>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>


节点2执行：

/u01/app/12.1.0/grid/oui/bin/runInstaller -updateNodeList -noClusterEnabled ORACLE_HOME=/u01/app/12.1.0/grid CLUSTER_NODES=rac1,rac2 CRS=true  "INVENTORY_LOCATION=/u01/app/oraInventory" LOCAL_NODE=rac2


[grid@rac2 bin]$ /u01/app/12.1.0/grid/oui/bin/runInstaller -updateNodeList -noClusterEnabled ORACLE_HOME=/u01/app/12.1.0/grid CLUSTER_NODES=rac1,rac2 CRS=true  "INVENTORY_LOCATION=/u01/app/oraInventory" LOCAL_NODE=rac2

Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 2753 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

'UpdateNodeList' failed.


节点2执行：

[grid@rac2 bin]$ ./attachHome.sh 

Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 2753 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

'AttachHome' was successful.

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.1.0/grid" TYPE="O" IDX="1"/>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>


节点2执行

[grid@rac2 bin]$ /u01/app/12.1.0/grid/oui/bin/runInstaller -updateNodeList -noClusterEnabled ORACLE_HOME=/u01/app/12.1.0/grid CLUSTER_NODES=rac1,rac2 CRS=true  "INVENTORY_LOCATION=/u01/app/oraInventory" LOCAL_NODE=rac2

Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 2753 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

'UpdateNodeList' was successful.


[root@rac1 ContentsXML]# cat inventory.xml 

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.1.0/grid" TYPE="O" IDX="1" CRS="true">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

[root@rac2 ContentsXML]# cat inventory.xml 

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraGI12Home1" LOC="/u01/app/12.1.0/grid" TYPE="O" IDX="1" CRS="true">

   <NODE_LIST>

      <NODE NAME="rac1"/>

      <NODE NAME="rac2"/>

   </NODE_LIST>

</HOME>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>






来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30393815/viewspace-2138790/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30393815/viewspace-2138790/

cuimijie1971
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
重建oracle inventory
yinghuabanwo的博客
03-23 451
重建Oracle inventory 有的时候在打psu，或升级，运行opatch时经常会遇到 OPatch failed with error code 73 的问题，这种问题有时是由于oraInventory被异常删除导致的，可采用重建方法解决： 10gr1 $cd $ORACLE_HOME/oui/bin ./runInstaller−silent−attachHomeORACLEHOME=...
Inventory Update
kyr1e的博客
01-26 455
题目依照一个存着新进货物的二维数组，更新存着现有库存(在 arr1 中)的二维数组. 如果货物已存在则更新数量 . 如果没有对应货物则把其加入到数组中，更新最新的数量. 返回当前的库存数组，且按货物名称的字母顺序排列要求updateInventory() 应该返回一个数组. updateInventory([[21, "Bowling Ball"], [2, "Dirty Sock"], [1, "
【freecodecamp】更新仓库 Inventory Update
角角兔的博客
08-11 295
题目要求 freecodecamp 上面的一个练习题 题目要求是： 依照一个存着新进货物的二维数组，更新存着现有库存(在 arr1 中)的二维数组. 如果货物已存在则更新数量 . 如果没有对应货物则把其加入到数组中，更新最新的数量. 返回当前的库存数组，且按货物名称的字母顺序排列. 当你遇到困难的时候，记得查看错误提示、阅读文档、搜索、提问。 问题分析 1.更新的顺序要按照后面的数组来...
oracle重建inventory,Oracle中Inventory目录作用以及如何重建此目录-Oracle
weixin_33462050的博客
04-12 350
Oracle中Inventory目录作用以及如何重建此目录oraInventory存放的是Oracle软件安装的目录信息，Oralce的安装升级都需要用到这个目录，来看看Oracle文档中对这个目录的一点说明：All Oracle software installations rely on this directory.Ensure that you back it up regularly.D...
在$ORACLE_BASE/oraInventory/logs中查找安装语言集
cuixie2370的博客
04-10 81
/u01/product/oraInventory/logsSetting value of sl_dbCharSet to West European WE8ISO8859P1,English US7ASCII,West Eu...
Oracle rac 两节点升级.docx
06-17
在本例中，Oracle Inventory Directory位于/app/product/oraInventory，而ORACLE_BASE分别位于/app/product/grid和/app/product/oracle。 2. **创建新目录**：为了新版本的Oracle RAC，需要在每个节点上创建新的...
oracle rac部署
01-10
- 主机文件系统规划：规划文件系统，如/oraInventory、/u01/app/oracle、/u01/app/grid等，用于存放软件、日志和数据文件。 3. 存储规划 共享存储是RAC的关键部分，可以使用SAN（Storage Area Network）或NAS...
ORACLE RAC 在 LINUX 上的部署
05-16
设置适当的文件系统权限和所有权，通常使用`oraInventory`组和`oracle`用户。 其次，**网络规划**是RAC的核心部分。RAC需要至少两个网络接口：一个用于客户端连接（Public Network），另一个用于集群内部通信...
Oracle 10g RAC安装配置.pptx
05-02
CRS 安装升级包括五个步骤：root 用户执行 rootpre.sh 脚本、CRS_HOME 路径规划、VIP 地址规划、root 用户执行 /home/oracle/oraInventory/orainstRoot.sh 和 $CRS_HOME/root.sh 脚本、VIP 配置 BUG。 数据库软件...
Oracle增加、更新、删除、查询xml节点
jike11231的博客
05-22 4358
这里整理下项目开发中用到了SQL对数据库中XML类型字段增删改查的操作，好记性不如烂笔头，特此整理如下。 1、Oracle更新XML字段的方式整理如下： 方式一（针对字段形如 ）： 操作DAT_DOCUMENT表，更新为生产测试设备 update DAT_DOCUMENT t set DOCUMENT_DATA = UpdateXML(t.DOCUMENT_DATA, '/root/serviceObject',
11g R2 节点系统重建后，删除节点及添加节点 过程和问题解决
热门推荐
badman250的专栏
07-05 3万+
11g R2 节点系统重建后，删除节点及添加节点 过程和问题解决    故障现象：   一个RAC数据库，两个节点，RedHat 6.3_X64的系统，因为业务问题，节点2的服务器的系统进行了重装。   现需要重建节点2 。 节点的重建   一：先从集群中清除节点2的信息
oracle 10g rac 添加节点与删除节点步骤
cucanqi9387的博客
06-09 159
环境aIx 6.1 +oracle 10.2.0.4+emc cx500 删除节点步骤： 1.Deletetheinstanceonthenodetobedeleted. 2.Cleanupth...
Linux：Check if the DISPLAY variable is set.
suchenbin的博客
07-22 1768
问题描述：安装oracle过程中，执行./runInstaller时报错 [oracle@*** database]$ ./runInstaller Starting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB. Actual 26477 MB Passed Che...
Oracle RAC inventory.xml损坏后如何修复
weixin_34318956的博客
03-03 237
不建议直接修改该文件 1.从其它节点拷贝一份 2.使用runInstaller工具（这个工具位于&lt;GI_HOME&gt;/oui/bin路径下）重建inventory.xml文件 步骤1：添加GI HOME $./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/app/11.2.0/gri...
inventory.xml中的Oracle_home已存在
bruce
07-06 4132
重新安装RAC数据库时报下列错误： Remote 'AttachHome' failed on nodes: 'prod02'. Refer to '/u01/app/oraInventory/logs/installActions2015-07-06_10-45-26PM.log' for details. It is recommended that the following comman
How to Update Inventory to Set/Unset "CRS=true" Flag for Oracle Clusterware Home (文档 ID 1053393.1)
oradbm的博客
11-01 215
OUI option -updateNodeList can be used to set/unset the flag.To set the flag on a three-node RAC cluster on UNIX: On node1 as clusterware user: /ocw/grid/oui/bin/runInstaller -updateNodeList ORACLE_H...
Oracle Study之--Oracle 11g RAC故障（Failed to create or upgrade OLR）
天涯客*Blog
09-30 2470
Oracle Study之--Oracle 11g RAC故障（Failed to create or upgrade OLR） 系统环境：       操作系统： RedHat EL5.5       Cluster：   Oracle Grid 11.2.0.1.0       Oracle：     Oracle 11g  11.2.0.1.0 故障现象：
oracle_rac日常基本维护命令
09-29
oracle_rac日常基本维护命令

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值