Re: Moving Oracle RAC VMs from Linux to Windows

From: Anand Rao <panandrao_at_gmail.com>
Date: Tue, 25 Apr 2017 16:21:15 +0530
Message-ID: <CANFhCMdH13GveNu110e2eX-4dxA-sz55xCf0shpN3QyrU-nTNw_at_mail.gmail.com>



Hi,

Managed to find the missing link. We need to rewrite the ASM devices permission rules with the new SCSI IDs.

After attaching the ASM disks in Virtual Media Manager or by manual commands, we need to do the following.

  1. Boot Linux image on Virtual Node 1.
  2. Find the new SCSI ID of the devices using the command (for OLE 6.3),
/sbin/scsi_id -g -u -d /dev/sdb
/sbin/scsi_id -g -u -d /dev/sdc
/sbin/scsi_id -g -u -d /dev/sdd
/sbin/scsi_id -g -u -d /dev/sde

3) Change the entries in /etc/udev/rules.d/99-oracle-asmdevices.rules to match the new SCSI IDs.

4) Run partition probes and reload UDEV rules.

Voila! +ASM1 instance and RAC1 instance boot up perfectly fine.

5) Repeat the same procedure on Virtual Node 2.

Virtual Node 2 has discovered the ASM disks which is great. But OCSSD daemon starts and dies due to some network error as per the log file. But that is another issue. The main problem is solved which was porting from Linux Host to a Windows Host.

Thanks to everyone, especially Tim's wonderfully informative guide(s) on his website.

Regards,
Anand

On 25 April 2017 at 09:18, Anand Rao <panandrao_at_gmail.com> wrote:

> Hi Thomas,
>
> I did not run the command but accomplished the same using the GUI. Please
> see the output of "vboxmanage list hdds".
>
> c:\Program Files\Oracle\VirtualBox>vboxmanage list hdds
> UUID: b00cf591-4eb7-4ad3-a368-df41e76b0691
> Parent UUID: base
> State: created
> Type: normal (base)
> Location: C:\Users\Anand Rao\VirtualBox VMs\OLERAC1\OLERAC1-disk002.
> vmdk
> Storage format: VMDK
> Capacity: 51200 MBytes
> Encryption: disabled
>
> UUID: 7baed035-025e-4028-ae46-d6788cb403c1
> Parent UUID: base
> State: created
> Type: shareable
> Location: C:\Users\Anand Rao\VirtualBox VMs\OLERAC1\asm-disk1.vmdk
> Storage format: VMDK
> Capacity: 5120 MBytes
> Encryption: disabled
>
> UUID: 66e128e1-940a-4c6b-8553-210a90952731
> Parent UUID: base
> State: created
> Type: shareable
> Location: C:\Users\Anand Rao\VirtualBox VMs\OLERAC1\asm-disk2.vmdk
> Storage format: VMDK
> Capacity: 5120 MBytes
> Encryption: disabled
>
> UUID: fa86a944-3225-4fc0-b625-e447ad517d9e
> Parent UUID: base
> State: created
> Type: shareable
> Location: C:\Users\Anand Rao\VirtualBox VMs\OLERAC1\asm-disk3.vmdk
> Storage format: VMDK
> Capacity: 5120 MBytes
> Encryption: disabled
>
> UUID: a54e33c9-4308-4aad-a420-db940f403631
> Parent UUID: base
> State: created
> Type: shareable
> Location: C:\Users\Anand Rao\VirtualBox VMs\OLERAC1\asm-disk4.vmdk
> Storage format: VMDK
> Capacity: 5120 MBytes
> Encryption: disabled
>
> The only difference is that on Linux, the files were asm1.vdi, asm2.vdi,
> etc.
>
> Regards,
> Anand
>
> On 24 April 2017 at 19:00, Thomas Roach <troach_at_gmail.com> wrote:
>
>> Did you try running this command on Windows to attach them?
>>
>> VBoxManage storageattach ol5-112-rac1 --storagectl "SATA" --port 1 --device 0 --type hdd \
>> --medium asm1.vdi --mtype shareable
>>
>>
>> Sent from my iPhone
>>
>> On Apr 24, 2017, at 4:17 AM, Anand Rao <panandrao_at_gmail.com> wrote:
>>
>> Thanks Thomas.
>>
>> Unfortunately, this is for a Linux host. I have gone through this and
>> also the updated article which describes OLE 6.3.
>>
>> My issue is porting the "RAC Virtual Boxes" from Linux to Windows. How do
>> we "re-attach" the existing Linux ASM virtual disks to Windows?
>>
>> Best Wishes,
>> Anand
>>
>> On 24 April 2017 at 13:23, Thomas Roach <troach_at_gmail.com> wrote:
>>
>>> See if these commands will work on Windows. They should?
>>>
>>> https://oracle-base.com/articles/11g/oracle-db-11gr2-rac-ins
>>> tallation-on-oel5-using-virtualbox#create_shared_disks
>>>
>>> Sent from my iPhone
>>>
>>> On Apr 24, 2017, at 3:29 AM, Anand Rao <panandrao_at_gmail.com> wrote:
>>>
>>> Hi,
>>>
>>> I have setup an Oracle 11g R2 RAC on two OLE 6.3 nodes using VirtualBox
>>> 5.1. The host OS is OLE 7.1 and the test setup was just using a single hard
>>> disk.
>>>
>>> Managed to export the VMs from OLE 7.1 and import them to my laptop
>>> which runs Windows 10.
>>>
>>> After some changes to the settings, the OS did boot but CRS failed which
>>> i think is due to the ASM disks. Checked the CRS logs, etc. and it was
>>> indeed the "missing "voting disks.
>>>
>>> On my Linux Host (OLE 7.1), the ASM disks were /dev/asm-disk1 and so on.
>>> On Windows they are named ASM-disk1.vmdk and so on.
>>>
>>> I did try to remove and add shareable storage in VirtualBox on Windows
>>> but i think something is missing here. The shareable storage from Windows
>>> is not being pickup by the OLE 6.3 Virtual Host.
>>>
>>> Does anybody know how to make these "virtual ASM disks" shareable so
>>> that Linux can see it? Is there a guide i can follow to setup a Windows
>>> based VM for Oracle 11g RAC?
>>>
>>> I am just hoping that I can reuse the whole setup as it is.
>>>
>>> Thanks,
>>> Anand
>>>
>>>
>>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 25 2017 - 12:51:15 CEST

Original text of this message