DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Oracle 10g RAC and ASM - high availability

  1. #1
    Join Date
    Jul 2003
    Posts
    136

    Exclamation Oracle 10g RAC and ASM - high availability

    Environment: Oracle 10.2 (Standard edition)
    Windows 2003 server connected to SAN

    We will have about 15-20 different databases running through 1-2 windows oracle servers. The purpose is to have high availability and quick failover.

    1. Can we use RAC without using ASM. How easy/tough it is going to be managing/using RAC without ASM.

    2. If possible should we use Oracle 64 bit with Windows 64 bit OS.

    Please advice.

    Thanks

    -D

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you can only use ASM with standard edition

    running 15 instances in RAC does not make sense why not consolidate them?

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Quote Originally Posted by pando
    you can only use ASM with standard edition
    Huh?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    RAC Standard --> ASM

  5. #5
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Yes, I belive PANDO is right. Just do not know if it is a technological limit or a licence limit
    Besides, I do not see what's wrong with ASM and why should we try to avoid using it

  6. #6
    Join Date
    Jul 2003
    Posts
    136
    Quote Originally Posted by Bore
    Yes, I belive PANDO is right. Just do not know if it is a technological limit or a licence limit
    Besides, I do not see what's wrong with ASM and why should we try to avoid using it
    We do need to keep 15 db seperate.

    So are you saying, ASM is a proven technology with all posotive benefits and should always be employed?

    The reason for avoiding ASM is to be able to continue working with file system and not raw disks - our current much needed tool used by many here works with file system. The tool drops and adds schemas and tablespaces on daily basis.

    I am still looking for clear answers to:

    1. Can we (should we) use RAC without using ASM.
    2. Should we use ASM without using RAC.
    3. How easy/tough it is going to be managing/using RAC without ASM.
    4. If possible should we use Oracle 64 bit with Windows 64 bit OS.

    Please advice

    -D

  7. #7
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by daljitsb
    So are you saying, ASM is a proven technology with all posotive benefits and should always be employed?
    Yes it is.
    Easy to use, near raw-device performance... what else would you ask for?
    ASM is so good Oracle is building an O/S around it.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  8. #8
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Well,
    I am affraid that if u use RAC, file system is not an option at all (except if you do not use OCFS)

    For RAC you'll need either ASM or raw partitions, because the disks should be mounted by all the instances at the same time, which I am affraid is not possible with most file systems.
    About the ASM, I have some customers in the banking sector, running RAC on ASM. Is that good enough for you?

    Regards
    Boris

  9. #9
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    From 10g there is no 32 bit, all moving to 64 bits. May be you need to check the applications which would support 64 bits db's.

    I would suggest 64 bits.

    Also if you need control of your file systems and have a good network and system admin team, you can go for raids and SAN storage to maintain your db files.

    If you need Oracle to take care of the file systems and do not have a team to take of your raids and SAN, then go for ASM. Choice is yours and your management
    Last edited by dbasan; 04-25-2007 at 10:08 AM.

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    of course there is 32bit oracle, there are still 32Bit os'es out there, linux and windows being prime examples

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width