Earlier in another blog post, I wrote on the subtle differences in how to start Enterprise Manager Database Control (dbconsole) in Oracle Database 11g Release 2

Let’s login to the EM Database Control. Your URL to login should be something like this:

Scroll to the bottom of the screen to the instances section. You will see the database and ASM instance information as shown here:
Picture 107.png

Click on the +ASM1_[HOSTNAME] instance URL
The Automatic Storage Management Home page now includes sections for ASM Clustered File Systems (ACFS) and Volumes.

Picture 108.png

You will also notice a new tab dedicated to support the new ASM Cluster File System feature. The ASM Cluster File System tab will simplify your ability to create volumes, create cluster file systems and ACFS snapshots. In this blog post, we will only cover creating volumes and ASM cluster file systems.

Oracle ASM Dynamic Volume Manager (Oracle ADVM)

The new Oracle ASM Dynamic Volume Manager (Oracle ADVM) provides volume management services and a standard disk device driver interface. A volume device is constructed from an ASM volume. You can create one or more volumes devices within a disk group. Once you create a volume, you can create a file system using that volume. You can create an ASM cluster file system off of the ASM volume. Likewise, you can create an EXT3 or OCFS2 file system based on the ASM volume. Likewise, as Oracle ports ACFS to other Unix Platforms, you can create the OS native file systems using Oracle ASM disk group volumes. Oracle ACFS is layered on ASM through the ADVM interface.

Creating an OCFS2 file system on top of ASM Disk Group does not make sense, but it is do-able.

Requirements for ADVM
1. COMPATIBLE.ASM and COMPATIBLE.ADVM attributes must be set to 11.2.
2. Volume name can be a maximum of 11 alphanumeric characters (no dashes and first character must be alphabetic)

Let’s click on the new ASM Cluster File System tab and create ourselves an ASM Cluster File System.

You will see the following screen:
Picture 110.png

Notice that we already created the VOL_RPTS volume that is already mounted as /apps/oracle/acfsmounts/data_vol_rpts mount point. Let’s create a new volume and mount another file system. To start this process, click on the Create button on the right corner. You will be directed to the Create ASM Cluster File System screen. Before we can create an ASM Cluster File System, we must first create a volume. Click on the the Create ASM Volume button. From the Create ASM Volume screen,
Picture 111.png
Enter the values for Volume, Data Group, and Size.

Notice the size can be specified in MB, GB and TB.
If you want to see the SQL, click on the Show Command button
Picture 112.png
Click on the Return button to go back to the Create ASM Cluster File System Screen
You will notice that the Volume Device field is populated with the new Volume that you just created
Specify a label (optional) if you want and specify a Mount Point

Picture 113.png
Again, click on the Show Command button

Picture 115.png
Click on the Return button to back to the Create ASM Cluster File System screen
Click on the OK button to create the ACFS file system
You will be requested to enter OS credentials – This operating system user name and password will be used to perform ASM Cluster File System operations on this host.

You will receive a confirmation status on top of the screen indicating that the file system was successfully created:
Picture 116.png

Next, click on the VOL_LOGFILE Volume radio button and click on the Mount button on the top left portion of the screen. You will be routed to the Mount ASM Cluster File System: [VOLUME_NAME] screen.
Picture 117.png

Unfortunately, you will not be able to mount the file system from Enterprise Manager. Only thing you will be able to do is generate the command and ask your system administrator to mount the file system.
Picture 118.png

As the root user, issue the mount command shown from this screen.

[root@jin1 oracle]# /bin/mount -t acfs /dev/asm/vol_logfile-340 /apps/oracle/acfsmounts/data_vol_logfile

Now from the OS, you can see the output from the df -h command to see the new file system mounted:

[root@jin1 oracle]# df -h
Filesystem            Size  Used Avail Use% Mounted on
                      122G   11G  106G   9% /
/dev/sda1              99M   12M   82M  13% /boot
tmpfs                 1.1G  154M  874M  15% /dev/shm
.host:/               163G  141G   23G  87% /mnt/hgfs
                      5.0G   49M  5.0G   1% /apps/oracle/acfsmounts/data_vol_rpts
                      2.0G   41M  2.0G   2% /apps/oracle/acfsmounts/data_vol_logfile

Click on the Return button to go back to the Mount Cluster File System screen. Click the Return button again to back to the ASM Cluster File System main screen.

Posted by Charles Kim, Oracle ACE

Posted in ASM
Share this post, let the world know

Leave a Reply

Your email address will not be published. Required fields are marked *