search cancel

Can the Automic database be on Amazon RDS for Oracle

book

Article ID: 189982

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

I am currently having AWS RHEL linux servers built for our upcoming update to Automic 12.3 .  I have been asked if the Oracle database for the Automic Engine can be set up on Amazon RDS for Oracle instead of creating an AWS server with Oracle database installed on it.  Does Automic Support this environment?

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Unfortunately Amazon RDS for Oracle RDS doesn't supply SYSDBA privileges. 

In our documentation we advise that you must set the following Execute Right:

GRANT execute ON dbms_lock TO <user>

This right can only be set by a user who has the SYSDBA privilege.

Amazon; documents that they don't supply this right:

https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html

and therefore we unfortunately cannot support this environment.