Differences

This shows you the differences between two versions of the page.

--- oracle_dbfs [2020/11/03 15:51] – andonovj
+++ oracle_dbfs [2020/11/03 16:08] (current) – andonovj
@@ Line 172: / Line 172: @@
 =====Management=====
-Finally we can start it as follows:
+The management of DBFS, includes, stop/start and registartion in the Grid Infra:
+====Start/Stop====
 <Code:bash|Start DBFS>
 --Mount
@@ Line 211: / Line 212: @@
 install               402G  190G  212G  48% /media/sf_install
 [oracle@ol6-121-rac1 admin]$
+</Code>
+====Register DBFS into Grid Infra====
+We can register the DBFS into Grid infra and though allow failover if the instance crashes:
+<Code:bash|Register DBFS into Grid Infra>
+[OS prompt]$ cp /media/sf_install/add-dbfs-resource.sh ~
+[OS prompt]$ cd ~
+[OS prompt]$ chmod +x add-dbfs-resource.sh
+[OS prompt]$ cat add-dbfs-resource.sh
+[oracle@ol6-121-rac1 ~]$ ./add-dbfs-resource.sh
+[oracle@ol6-121-rac1 ~]$ grid_env
+[oracle@ol6-121-rac1 ~]$ crsctl stat res dbfs_mount
+NAME=dbfs_mount
+TYPE=local_resource
+TARGET=OFFLINE, OFFLINE
+STATE=OFFLINE, OFFLINE
+[oracle@ol6-121-rac1 ~]$ crsctl start res dbfs_mount
+CRS-2672: Attempting to start 'dbfs_mount' on 'ol6-121-rac1'
+CRS-2672: Attempting to start 'dbfs_mount' on 'ol6-121-rac2'
+CRS-2676: Start of 'dbfs_mount' on 'ol6-121-rac2' succeeded
+CRS-2676: Start of 'dbfs_mount' on 'ol6-121-rac1' succeeded
+[oracle@ol6-121-rac1 ~]$ crsctl stat res dbfs_mount
+NAME=dbfs_mount
+TYPE=local_resource
+TARGET=ONLINE                , ONLINE
+STATE=ONLINE on ol6-121-rac1, ONLINE on ol6-121-rac2
 </Code>
@@ Line 218: / Line 246: @@
 Below you can find the script we have used.
-<Code:bash|Mount dbfs.sh>
+<Code:bash|mount-dbfs.sh>
-[root@ol6-121-rac1 script]# cat /media/sf_install/mount-dbfs.sh
 #!/bin/bash
@@ Line 658: / Line 685: @@
 esac
+</Code>
+<Code:bash|add-dbfs-resource.sh>
+##### start script add-dbfs-resource.sh
+#!/bin/bash
+ACTION_SCRIPT=/u01/app/12.1.0.2/grid/crs/script/mount-dbfs.sh
+RESNAME=dbfs_mount
+DBNAME=OGGRAC
+DBNAMEL=`echo $DBNAME | tr A-Z a-z`
+ORACLE_HOME=/u01/app/12.1.0.2/grid
+PATH=$ORACLE_HOME/bin:$PATH
+export PATH ORACLE_HOME
+crsctl add resource $RESNAME \
+-type local_resource \
+-attr "ACTION_SCRIPT=$ACTION_SCRIPT, \
+CHECK_INTERVAL=30,RESTART_ATTEMPTS=10, \
+START_DEPENDENCIES='hard(ora.$DBNAMEL.db)pullup(ora.$DBNAMEL.db)
+',\
+STOP_DEPENDENCIES='hard(ora.$DBNAMEL.db)',\
+SCRIPT_TIMEOUT=300"
+##### end script add-dbfs-resource.sh
 </Code>