Database Administration (MOSC)

MOSC Banner

catupgrd.sql still hanging after add space to TEMP tablespace

edited Aug 9, 2013 7:26AM in Database Administration (MOSC) 9 commentsAnswered
Hi,

In the middle of upgrade database from 11.2.0.1 to 11.2.0.3, the database has the error on alert.log

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

After add space using another terminal:

SQL>  alter tablespace temp add tempfile '/u02/oradata/tedprd01/temp02.dbf' size 2G;

the process still hanging at the following step:

SQL> BEGIN
  2   sys.dbms_registry.loaded('APS');
  3   aps_validate;
  4  END;
  5  /

How to make it continue?

Thanks,

Xiaogang

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center