Upgrade from 10gR1 to R2. hanging.

From: Ravi Madabhushanam <ravi.madabhushanam_at_gmail.com>
Date: Sun, 6 May 2007 19:22:44 +0530
Message-ID: <f2f282d10705060652h3d87e358gfe40f2b4e8e64211@mail.gmail.com>

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
--

http://www.freelists.org/webpage/oracle-l Received on Sun May 06 2007 - 08:52:44 CDT