Upgrade from 10gR1 to R2. hanging.
- From: "Ravi Madabhushanam" <ravi.madabhushanam@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Sun, 6 May 2007 19:22:44 +0530
Hi all,
I'm doing an upgrade from 10.1.0.4 o 10.2.0.3. OS:Redhat Linux AS3.
While running catupgrd.sql , the process is just waiting at a
particular statement(mentioned below). I've checked event from other
session. It is presently waiting on "latch free" event. Latch
name:simulator lrs latch. Latch#=127
For last 3 hrs, there is no update. Can you please help me how to know
the progress. In alert log, nothing is happening, not even a log
switch. There isn't any load on the system. load average is just 1.
--------
SQL> Rem Define the HAE_SUB subscriber for the alert_que
SQL> declare
2 subscriber sys.aq$_agent;
3 begin
4 subscriber := sys.aq$_agent('HAE_SUB',null,null);
5 dbms_aqadm_sys.add_subscriber(queue_name => 'SYS.ALERT_QUE',
6 subscriber => subscriber,
7 rule => 'tab.user_data.MESSAGE_LEVEL = '
.....
TIA,
Regards,
Ravi
--
//www.freelists.org/webpage/oracle-l
Other related posts:
