Oracle RAC: ON and OFF |
 |
| 09 May 2007 | McGraw-Hill |
|
|
 Oracle's RAC: ON and OFF
In some cases, you may want to disable the RAC options for testing purposes -- perhaps to run a benchmark or convert the RAC binaries to single instance binaries. In such a case, you can use the following procedure to convert the RAC installation to non-RAC. Disabling and enabling RAC options are available only for UNIX platforms. Windows installations do not support relinking binaries with RAC ON and OFF.
Use the following steps to disable RAC (known as RAC OFF):
- Log in as the Oracle software owner (which is typically the UNIX account oracle) in all nodes.
- Shut down all the instances from all the nodes using a NORMAL or IMMEDIATE option.
- Change the working directory to $ORACLE_HOME/lib:
cd $ORACLE_HOME/lib
- Run the following make command to relink the Oracle binaries without the RAC option:
make -f ins_rdbms.mk rac_off
This normally runs for few minutes and should not pose any errors.
- . Now relink the Oracle binaries:
make -f ins_rdbms.mk ioracle
Now the Oracle binaries are relinked with the RAC OFF option. You may have to edit the init.ora or SPFILE parameters accordingly. If errors occur in step 4, you may need to contact Oracle Support and log a service request with the trace and log files.
Use the following steps to enable RAC (known as RAC ON):
- Log in as the Oracle software owner (typically the UNIX account oracle) in all nodes.
- Shut down all the instances from all the nodes using a NORMAL or IMMEDIATE option.
- Change the working directory to $ORACLE_HOME/lib:
cd $ORACLE_HOME/lib
- Run the following make command to relink the Oracle binaries without the RAC option:
make -f ins_rdbms.mk rac_on
This normally runs for a few minutes and should not pose any errors.
- Now relink the Oracle binaries:
make -f ins_rdbms.mk ioracle
Now the Oracle binaries are relinked with the RAC ON option. You may need to edit the init.ora or SPFILE parameters accordingly. If any errors occur in step 4, you may need to contact Oracle Support and log a service request with the trace and log files.
Use the following table of contents to navigate to chapter excerpts or click here to view RAC Troubleshooting in its entirety.
| About the book: |
|
| Oracle Database 10g: Real Applications Clusters Handbook Learn to implement Oracle real application clusters from the ground up. Maximize database availability, scalability, and efficiency. Find RAC concepts, administration, tuning, and troubleshooting information. You'll learn how to prepare and create Oracle RAC databases and servers, and automate administrative tasks. You'll also get full coverage of cutting-edge Oracle RAC diagnostic tools, backup and recovery procedures, performance tweaks and custom application design strategies. Buy this book at McGraw-Hill/Osborne |
| About the author: |
|
| K Gopalakrishnan is a senior principal consultant with the Advanced Technology Services group at Oracle Corporation, specializing exclusively in performance tuning, high availability, and disaster recovery. He is a recognized expert in Oracle RAC and Database Internals and has used his extensive expertise in solving many vexing performance issues all across the world for telecom giants, banks, financial institutions, and universities. |
|
|
|
|
|
| TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of . |
|
| | |
All Rights Reserved, , TechTarget |
|
|
|
|
|
Home: 
