ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 212503

calendar_today

Updated On:

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 :

[[email protected] ~]$ 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
[[email protected] ~]$

 

 

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