Getting error during r12 installation [CAUAJM_E_112560] Automation Storage Management (ASM) is disabled.

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

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 ~]$

 

 

Environment

Release : 12

Component : CA Workload Automation AE (AutoSys)

Resolution

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