ASm On windows

452030

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

Madrid

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

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

Use asmtool for this on Windows...

Refer to: (for more details)

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

Hans Forbrich

I should have known Howard would have worked a solution already. <g>

Madrid

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

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

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

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

>


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

>

The above link appears to be no longer available. Can anybody paste the contents???