Oracle Certification, Database Administration, SQL, Application, Programming Reference Books
Change Oracle Installation Location on Linux

I installed oracle 10g on a linux machine, which has two hard drives, the current installation is at /u01/app/oracle/product/10.1.1/myoraclehome

However, there is not much space left on this drive, how do I move oracle installation to a different location... I guess I have to shutdown oracle, change *.ora and control files, etc.

On LINUX you can use symbolic links to do that.

- find a partition with enough disk space and mount it - let's say /mnt/disk1

- shutdown your Oracle DB and listener

- copy the $ORACLE_BASE to /mnt/disk1 (this will be /u01/app/)

$ cp -R /u01/app/* /mnt/disk1

- drop the /u01/app/oracle directory

$ rm -rf /u01/app/oracle

- create a symbolic link to it

$ ln -s /mnt/disk1/oracle /u01/app/oracle

Now you can startup the DB and listener

Quick Links:
Do you have an Oracle Question?

Best regards,
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of or the content authors.