Re: Upgrade from 10gR1 to R2. hanging.
- From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
- To: ravi.madabhushanam@xxxxxxxxx
- Date: Sun, 6 May 2007 14:03:20 -0500
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@xxxxxxxxx> 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
--
//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@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
