This content has been marked as final. Show 5 replies
There will not any node evictions by using the shared oracle home.
what is the best way to prevent node eviction or any complications for a shared oracle home?
remote_listener parameter must set to scan listener. It is default to scan listener if you create a database using DBCA.
What about scan listeners? I just add the db in?
Its all depends upon how busy the DB's will be and how you want to deal with it.
If we add a new db, what should I do with the db connection? Should I designate one node for one db or do same failover/load balance services?
In general spawn the services across all nodes and use load balance so that connections will be evenly spread across all instances. In this way you will be using all instances effectively.
Again its need to be desinged as per your needs and by considering the nature of app.
Some advice you would receive would be to consolidate the second "database" as a schema into the existing database. This can be done if there are no conflicts in public synonyms. Your SGA has to be increased and backups would backup both schemas together.
Is there a particular need to have a physically separate database ?
Have you looked up Instance Caging and Server Pools and Policy Managed databases ?
See the Oracle Database Quality of Service Management User's Guide at http://docs.oracle.com/cd/E11882_01/server.112/e24611/toc.htm
Hemant K Chitale