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/)

$ cd $ORACLE_BASE
$ 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

No comments:

topics