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