are two separate servers needed for each database?It depends on
Billy Verreynne wrote:Surely in this case, Billy, you would want all ten nodes to be members of all three pools: include them all in the -n list of srvctl add srvpool for all the pools. But then each limit each pool's active membership with the -u argument, such that pool1 can have max 5 active servers and so on. Let the cluster decide which servers whould run which instances, rather than hard coding it?
RAC support server pools. Which is perhaps what you should consider. You can create a cluster/grid of 10 servers and 3 server pools. Each pool runs a specific RAC database on a specific number of servers.
E.g. pool 1 is nodes 1 to 5 and runs RAC db1. Pool 2 is nodes 6 and 7 and runs RAC db2. Pool 3 is nodes 8 to 10 and runs RAC db3. If you need more horses for db3, you can dynamically decrease pool 1 by 1 server and reassign that server to pool 3.