错误案例:
GRID进程启动正常,CRS资源全部online;但在安装Oracle 数据库软件时,不能发现集群环境!
解决方法:
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 11-Mar-2013***
Goal
A few Oracle clusterware/database utilities depend on "CRS=true" flag in central inventory to determine which is current clusterware home, if the flag is not set or set on wrong home, those utilities will fail. "CRS=true" is allowed to be only on active clusterware home(in upgraded case) as there can be only one active clusterware home per node.
Even the behaviour has changed in latest version of 11gR2 Grid Infrastructure, due to a few known issues, the flag is still needed as a workaround in some case- refer to note 1316815.1 for one known issue.
This note provides instructions to update the flag in central inventory.
Fix
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_HOME="/ocw/grid" CRS=true
## ==> /ocw/grid is current clusterware home
To unset the flag on a three-node RAC cluster on Windows:
On node1 as clusterware user:
d:\ocw\crs\oui\bin\setup -updateNodeList ORACLE_HOME="d:\ocw\crs" CRS=false
## ==> /ocw/crs is pre-upgrade clusterware home but the flag is still there
To confirm the changes, review inventory.xml in central inventory.
Central inventory location is defined by parameter inventory_loc in /etc/oraInst.loc, /var/opt/oracle/oraInst.loc or Windows Registry depend on platform.
Example on Linux:
$ cat /etc/oraInst.loc | grep inventory_loc
inventory_loc=/home/grid/oraInventory
$ cat /home/grid/oraInventory/ContentsXML/inventory.xml
..
<HOME NAME="Ora11g_gridinfrahome1" LOC="/ocw/grid" TYPE="O" IDX="4" CRS="true">
<NODE_LIST>
<NODE NAME="racnode1"/>
<NODE NAME="racnode2"/>
<NODE NAME="racnode3"/>
</NODE_LIST>
</HOME>
..
Note: inventory.xml must not be modified manually to avoid inventory corruption.