My Oracle Support Banner

ORA-02311 After Installing Patch 27774706 And Executing Datapatch (Doc ID 2509862.1)

Last updated on NOVEMBER 07, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.0.1 version, RDBMS

ORA-02311 after installing Patch 27774706 and executing datapatch

When executing the steps in Doc ID 2453673.1 due to ORA-20001 DB Auto Task Failures, the following error is received:

ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_110728"
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: in "SYS.DBMS_STATS", Zeile 47209
ORA-06512: in "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: in "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: in "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: in "SYS.DBMS_STATS", line 47199


But after installing Patch 27774706, executing the below steps ...

$ sqlplus / as sysdba
drop table WRI$_ADV_DEFINITIONS;
@?/rdbms/admin/catadvtb.sql
@?/rdbms/admin/utlrp.sql
execute dbms_advisor.setup_repository;
EXEC dbms_stats.init_package();
, and executing datapatch -verbose we get
:
Validating logfiles...
Patch 27774706 apply: WITH ERRORS
logfile: <DIR>/sqlpatch/27774706/22251824/27774706_apply_HLO2_2018Dec12_17_05_28.log (errors)
Error at line 33: ORA-02311: cannot alter with COMPILE option a valid type with type or table

 

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
References


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