After Application of April PSU Patch 27338041(12.1.0.2.180417) , DBMS_ASH_INTERNALS Is Invalid

(Doc ID 2392962.1)

Last updated on MAY 07, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Generic UNIX

Symptoms

2070/5 PL/SQL: Statement ignored
2070/43 PLS-00302: component 'ID2NAME_SUBQ' must be declared

 

Changes

 Applied April 2018 PSU Patch 27338041(12.1.0.2.180417)

or

Upgraded database to 12.1.0.2 .Then check 'opatch lsinventory' output which shows the April 2018 PSU Patch 27338041(12.1.0.2.180417) been applied.

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