Re: 7.3.3 to 8.1.5 upgrade

Thanks,

After playing around with the system tablespace size and archiving options it now does not get stuck at this point.

However, after doing a ALTER DATABASE CONVERT successfully and performing an ALTER DATABASE OPEN RESETLOGS also successfully, I attempt to run the conversion script. u0703040.sql as instructed.

Unfortunately, this is getting stuck, or taking an exceedingly long time (I haven't given it more than an overnight run - 14 hours or so). This is exactly described in the manuals as something to watch out for.

However, having played around with LARGE_POOL_SIZE, SHARED, CHECKPOINT settings etc., it still isn't getting anywhere.

Any clues here?

In article <P4dD3.8621$N77.662177_at_typ11.nn.bcandid.com>,   "Van Messner" <vmessner_at_netaxis.com> wrote:
> Unless you have a LOT of extra space in your system tablespace in the
7.3.3
> version, you should add a datafile to the system tablespace before
doing the
> migration. Try adding one of around 200M and see if you still
experience
> the problem.
>
> Van
>
> Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:937237189.17218.0.nnrp-03.9e984b29_at_news.demon.co.uk...
> >
> > Are you sure that it is really hanging.
> >
> > The source$ table is likely to be one of the largest
> > in the SYS schema (lots of text lines of all that pl/sql)
> > so possibly you are generating a lot of redo, and getting
> > checkpoint waits etc.
> >
> > Can you get a handle on the wait event that the process
> > is stuck on ? This may give some clues.
> >
> > If necessary use svrmgrl and fire in:
> > connect internal
> > oradebug setospid {process id of shadow}
> > oradebug event '10046 trace name context forever , level 8'
> >
> >
> > --
> >
> > Jonathan Lewis
> > Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
> >
> > darenscott_at_my-deja.com wrote in message
<7rj4cf$obt$1_at_nnrp1.deja.com>...
> > >When attempting an upgrade of a 7.3.3 instance to a 8.1.5 instance,
> > >the migration utility (mig) seems to be hanging when creating a
simple
> > >table, i.e.
> > >
> > > create table source$ as select * from sys.source$;
> > >
> > >I think I have set up the environment to be able to perform this
> > >migration, i.e. 7.3.3 environment, 8.1.5 environment, tablespace
> > >checks, etc., but this consistently hangs at this point.
> > >
> > >Anybody else experience this problem, and if so what's the
solution.
> > >
> > >
> > >
> > >
> > >
> > >Sent via Deja.com http://www.deja.com/
> > >Share what you know. Learn what you don't.
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 16 1999 - 10:14:23 CDT