My Oracle Support Banner

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

Last updated on OCTOBER 12, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.