ASM instance wont mount
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ASM instance wont mount

  1. #1
    Join Date
    Mar 2007
    Posts
    2

    ASM instance wont mount

    HI, I have 10g release 2 installed on CENTOS 4.4, I use ASM striping with with 4 raw disks.

    I had a system crash due to a power failure and now the the ASM wont mount the diskgroup.

    export $ORACLE_HOME=+ASM
    ...
    SQL> startup mount;
    ASM instance started

    Total System Global Area 130023424 bytes
    Fixed Size 2071000 bytes
    Variable Size 102786600 bytes
    ASM Cache 25165824 bytes
    ORA-15110: no diskgroups mounted


    SQL> alter diskgroup RESEARCH1 mount;
    alter diskgroup RESEARCH1 mount
    *
    ERROR at line 1:
    ORA-15032: not all alterations performed
    ORA-15063: ASM discovered an insufficient number of disks for diskgroup
    "RESEARCH1"


    now when I use /etc/init.d/oracleasm listdisks I can see all my disks:
    DISK1
    DISK2
    DISK3
    DISK4

    then i tried to change asm_diskstring to point the mounting point, here is my ora file:

    *.asm_diskgroups='RESEARCH1'
    +ASM.asm_diskgroups='RESEARCH1' #Manual Dismount
    *.asm_diskstring='/dev/oracleasm/disks'
    *.background_dump_dest='/home/oracle/product/10.2.0/db_1/admin/+ASM/bdump'
    *.core_dump_dest='/home/oracle/product/10.2.0/db_1/admin/+ASM/cdump'
    *.instance_type='asm'
    *.large_pool_size=12M
    *.remote_login_passwordfile='EXCLUSIVE'
    *.user_dump_dest='/home/oracle/product/10.2.0/db_1/admin/+ASM/udump'

    any ideas?
    Thanks
    Assaf

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Check the disks status in v$asm_disk. All the disks should be ONLINE.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width