Oracle Flex ASM is managed by ASMCA, CRSCTL, SQL*Plus, and SRVCTL. The
INSTANCE_TYPE initialization parameter specifies the type of instance.
INSTANCE_TYPE initialization parameter has an additional value
ASMPROXY, in addition to
RDBMS, to identify Oracle ASM proxy instances. An Oracle ASM proxy instance has its parameter set to
You can use the ASMCMD
showclustermode command to determine whether Oracle Flex ASM is enabled. For example:
$ asmcmd showclustermode ASM cluster : Flex mode enabled
SRVCTL is extended to enable an administrator to create or change attributes of Oracle Clusterware resources. You can use SRVCTL to determine the status of the instances in an Oracle Flex ASM configuration. For example:
$ srvctl status asm -detail ASM is running on mynoden02,mynoden01 ASM is enabled.
You can also use SRVCTL to determine whether Oracle Flex ASM is enabled. If enabled, then
asm displays the number of Oracle ASM instances that has been specified for use with the Oracle Flex ASM configuration. For example:
$ srvctl config asm ASM instance count: 3
You can modify the Oracle ASM instance count, or cardinality, with the SRVCTL
asm command. For example:
$ srvctl modify asm -count 4 $ srvctl modify asm -count ALL
You can view Oracle Flex ASM connections with SQL*Plus and ASMCMD commands. Fore example:
SQL> SELECT instance_name, db_name, status FROM V$ASM_CLIENT; INSTANCE_NAME DB_NAME STATUS --------------- -------- ------------ +ASM1 +ASM CONNECTED orcl1 orcl CONNECTED orcl2 orcl CONNECTED $ asmcmd lsct data DB_Name Status Software_Version Compatible_version Instance_Name Disk_Group +ASM CONNECTED 22.214.171.124.2 126.96.36.199.2 +ASM DATA orcl CONNECTED 188.8.131.52.2 184.108.40.206.0 orcl1 DATA orcl CONNECTED 220.127.116.11.2 18.104.22.168.0 orcl2 DATA
SQL> ALTER SYSTEM RELOCATE CLIENT 'client-id';
In the previous SQL statement,
client-id is of the form
DB_NAME columns are contained in the
V$ASM_CLIENT view. You must connect as
SYSASM to the Oracle ASM instance to run the SQL statement. When you issue this statement, the connection to the client is terminated and the client fails over to the least loaded instance. If the client is currently connected to the least loaded instance, then the connection to the client is terminated and the client fails over to that same instance.
Every database user must have a wallet with credentials to connect to Oracle ASM. CRSCTL commands can be used by the database user to manage this wallet. All Oracle ASM user names and passwords are system generated.
There are no new initialization parameters specifically for instances in an Oracle Flex ASM configuration; however, the settings of existing parameters should be reviewed and possibly adjusted for the Oracle Flex ASM environment. Refer to "Recommended Settings for Oracle ASM Initialization Parameters".
Oracle Database Reference for more information about the
INSTANCE_TYPE initialization parameter
Oracle Database SQL Language Reference for information about the
Oracle Clusterware Administration and Deployment Guide for information about CRSCTL commands
Oracle Real Application Clusters Administration and Deployment Guide for information about SRVCTL commands
Oracle Grid Infrastructure Installation Guide for information about installing Oracle Clusterware