Linux – Resizing partitions/moving /u01 oracle directory

linuxoracle-11gpartition

I've got a test server recently set up at work which has oracle installed under /u01 – but without realising it, I've set the root partition to be ~50GB, so have filled the partition very quickly once I started loading tablespaces.

The /home partition is ~1.8TB with ~1.4TB free. Basically I'm trying to work out either
1) How to resize the /home and /(root) partitions
2) How to move the /u01 folder to /home/oracle/u01 or similar without Oracle going mental

I can't change the partitions while the server is running, presumably… would my best bet be to use a live CD or something to resize partitions, or is it possible to resize while running? Or alternatively, can I move Oracle's base folder without causing too much trouble

Thanks!

Best Answer

Create a new directory for Oracle in the 1.8TB /home. Then either (a) have your DBA tell Oracle to use that; or (b) shutdown Oracle, move the contents of /u01 to this new directory, remove /u01 and recreate /u01 as a symbolic link to the new directory.

Related Solutions

Lvm – How to resize a regular (non-LVM) partition

In theory, you could reduce the size of sda1, increase the size of the extended partition, shift the contents of the extended partition down, then increase the size of the PV on the extended partition and you'd have the extra room. However, the number of possible things that can go wrong there is just astronomical, so I'd recommend either buying a second hard drive (and possibly transferring everything onto it in a more sensible layout, then repartitioning your current drive better) or just making some bind mounts of various bits and pieces out of /home into / to free up a bit more space.

Resize base XenServer 6.0 partition

An hour of googling was 5 minutes short to find the answer... anyway:

gdisk and sgdisk allow to relocate the second GPT header in "expert mode".

If the basic situation was like this:

# sgdisk -p /dev/sda
Disk /dev/sda: 3902341120 sectors, 1.8 TiB
Logical sector size: 512 bytes
Disk identifier (GUID): 01BFC515-C093-495B-A33F-CA925FB74357
Partition table holds up to 128 entries
First usable sector is 34, last usable sector is 1951170526
Partitions will be aligned on 2048-sector boundaries
Total free space is 6042 sectors (3.0 MiB)

Number  Start (sector)    End (sector)  Size       Code  Name
   1            2048         8388641   4.0 GiB     0700  
   2         8390656        16777249   4.0 GiB     0700  
   3        16779264      1951170526   922.4 GiB   8E00

(note the last usable sector is 1951170526)

By using the x command in gdisk and then e command, the partition table looks like this:

Expert command (? for help): p
Disk /dev/sda: 3902341120 sectors, 1.8 TiB
 Logical sector size: 512 bytes
Disk identifier (GUID): 01BFC515-C093-495B-A33F-CA925FB74357
Partition table holds up to 128 entries
First usable sector is 34, last usable sector is 3902341086
Partitions will be aligned on 2048-sector boundaries
Total free space is 1951176602 sectors (930.4 GiB)

Number  Start (sector)    End (sector)  Size       Code  Name
   1            2048         8388641   4.0 GiB     0700  
   2         8390656        16777249   4.0 GiB     0700  
   3        16779264      1951170526   922.4 GiB   8E00

(note the last usable sector is 3902341086)

After that, removing and re-creating a larger partition works without a problem.

Best Answer

Related Solutions

Lvm – How to resize a regular (non-LVM) partition

Resize base XenServer 6.0 partition

Related Topic