• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to Convert STANDARD ASM to FLEX ASM in 12C

by admin

You can convert an Oracle ASM configuration to an Oracle Flex ASM using ASMCA. This functionality is only available in an Oracle Grid Infrastructure 12c configuration. Before you convert an Oracle ASM configuration to an Oracle Flex ASM, you must ensure the following:

  1. Oracle Cluster Registry (OCR) is stored in a disk group.
  2. The server parameter file (SPFILE) is stored in a disk group.
  3. The password file (ORAPWD file) is stored in a disk group.
  4. The disk group where the OCR, SPFILE, and ORAPWD files are stored has Oracle ASM compatibility (COMPATIBLE.ASM) set to 12.1 or higher.

ASMCA also informs you if any requirement, such as storing an ORAPWD file in a disk group, has not been met before starting the conversion.

Step 1 – Configure ASM

ASM Instances page that enables you to perform operations on selected Oracle ASM instances.

standard asm to flex asm in grid 12c

Steps 2 – Specify listener port and network interface

The next page shows the Convert to Oracle Flex ASM dialog box that enables you to specify the listener port and network interface for the conversion to Oracle Flex ASM.

specify listener port and interface for conversion to oracle flex in ASM 12c

Step 3 – Run the scripts

The next page shows the ASM Conversion dialog box with the script that must be run.

run scripts - conversion to oracle flex asm in 12c

To complete the Oracle Flex ASM conversion, ASMCA generates the converttoFlexASM.sh script that must be run as privileged user(root) only on the local node where ASMCA is running.

verify if the Flex ASM has been configured successfully from asmcmd using the command:

asmcmd> show clustermode

Filed Under: ASM, oracle, oracle 12c

Some more articles you might also be interested in …

  1. Script To Find Redolog Switch History And Find Archivelog Size For Each Instances In Oracle RAC
  2. Oracle SQL Script to Report Tablespace Free and Fragmentation
  3. How To Shrink A Temporary Tablespace in Oracle Database
  4. Beginners Guide to Oracle Database 18c Multitenant Architecture
  5. How to Enable or Disable Automated Statistics Collection in Oracle Database
  6. Interview Questions : Oracle Flex ASM 12c
  7. Oracle SQL Script to Detect Tablespace Fragmentation
  8. Using PL/SQL to Manipulate Data using DML Commands
  9. ORA-16713: The Oracle Data Guard broker command timed out When Changing LogXptMode
  10. How to Drop/Truncate Multiple Partitions in Oracle 12C

You May Also Like

Primary Sidebar

Recent Posts

  • ctags: Generates an index (or tag) file of language objects found in source files for many popular programming languages
  • csvtool: Utility to filter and extract data from CSV formatted sources
  • csvstat: Print descriptive statistics for all columns in a CSV file
  • csvsql: Generate SQL statements for a CSV file or execute those statements directly on a database

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright