1 2 3 Previous Next 35 Replies Latest reply: Oct 24, 2012 1:25 PM by Wasimul-Oracle RSS

    getting errors while creating asm disk groups

    user13376823
      while creating disk groups on 10gR2 database on linux redhat 5.3

      im getting following errors :

      ERROR at line 1:
      ORA-15018: diskgroup cannot be created
      ORA-15031: disk specification '/dev/raw/raw4' matches no disks
      ORA-15025: could not open disk '/dev/raw/raw4'
      ORA-27041: unable to open file
      Linux Error: 19: No such device
      Additional information: 42
      Additional information: 213402552
      Additional information: -1079643768
      ORA-15031: disk specification '/dev/raw/raw3' matches no disks
      ORA-15025: could not open disk '/dev/raw/raw3'
      ORA-27041: unable to open file
      Linux Error: 19: No such device
      Additional information: 42
      Additional information: 213402552
      Additional information: -1079643768
      ORA-15031: disk specification '/dev/raw/raw2' matches no disks
      ORA-15025: could not open disk '/dev/raw/raw2'
      ORA-27041: unable to open file
      Linux Error: 19: No such device
      Additional information: 42
      Additional information: 213402552
      Additional information: -1079643768
      ORA-15031: disk specification '/dev/raw/raw1' matches no disks
      ORA-15025: could not open disk '/dev/raw/raw1'
      ORA-27041: unable to open file
      Linux Error: 19: No such device
        • 1. Re: getting errors while creating asm disk groups
          Osama_Mustafa
          check
          Disk Is not Discovered in ASM, Diskgroup Creation Fails with Ora-15018 Ora-15031 Ora-15014 [ID 431013.1]
          • 2. Re: getting errors while creating asm disk groups
            user13376823
            i followed article http://www.xeriff.com/wkx/index.php?title=Installing_Oracle_ASM_using_UNIX_files_as_disk_devices and i have created diskgroups.

            but when i query my database it shows me old status :


            select name from v$datafile;

            NAME
            --------------------------------------------------------------------------------
            /opt/oracle/product/10.2.0/oradata/ORCL/system01.dbf
            /opt/oracle/product/10.2.0/oradata/ORCL/undotbs01.dbf
            /opt/oracle/product/10.2.0/oradata/ORCL/sysaux01.dbf
            /opt/oracle/product/10.2.0/oradata/ORCL/users01.dbf
            /opt/oracle/product/10.2.0/oradata/ORCL/example01.dbf
            /opt/oracle/product/10.2.0/oradata/ORCL/rman_01.dbf




            why it is not showing me ASM file system ??
            • 3. Re: getting errors while creating asm disk groups
              Osama_Mustafa
              you could use easiest way by installing asmlib rpm and create what you want /
              • 4. Re: getting errors while creating asm disk groups
                user13376823
                these are contents of my initORCL.ora :

                ORCL.__db_cache_size=251658240
                ORCL.__java_pool_size=4194304
                ORCL.__large_pool_size=4194304
                ORCL.__shared_pool_size=104857600
                ORCL.__streams_pool_size=0
                *.audit_file_dest='/opt/oracle/product/10.2.0/db_1/admin/ORCL/adump'
                *.background_dump_dest='/opt/oracle/product/10.2.0/db_1/admin/ORCL/bdump'
                *.compatible='10.2.0.1.0'
                *.control_files='/opt/oracle/product/10.2.0/oradata/ORCL/control01.ctl','/opt/oracle/product/10.2.0/oradata/ORCL/control02.ctl','/opt/oracle/product/10.2.0/oradata/ORCL/control03.ctl'
                *.core_dump_dest='/opt/oracle/product/10.2.0/db_1/admin/ORCL/cdump'
                *.db_block_size=8192
                *.db_domain=''
                *.db_file_multiblock_read_count=16
                *.db_name='ORCL'
                *.db_recovery_file_dest='/opt/oracle/product/10.2.0/db_1/flash_recovery_area'
                *.db_recovery_file_dest_size=2147483648
                *.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
                *.job_queue_processes=10
                *.local_listener='LISTENER_ORCL'
                *.log_archive_dest='/opt/oracle/product/10.2.0/db_1/flash_recovery_area/ORCL/archives'
                *.log_archive_format='PROD_%t_%s_%r.ARC'
                *.log_archive_start=TRUE
                *.open_cursors=300
                *.pga_aggregate_target=121634816
                *.processes=150
                *.remote_login_passwordfile='EXCLUSIVE'
                *.sga_target=365953024
                *.undo_management='AUTO'
                *.undo_tablespace='UNDOTBS1'
                *.user_dump_dest='/opt/oracle/product/10.2.0/db_1/admin/ORCL/udump'





                these are contents of init+ASM.ora

                ###########################################
                # Automatic Storage Management
                ###########################################
                # asmallow_only_raw_disks=false
                # asm_diskgroups='TESTDB_DATA1'

                # Default asm_diskstring values for supported platforms:
                # Solaris (32/64 bit) /dev/rdsk/*
                # Windows NT/XP \\.\orcldisk*
                # Linux (32/64 bit) /dev/raw/*
                # HPUX /dev/rdsk/*
                # HPUX(Tru 64) /dev/rdisk/*
                # AIX /dev/rhdisk/*
                # asm_diskstring=''

                ###########################################
                # Diagnostics and Statistics
                ###########################################
                background_dump_dest=/opt/oracle/product/10.2.0/db_1/admin/+ASM/bdump
                core_dump_dest=/opt/oracle/product/10.2.0/db_1/admin/+ASM/cdump
                user_dump_dest=/opt/oracle/product/10.2.0/db_1/admin/+ASM/udump

                ###########################################
                # Miscellaneous
                ###########################################
                instance_type=asm
                ##compatible=10.1.0.4.0
                compatible=10.2.0.1.0
                DB_UNIQUE_NAME=+ASM

                ###########################################
                # Pools
                ###########################################
                large_pool_size=12M

                ###########################################
                # Security and Auditing
                ###########################################
                remote_login_passwordfile=exclusive




                disk groups are succcesfully configured but my database is still showing old file system.

                please guide

                Edited by: user13376823 on Oct 22, 2012 10:35 AM
                • 5. Re: getting errors while creating asm disk groups
                  Osama_Mustafa
                  Are you sure while creating database you choose ASM not File system .
                  • 6. Re: getting errors while creating asm disk groups
                    415289
                    why it is not showing me ASM file system ??
                    because during database creation you've selected local file system inplace of ASM.
                    either create new database by dbca and place files at ASM.
                    or migrate these files from local filesystem to ASM by RMAN.

                    http://docs.oracle.com/cd/B19306_01/server.102/b14196/install.htm#CHDCHDDG
                    • 7. Re: getting errors while creating asm disk groups
                      Osama_Mustafa
                      well this exactly what i meant :)
                      • 8. Re: getting errors while creating asm disk groups
                        user13376823
                        hi kuljit pha ji thnaks for your reply

                        database is already installed with non-asm file system


                        do i remove old database and create new one with dbca ?
                        • 9. Re: getting errors while creating asm disk groups
                          Osama_Mustafa
                          if you database dosen't contain any data or information that you need , its an easy to drop the old one and recreate it . if you want data then you should do move from file system to ASM
                          • 10. Re: getting errors while creating asm disk groups
                            user13376823
                            osama thanks for your co-opeartion.

                            i am learning asm and this is a test scenario on my vmware .

                            i want to go through all details and procedures .
                            • 11. Re: getting errors while creating asm disk groups
                              Osama_Mustafa
                              well if you want to learn more and gain experience then i suggest to learn how to move from file system to ASM .
                              Check my blog
                              http://osamamustafa.blogspot.com/2012/06/migrate-database-from-file-system-to.html

                              also you can do versa vice
                              • 12. Re: getting errors while creating asm disk groups
                                user13376823
                                i created asmdisk and diskgroup at /asmdisks.

                                my database is installed at /opt

                                how i can move my diskgroup from /asmdisk to /opt ??
                                • 13. Re: getting errors while creating asm disk groups
                                  Osama_Mustafa
                                  check this
                                  http://osamamustafa.blogspot.com/2012/07/moving-spfile-from-asm-to-file-system.html
                                  • 14. Re: getting errors while creating asm disk groups
                                    user13376823
                                    dear osama ,

                                    i am also reviewing your blog.

                                    before i was following this doccument and i also did work according to this blog :

                                    http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_10.shtml

                                    what is this guy doing in the later part of article ( after creating users2 data file ) ?

                                    why do we need scripts for auto shutdown and startup ?

                                    i am thankful to every one.
                                    1 2 3 Previous Next