SES Patch Set 10.1.8.4 Failed With Error: FAILED validation of schema: EQSYS (Doc ID 1322458.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Secure Enterprise Search - Version: 10.1.8.4 and later   [Release: and later ]
Information in this document applies to any platform.

Symptoms


While applying 10.1.8.4 patchset on Oracle SES 10.1.8.2.0 it fails with these errors.



... granting execute privilege on stored procedures to public
... creating procedure MOVE_EQ
... creating remove_mdata
... creating or replacing snapshot supporting views
Migrating Security Data
Validating the installation
Invoking Enterprise Search Install/Upgrade validation procedure VALIDATE_EQ
=======================================================
= FAILED validation of schema: EQSYS
=======================================================
BEGIN SYS.VALIDATE_EQ; END;

*
ERROR at line 1:
ORA-20000: Secure Enterprise Search validation failed
ORA-06512: at "SYS.VALIDATE_EQ", line 170
ORA-06512: at line 1



... checking for invalid objects... see list below
================== list start

OBJECT_NAME OBJECT_TYPE STATUS
------------------------------ ------------------- -------
EQ_QRY PACKAGE BODY INVALID
================== list end

... execute utlrp.sql to recompile invalid objects

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2011-04-20 13:30:27

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2011-04-20 13:30:28
Invoking Enterprise Search Install/Upgrade validation procedure VALIDATE_EQ
=======================================================
= FAILED validation of schema: EQSYS
=======================================================

... checking for invalid objects... see list below
================== list start

OBJECT_NAME OBJECT_TYPE STATUS
------------------------------ ------------------- -------
EQ_QRY PACKAGE BODY INVALID

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