Create an Oracle10gASM Database

Welcome to the Oracle community forum and interact with 2 million technical staff. Overview: In a real massive database environment, DBA may spend a lot of time on disk management, for example, if a tablespace occupies the entire disk, DBA needs to add another disk to the operating system, and then create a new data file on the new disk.

Welcome to the Oracle community forum and interact with 2 million technical staff> go to overview. In The Real massive database environment, DBA may spend a lot of time on disk management, for example, if a tablespace occupies the entire disk, DBA needs to add another disk to the operating system, and then create a new data file on the new disk.

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

Overview

In a real massive database environment,DBAIt may take a lot of time for disk management. For example, a tablespace will occupy the entire disk,DBAYou need to add another disk to the operating system, and then create a new data file on the new disk. If it is a single disk, this is not very cumbersome, the problem is that if we usedRAIDOr yes.LVMA large amount of data is still distributed on the previous disks. If we want to make the data evenly distributed on the previous disks and new disks, it may take us a day or even a few days to export and import the original data. If there is a way to add a disk to the system and then tellOracleWe will use this disk, and the rest of the work will beOracleTo complete, what a good thing! Fortunately,Oracle 10g This function has been provided, which isASM(Automatic Storage Management). We call it"Automatic Storage Management".Oracle 10g OfASMNot only helpDBAFree from tedious disk space management, and more noteworthy isASMAt the same time, the strip and image functions are provided, and these functions must be configured separately.RAID.

This article passesVmwareInstallRHEL3 + Oracle 10g To experienceASMWhy is database powerful?Vmware? Because inVmwareYou can add or delete a virtual disk (Virtual Disk) To facilitate testing.ASMDatabase. I don't think anyone can capture five or six hard disks to perform such a test.J

Hardware configuration

IBM R50 5GC

China 1.5 GB , 1G Memory, 40 GB Hard Disk

Software Configuration

Windows XP Pro SP1,VMware GSX Server 2.5.1 ,RHEL3,Oracle 10g For Linux

Install VMware

This step is not mentioned.,What I installed isVMware GSX Server,No testsVMware Workstation,Therefore, the steps in this article cannot be implemented.

In VMware Install RHEL3

1. InstallRHEL3

This process is not much to mention. It should be installed in the actual environment.RHEL3Same. It is worth noting thatVmwareTherefore, it may fail to start properly during installation.Xwindow, You can install it on the Character interface. After installation, restart the system,XwindowIt is automatically started. Remember to install all the Development Kits. This will avoid any problems that may occur in the future.LinkError. In my test environmentRHEL3Total 384 M Memory.

2. Add4Block Virtual Disk

Follow the steps below to add hardware in the properties of the virtual machine, and then addVirtual Disk

Next, because the virtual disk we created is only used to placeOracleAnd we will useASMInFailgroupSo set the maximumSizeYes 1G That's enough.

Next, specify the name and storage location of the virtual disk file, which is stored in the same directory of the Virtual Machine by default. Here we specify the file namePhysical1

ClickAdvancedButton to set the physical mount point of the virtual disk. Generally, we select a different system disk from the existing system disk of the virtual machine.SCSIPort. For example, the system disk of our VM isSCSI0: 0, Set this diskSCSI1: 0. The other three disks to be added areSCSI1: 1,SCSI1: 2AndSCSI1: 3

[1] [2] [3]