Friday, August 23, 2013

Installing Oracle 10g RAC on Oracle VM in windows 2008 using openfiler as shared storage

Dear friends those who interested in knowing more about RAC architecture , they need to prepare one RAC system for their study purpose.Here i got some helpful information from you-tube that provides detailed information  about installing Oracle 10g RAC on windows  .
Thanks Mr.Ahmed D.sherif for his nice presentation.  Here in his demonstration he uses Oracle VM as virtual box, windows server 2003 (32bit) as guest operating system , openfiler+Microsoft iscsi  initiator as shared storage ,oracle database and clusterware (10.2.0.1).

But some softwares listed above  are not available for me and i completed the same setup using  windows server 2008 standard edition(64bit) and oracle software (10.2.0.4) (both clusterware and database software).
The youtube link that i followed is given below,
Part1
http://www.youtube.com/watch?v=6BmwrR3Vcpc
Part2
http://www.youtube.com/watch?v=w7foLjbac4c
Part3
http://www.youtube.com/watch?v=BMPd_XAmtdc
Part4
http://www.youtube.com/watch?v=shVTEpyBohI
Part5
http://www.youtube.com/watch?v=shVTEpyBohI

You can fulfill the RAC set up by following  above link . But i hitched in several stage ,and it eat up my valuable time . Here i want to share that experience.

1. You can install Openfiler software by watching the video , during installation you will prompted for root user password. After installation you will get an url for openfiler interface just like
https://192.168.1.141:446 , it will ask for username and password
Here you have to give  'openfiler' as username not 'root'  ,as  i don't know the default password for 'openfiler' user , so i reset the password by 'root' user.

2.You don't need to download microsoft iscsi software  for windows 2008 server , as it comes in built with windows 2008 server  editions.

3. Once you configured shared disk for RAC in openfiler , You  have to configure the disk on each nodes through microsoft-iscsi. After configuring microsoft-iscsi you can see the shard disk has been appeared in 'Disk Management'  window on every node. Each disk should be in 'online' mode.After that you have to partition each disk (here 5) without any file system and drive name. After these stage i struggled a lot , because while cluster-ware installation it did not detect my previously created shared disk.After googling and studying a lot of articles for more than one weeks, i came to know that in windows clusterware does not support partition created as primary .In windows 2008 server ,by default  it creates partition as 'primary' partition .So you have to use diskpart command to create extended partition in windows 2008. So i deleted every partition that i mounted from storage. Then i created extended partition by using diskpart command.
How to use diskpart command 
1. Take command prompt and run diskpart command 
then type 
DISKPART>list disk
it will show all available disks, 
2.Then select the disk that you want to make extended partition by
DISKPART>select disk 1 
3.Then create extended partition on the selected disk  
DISKPART> create partition extended
You have to follow the same step for remaining disk . Once you created extended partition for all allocated disk , you can create logical partition by right clicking  each disk in the  'Disk Management' window.While creating logical drive keep in mind that not to format the disk  drive also not assign any drive letter.  The end result  become 5 logical disk (as per the video) and are ready to recognized by the clusterware software. Once the disks are ready 
you can go ahead with clusterware installation .

Note:- 
In oracle 10g raw devices are used for storing voting disk and ocr , but from 11g onwards you can keep these things in ASM . So here first two raw device are used for voting disk and ocr (both are configured in external redundancy - having only one disk) and remaining three raw devices are used for ASM.
Rest of my installation never stuck in any stage and i competed my two node RAC setup.

Hope it helps somebody those interested in oracle RAC architecture. 
Enjoy the reading :)
  

2 comments:

  1. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle Pre _RAC Installation, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Oracle Pre _RAC Installation. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us:
    Name : Arunkumar U
    Email : arun@maxmunus.com
    Skype id: training_maxmunus
    Contact No.-+91-9738507310
    Company Website –http://www.maxmunus.com



    ReplyDelete
  2. Mark Hurd Oracle Web Center is the center of engagement for business powering exceptional experiences for customers, partners, and employees. It connects people, processes, and information with the most complete portfolio of portal, content management, Web experience management, and collaboration technologies…..

    ReplyDelete