1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to implement asm for existing standalone oracle 11g database

Discussion in 'Installation - Unix and Unix Like' started by sunil, Sep 24, 2015.

  1. sunil

    sunil Active Member

    Messages:
    51
    Likes Received:
    1
    Trophy Points:
    140
    Location:
    MICHIGAN
    Hi David,
    We are trying to move from NON-ASM to ASM for existing standalone oracle 11g databases. So, Could you please provide the steps to implement the ASM for this existing oracle database.

    Thanks,
    Sunil Gowda
     
  2. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    Uwe Hesse has a nice article on the steps here:
    http://uhesse.com/2010/12/01/database-migration-to-asm-with-short-downtime/

    However, you can Google "migrating oracle database from local filesystem to asm" and get a couple dozen hits on the process.
     
  3. sunil

    sunil Active Member

    Messages:
    51
    Likes Received:
    1
    Trophy Points:
    140
    Location:
    MICHIGAN
    Hi Matthews,
    Here the requirement is, For the non-asm standalone database, we have to implement ASM and have to migrated oracle database local file system to asm and have to upgrade to 12c. So, do i need to install 12c GI or 11g GI. As anyway, here we are upgrading the oracle database from 11g to 12c.

    So, it would be great if you could help us on this task. How to take steps to start.


    Thanks,
    Sunil Gowda
     
  4. sunil

    sunil Active Member

    Messages:
    51
    Likes Received:
    1
    Trophy Points:
    140
    Location:
    MICHIGAN
    Here, the database size is around 5TB and it will grow upto 10TB. So, we need exact hardware requirements to implement ASM. As currently, we are using file systems each with 500GB. So, we would like to introduce the ASM and migrate all the files from file systems to ASM. Here, we will have only one database per server.

    Thanks,
    Sunil
     
    Last edited: Sep 25, 2015
  5. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You should install the 12c Grid.
     
  6. sunil

    sunil Active Member

    Messages:
    51
    Likes Received:
    1
    Trophy Points:
    140
    Location:
    MICHIGAN
    Thanks for the suggestion David. It would be great if you could send me the exact document for this 12c grid installation for standalone server. I have found few documents in google. but i think am missing few points in those documents which am unaware of those steps.

    Thanks,
    Sunil
     
  7. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    This was easy to find, I can't understand why you couldn't:

    http://www.oracle.com/technetwork/oem/enterprise-manager/documentation/index.html
     
  8. alphaqueen

    alphaqueen Newly Initiated

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Madison USA
  9. sunil

    sunil Active Member

    Messages:
    51
    Likes Received:
    1
    Trophy Points:
    140
    Location:
    MICHIGAN
    Hi,
    Actually My question is, i have physical Volume i.e 1TB and have created Logical Group i.e Oracle ASM on top of it. then i have created Logical Volume i.e disk1 ... disk4 which are raw disks. So, My question is, can we use this raw disks for ASM or do we need to mount disks on file systems?

    Thanks,
    Sunil
     
  10. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
  11. sunil

    sunil Active Member

    Messages:
    51
    Likes Received:
    1
    Trophy Points:
    140
    Location:
    MICHIGAN
    Thank you.