Recompile the invalid objects of Grid Repository

Check the invalid objects of Grid Repository

Login with Sysman user & check invalid objects present in SYSMAN Schema:

SELECT object_name, object_type FROM user_objects
WHERE object_name NOT LIKE 'BIN$%' AND status='INVALID'

Recompile the invalid objects of SYSMAN schema in Grid Repository:

Set the OMS Home and login with repository database:

SQLPLUS> @<OMS_HOME>/sysman/admin/emdrep/sql/core/latest/admin/admin_recompile_invalid.sql SYSMAN

Otherwise compile the invalid objects manually:

SQL> alter package <package name> compile;
SQL> alter package <package body name> compile body;
SQL> alter view <view name> compile;
SQL> alter synonym <synonym name> compile;
SQL> alter public synonym <synonym name> compile;
SQL> alter procedure <procedure name> compile;
SQL> alter function <function name> compile;