u6678700.drv: FAILED: file ademusr.sql

Action plan to avoid ademusr.sql  job issue:

Issue:

AD Worker error:
The following ORACLE error:
ORA-01720: grant option does not exist for 'SYS.DBA_USERS'
occurred while executing the SQL statement:
GRANT select on FND_OAM_DBAUSERS_VL to em_oam_monitor_role

AD Worker error:
The following ORACLE error:

ORA-01720: grant option does not exist for 'SYS.GV_$SESSION'


Cause:

-APPS user do not have select privileges on 'SYS.DBA_USERS' table.

-Missing select with grant option privilege on sys.GV_$SESSION.


Reference:

-Patch 11i.ATG_PF.H.RUP7 (6241631) Failed With ORA-01720 While Running ademusr.sql [ID 1056816.1]

-ORA-01720: grant option does not exist for 'SYS.GV_$SESSION' [ID 1292658.1]


Solution:

To implement the solution, execute the following steps:

Grant select privileges to APPS user on 'SYS.DBA_USERS' object.

1. On Database Tier connect to SQLPlus as sysdba : sqlplus "/ as sysdba"

2. Execute the following on SQLPlus:

SQL> GRANT SELECT ON DBA_USERS TO APPS WITH GRANT OPTION;

3. As SYSTEM user, run the following from SQL Plus:


SQL> grant select on sys.GV_$SESSION to apps with grant option;


Restart the failed Worker using the adctrl utility in a second Shell session and continue.