Oracle10g Installation with ASM in Oracle Virtual Box

--- Create ASM Disk --------

VBoxManage.exe createhd --filename asm1.vdi --size 4096 --format VDI --variant Fixed
VBoxManage.exe createhd --filename asm2.vdi --size 4096 --format VDI --variant Fixed

VBoxManage.exe storageattach ORALINUXASM --storagectl "SATA Controller" --port 1 --device 0 --type hdd --medium asm1.vdi --mtype shareable
VBoxManage.exe storageattach ORALINUXASM --storagectl "SATA Controller" --port 2 --device 0 --type hdd --medium asm2.vdi --mtype shareable

VBoxManage.exe modifyhd asm1.vdi --type shareable
VBoxManage.exe modifyhd asm2.vdi --type shareable


--- Output of the commands -------


C:\Program Files\Oracle\VirtualBox>VBoxManage.exe createhd --filename asm1.vdi --size 4096 --format VDI --variant Fixed
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Disk image created. UUID: 67e80984-5851-4643-92d4-d6c56798d725

C:\Program Files\Oracle\VirtualBox>VBoxManage.exe createhd --filename asm2.vdi --size 4096 --format VDI --variant Fixed
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Disk image created. UUID: e9f9c911-f6b1-4c59-958e-a83d998d4300

C:\Program Files\Oracle\VirtualBox>VBoxManage.exe storageattach ORALINUXASM --storagectl "SATA Controller" --port 1 --device 0 --type hdd --medium asm1.vdi --mtype shareable

C:\Program Files\Oracle\VirtualBox>VBoxManage.exe storageattach ORALINUXASM --storagectl "SATA Controller" --port 2 --device 0 --type hdd --medium asm2.vdi --mtype shareable

C:\Program Files\Oracle\VirtualBox>VBoxManage.exe modifyhd asm1.vdi --type shareable

C:\Program Files\Oracle\VirtualBox>VBoxManage.exe modifyhd asm2.vdi --type shareable


-----------------------------------------


Start the VM and install oracleasm rpms from this server with exact kernel match:

http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel5-084877.html



If attachment is not done you can do it manually from virutal server's SATA controller option.
--------------------------------------------------------------------

Comments

Post a Comment

Popular posts from this blog

SQL Server: Finding Query using SPID

A SPID in SQL Server is a Server Process ID. Every time an application connects to SQL Server, a new connection (or SPID) is created. This connection has a defined scope and memory space and cannot interact with other SPIDs. The term SPID is synonymous with Connection, or Session. Status of a Session: RUNNING: This status means session is running one or more batches. When Multiple Active Result Sets (MARS) is enabled, a session can run multiple batches. SUSPENDED : It means that the request currently is not active because it is waiting on a resource. The resource can be an I/O for reading a page, A WAIT can be communication on the network, or it is waiting for lock or a latch. It will become active once the task it is waiting for is completed. Once I/O is completed (Data for table tblStudents is available in the memory), query will move into RUNNABLE queue. RUNNABLE : The SPID is in the runnable queue of a scheduler and waiting for a quantum to run on the sche...
Read more

Restoring Master, Model and MSDB from Netbackup

Restoring System Databases got two parts: Taking the instance in single user mode and Restoring the Master Database If you need to rebuild the system databases on top of this you can use the below command: "C:\Program Files\Microsoft SQL Server\ 100 \Setup Bootstrap\ SQLServer2008R2 \setup.exe" /ACTION=REBUILDDATABASE /INSTANCENAME=SQL008 /SQLSYSADMINACCOUNTS=domain\ServiceUserName /SAPWD="yourpasswordOfSAuser" /SQLCOLLATION="Latin1_General_CI_AS" here 100 is for SQL Server 2008R2. It can vary case by case. How to take instance to single user mode: Two situation can happen: 1. Standalone Instance  2. Failover Cluster Instance 1. Standalone Instance: Go to SQL Config Manager SQL Service Properties -> Advanced Properties -> Startup Parameters put -m; in the Startup Parameters Apply and Okay - it will ask to restart the SQL Service to take effect. Stop and Start the service from Config Manager or you can stop and serv...
Read more