No. Did you follow Chapter 7's instructions to the letter?
Regards
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
"Dave Haas" <davehaas_at_--nospam--hotmail.com> wrote in message
news:zXLl8.34712$%6.1208082_at_news2.telusplanet.net...
> Hi Howard.
>
> I know that setting the compatibility parameter is only one step. The
> problem i'm having is getting the database to the open stage so that i can
> run the dd upgrade script. If i can't open the db then i can't continue
the
> process.
>
> BTW, I do have a Technet account, just not a Metalink one :)
>
> Do you think it might be the fact that I'm running 8.1.7.0.0 instead of
the
> latest release of 8.1.7.?.?
>
> Dave
>
>
> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> news:a781je$34r$1_at_lust.ihug.co.nz...
> > What you describe is not how the upgrade from 8 to 9 is done. There's
> much
> > more to it that just setting the compatibility parameter. There's other
> > parameters to check, and a number of scripts to run.
> >
> > Check out
> >
>
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90191/mi
> > gupgra.htm#901509
> >
> > for full details (and watch out for any wrapping in that address). This
> is
> > available from technet.oracle.com (as is all the documentation), and you
> > have to be a member first. Membership, however, is free and instantly
> > granted, and they don't spam.
> >
> > If for some reason the link doesn't work for you, search for "Oracle9i
> > migration", and click on the link for 'Migrating from Oracle7 Using the
> > Migration Utility'. From there, navigate to Chapter 7, somewhat
> > mysteriously entitled "i Release".
> >
> > Regards
> > HJR
> > --
> > ----------------------------------------------
> > Resources for Oracle: http://www.hjrdba.com
> > ===============================
> >
> >
> > "Dave Haas" <davehaas_at_--nospam--hotmail.com> wrote in message
> > news:YyKl8.34683$%6.1200943_at_news2.telusplanet.net...
> > > Hi all.
> > >
> > > This is related to a previous post.
> > >
> > > Right now I'm attempting to upgrade an vanilla 8.1.7 database to a
9.0.1
> > > database.
> > >
> > > Setup:
> > >
> > > Win2k SP2
> > > Celeron 466
> > > 384M Ram
> > > Vanilla 8.1.7 (no service paks, downloaded from technet)
> > > Vanilla 9.0.1 (no service paks, downloaded from technet)
> > >
> > > When it was an 8.1.7 database everything was fine. I copied the
> datafiles
> > > over to the 9i OFA directory structure under the 9i ORACLE_HOME and
> > updated
> > > the COMPATIBILITY parameter to 9.0.1. I don't think I'm using any
> obsolete
> > > parameters in the init.ora.
> > >
> > > I deleted the 8i Service and created a 9i service. I can get the
> database
> > > to the mount stage, but when I attempt to open it, BOOM:
> > >
> > > ORA-00600: internal error code, arguments: [qctstc2o1], [3], [1],
[31],
> > [1],
> > > [4000], [0], []
> > >
> > > I don't have a Metalink account (therefore, no patches). Anyone know
> what
> > > this one means? I've eliminated the password files and set
> > > REMOTE_LOGIN_PASSWORD_FILE to NONE and disabled the system triggers,
so
> > > that's not it.
> > >
> > > Any ideas???
> > >
> > > Dave
> > >
> > >
> >
> >
>
>
Received on Tue Mar 19 2002 - 13:05:46 CST
