In the past we have only been able to have one AutoSys/WAAE Instance per Oracle database instance. Is that still the case?
We are pleased to inform you that we have delivered Oracle 12c container support in R11.3.6 SP06. Now you can have multiple AE Instance per Oracle database.
Thanks Nitin. that gives us another option.
One more option.......
One database, different schemas and I have implemented this type of architecture with AE 11.3.6
Check this link out for more help with your question:
Multiple Schema Versus Multiple Databases - Oracle Distributed Systems [Book]
as Chris has said. Oracle DBAs have played schema games for quite some time now. :-)
make sure Oracle 12c is patched for the change_cursor bug. once you set that to similar it will hurt without the patch.