Liquibase Enterprise was formerly known as Datical DB.
Oracle on Amazon RDS differences from Oracle on prem Database Setup
In general the Datical features for Oracle Database Setup apply to Oracle on Amazon RDS.
There are a number of important exceptions.
Feature Support
- SSL connections through Oracle Wallet - Supported.
- See SSL Connection to an Oracle Database Through Oracle Wallet.
- See also AWS documentation on using SSL - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.Options.SSL.html
- Pluggable Databases (PDBs) - AWS does not support Pluggable databases on Oracle RDS
- Oracle Flashback database - AWS does not support Flashback database on Oracle RDS
Permissions
AWS places some restrictions on certain system privileges. The DBA does not have access to highly privileged accounts such as SYS, SYSTEM, or SYSDBA. Instead, DBAs have access to a MASTER account that is used to administer the database via the RDSADMIN utilities.
The following permissions are not allowed on Oracle RDS.
GRANT CREATE ANY DIRECTORY GRANT CREATE ANY DATABASE LINK GRANT DROP ANY DATABASE LINK
TRACE_FILE_DIR
The TRACE_FILE_DIR parameter does not apply to Oracle RDS. Instead, the default RDS directory called 'BDUMP' (background_dump_dest) will be used by the Datical Convert SQL process to retrieve the trace file.
Copyright © Liquibase 2012-2022 - Proprietary and Confidential