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

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips