EM 12c: Clicking on 'Tablespace Space Used %' Metric for a Database Target Results in Error ORA-01652: Unable To Extend Temp Segment By 128 In Tablespace TEMP

(Doc ID 2341873.1)

Last updated on DECEMBER 22, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.5.0 and later
Enterprise Manager Base Platform - Version 12.1.0.5.0 and later
Information in this document applies to any platform.

Symptoms

When clicking on the Target database -> All metrics --> Table space used (%), the below error message is reported:

JBO-29000: Unexpected exception caught: oracle.sysman.emSDK.page.mtrx.GetDataException, msg=ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.sysman.emSDK.page.mtrx.GetDataException, msg=ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

This error only occurs for this particular metric on this DB target.

The repository DB alert log shows multiple occurrences of the below errors:

ORA-1652: unable to extend temp segment by 128 in tablespace TEMP

 

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