Automic Workload Automation

Dear Community,

Does anyone knows about  AWA 12.X support on Oracle ADG configuration:

 1) for AE’s database

2) and other Agents/Components connecting to Oracle database (eg: Oracle EBS,SQL,Oracle Retail )

Sample ADG database connection string we used is like belwo:

jdbc:oracle:thin:@(DESCRIPTION =(CONNECT_TIMEOUT=15)(FAILOVER = ON)(LOAD_BALANCE = OFF)(TRANSPORT_CONNECT_TIMEOUT=6)(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = ablinuxbl807.hq.emirates.com)(PORT = 6516))(ADDRESS = (PROTOCOL = TCP)(HOST = xylinuxbl807.hq.emirates.com)(PORT = 6516)))(CONNECT_DATA =(SERVICE_NAME = aedb_ha)))

Note: Documentation does indicates its support for Oracle RAC configuration but not anything specific to Oracle ADG.

Rgds,

Indika Peiris

Adrian_Fresno_menendez_4090

Apriciate if you can give some update on this?

Rgds,
Indika Peiris

Hello Indika, from what I have seen on the documentation, as AWA engine needs an Oracle client 64bits installed and configured to use the Oracle Database, I think that this will be correctly supported for the AE's database.
As for the Rapid Agents, they all use the jdbc driver, and you can select it when creating the CONN object:
https://docs.automic.com/documentation/webhelp/english/AWA/12.0/DOCU/12.0/AWA%20Guides/help.htm#AWA/Objects/obj_Connection_overview.htm?Highlight=conn

So I think that it should also be ok, nevertheless I don't think that this has been tested on our environments.

Hi Community and  Adrian_Fresno_menendez_4090

Here I can confirm that OEBS RA Agent 4.X( latest version ) supports Oracle ADG (Active data grad) database connection configuration.
https://us.v-cdn.net/5019921/uploads/editor/7z/jv1b6weqw104.png" width="610">

Also please note that we have to use the deprecated feature not sure what would we do when they realy deprecate this option  :#  .

Agent started fine and I can query the database objects successfully. No error on the logs and I assume everything OK. I'm sorry did not try running jobs so far.
Our Oracle database version is (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0)

If someone tested AE Database on oracle ADG, please update me too. ( I do not have test database yet )

Rgds,
Indika Peiris

Thanks a lot for the feedback IndikaPeiris611408, I will transmit this information to our Product Management and let you know about the "Free For Entry" feature if it will be kept on upcoming releases or replaced by something else.

Found a post related to the same topic by

nofollow" target="_blank" href="https://community.automic.com/profile/7439/Andreas%20Sprosec">Andreas Sprosec" , He has shared very important information about AE Database support on Oracle Database with ADG configuration. Information seems provided by Professional Service Team EMEA.

Link to the post ( Use google or bower language translator to convert it to English)
https://community.automic.com/discussion/8086/automic-und-data-guard 

"Oracle DataGuard can and is currently used by customers as a high-availability solution for Automation Engine databases. 

For an Automation Engine system, it makes no difference whether the database consists of a single instance, multiple DataGuard mirrored instances, a RAC, or a combination of RAC and DataGuard. The behavior of a connection loss to the database is identical in all cases.
.
.
"

Thank you 

nofollow" target="_blank" href="https://community.automic.com/profile/7439/Andreas%20Sprosec" title="Link: https://community.automic.com/profile/7439/Andreas%20Sprosec">Andreas Sprosec" for sharing the valuable information with community.

Hi @Indika Peiris,

Please confirm if you have been successful to schedule OEBS jobs on ADG mirrored OEBS DB Instance. We have a similar use case as below and your feedback will certainly be helpful.

Currently OEBS RA core agent is using a connection object to connect with primary OEBS DB instance. 

We are planning to create a ADG standby OEBS DB which will be in sync with primary OEBS DB instance and will be used in case of primary DB failure. All the existing triggers and objects created by OEBS RA core agent into primary OEBS DB will be copied to standby OEBS DB. 

To support the connectivity between OEBS RA core agent and standby OEBS DB instance, we will create another connection object for standby OEBS DB instance. In case of primary DB failure, we will just edit the OEBS RA core agent to use the 2nd connection object for standby OEBS DB. 

Please let us know if there is any product limitation for OEBS RA core agent to support connecting with standby OEBS DB for OEBS jobs scheduling. 

Thanks.