catupgrd.sql still hanging after add space to TEMP tablespace
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