Gab.Loves.Oracle

Here the draft that I followed in my post: Partition EMC LUNs to allocate more disk space for Oracle 1. Partition the presented disks "EMC was able to create the 3x20Gb storage " Say for example the presented disks are: # fdisk -l /dev/hda /dev/hdb /dev/hdc # fdisk /dev/hda n --new patition p --partition 1 --partition 1 <Enter> +1024M --size of the partition n --new partition p --partition 2 -- partition 2 <Enter> +1024M --size of the partition n --new partition p --partition <Enter> --default 4th partition <Enter> p --print the partitions I made w --write the new partition table and save --see my drawing for the details. 2. Format the partitioned devices # mkfs -t ext3 /dev/hda1 # mkfs -t ext3 /dev/hda2 # mkfs -t ext3 /dev/hda3 3. Create a TEMPORARY mount point for the new devices # mkdir /mnt/bdump # mkdir /mnt/cdump # mkdir /mnt/udump --set necessary permissions to the oracle user ...

Hi, As a Junior DBA, as of the moment, you may find my posts a little easy, but I would like to share these easy things to all newbies to Oracle. I have a recent activity with one of our clients. Here is the scenario and I would like to share it: Problem: Oracle dump files are very important to this client because they are using it for troubleshooting purposes on their RAC environment. Oracle's bdump, cdump and udump grows so fast that they need to change the disk to allocate bigger disk space. These logs make /u01 ,which is the mount for for their ORACLE_HOME, grow big and reaches 99%. Goal: 1. To partition the presented disk done by the storage engineer 2. To allot one disk per node since the disks are visible on the three nodes 3. Move the log files to these new mount points 4. Make sure that these newly partitioned disks are accessible by Oracle. Here's what I did: Findings: -        EMC was able to create three LUNs of 20 GB each. -   ...