Monday, March 7, 2016

ACFS: Automatic Cluster FileSystem on RAC 12c

Steps to create ACFS using ASMCA 
Create Diskgroup
Create ASM volume
Create ACFS 

Creating New Diskgroup "DTRAILS" for creating ACFS 
Create New Volume on newly created diskgroup 
After Creating New Volume, Created ACFS as follows

After ---

Created new Directories required and change permissions, where you want to mount ACFS on Nodes of Cluster 
[root@tnc1 ~]# 
[root@tnc1 ~]# mkdir -p /u03/trails
[root@tnc1 ~]# chown -R oracle:oinstall /u03/trails
[root@tnc1 ~]# 

Fill details as required and click ok to create ACFS. At the end it will ask you to run .sh script, which mounts the ACFS on both file system 

[root@tnc1 ~]# /u01/app/oracle/cfgtoollogs/asmca/scripts/acfs_script.sh
ACFS file system /u03/trails is mounted on nodes tnc1,tnc2

[root@tnc2 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       26G   20G  4.2G  83% /
/dev/sda1              99M   23M   72M  24% /boot
tmpfs                  12G  169M   12G   2% /dev/shm
none                  1.1G  104K  1.1G   1% /var/lib/xenstored
/dev/asm/sharkoki-6   3.0G  1.1G  2.0G  35% /u02/goldengate
/dev/asm/strail-174   1.9G   81M  1.8G   5% /u03/trails

---Nikhil Tatineni---

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...