1 Reply Latest reply: Apr 15, 2013 7:34 AM by Bas de Klerk RSS

    how can i find my asm is enabled or disabled

    947771
      hi,

      i would like to know how can i find my asm is enabled or disabled.

      oracle 11g express
      Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

      yours sincerely
        • 1. Re: how can i find my asm is enabled or disabled
          Bas de Klerk
          Hi,

          asm is not supported in XE,
          http://docs.oracle.com/cd/E17781_01/license.112/e18068/toc.htm#BABBCJEB

          So no need to check this (otherwise you could check the instance parameter DB_CREATE_FILE_DEST to see if this points to an ASM diskgroup, syntax of a diskgroup starts with a + sign, so no normal directory notation)

          regards
          Bas