ORA-00604 / ORA-20900: RDS only supports Oracle Managed during create of WCC or Autosys databases

Products

• Autosys Workload Automation

Issue/Introduction

Customer is trying to create WCC/Autosys databases, against RDS AWS Oracle database.  

cawa_installer.log has below errors:

2021-05-17 16:06:15,892 [installer] INFO com.ca.autosys.db.main.AutoSysDBConnection - Running query : CREATE TABLESPACE WCC_DATA DATAFILE '/rdsdbdata/userdirs//WCC_DATA.DBF' SIZE 800M REUSE AUTOEXTEND ON NEXT 300K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

2021-05-17 16:06:15,892 [installer] ERROR com.ca.autosys.db.main.AutoSysDBConnection - Error in query execution :java.sql.SQLSyntaxErrorException: ORA-04088: error during execution of trigger 'RDSADMIN.RDS_DDL_TRIGGER2' ORA-00604: error occurred at recursive SQL level 1 ORA-20900: RDS only supports Oracle Managed Files. Check ddl and remove any named identifiers ORA-06512: at "RDSADMIN.RDSADMIN_TRIGGER_UTIL", line 266 ORA-06512: at line 2

2021-05-17 16:06:15,908 [installer] ERROR com.ca.autosys.db.install.CreateOracleDatabaseService - Error in create tablespace, error is {}

Environment

Release : 12.0

Component : WORKLOAD CONTROL CENTER

Cause

Oracle storage management option  Oracle Storage Management was selected, which makes the installer prompt for datafile names, paths, sizes etc.,

Resolution

Select the Storage Management = Oracle Managed Files (OMF)  option during the install and retry the install