Enable Oracle ASMFD for CTE
To enable Oracle ASMFD:
-
Log in as the root user and stop the Oracle Grid Infrastructure for a standalone server, type:
$GRID_HOME/bin/crsctl stop has
-
Configure Disk Discovery for AFD. Modify the following files by adding the content of
/dev/secvm/dev/sd*
to the OS files in/etc/oracleafd.conf
and/etc/afd.conf
with aft_filtering enabled, type:cat /etc/afd.conf afd_diskstring='/dev/sd*,/dev/secvm/dev/sd*' afd_filtering=enable cat /etc/oracleafd.conf afd_diskstring='/dev/sd*,/dev/secvm/dev/sd*' afd_filtering=enable
- To prevent the file from changing back to
afd_diskstring='/dev/sd*'
make it read only, type:chmod 444 /etc/oracleafd.conf /etc/afd.conf
- To prevent the file from changing back to
-
Restart ACFS before proceeding, type:
acfsload stop acfsload start
-
Restart the Oracle Grid Infrastructure, type:
$GRID_HOME/bin/crsctl start has
-
Verify that
/dev/secvm/dev/sd*
is part of the SQL output and the state is enabled as a grid, type:SELECT SYS_CONTEXT('SYS_ASMFD_PROPERTIES', 'AFD_DISKSTRING') FROM DUAL;
Expected Response
SYS_CONTEXT('SYS_ASMFD_PROPERTIES','AFD_DISKSTRING') -------------------------------------------------------------------------------- /dev/sd*,/dev/secvm/dev/sd*
Note
If using Oracle RAC (Real Application Clusters), repeat the previous steps for all of the nodes in the related RAC cluster.