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

Problems with exp utility after patch installation

After installing Oracle database server version 9.2.0.1, I required it to be updated to 9.2.0.5, which is done by Oracle patch installation. Now I am facing a problem in exporting the data using the exp utility.

After installing Oracle database server version 9.2.0.1, I required it to be updated to 9.2.0.5, which is done by Oracle patch installation. Now I am facing a problem in exporting the data using the exp utility. The exp utility version is also updated. I also restarted the database in migrate mode and executed catpatch.sql and utlrp.sql. Still I have the same problem. Also, why is it required that the database should be restarted in migrate mode?
I'm not entirely sure I understand what the issue is with your upgrade but I will do my best to address your questions. You have upgraded your database from 9.2.0.1 to 9.2.0.5 and noticed that the exp utility has also been upgraded. This is expected behavior for a database upgrade. Depending on the upgrade, certain components may or may not be upgraded. In this case, the export and import utilities do get upgraded from 9.2.0.1 to 9.2.0.5 (according to the 9.2.0.5 readme.txt). So when you export data from this database after the upgrade is completed, it will use the newly upgraded export utility, as it should. Are you receiving an error when you attempt to export data? If so, please submit another question and include specific error messages.

With respect to your second question about 'startup migrate,' this was introduced with Oracle 9.2 and basically starts up the instance in preparation for the upgrade or patch. Several 'alter system' commands are executed automatically upon startup (e.g., sets job_queue_processes to 0, enables restricted session, etc.). This is to prevent expected errors that occur during an upgrade or patch application from being returned to the session or sent to spool files. It is important that you restart your database normally after the upgrade or patch application has completed.

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