Database Reference
In-Depth Information
Summary
In summary, the following guidelines are offered for the operational aspects of a RAC cluster.
•
Use services effectively to partition the application workload. Load balancing and failover can
be achieved elegantly with the use of services.
•
Use SCAN listeners and SCAN IP addresses. Publish only SCAN name to the application.
Do not allow an application to connect to VIP listeners directly.
•
Use three SCAN IP addresses mapping to a SCAN name.
•
Set up TAF attributes of a service to implement TAF.
•
Use tools such as universal connection pool or Active GridLink data source to implement
faster failover and load balancing capabilities.
•
Use as many temp files as the number of instances for temporary tablespaces. Allocate more
space if you are planning to add more instances to the database.
•
Manage application connection and users so as to reduce locking due to soft reservation in
temporary tablespaces.
•
Verify that oradism binary has correct permissions so that background processes can execute
at an elevated priority.
•
In Linux, implement HugePages to avoid unnecessary reboots.