New installation of Autosys in AWS using Oracle 19c RDS is failing

Products

• Autosys Workload Automation

Issue/Introduction

When trying to install Autosys scheduler, wherein we choose option 2 to "Create the database schema [Creates the AutoSys database schema]"
It's getting stuck at the same point while making JDBC connection after entering the sys DB password and not progressing further. 

2025-08-07 13:40:59,142 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder(57) - TNS_ADMIN=null
2025-08-07 13:40:59,142 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder(86) - url template:jdbc:oracle:thin:@//${servername}:${port}/${dbname}
2025-08-07 13:40:59,142 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder(88) - Setting host and port: <hostname.example.com>: 1521
2025-08-07 13:40:59,143 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder(90) - Database connection string :jdbc:oracle:thin:@//<hostname.example.com>:${port}/SYS$USERS
2025-08-07 13:40:59,143 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder(92) - Database connection string :jdbc:oracle:thin:@//<hostname.example.com>:1521/SYS$USERS
2025-08-07 13:40:59,143 [main] DEBUG com.ca.autosys.db.url.OracleURLBuilder(71) - Database connection string :jdbc:oracle:thin:@//<hostname.example.com>:1521/SYS$USERS
2025-08-07 13:40:59,144 [main] DEBUG com.ca.autosys.db.connection.DBConnectionOracle(90) - tnsAdmin= null
2025-08-07 13:40:59,144 [main] INFO  com.ca.autosys.db.connection.DBConnectionOracle(129) - connecting ... [jdbc:oracle:thin:@//<hostname.example.com>:1521/SYS$USERS]
2025-08-07 13:40:59,144 [main] INFO  com.ca.autosys.db.connection.DBConnectionOracle(131) - Connecting  with user ... [USER_NAME]
2025-08-07 13:40:59,145 [main] INFO  com.ca.autosys.db.connection.DBConnectionOracle(154) - connecting ... [jdbc:oracle:thin:@//<hostname.example.com>:1521/SYS$USERS]

The below KB article was implemented, but this did not help resolve this issue.

Autosys install tries to connect to SYS$USERS AWS RDS database, ORA-12514 in installer log

Environment

AutoSys 12.x, 24.x

Cause

Using an Oracle 19C standalone database in AWS RDS instead of a Containerized (Tenant) database

Resolution

Recreate the database as a Containerized (Tenant) database.

Additional Information

Examples of potential problems using an AWS RDS Oracle 19c Standalone database

• Unable to upgrade the database properly
• Autosys patches not working properly
• Autosys Upgrades failing.
• Unexpected behavior of normal operations and job execution.