Re: Anyone seen this 600 Error?

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

>

>