On an Oracle RAC server, you may receive an error as follows when you want to create a new database with runinstaller.
INS-35354: The System on Which you are Attempting to Install Oracle RAC is not Part of a Valid Cluster
There are two main reasons for this problem:
The database version you want to create may not be compatible with the grid infrastructure version installed. For example, if there is a 12.2.0.1 grid infrastructure, it will not install the database binary of 11.2.0.3 version. This applies only to RAC systems.
The other reason is that there is no CRS = “true” in the corresponding row in the inventory.xml file for the current grid home. In this case, it is necessary to update grid home in the inventory.xml file to CRS = “true”. Instead of manually changing the inventory.xml, this should be done as follows. Otherwise, problems may occur.
First, you need to detect the oraInventory directory. You can access this information from the /etc/oraInst.loc file.
1 2 3 | -bash-4.3$ cat /etc/oraInst.loc inventory_loc=/u01/app/oraInventory inst_group=oinstall |
The grid home, which is not CRS = “true” in the inventory.xml file, can be detected as follows.
1 2 | -bash-4.3$ cd /u01/app/oraInventory/ContentsXML/ -bash-4.3$ cat inventory.xml |
For example, if a grid home with a value of LOC = “/u01/app/11.2.0/grid” is not CRS = “true”, it should be updated as follows.
1 | $GRID_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME="/u01/app/11.2.0/grid" CRS=true |
You must do this on all nodes including RAC.
Then open the inventory.xml file and check “CRS = true”.
Database creation with RunInstaller will continue without any problem. If there are problems due to incompatibility, this update will not work.