In this Document
Oracle Database - Enterprise Edition - Version 9.2.0.1 and later Information in this document applies to any platform. 适用于: Oracle数据库 - 企业版 - 版本9.2.0.1和更高版本 本文档中的信息适用于任何平台。
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”。
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 |