My Oracle Support Banner

WHEN LOGIN VIA EM EXPRESS, ORA-979 IS RAISED (Doc ID 2390782.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms

When login to database via EM Express, an error dialog with ORA-979 is displyed.

ERROR
-----------------------
ORA-00979: not a GROUP BY expression
ORA-06512: at "SYS.PRVT_AWR_VIEWER", line 9171
ORA-06512: at "SYS.PRVT_AWR_VIEWER", line 13196
ORA-06512: at "SYS.PRVTEMX_DBHOME", line 876
ORA-06512: at "SYS.PRVTEMX_DBHOME", line 144
ORA-06512: at "SYS.WRI$_REPT_DBHOME", line 91
ORA-06512: at "SYS.DBMS_REPORT", line 898
ORA-06512: at line 1

ex)

 

Changes

setting "_fix_control"='11657903:ON' 

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!


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