Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Oracle 11g R1/R2 Real Application Clusters Essentials

You're reading from   Oracle 11g R1/R2 Real Application Clusters Essentials Design, implement, and support complex Oracle 11g RAC environments for real world deployments

Arrow left icon
Product type Paperback
Published in May 2011
Publisher Packt
ISBN-13 9781849682664
Length 552 pages
Edition 1st Edition
Languages
Arrow right icon
Toc

Table of Contents (20) Chapters Close

Oracle 11g R1/R2 Real Application Clusters Essentials
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
1. High Availability FREE CHAPTER 2. Oracle 11g RAC Architecture 3. Clusterware Installation 4. Automatic Storage Management 5. Managing and Troubleshooting Oracle 11g Clusterware 6. RAC Database Administration and Workload Management 7. Backup and Recovery 8. Performance Tuning 9. Oracle 11g Clusterware Upgrade 10. Real-world Scenarios 11. Enabling RAC for EBS 12. Maximum Availability Additional Resources and Tools for the Oracle RAC Professional Index

Oracle cluster interconnects


To verify the interconnect settings, query the (G)V$CLUSTER_INTERCONNECTS and the (G)V$CONFIGURED_INTERCONNECTS. For example, in order to verify interconnect settings with V$CLUSTER_INTERCONNECTS, issue the following SQL statement:

SQL> SELECT * FROM V$CLUSTER_INTERCONNECTS;
NAME    IP_ADDRESS     IS_ _    SOURCE
--------------- ---------------- --- -------------------------------
Eth0    10.10.10.34    NO       Oracle Cluster Repository

To verify the interconnect settings with V$CONFIGURED_INTERCONNECTS, issue the SQL statement, as specified in the following example:

SQL> SELECT * FROM V$CONFIGURED_INTERCONNECTS;
NAME    IP_ADDRESS     IS_       SOURCE
--------------- ---------------- --- -------------------------------
eth1    10.10.10.34    NO        Oracle Cluster Repository
eth0    10.10.10.144   YES       Oracle Cluster Repository
SQL> DESC V$CONFIGURED_INTERCONNECTS
Name   Null?           Type
----------------------------------------- -------- -...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image