Is it possible to run two completely different Oracle databases on a two-node RAC cluster?
Short answer is yes....it is possible. This will run with no issues as long you have the resources available for an additional database.
I am inclined to suggest that they split it up into two two-node RAC clusters on four smaller host servers.
This is another option. In the past I've had two databases on a RAC cluster which was implemented due to cost/licensing reasons ( I don't think this applies to SE, but you'll need to check).
However having having them on separate hosts mean that you will only potentially have downtime on one database if you decide to do something like upgrade one of the databases and as a result have to upgrade GI as well. This would mean downtime for all your databases which use the GI.
1 person found this helpful
You may be limited by licensing issues, that you need to discuss with your management. Data Guard would need Enterprise Edition licenses per CPU multiplied by core factors, RAC needs only Standard Edition licences per CPU (no core factor). So your four node solution would need four Standard Edition licences, whereas the two node solution needs only two.
Thanks for your answer and thoughts. We are looking to go 11gR2 right now but I am also exploring 12c with the "pluggable database" I checked and we DO have sufficient licenses for four node.
Thanks for the Answer you have reinforced my belief that a four node configuration would be best going forward.
I've once encountered a RAC with 6 nodes, and 8 databases on it, each one running in all the nodes, so yea it is possible.
Just as a word of warning. You will have more than one Global SGA shipping blocks accross the same interconnect, so be sure to have a proper physical set up on your interconnect to support the added traffic or you may have major issues with interconnect performance.