Oracle Rules Manager shows status 'INVALID' (Doc ID 1078135.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 14-12-2012***

Symptoms

In DBA_REGISTRY, the component "Oracle Rules Manager" shows in INVALID status.

SELECT comp_id, comp_name, version, status, schema
FROM dba_registry
WHERE status <> 'VALID';

COMP_ID COMP_NAME VERSION STATUS SCHEMA
----------------------------------------------------------
RUL Oracle Rules Manager 10.2.0.2.0 INVALID EXFSYS



SELECT owner, object_name, object_type, created, last_ddl_time, status
FROM dba_objects
WHERE status <> 'VALID';

Owner Object_Name Object_Type Created Last_DDL_Time Status
------------------------------------------------------------------------------------
EXFSYS DBMS_RLMGR_DR PACKAGE BODY 16-Feb-2006 20:31:54 17-Mar-2010 14:01:51 INVALID
EXFSYS DBMS_RLMGR_UTL PACKAGE BODY 16-Feb-2006 20:31:53 17-Mar-2010 14:01:51 INVALID



An attempt to re-compile the objects fails with errors like:

EXFSYS DBMS_RLMGR_DR 20/21 PLS-00201: identifier 'DBMS_LOCK' must be declared
EXFSYS DBMS_RLMGR_DR 20/11 PL/SQL: Statement ignored
EXFSYS DBMS_RLMGR_DR 32/23 PLS-00201: identifier 'DBMS_LOCK' must be declared
EXFSYS DBMS_RLMGR_DR 32/13 PL/SQL: Statement ignored
EXFSYS DBMS_RLMGR_DR 86/17 PLS-00201: identifier 'DBMS_LOCK' must be declared
EXFSYS DBMS_RLMGR_DR 86/7 PL/SQL: Statement ignored
EXFSYS DBMS_RLMGR_DR 103/21 PLS-00201: identifier 'DBMS_LOCK' must be declared
EXFSYS DBMS_RLMGR_DR 103/11 PL/SQL: Statement ignored

Changes

The execution privilege on DBMS_LOCK was revoked from the user EXFSYS.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms