Forum Stats

  • 3,782,555 Users
  • 2,254,666 Discussions
  • 7,880,122 Comments

Discussions

ASm On windows

452030
452030 Member Posts: 412
edited Apr 20, 2010 11:30AM in General Database Discussions
I want to use regular "Windows disks" for ASM.

I have created unformated logical drives on windows. When i run dbca wizard for asm but when creating disk group i changed the disk discover path using \\.\*: for finding the logical drives i get an error

ora-02097 parameter cannot be modified because specified value is invalid.
ora-15031 disk specification \\.\*: matches no disks
ora-15056 additional error message

any One have any idea whats be the possible cause. If any one configure asm just like i am doing. Please help me. Using oracle 10g rel 2.

Thanks

Comments

  • Madrid
    Madrid Member Posts: 7,573
    Prepare Disks for Database Storage

    You need to configure disk storage for use with Automatic Storage
    Management (ASM). ASM storage consists of one or more disk groups, each
    of which can span multiple disks. To prepare the shared disks that you
    identified you need to create two or more logical drives, each on a different shared disk, for a total of at least 7 GB. To prepare each logical drive, perform these
    steps:

    Navigate to Start > Settings > Control Panel > Administrative Tools >
    Computer Management

    Expand the Storage folder to Disk Management

    Identify a shared disk that contains the required amount of free space
    and right click inside an unused part of an extended partition.

    Choose Create Logical Drive in the option window and a wizard presents
    pages for configuring the logical drive.

    Enter the size that you want for the partition. All of the partitions
    that you create for your ASM disk groups should include as much of the
    free space on the disk as possible. Additionally, however, the
    partitions should all be the same size.

    Choose the option Do not assign a drive letter and then choose the
    option Do not format this partition. Click Finish on the last page of
    the wizard.


    Stamp the Logical Drives for ASM
    To enable disk discovery during the database install, the logical drives
    used to store your database files must be stamped with an ASM header
    using a GUI tool called asmtoolg. All disk names created by the tool
    begin with the prefix ORCLDISK for identification purposes. Complete the
    following procedure to stamp the logical drives that you created.

    To open the tool, double-click CRS home\BIN\asmtoolg where

    Select Add or change label and click Next on the Welcome screen.

    On the Stamp Disks screen, select the disks to stamp and keep the
    default settings for Generate stamps with this prefix, then click Next.

    Click Next on the Stamp disks screen.

    Click Finish to save your work and exit from the tool.


    ~ Madrid
  • Hans Forbrich
    Hans Forbrich Member Posts: 11,543
    edited Jul 24, 2007 4:15PM
    Madrid,

    In Linux, we can create loopback devices that will simulate the raw devices we need to ASM disks. Are you aware of a similar technique for Windows?


    Or is the above 'the technique'? (Can't test - no WIndows machine available right now.)

    /Hans
  • 530453
    530453 Member Posts: 718
    Use asmtool for this on Windows...

    Refer to: (for more details)

    http://www.dizwell.com/prod/node/33
  • Hans Forbrich
    Hans Forbrich Member Posts: 11,543
    I should have known Howard would have worked a solution already. <g>
  • Madrid
    Madrid Member Posts: 7,573
    edited Jul 24, 2007 5:47PM
    I have tried to find loopback like commands for windows, but so far I have not been successful in emulating raw devices this way. The only way I have found is by using an extended partition without format. So it means you should have another disk where partitions can be created.

    I will try the solution provided on the previous posting, I think something interesting will come out from this.



    ~ Madrid.
  • 530453
    530453 Member Posts: 718
    http://www.dizwell.com/prod/node/33

    This is a really good article to create ASM on laptop by creating Fake Hard Disks. Works very well and is stable for testing purposes.

    Regards
  • 452030
    452030 Member Posts: 412
    Thanks to all for valuable comments.
    With ur's comments i finally be able to configure ASM on windows regular disks.

    Thanks once again. Please tell me one thing what is the best way to move the production database into ASM enviornment. e.g import database or restore from backup. Need comments

    Thanks
  • 488408
    488408 Member Posts: 432
    Hi,

    after createing the ASM instance and diskgroups, the best way is to migrate the database to ASM.

    if you Login to the EM, then GO to the Administrator tab, there is a optional to migrate them


    Senthil Kumar
  • ankurk
    ankurk Member Posts: 97
    >


    http://www.dizwell.com/prod/node/33

    >

    The above link appears to be no longer available. Can anybody paste the contents???
This discussion has been closed.