Re: How to rename oracle home

Murthy Yedanapudi wrote:
>
> HI
> After copying all the necessary files ( datafiles, control
> and log files) is it possible to change ORACLE_HOME for the copy and
> run the database? If so can anyone give an idea?
>
> Thanks in advance
> Murthy

No. You can't just copy control files and data files to a new location and hope that a change in ORACLE_HOME will suffice. The ORACLE_HOME location is usually stored in an environment variable, which is expanded to it's current value before being stored in the database control files (if you reference it in a data file creation and the expansion works, which sometimes it does not).

You will need to adjust the control files by using ALTER DATABASE RENAME FILE to make your moved database work with the files in their new locations. ORACLE_HOME is just to tell the system where the Oracle executables and additional programs are stored, not the location of an actual databases data files. You will also have to adjust the entries in your init.ora and config.ora files to point to the new locations of any referenced files which have been moved.

Steve Phelan. Received on Tue Mar 11 1997 - 00:00:00 CST