AutoSys Workload Automation

Expand all | Collapse all

Can we have only one WAAE Instance on an Oracle Database instance?

Jump to Best Answer
  • 1.  Can we have only one WAAE Instance on an Oracle Database instance?

    Broadcom Employee
    Posted 10-15-2017 10:07 PM

    In the past we have only been able to have one AutoSys/WAAE Instance per Oracle database instance.  Is that still the case?



  • 2.  Re: Can we have only one WAAE Instance on an Oracle Database instance?
    Best Answer

    Broadcom Employee
    Posted 10-16-2017 01:07 AM

    Hello Paul,

     

    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.

     

    Regards

    Nitin Pandey  



  • 3.  Re: Can we have only one WAAE Instance on an Oracle Database instance?

    Posted 10-17-2017 11:54 AM

    make sure Oracle 12c is patched for the change_cursor bug. once you set that to similar it will hurt without the patch.



  • 4.  Re: Can we have only one WAAE Instance on an Oracle Database instance?

    Broadcom Employee
    Posted 10-16-2017 03:30 AM

    Thanks Nitin. that gives us another option.



  • 5.  Re: Can we have only one WAAE Instance on an Oracle Database instance?

    Posted 10-17-2017 11:49 AM

    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] 

    Best,

    Chris <CJ>



  • 6.  Re: Can we have only one WAAE Instance on an Oracle Database instance?

    Posted 10-17-2017 11:56 AM

    as Chris has said. Oracle DBAs have played schema games for quite some time now. :-)