Article Content
Article Number | 000028212 |
Applies To | Affected Versions: All Versions |
Resolution | If you are in a situation where you need to add more disk space for the database, the best approach is to add additional disks to Oracle ASM disk group. Aveksa uses Oracle ASM to provide a large virtual disk for the database. We use one disk group named DG01. Normally, there is only one disk VOL1, but additional disks can be added. The disks should be configured as standard Linux partitions. In this example, the two partitions that we want to add are:
Note: this assumes that the disk partitions have already been created via pvcreate / fdisk.
Note that the environment commands and the sqlplus user are different depending on if Oracle 10g or 11g is being used. The actual alter command is the same regardless of version.
For Oracle 10g:
$ export ORACLE_SID=+ASM
For Oracle 11g:
$ export ORACLE_HOME=$ORACLE_GRID_HOME $ export PATH=$ORACLE_GRID_HOME/bin:$PATH
$ export ORACLE_SID=+ASM $ export ORACLE_HOME=$ORACLE_GRID_HOME $ export PATH=$ORACLE_GRID_HOME/.bin:$PATH
To add the new disk devices to the existing ASM diskgroup:
|