Autosys installation/Upgrade Failed

Document ID : KB000008690
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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

 

Environment:
ALL Supported Versions WAAE and DB's.
Cause:

You would get this error if AEDBADMIN doesn’t have the 'SELECT_CATALOG_ROLE' role granted.

 

Resolution:

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

Additional Information:

If this does not resolve the issue, please raise a case to support.