Showing posts with label VirtualBox. Show all posts
Showing posts with label VirtualBox. Show all posts

Sunday, October 18, 2015

Prepare virtualbox shareable disk for RAC installation

C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" createhd --filename D:\VMs\RAC01\Data1.vdi --size 10240 --variant Fixed
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 9f3cd90c-99ec-4520-b6d9-0217912ae92a

C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" createhd --filename D:\VMs\RAC01\Data2.vdi --size 10240 --variant Fixed
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 3de86535-4736-424c-97b1-e102c1474007

C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" createhd --filename D:\VMs\RAC01\Quorum.vdi --size 1024 --variant Fixed
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 1ce7ab6b-2c88-441b-985e-0c21226160d7

=====================================================================================================================
C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" storagectl "RAC01" --name "SAS" --add sas --controller LSILogicSAS
C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" storagectl "RAC02" --name "SAS" --add sas --controller LSILogicSAS
C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" storagectl "RAC01" --name "SAS" --portcount=8
C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" storagectl "RAC02" --name "SAS" --portcount=8
=====================================================================================================================

C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" storageattach "RAC01" --storagectl "SAS" --port 0 --device 0 --type hdd --medium D:\VMs\RAC01\Data1.vdi --mtype shareable
C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" storageattach "RAC01" --storagectl "SAS" --port 1 --device 0 --type hdd --medium D:\VMs\RAC01\Data2.vdi --mtype shareable
C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" storageattach "RAC01" --storagectl "SAS" --port 2 --device 0 --type hdd --medium D:\VMs\RAC01\Quorum.vdi --mtype shareable

C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" storageattach "RAC02" --storagectl "SAS" --port 0 --device 0 --type hdd --medium D:\VMs\RAC01\Data1.vdi --mtype shareable
C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" storageattach "RAC02" --storagectl "SAS" --port 1 --device 0 --type hdd --medium D:\VMs\RAC01\Data2.vdi --mtype shareable
C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" storageattach "RAC02" --storagectl "SAS" --port 2 --device 0 --type hdd --medium D:\VMs\RAC01\Quorum.vdi --mtype shareable

C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" showhdinfo D:\VMs\RAC01\Quorum.vdi
UUID:           1ce7ab6b-2c88-441b-985e-0c21226160d7
Parent UUID:    base
State:          created
Type:           shareable
Location:       D:\VMs\RAC01\Quorum.vdi
Storage format: VDI
Format variant: fixed default
Capacity:       1024 MBytes
Size on disk:   1026 MBytes
Encryption:     disabled
In use by VMs:  RAC01 (UUID: bf507dfc-853c-489c-a9d4-7411139e0635)
                RAC02 (UUID: eec5df93-a181-4531-a5c2-e824a77a554a)

C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" showhdinfo D:\VMs\RAC01\Data1.vdi
UUID:           9f3cd90c-99ec-4520-b6d9-0217912ae92a
Parent UUID:    base
State:          created
Type:           shareable
Location:       D:\VMs\RAC01\Data1.vdi
Storage format: VDI
Format variant: fixed default
Capacity:       10240 MBytes
Size on disk:   10242 MBytes
Encryption:     disabled
In use by VMs:  RAC01 (UUID: bf507dfc-853c-489c-a9d4-7411139e0635)
                RAC02 (UUID: eec5df93-a181-4531-a5c2-e824a77a554a)

C:\Windows\system32>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" showhdinfo D:\VMs\RAC01\Data2.vdi
UUID:           3de86535-4736-424c-97b1-e102c1474007
Parent UUID:    base
State:          created
Type:           shareable
Location:       D:\VMs\RAC01\Data2.vdi
Storage format: VDI
Format variant: fixed default
Capacity:       10240 MBytes
Size on disk:   10242 MBytes
Encryption:     disabled
In use by VMs:  RAC01 (UUID: bf507dfc-853c-489c-a9d4-7411139e0635)
                RAC02 (UUID: eec5df93-a181-4531-a5c2-e824a77a554a)

Sunday, October 11, 2015

"The network address is invalid" for SQL Cluster Resource Name

Error Message:

The given network name is unusable because there was a failure trying to determine if the network name is valid for use by the clustered SQL instance due to the following error: 'The network address is invalid.'

Found the solution: 

there is nothing wrong with my AD/DNS setup. And after uninstalling the VirtualBox Guess Tool, it works.


Reference: 
https://www.sqlskills.com/blogs/jonathan/building-a-completely-free-playground-for-sql-server-4-creating-the-cluster/

Sunday, December 5, 2010

Connect to VirtualBox Guest through NAT network (Solaris+ssh)

Here the e1000 can be replaced by pcnet, if you are using Windows/Linux guest with PCNet Type of ethernet card emulation.

And Solaris here is the Guest Name

C:\Program Files\Oracle\VirtualBox>VBoxManage getextradata "Solaris" enumerate
Oracle VM VirtualBox Command Line Management Interface Version 3.2.12
(C) 2005-2010 Oracle Corporation
All rights reserved.

Key: GUI/InfoDlgState, Value: 400,450,normal
Key: GUI/LastGuestSizeHint, Value: 720,400
Key: GUI/LastWindowPostion, Value: 265,101,720,442
Key: GUI/MiniToolBarAlignment, Value: bottom
Key: GUI/SaveMountedAtRuntime, Value: yes
Key: GUI/ShowMiniToolBar, Value: yes

C:\Program Files\Oracle\VirtualBox>VBoxManage setextradata "Solaris" "VBoxInternal/Devices/e1000/0/LUN#0/Config/ssh/HostPort" 2222
Oracle VM VirtualBox Command Line Management Interface Version 3.2.12
(C) 2005-2010 Oracle Corporation
All rights reserved.

C:\Program Files\Oracle\VirtualBox>VBoxManage setextradata "Solaris" "VBoxInternal/Devices/e1000/0/LUN#0/Config/ssh/GuestPort" 22
Oracle VM VirtualBox Command Line Management Interface Version 3.2.12
(C) 2005-2010 Oracle Corporation
All rights reserved.


C:\Program Files\Oracle\VirtualBox>VBoxManage setextradata "Solaris" "VBoxInternal/Devices/e1000/0/LUN#0/Config/ssh/Protocol" TCP
Oracle VM VirtualBox Command Line Management Interface Version 3.2.12
(C) 2005-2010 Oracle Corporation
All rights reserved.


C:\Program Files\Oracle\VirtualBox>VBoxManage getextradata "Solaris" enumerate
Oracle VM VirtualBox Command Line Management Interface Version 3.2.12
(C) 2005-2010 Oracle Corporation
All rights reserved.

Key: GUI/InfoDlgState, Value: 400,450,normal
Key: GUI/LastGuestSizeHint, Value: 720,400
Key: GUI/LastWindowPostion, Value: 265,101,720,442
Key: GUI/MiniToolBarAlignment, Value: bottom
Key: GUI/SaveMountedAtRuntime, Value: yes
Key: GUI/ShowMiniToolBar, Value: yes
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/ssh/GuestPort, Value: 22
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/ssh/HostPort, Value: 2222
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/ssh/Protocol, Value: TCP

C:\Program Files\Oracle\VirtualBox>netstat -na|findstr 22
TCP 120.28.9.137:3305 61.18.190.228:443 ESTABLISHED



C:\Program Files\Oracle\VirtualBox>netstat -na|findstr 22
TCP 0.0.0.0:2222 0.0.0.0:0 LISTENING
TCP 120.28.9.137:3305 61.18.190.228:443 ESTABLISHED