Re: Anyone seen this 600 Error?

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:02:55 CST