Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: 7.3.3 to 8.1.5 upgrade
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.
>
>
Received on Mon Sep 13 1999 - 15:25:25 CDT