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
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.