Re: Renaming ORACLE_HOME directory. Any problems?

I suggest you to follow the Oracle recommendations about how to distribute the oracle files.

If you have database datafiles inside the ORACLE_HOME directory tree to chage the location will be a little more challenge because you have to rename the datafiles with the ALTER DATABASE command. To do so start the instance BUT NOT open the database. The manual explains how to do that but if you have any doubt do not hesitate to contact me (ldiego_at_anaya.es).

After this renaming you can shutdown the instance and change any other files such as /etc/oratab to the new ORACLE_HOME. Do not forget to change the environment variables for any user that may access oracle databases if you do not use the 'oraenv' or 'coraenv' scripts.

Compile any application as Jim said.

I hope not to forget anything important. The main task is to tell the database where there are the database datafiles. The same happens with the init<sid>.ora path definitions and the location of the control files and dump directories.

Take on account to update the locations of the redolog files. Use the V$LOGFILE to know where they where and use the ALTER DATABASE to change them. Manuals should explain this procedure.

Luis de Diego
DBA - GRUPO ANAYA - Received on Thu Sep 19 1996 - 00:00:00 CEST