Adding an RAC database instance

Assuming that you have created an RAC database with a single instance named RACDB, later on you may want to add a new instance to the RAC database to avoid a single point of failure, or to scaleup your application workload over multiple instances. One of the primary advantages of an RAC database, in contrast to a standalone database, is that an RAC database can consist of two or more instances accessing a single database. Having two or more instances enables you to achieve scalability by balancing the application workload across available instances to achieve better performance. It also provides a high availability solution by rapidly reestablishing the lost user connections from a failed instance to the other surviving instance in the RAC database.

Adding more instances to an RAC database is a very simple task and Oracle provides the following ways to achieve this:

• DBCA

• Enterprise Manager (grid control)

• Manual method

Adding a new instance using DBCA

Although...