RE: Move oracle home

I performed strings on a control file and didn't find any reference for the $ORACLE_HOME directory path. For O8.1.6 is $ORACLE_HOME not maintained in the control files?

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Joe S. Testa
Sent: Tuesday, January 16, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Subject: Move oracle home

Use to be the oracle home was stored in either the controlfile or the headers of the datafiles, i cant remember which but if it was the headers of the datafiles, you were screwed.

joe

         "Steve Orr" <sorr_at_arzoo.com> Save Address - Block Sender  To:

         Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Save Address
 Subject:

         Moving Oracle Server Software

software (8.1.6.). Rather than re-install Oracle I'm thinking about just moving everything to a different mount point (another volume). What are the steps?

1. shutdown the database.
2. copy software from oldmount01 to newmount01 as follows:
   $ cd /oldmount01
   $ find . -depth -print | cpio -pdmv /newmount01
   
3. edit init.ora file as necessary
4. edit oratab file as necessary
5. change path and environment variables in .profile of oracle account.
6. edit all supporting shell scripts as necessary
7. edit listener.ora file as necessary (references $ORACLE_HOME)
8. cross fingers and restart the database
9. clean/remove up oldmount01 files

Anything else I need to consider? Recommendations?

TIA!!!
Steve Orr

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe S. Testa
  INET: jstesta_at_dorseyplus.com
also send the HELP command for other information (like subscribing).