Can the Automic database be on Amazon RDS for Oracle
Article ID: 189982
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.
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.
Feedback
Yes
No
Powered by
