How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC (文档 ID 28

How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC (文档 ID 284785.1) 如何检查Oracle二进制/实例是否是RAC启用的，并重新链接RAC中的Oracle二进制文件

转到底部

---

In this Document Goal   Solution     To check whether Oracle binary is RAC enabled:     To check whether a running instance is a RAC instance :     Steps to relink oracle binary with RAC option: APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.1 and later Information in this document applies to any platform. 适用于： Oracle数据库 - 企业版 - 版本9.2.0.1和更高版本 本文档中的信息适用于任何平台。 GOAL This note is to check whether Real Application Clusters(RAC) option is linked into Oracle binary and whether a database instance is a RAC instance, and how to relink Oracle binary in RAC environment. The likely error includes "Oracle home is not a cluster database home".  本文章是检查Real Application Clusters（RAC）选项是否链接到Oracle二进制文件以及数据库实例是否是RAC实例，以及如何在RAC环境中重新链接Oracle二进制文件。 可能的错误包括“Oracle home不是集群数据库home”。 SOLUTION To check whether Oracle binary is RAC enabled: 检查oracle二进制是否是RAC启用的 As ORACLE_HOME owner: On Linux/UNIX except AIX:在 除了AIX之外Linux/UNIX上：   ar -t $ORACLE_HOME/rdbms/lib/libknlopt.a|grep kcsm.o On AIX:在AIX上   ar -X32_64 -t $ORACLE_HOME/rdbms/lib/libknlopt.a|grep kcsm.o If above command does not return anything, RAC option is not linked in. A RAC enabled oracle binary should return "kcsm.o". 如果上面的命令没有返回任何东西，则RAC选项没有链接。一个RAC启用的oracle二进制应该返回“kcsm.o”。 To check whether a running instance is a RAC instance : 检查一个正在运行的的实例是不是RAC实例： Multiple options here:（多个方式） 1. Check sqlplus banner【横幅？】 (Applicable to Windows):（适用于Windows） $ORACLE_HOME/bin/sqlplus / as sysdba SQL*Plus: Release 11.1.0.6.0 - Production on Fri Dec 26 12:11:13 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options A RAC instance will show "Real Application Clusters" option in the banner.在横幅中一个RAC实例应该显示"Real Application Clusters"选项 2. Check whether lmon background process exists for the instance 检查实例是否存在lmon后台进程 ps -ef| grep lmon | grep <ORACLE_SID> oracle   627     1  0   Apr 15     ?  1:02 ora_lmon_racdb1 Only RAC instance has lmon background process. 只有rac实例才有lmon后台进程 3. Check cluster_database parameter 检查集群数据库的参数 SQL> show parameter cluster_database Output "true" means it's RAC instance but this is not reliable as a RAC instance may have cluster_database set to false during maintenance period. 输出“true”表示它是RAC实例，但这不可靠，因为RAC实例可能在维护期间将cluster_database设置为false。 Steps to relink oracle binary with RAC option: 通过RAC选项重新链接oracle二进制的步骤： Execute the following on all nodes where the ORACLE_HOME exists: 在ORACLE_HOME存在的所有节点上执行以下命令： 1. As ORACLE_HOME owner, stop all resources (database, listener, ASM etc) that's running from the home. When stopping database, use NORMAL or IMMEDIATE option. 作为ORACLE_HOME所有者，停止从家目录中运行的所有资源（数据库，侦听器，ASM等）。 停止数据库时，使用NORMAL或IMMEDIATE选项。 2. If relinking 11gR2 Grid Infrastructure home, unlock GI home as root: $GRID_HOME/crs/install/rootcrs.pl -unlock 如果重新链接11gR2 Grid Infrastructure目录，解锁GI作为根用户：$ GRID_HOME / crs / install / rootcrs.pl -unlock 3. As ORACLE_HOME owner, execute the following to relink: 以ORACLE_HOME 目录的拥有者执行以下命令进行重链接   cd $ORACLE_HOME/rdbms/lib   make -f ins_rdbms.mk rac_on ioracle If interconnect is infiniband and RDS protocol is being used instead of UDP: 如果互连是infiniband并且正在使用RDS协议而不是UDP：   cd $ORACLE_HOME/rdbms/lib   make -f ins_rdbms.mk ipc_rds ioracle Caution: confirm infiniband interconnect and RDS protocol before executing it  Note: If you are changing more than 1 home, repeat the make command for all homes.  注意：在执行之前，请确认infiniband互连和RDS协议 注意：如果您更改超过1个home，请对所有home重复make命令。 4. If relinking 11gR2 Grid Infrastructure home, lock GI home as root: $GRID_HOME/crs/install/rootcrs.pl -patch

如果重连11gR2GI home，以root用户锁住GI home