Home » RDBMS Server » Server Administration » upgrade to 11.2.0.3 stuck at execute dbms_registry_sys.gather_stats(null); for 4 hours. (2 mERGED) (aix 6.0; oracle 11.2.0.2 to 11.2.0.3)
upgrade to 11.2.0.3 stuck at execute dbms_registry_sys.gather_stats(null); for 4 hours. (2 mERGED) [message #546894] Fri, 09 March 2012 16:27 Go to next message
cakeday
Messages: 31
Registered: May 2010
Member
i am upgrading a 11.2.0.2 database to 11.2.0.3;

my upgrade has been stuck at the following steps the past 4 hours..

What are my OPTIONS ?



TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP STATS_BGN 2012-03-09 10:03:32

1 row selected.

SQL>
SQL> execute dbms_registry_sys.gather_stats(null);

= = =

i am running out of outage time -- if i kill this upgrade where does that leave me ?

PLEASE HELP!
upgrade to 11.2.0.3 stuck at execute dbms_registry_sys.gather_stats(null); for 4 hours. [message #546895 is a reply to message #546894] Fri, 09 March 2012 16:29 Go to previous message
cakeday
Messages: 31
Registered: May 2010
Member
i am upgrading a 11.2.0.2 database to 11.2.0.3;

my upgrade has been stuck at the following steps the past 4 hours..

What are my OPTIONS ?



TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP STATS_BGN 2012-03-09 10:03:32

1 row selected.

SQL>
SQL> execute dbms_registry_sys.gather_stats(null);

= = =

can i run any queries to see, if the database is actually doing something ?

i am running out of outage time -- if i kill this upgrade where does that leave me ?

PLEASE HELP!
Previous Topic: how to find updated table
Next Topic: ORA-01652: unable to extend temp segment by 128 in tablespace DATA_01
Goto Forum:
  


Current Time: Fri Mar 29 05:17:02 CDT 2024