DBMaint is not running properly due to a failing DB query.
CAUAJM_I_60019 dbstatistics: Running dbstatistics at: Fri Aug 26 16:25:37 2016
CAUAJM_I_60020 dbspace: Running dbspace at : Fri Aug 26 16:25:45 2016
CAUAJM_E_18416 Event Server: <aedbd> Failed Query: <SELECT a.blocks, d.block_size FROM all_tables a JOIN dba_tablespaces d ON a.tablespace_name=d.tablespace_name WHERE lower(a.table_name)='ujo_afm'>
CAUAJM_E_18402 ORA-00942: table or view does not exist
CAUAJM_I_18403 Processing OCI function not used(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <862>
We have customized tablespaces such AEDBADMIN_DATA and AEDBADMIN_IDX
Workload Automation AE
Follow the steps below resolve this issue:
'ujoadmin' is a role in the AEDB and needs to have the following permissions granted (if they do not exist):
GRANT ANALYZE ANY TO ujoadmin;
GRANT SELECT ON DBA_TABLESPACES TO ujoadmin;
Also, 'aedbadmin' needs the following permissions granted (if they do not exist):
GRANT ujoadmin TO aedbadmin;
Run the following SELECT statement against the AEDB :
SELECT a.blocks, d.block_size FROM all_tables a
JOIN dba_tablespaces d ON a.tablespace_name=d.tablespace_name
WHERE lower(a.table_name)='ujo_afm';