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):
cd $ORACLE_HOME/lib
make -f ins_rdbms.mk rac_off
This normally runs for few minutes and should not pose any errors.
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):
cd $ORACLE_HOME/lib
make -f ins_rdbms.mk rac_on
This normally runs for a few minutes and should not pose any errors.
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. |
09 May 2007