Oracle relink RAC binary options description

The previous articles about oraclebinary options are as follows:

 

Oracle binary options description

Http://blog.csdn.net/tianlesoftware/article/details/7577637

 

Description of relink binary options for a single oracle instance

Http://blog.csdn.net/tianlesoftware/article/details/7577652

 

New Features of Oracle 11gr2 relink script

Http://blog.csdn.net/tianlesoftware/article/details/7577873

 

From the above blogs, we can confirm that the name of the RAC component is kcsm. O. You can also learn how to relink related components under a single instance. This article mainly describes how to relink Oracle RAC components.

 

The MOs documentation is as follows:

How to check whether Oracle binary/instance is racenabled and relink Oracle binary in RAC [ID 284785.1]

 

1. Check whether RAC option is enabled

 

Use the ORACLE_HOME user to log on.

 

Run the following command on Linux/Unix (except AIX:

Ar-T $ ORACLE_HOME/rdbms/lib/libknlopt. A | grep kcsm. o

 

Run the following command on the AIX platform:

Ar-x32_64-T $ ORACLE_HOME/rdbms/lib/libknlopt. A | grep kcsm. o

 

If the command does not return any information, it indicates that RAC option has no link. If kcsm. O is returned, it indicates that the RAC option has been enabled.

 

 

Ii. Check whether the RAC instance is running

You can use multiple methods.

 

2.1 Method 1: Check the sqlplus title

$ 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,200 7, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-Production
With the partitioning, real Application Clusters, OLAP and data miningoptions

 

In the RAC environment, "Real applicationters ters" is displayed in the title of sqlplus ".

 

2.2 Method 2: Check whether the lmom process exists

 

PS-Ef | grep lmon | grep <oracle_sid>
Oracle 627 1 0 apr15? 1: 02 ora_lmon_racdb1

 

Only the RAC instance has this process. If this process exists, it indicates that it is the RAC environment.

 

2.3. Method 3: Check cluster_database Parameters

 

SQL> show parameter cluster_database

 

If the return value of this parameter is true, it indicates that the RAC environment is used. Note that when we maintain RAC, this parameter may be temporarily modified to false.

 

 

Iii. relink RAC Components

 

Perform the following steps on all nodes.

 

1. log in with the ORACLE_HOME user.

 

2. Stop all resources (databases, listener, ASM, etc ). Use the normal or immediate parameter when stopping a database.

 

3. If the grid infrastructure home of relink 11gr2 is used, run the following command as the root user to unlock the gi home:

$ Grid_home/CRS/install/rootcrs. pl-Unlock

 

4. Perform the relink operation:

CD $ ORACLE_HOME/rdbms/lib

Make-F ins_rdbms.mk rac_on ioracle

 

If interconnect is InfiniBand and RDS protocol, instead of UDP, you also need to execute the following command:

CD $ ORACLE_HOME/rdbms/lib
Make-F ins_rdbms.mk ipc_rds ioracle

 

Before executing this command, make sure that InfiniBand Interconnect and RDS protocol are used.

 

 

5. After relink gi home is finished, run the following command as the root user: Lock GI home:

$ Grid_home/CRS/install/rootcrs. pl-patch

 

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Skype: tianlesoftware

QQ: tianlesoftware@gmail.com

Email: tianlesoftware@gmail.com

Blog: http://www.tianlesoftware.com

WEAVER: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

LinkedIn: http://cn.linkedin.com/in/tianlesoftware

 

 

------- Add a group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, reject the application ----

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Dba6 group: 158654907 dba7 group: 172855474 DBA group: 104207940