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
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
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
How many database instances can be created on an Oracle server with an installation drive containing 15 GB free space? Continue Reading