Re: Upgrade from 10gR1 to R2. hanging.

You can select from v$sess_io and see if it is doing any IO. Also 10046 trace will show if anything is happening ( which is probably what you are seeing in v$session_event. I'd search metalink for bugs if I were you & open SR.

Regards, Ranko.

On 5/6/07, Ravi Madabhushanam <ravi.madabhushanam_at_gmail.com> wrote:
> 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
>
>
>

-- 
Regards,
Ranko Mosic
Consultant Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
--
http://www.freelists.org/webpage/oracle-l