Can Oracle Home and database instance be owned by different users?
Is this possible?
Oracle Home owned by user "oracle"
Database prod1 in this home owned (instance started as user) by user "oraprod1" and database prod2 by user "oraprod2"
Theoretically, if the user permissions are same, it should not be a problem (I think).
If it is actually possible, a case where we have RAC for both the databases and use crsctl or srvctl to startup/shutdown the databases, will the databases start as user "oracle" or as respective users (oraprod1/oraprod2)?
Regards,
Amol.