Can I run multiple instances of cloudera manager pointing to a different oracle database instance in the same oracle cluster with different SIDs.Say I create 3 oracle db instances (o1,o2 and o3) within the same cluster for my dev and qa instances.Is it supported?.
Yes, this is supported. The database for CM does not need to be dedicated to CM. Just be sure to configure it appropriately for multiple CM servers to run on it.
Thank you Darren.Another alternate approach which I was thinking was having different schema names (say activitymonitor_dev,activitymonitor_qa,clouderamanger_qa etc) in the same data base instance.Do you think there could be any issues if I go via this route.