Invalid Object MSC_EXA_UTIL

Step if the package MSC_EXA_UTIL is invalid

Error statement in Package body(Line 23)

FUNCTION check_exa_nodes return number IS
vCount number;
BEGIN
 select count(*) into vCount from v$cell;
 if ( vCount > 0) then

SOLUTION

This is due to a missing grant.

To allow the package to be valid run the command below ss sys user,


SQL> GRANT SELECT ON V_$CELL TO APPS;