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

From:

         "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? Received on Tue Jan 16 2001 - 14:37:48 CST