RE: Move oracle home

That is why the good lord gave us symbolic links.

-----Original Message-----
From: Joe S. Testa [mailto:jstesta_at_dorseyplus.com] Sent: Tuesday, January 16, 2001 3: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

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).