What is this Site!!

All about Real time requirements in Orale Stay Tune!!

Monday, October 1, 2007

Oracle loction on linux



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

3 comments:

12345 said...

Good blog thanks for sharing this informative article.
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad

Anonymous said...

Such a nice blog, I really like what you write in this blog, I also have some relevant Information about Best HR Training In Hyderabad | Hr training institute in Hyderabad! if you want more information.
Oracle Fusion HCM Online Training
Oracle Fusion Financials Online Training

Rainbow Training Institute said...

Really very helpful article , Thank you for sharing

Spark and Scala Online Training
Spark Scala Training
Hyderabad