Q
Problem solve Get help with specific problems with your technologies, process and projects.

Errors trying to migrate from Oracle 7 to 9i

I have got this problem while trying to migrate from Oracle 7 release 7.3.4.5.0 to Oracle 9i release 9.2.0.1.0. While issuing "alter database open resetlogs migrate", the database keeps terminating unexpectedly while the following ORA error has been recorded in the respective alert log file:

ORA-00600: internal error code, arguments: [qctstc2o1], [3], [1], [1], [1], [4000], [0], []

The SQL statement found in the SMON trace file is:

select value$ from props$ where name='DEFAULT_TEMP_TABLESPACE'

Just wondering if there might be any Oracle 9i bug relating to this?


You might try setting o7_dictionary_accessibility=TRUE in your 9i init.ora file and see if that resolves the error. If that doesn't resolve the problem, then you should contact Oracle Support and open a TAR.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close