IAM-1020021 Unable to execute job : Refresh Role Memberships with Job History Id:xxxxx

Refresh Role Memberships schedule job is failing

 

 

 

 

 

 

 

 

 

The schedule job "Refresh Role Memberships" is failing every time. The following error is seen in the log file.

[2022-05-17T11:39:49.111+00:00] [oim_server1] [WARNING] [] [oracle.iam.scheduler.vo] [tid: OIMQuartzScheduler_Worker-6] [userId: oiminternal] [ecid: 8d6118d3-c0fd-4fd4-8f76-d7cce785005b-000000ae,1:17] [APP: oim] [partition-name: DOMAIN] [tenant-name: GLOBAL] IAM-1020021 Unable to execute job : Refresh Role Memberships with Job History Id:148269[[
oracle.iam.platform.utils.SuperRuntimeException: Role membership rule evaluation failed for following roles :497
at oracle.iam.identity.scheduledtasks.RefreshRoleMembershipsTask.execute(RefreshRoleMembershipsTask.java:181)

 

Troubleshooting:

 

checked UGP and DYN_EVAL_CHANGELOG tables
UGP table does not have a record for UGP_KEY=497;
DYN_EVAL_CHANGELOG have a record for ENTITY_ID=497; 

Solution:

There is a record for 497 Entity_ID in DYN_EVAL_CHANGELOG table for relationship_type = ROLE_USER.
So, one can take backup of db and delete that entry.
Rerun Refresh Role Memberships job to resolve the issue.

ORA-00845: MEMORY_TARGET not supported on this system

Error : ORA-00845: MEMORY_TARGET not supported While starting the Oracle Database.

SQL> startup

ORA-00845: MEMORY_TARGET not supported on this system

Solution:

1) Set the ORACLE_HOME to DB Product Home

export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1

2) login as root

[root@oracle oracle]# df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/mapper/vg_oracleem-lv_root

                              93G   19G   69G     22% /

tmpfs                     7.2G   112K  7.2G     0% /dev/shm

/dev/sda1               485M   99M  362M  22% /boot

Note: The highlighted mount is 0% used though does not have enough memory to start the DB

3) Change the size of file system to 12g 

[root@oracle oracle]# mount -t tmpfs shmfs -o size=12g /dev/shm

This will be temporary solution to start the DB.

4) Start the DB

5)To permanently fix it you have to edit the file /etc/fstab by logging in as root user and commit the changes by saving the file.

[root@oracle ~]# cat /etc/fstab

tmpfs                   /dev/shm                tmpfs   size=12g        0 0

6) Start the DB.

SQL> startup

ORACLE instance started.

Total System Global Area 1.1758E+10 bytes

Fixed Size                  2239056 bytes

Variable Size            5939135920 bytes

Database Buffers         5804916736 bytes

Redo Buffers               12128256 bytes