Recompile the invalid objects of the Grid repository

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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.