Sunday, January 24, 2016

ODA - Using ACFS for storing database is a must in ODA X5

Here is an important information for you, who purchased ODA X5 and planning to migrate EBS instances to the ODA environment.
Be aware that you will have to use at least an Oracle Database 11.2.0.3.15 and you will have to use ACFS for storing the EBS database.

Reference Oracle:

Oracle Database Appliance 12.1.2.0 introduces a fundamental change in the storage layer – the introduction of Oracle ACFS. Oracle ACFS is designed to deliver the best performance for Oracle databases. Oracle ACFS supports the creation of filesystem snapshots – a feature that vastly simplifies the creation of space efficient database clones. Going forward, new databases should only be created on ACFS filesystems in a new ODA deployment scenarios

Reference Oracle Support:

X5-2 does NOT support database versions 11.2.0.3.x (except 11.2.0.3.15 ACFS DB created from ODA 12.1.2.4 onwards) and 11.2.0.2.x. Only 11.2.0.3.15 (with ODA 12.1.2.4 onwards), 11.2.0.4.x and 12.1.0.2.x databases are supported must run on ACFS. Reason: X5-2 contains 4TB disks which exceed the 11.2 ASM disk size limit of 2TB. Running 11.2 databases on ASM will lead to data corruption, regardless of the OAK version. While OAK 12.1.2.3 will prevent creation of unsupported databases, OAK 12.1.2.2 did not. If you have created any unsupported 11.2.0.2.x or 11.2.0.3.x ASM DBs on X5-2, you must immediately upgrade to 11.2.0.3.15, 11.2.0.4.x or 12.1.0.2.x and manually migrate from ASM to ACFS.

4 comments :

  1. Hi Arsalan
    I am working on Migrating EBS environmnet from Dell server to ODA X52.
    ODA is supporting 11.2.0.3.15 DB only and i have to migrate 11.2.0.3.0 database to ODA so my question is what are the options? keep in mind that the option to upgrade DB first on Dell server is not available for me due to some other constraints.
    Thanks
    Malik

    ReplyDelete
  2. 11.2.0.3 database will probably work with the 11.2.0.3.15 binaries, but it will be not a supported conf. Having 11.2.0.3 (without .15) will be an unsupported configuration for ODA X5.2.
    You should also check your ODA version. These statements are true for ODA 12.1.2.4 and onwards.
    What you can do is one of the following;

    1) You can create a 11.2.0.3.15 home on ODA and use expdp/impdp to migrate your source databases to ODA.. You don't have to do any upgrade here.
    2) You can create a 11.2.0.3 oracle home on ODA. Then you can migrate your database to ODA using this newly created oracle home. Once you migrate your database to the ODA machine using the 11.2.0.3 oracle home, you can immediately upgrade your home/database to be 11.2.0.3.15, to be supported.

    ReplyDelete
  3. Thanks Arsalan for the quick reply.
    ODA X5.2 is just arrived and waiting to be configured and i hope this will be latest and greatest ODA version.
    Another question about ODA architecture related. We will use Virtualize environment on ODA. Due to licence constraints((We can only use 4 core on each Physical Node) we will use 2 VM for AppsTier and 1VM for DB. On the DB VM we will create 2 Oracle Home one for EBS and another for Non-EBS DB.
    My question is do you see any concern about 2 Oracle_Home on same DB VM? what is your advise keeping in mind we only have 4 core to use on each Node?
    Thanks
    Malik

    ReplyDelete
    Replies
    1. Malik,

      if you need assistance; please open an issue in to my forum using the link below;

      http://ermanarslan.blogspot.fr/p/forum.html

      you will see bunch of categories there, open your issue into the related category. Thanks.

      Delete