Autosys R11.3 x installation/Upgrade failed with ORA-00942. You would see below error in “install_aedb.log”.
SELECT COUNT(*) FROM dba_tables WHERE table_name = UPPER('UJO_ALAMODE') AND owner = UPPER('aedbadmin')
ERROR at line 1:
ORA-00942: table or view does not exist
You would get this error if AEDBADMIN doesn’t have the 'SELECT_CATALOG_ROLE' role granted.
Hence, the following should fix:
GRANT 'SELECT_CATALOG_ROLE' TO AEDBADMIN;
By the way, the following privileges are granted to AEDBADMIN user by default
GRANT CREATE VIEW TO AEDBADMIN
GRANT 'CONNECT' TO AEDBADMIN
GRANT 'EXECUTE_CATALOG_ROLE' TO AEDBADMIN
GRANT 'RESOURCE' TO AEDBADMIN
GRANT 'SELECT_CATALOG_ROLE' TO AEDBADMIN
GRANT CREATE PUBLIC SYNONYM TO AEDBADMIN
If this does not resolve the issue, please raise a case to support.