[Translated from mos] Check whether $ ORACLE_HOME is the HOME method of RAC and the Oraclebinary method of relinkRAC.

[Translated from mos] Check whether $ ORACLE_HOME is the HOME method of RAC and the Oraclebinary method of relinkRAC.

Check whether $ ORACLE_HOME is the HOME method of RAC and the Oracle binary method of relink RAC.

Source:
How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC (Document ID 284785.1)

Applicable:
Oracle Database-Enterprise Edition-Version 9.2.0.1 and later
Information in this document applies to any platform.

Objectives:
This article checks whether the RAC option is linked to Oracle binary. It also checks whether an instance is a rac instance and provides the relink Oracle binary method in the rac environment.

Solution:

Check whether the RAC option is enabled for Oracle binary.

Log on as the owner of ORACLE_HOME

For UNIX except AIX:

ar -t $ORACLE_HOME/rdbms/lib/libknlopt.a|grep kcsm.o

AIX:

ar -X32_64 -t $ORACLE_HOME/rdbms/lib/libknlopt.a|grep kcsm.o

If the preceding command does not return anything, RAC option indicates no link.
If RAC is linked to Oracle binary, the above command should return "kcsm. o"

Check whether a running Oracle database instance is a rac instance:
You can use the following methods:
Method 1: Check the display after sqlplus/as sysdba ---- 'real Application clusters'

$ORACLE_HOME/bin/sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 - Production on Fri Dec 26 12:11:13 2008Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining options

Method 2: Check whether the lmon background exists

ps -ef| grep lmon | grep 
 
  oracle   627     1  0   Apr 15     ?  1:02 ora_lmon_racdb1
 

Method 3: Check the database parameters of cluster_database:

SQL> show parameter cluster_database

If the output above is true, it indicates a rac instance. However, this method is not reliable, because when a rac instance needs to be maintained, you can change this parameter to false.

Relink oracle binary rac option steps:

Perform the following steps on all nodes

1. Use the owner of ORACLE_HOME to stop all resources (databases, listener, asm, and so on) Running in ORACLE_HOME ),
Use the NORMAL or IMMEDIATE option to close the database.
2. If the gi home of relink 11gR2 is used, use the root user to unlock the gi home: Remember to run it as the root user.

  $GRID_HOME/crs/install/rootcrs.pl -unlock

3. Run the following command with the owner of ORACLE_HOME:

  cd $ORACLE_HOME/rdbms/lib  make -f ins_rdbms.mk rac_on ioracle

If the heartbeat network uses the infiniband RDS protocol instead of the UDP protocol:

  cd $ORACLE_HOME/rdbms/lib  make -f ins_rdbms.mk ipc_rds ioracle

Warning before executing the preceding command, make sure that the heartbeat network is indeed using infiniband and RDS
Note: If you are changing more than 1 home, repeat the make command for all homes. --- what is the meaning of this sentence? Not quite understood
4. If relink 11gR2's gi home, use the root user to lock gi home: Remember to run it as the root user.

 $GRID_HOME/crs/install/rootcrs.pl -patch