- Posted by Gavin Soorma
- On October 16, 2009
- 4 Comments
The following are some of the new ASM related features introduced in 11g R2:
[oracle@redhat346 stage]$ sqlplus sys/xxx as sysdba SQL*Plus: Release 184.108.40.206.0 Production on Fri Oct 16 09:10:55 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production With the Automatic Storage Management option SQL> shutdown immediate; ORA-01031: insufficient privileges
The example below will show how we can configure and mount a ACFS on Red HatLinux with 11g R2.
Note: ASM operations like creating and adding disk groups etc which were earlier performed via DBCA will now be performed via the GUI ASM Configuration Assistant which needs to be launched via the ‘asmca‘ command from the Grid Infrastructure Home.
We first create a disk group called ASMCFS and then create a volume called ASMCFS_VOL1 of 25 GB using the disk group that we just created.
We will then use a mount point /u03 to mount this file system. A configuration script is created which includes the commands to be run as root to mount this file system. After the script is run we will see the ACFS file system mounted on /u03.
/bin/mount -t acfs /dev/asm/asmcfs_vol1-44 /u03 chown oracle:dba /u03 chmod 775 /u03 [oracle@redhat346 stage]$ df -k Filesystem 1K-blocks Used Available Use% Mounted on ..... ...... /dev/asm/asmcfs_vol1-44 26214400 89112 26125288 1% /u03