Exadata-Create DBFS Mount Point
Exadata DMA somtime come accross a situtation where a shared mount point needed to be created. To solve this problem oracle have come up with DBFS mount point concept. In this blog we will show how to create DBFS mount point.
1) In the procedures listed in this note, both Solaris and Linux database servers are assumed to have user equivalence for root and the DBFS respository database (typically "oracle") users. Each of those users is assumed to have a dbs_group file in their $HOME directory that contains a list of cluster hostnames. The dcli utility is assumed to be available on both Solaris and Linux database nodes.
2) For Linux database servers, there are several steps to
perform as root. Solaris database servers do not require this step and can skip
it. First, add the oracle user to the fuse group on
Linux. Run these commands as the root user.
(root)# dcli -g ~/dbs_group -l root usermod -a
-G fuse oracle
If you get below error after running above
command
|
[root@exad01dbadm01 ~]# dcli -g ~/dbs_group -l root
usermod -a -G fuse oracle |
Take the remedial action as below:-
[root@exad01dbadm01 ~]# find / -name dbs_group
-print
/home/oracle/dbs_group
/opt/oracle.SupportTools/onecommand/dbs_group
[root@exad01dbadm01 ~]#
Cp
/opt/oracle.SupportTools/onecommand/dbs_group /root
After that run the command:-
[root@exad01dbadm01 ~]# dcli -g ~/dbs_group -l root usermod -a -G fuse oracle
3)Create the /etc/fuse.conf file with the user_allow_other option. Ensure proper privileges are applied to this file.
(root)# dcli -g ~/dbs_group -l root "echo
user_allow_other > /etc/fuse.conf"
(root)# dcli -g ~/dbs_group -l root chmod 644
/etc/fuse.conf
4) For all database servers, create an empty directory that
will be used as the mount point for the DBFS filesystem.
(root)# dcli -g ~/dbs_group -l root mkdir /dbfs_direct
Change ownership on the mount point directory so oracle can access it.
(root)# dcli -g ~/dbs_group -l root chown oracle:dba /dbfs_direct
5) To pick up the additional group (fuse) membership for
the oracle user on Linux or the workaround above on Solaris, Clusterware must
be restarted. For example, to restart
Clusterware on all nodes at the same time (non-rolling),
you can use the following commands as root:
(root)# dcli -g ~/dbs_group -l root
/u01/app/11.2.0/grid/bin/crsctl stop crs
[root@exad01dbadm01 ~]#
dcli -g ~/dbs_group -l root /u01/app/11.2.0.4/grid/bin/crsctl stop crs
exad01dbadm01:
CRS-2791: Starting shutdown of Oracle High Availability Services-managed
resources on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.crsd' on 'exad01dbadm01'
exad01dbadm01:
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.cvu' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.DBFS_DG.dg' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.labdbm01.db' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.oc4j' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.cvu' on 'exad01dbadm01' succeeded
exad01dbadm01: CRS-2677:
Stop of 'ora.LISTENER_SCAN3.lsnr' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.exad01dbadm01.vip' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.DBFS_DG.dg' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2677: Stop of 'ora.registry.acfs' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2677: Stop of 'ora.labdbm01.db' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.DATA_01.dg' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.RECO_01.dg' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.RECO_01.dg' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2677: Stop of 'ora.scan3.vip' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2677: Stop of 'ora.exad01dbadm01.vip' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2677: Stop of 'ora.oc4j' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2677: Stop of 'ora.DATA_01.dg' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.asm' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.asm' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.ons' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.ons' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.net1.network' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.net1.network' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'exad01dbadm01'
has completed
exad01dbadm01:
CRS-2677: Stop of 'ora.crsd' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.ctssd' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.evmd' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.asm' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.mdnsd' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.evmd' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2677: Stop of 'ora.ctssd' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2677: Stop of 'ora.mdnsd' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2677: Stop of 'ora.asm' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.drivers.acfs' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.cssd' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.cssd' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.diskmon' on 'exad01dbadm01'
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.crf' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.crf' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.gipcd' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.diskmon' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2677: Stop of 'ora.gipcd' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2673: Attempting to stop 'ora.gpnpd' on 'exad01dbadm01'
exad01dbadm01:
CRS-2677: Stop of 'ora.gpnpd' on 'exad01dbadm01' succeeded
exad01dbadm01:
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'exad01dbadm01'
has completed
exad01dbadm01:
CRS-4133: Oracle High Availability Services has been stopped.
exad01dbadm02:
CRS-2791: Starting shutdown of Oracle High Availability Services-managed
resources on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.crsd' on 'exad01dbadm02'
exad01dbadm02:
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.DBFS_DG.dg' on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.labdbm01.db' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.exad01dbadm02.vip' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.DBFS_DG.dg' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2677: Stop of 'ora.registry.acfs' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2677: Stop of 'ora.labdbm01.db' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.DATA_01.dg' on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.RECO_01.dg' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.RECO_01.dg' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2677: Stop of 'ora.exad01dbadm02.vip' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2677: Stop of 'ora.scan1.vip' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2677: Stop of 'ora.DATA_01.dg' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.asm' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.asm' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.ons' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.ons' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.net1.network' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.net1.network' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'exad01dbadm02'
has completed
exad01dbadm02:
CRS-2677: Stop of 'ora.crsd' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.mdnsd' on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.crf' on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.ctssd' on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.evmd' on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.asm' on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.mdnsd' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2677: Stop of 'ora.crf' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2677: Stop of 'ora.ctssd' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2677: Stop of 'ora.evmd' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2677: Stop of 'ora.asm' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.drivers.acfs' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.cssd' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.cssd' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.gipcd' on 'exad01dbadm02'
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.diskmon' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.gipcd' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2673: Attempting to stop 'ora.gpnpd' on 'exad01dbadm02'
exad01dbadm02:
CRS-2677: Stop of 'ora.diskmon' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2677: Stop of 'ora.gpnpd' on 'exad01dbadm02' succeeded
exad01dbadm02:
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'exad01dbadm02'
has completed
exad01dbadm02:
CRS-4133: Oracle High Availability Services has been stopped.
exad01dbadm03:
CRS-2791: Starting shutdown of Oracle High Availability Services-managed
resources on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.crsd' on 'exad01dbadm03'
exad01dbadm03:
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.DBFS_DG.dg' on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.labdbm01.db' on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.exad01dbadm03.vip' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.DBFS_DG.dg' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2677: Stop of 'ora.registry.acfs' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2677: Stop of 'ora.labdbm01.db' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.DATA_01.dg' on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.RECO_01.dg' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.RECO_01.dg' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2677: Stop of 'ora.exad01dbadm03.vip' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2677: Stop of 'ora.scan2.vip' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2677: Stop of 'ora.DATA_01.dg' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.asm' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.asm' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.ons' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.ons' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.net1.network' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.net1.network' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'exad01dbadm03'
has completed
exad01dbadm03:
CRS-2677: Stop of 'ora.crsd' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.ctssd' on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.evmd' on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.asm' on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.mdnsd' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.evmd' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2677: Stop of 'ora.ctssd' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2677: Stop of 'ora.mdnsd' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2677: Stop of 'ora.asm' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.cssd' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.drivers.acfs' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2677: Stop of 'ora.cssd' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.diskmon' on 'exad01dbadm03'
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.crf' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.crf' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.gipcd' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.diskmon' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2677: Stop of 'ora.gipcd' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2673: Attempting to stop 'ora.gpnpd' on 'exad01dbadm03'
exad01dbadm03:
CRS-2677: Stop of 'ora.gpnpd' on 'exad01dbadm03' succeeded
exad01dbadm03:
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'exad01dbadm03'
has completed
exad01dbadm03:
CRS-4133: Oracle High Availability Services has been stopped.
exad01dbadm04:
CRS-2791: Starting shutdown of Oracle High Availability Services-managed
resources on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.crsd' on 'exad01dbadm04'
exad01dbadm04:
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.DBFS_DG.dg' on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.labdbm01.db' on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'exad01dbadm04'
exad01dbadm04:
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.exad01dbadm04.vip' on 'exad01dbadm04'
exad01dbadm04:
CRS-2677: Stop of 'ora.DBFS_DG.dg' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2677: Stop of 'ora.registry.acfs' on 'exad01dbadm04' succeeded
exad01dbadm04: CRS-2677:
Stop of 'ora.labdbm01.db' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.DATA_01.dg' on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.RECO_01.dg' on 'exad01dbadm04'
exad01dbadm04: CRS-2677:
Stop of 'ora.exad01dbadm04.vip' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2677: Stop of 'ora.RECO_01.dg' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2677: Stop of 'ora.DATA_01.dg' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.asm' on 'exad01dbadm04'
exad01dbadm04:
CRS-2677: Stop of 'ora.asm' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.ons' on 'exad01dbadm04'
exad01dbadm04:
CRS-2677: Stop of 'ora.ons' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.net1.network' on 'exad01dbadm04'
exad01dbadm04:
CRS-2677: Stop of 'ora.net1.network' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'exad01dbadm04'
has completed
exad01dbadm04:
CRS-2677: Stop of 'ora.crsd' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.mdnsd' on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.crf' on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.ctssd' on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.evmd' on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.asm' on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'exad01dbadm04'
exad01dbadm04:
CRS-2677: Stop of 'ora.crf' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2677: Stop of 'ora.mdnsd' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2677: Stop of 'ora.ctssd' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2677: Stop of 'ora.evmd' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2677: Stop of 'ora.asm' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'exad01dbadm04'
exad01dbadm04:
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.cssd' on 'exad01dbadm04'
exad01dbadm04:
CRS-2677: Stop of 'ora.drivers.acfs' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2677: Stop of 'ora.cssd' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.gipcd' on 'exad01dbadm04'
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.diskmon' on 'exad01dbadm04'
exad01dbadm04:
CRS-2677: Stop of 'ora.gipcd' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2673: Attempting to stop 'ora.gpnpd' on 'exad01dbadm04'
exad01dbadm04:
CRS-2677: Stop of 'ora.diskmon' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2677: Stop of 'ora.gpnpd' on 'exad01dbadm04' succeeded
exad01dbadm04:
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'exad01dbadm04'
has completed
exad01dbadm04:
CRS-4133: Oracle High Availability Services has been stopped.
(root)# dcli -g ~/dbs_group -l root
/u01/app/11.2.0/grid/bin/crsctl start crs
[root@exad01dbadm01 ~]#
dcli -g ~/dbs_group -l root /u01/app/11.2.0.4/grid/bin/crsctl start crs
exad01dbadm01:
CRS-4123: Oracle High Availability Services has been started.
exad01dbadm02:
CRS-4123: Oracle High Availability Services has been started.
exad01dbadm03:
CRS-4123: Oracle High Availability Services has been started.
exad01dbadm04:
CRS-4123: Oracle High Availability Services has been started.
6) As the RDBMS software owner, create the DBFS repository
inside the repository database. To create the repository, create a new
tablespace to hold the DBFS objects and a database user that will own the
objects.
create user dbfs_user identified by ******** default tablespace dbfsts quota unlimited on dbfsts;
grant create session, create table, create view, create
procedure, dbfs_role to dbfs_user;
grant create session, create table, create view, create
procedure, dbfs_role to dbfs_user;
7) With the user created and privileges granted, create the
database objects that will hold DBFS.(As RDBMS Binary Owner)
cd $ORACLE_HOME/rdbms/admin
sqlplus dbfs_user/********
SQL> start dbfs_create_filesystem dbfsts ogg
This script takes two arguments:
dbfsts: tablespace for the DBFS database objects
ogg: filesystem name, this can be any string and will
appear as a directory under the mount point
Output of the above commands:-
[oracle@exad01dbadm01
~]$ cd $ORACLE_HOME/rdbms/admin
[oracle@exad01dbadm01
admin]$ pwd
/u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/admin
[oracle@exad01dbadm01 admin]$ sqlplus dbfs_user/dbf$_exa
SQL*Plus: Release 11.2.0.4.0 Production on Wed May 7 10:12:13 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
dbfs_user/*********
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning,
Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real
Application Testing options
SQL> start
dbfs_create_filesystem dbfsts ogg
No errors.
--------
CREATE STORE:
begin
dbms_dbfs_sfs.createFilesystem(store_name => 'FS_OGG', tbl_name =>
'T_OGG', tbl_tbs =>
'dbfsts', lob_tbs => 'dbfsts', do_partition => false,
partition_key => 1,
do_compress => false, compression => '', do_dedup => false,
do_encrypt =>
false); end;
--------
REGISTER STORE:
begin
dbms_dbfs_content.registerStore(store_name=> 'FS_OGG', provider_name =>
'sample1',
provider_package => 'dbms_dbfs_sfs'); end;
--------
MOUNT STORE:
begin
dbms_dbfs_content.mountStore(store_name=>'FS_OGG', store_mount=>'ogg');
end;
--------
CHMOD STORE:
declare m integer;
begin m := dbms_fuse.fs_chmod('/ogg', 16895); end;
No errors.
8)Use the file mount-dbfs.sh for mounting the DBFS mount
point. To ensure that the file transfer didn't modify the script contents, run
dos2unix against it on the database server:
(root)# dos2unix /tmp/mount-dbfs.sh
9) Edit the variable settings in the top of the script for
your environment. Edit or confirm the settings for the following variables in
the script. Comments in the script will help you to confirm the values for
these variables.
DBNAME
MOUNT_POINT
DBFS_USER
ORACLE_HOME (should be the RDBMS ORACLE_HOME directory)
LOGGER_FACILITY (used by syslog to log the messages/output
from this script)
MOUNT_OPTIONS
DBFS_PASSWD (used only if WALLET=false)
DBFS_PWDFILE_BASE (used only if WALET=false)
WALLET (must be true or false)
TNS_ADMIN (used only if WALLET=true)
DBFS_LOCAL_TNSALIAS
10) After editing, copy the script (rename it if desired or
needed) to the proper directory (GI_HOME/crs/script) on database nodes and set
proper permissions on it, as the root user:
dcli -g ~/dbs_group -l root -d
/u01/app/11.2.0.4/grid/crs/script -f /tmp/mount-dbfs.sh
dcli -g ~/dbs_group -l root chown oracle:dba
/u01/app/11.2.0.4/grid/crs/script/mount-dbfs.sh
dcli -g ~/dbs_group -l root chmod 750
/u01/app/11.2.0.4/grid/crs/script/mount-dbfs.sh
11)After that Create a script to add DBFS as a cluster
resource like given below:-
##### start script add-dbfs-resource.sh
#!/bin/bash
ACTION_SCRIPT=/u01/app/11.2.0.4/grid/crs/script/mount-dbfs.sh
RESNAME=dbfs_mount
DBNAME=labdbm01
DBNAMEL=`echo $DBNAME | tr A-Z a-z`
ORACLE_HOME=/u01/app/11.2.0.4/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
Then run it as RDBMS OWNER:-
sh ./add-dbfs-resource.sh
9) Give permission to GI owner on the resource :-
|
crsctl setperm resource dbfs_mount
-u user:oragrid:r-x |
Please check our other blogs for Exadata.
Comments
Post a Comment
Please do not enter any spam link in comment Section suggestions are Always Appreciated. Thanks.. !