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

Moving database from C: drive to D: drive

I have Oracle 9.0.1 installed on a WIN2K server on the C: drive (ORACLE_HOME) and a database installed on the G: drive. How can I move the ORACLE_HOME from the C: drive to the D: drive and still retain the database?

I have Oracle 9.0.1 installed on a WIN2K server on the C: drive (ORACLE_HOME) and a database installed on the G: drive. How can I move the ORACLE_HOME from the C: drive to the D: drive and still retain the database?
Oracle does not support moving your ORACLE_HOME because the path is hard-coded in a variety of files and is very difficult to manually modify. This will especially cause problems when attempting to apply patches. The safest way to do this is to shut down your Oracle database and reinstall the Oracle software on the D: drive. Remember to copy over database-specific files from the old ORACLE_HOME to the new one, e.g., password files, etc., before starting up the database. Since your database should remain untouched on another partition or drive, as long as it is using the new ORACLE_HOME, it should start up successfully.

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