Home -> Usenet -> comp.databases.oracle -> Renaming ORACLE_HOME directory. Any problems?

Renaming ORACLE_HOME directory. Any problems?

From: Sridhar Pandari <pandaris_at_jecsun.cb.att.com>
Date: 1996/09/12
Message-ID: <519fkd$hlb_at_newsb.netnews.att.com>#1/1 








I seem to be in one of those unfortunate situations where I have to move the
ORACLE_HOME directory.


I originally installed oracle in /usr/local/apps/oracle which is a seperate
filesystem.  Now due to some field considerations, I will have to move it to
/opt/oracle.  I am planning to just rename the file system.  Does anyone see
any problem, or had any experience in doing that.



After renaming the directory.  I plan to do the following:



    
  
  1.   recreate the two instances of the databases that I have.  (I will do a
   backup before renaming the directory and restore it into the new instance)

  
  2.   change entries in /etc/oratab and /etc/listener.ora files to have the new
   ORACLE_HOME.


  
  3.   If any application doesn't work, probably recompile them (In case they have
   any hard coding pointing to old ORACLE_HOME)






Does anyone has any ideas as to what more I need to do.  I am running
oracle v7.2.3 on HP/UX 10.01.



Sridhar

-- 


                             \\/\\//
                             | O O |


Received on Thu Sep 12 1996 - 00:00:00 CEST












Original text of this message