4 Replies Latest reply: Dec 21, 2012 6:43 AM by Robin RSS

    ASM and database doubt

    Robin
      Hi,

      I've some doubt in ASM and database. We usually can identify the database whether it is in ASM or not in the datafile or control file location. Is there any other way to identify whether db is running in ASM?

      Your help is much appreciated.

      Thanks,
      Robin
        • 1. Re: ASM and database doubt
          EBSDBA
          Hi,

          Look in the parameter file...

          Thanks
          • 2. Re: ASM and database doubt
            Fran
            check any of asm views like:
            V$ASM_ALIAS
            V$ASM_CLIENT
            V$ASM_DISK     
            V$ASM_DISKGROUP     
            V$ASM_FILE


            if you haven't data, No ASM .
            • 3. Re: ASM and database doubt
              CKPT
              Robin wrote:
              Hi,

              I've some doubt in ASM and database. We usually can identify the database whether it is in ASM or not in the datafile or control file location. Is there any other way to identify whether db is running in ASM?

              Your help is much appreciated.

              Thanks,
              Robin
              You can see view SQL> select name,state from v$asm_diskgroup; from RDBMS instance
              If you can able to see the disk groups from the RDBMS instance, If the state is CONNECTED for the disk groups then the RDBMS instance is using ASM if not the status can be "MOUNT" or BROKEN, OR DISMOUNTED or UKNNOWN.

              >
              Robin      
                   Newbie
                   
              Handle:      Robin
              Status Level:      Newbie (5)
              Registered:      Oct 30, 2007
              Total Posts:      196
              Total Questions:      91 (73 unresolved)
              >

              Please try to close your old threads and also if any further are answered for any question close it or else other users will again review whole thread. Instead of that they can spend time in other threads. Hope you understood.

              Edited by: CKPT on Dec 21, 2012 5:48 PM
              • 4. Re: ASM and database doubt
                Robin
                Thanks a lot everyone. CKPT answer was very useful. I am closing the thread now as answered.