We getting the below error while application installation.
Database Validation
Error: [CAUAJM_E_112560] Automation Storage Management (ASM) is disabled.
We have validated with dba team and confirmed ASM is enabled also below is pmon details :
[dbuser@localhost ~]$ ps -eaf|grep pmon
dbuser 127470 127400 0 17:26 pts/0 00:00:00 grep --color=auto pmon
grid 238642 1 0 Apr11 ? 00:00:04 asm_pmon_+ASM
dbuser 239898 1 0 Apr11 ? 00:00:06 ora_pmon_AUTODBPRI
[dbuser@localhost ~]$
Release : 12
Component : CA Workload Automation AE (AutoSys)
These are the queries run during the R12 Install
SELECT DISTINCT 1 AS value FROM ROLE_SYS_PRIVS WHERE PRIVILEGE= 'CREATE ROLE'
SELECT VERSION FROM PRODUCT_COMPONENT_VERSION WHERE PRODUCT LIKE 'Oracle Database%' AND ROWNUM=1;
SELECT CDB AS VALUE FROM V$DATABASE;
SELECT VALUE FROM V$PARAMETER WHERE NAME = 'DB_CREATE_FILE_DEST';
The last query give the output null
2021-04-11 14:34:36,047 [main] INFO com.ca.autosys.db.validation.OracleDBValidator - ORACLE_DB_SETUP : usingASM - null
2021-04-11 14:34:36,047 [main] ERROR com.ca.wla.ae.installer.logger.LogHelper - [CAUAJM_E_112560] Automation Storage Management (ASM) is disabled.
The user needs a SELECT_CATALOG_ROLE role
After updating the user permissions the problem was resolved