The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

11gR2 Database Certified with E-Business Suite 12

Steven Chan
Senior Director
[Nov 15 2010 Update:  11gR2 is now certified; see this article for details] [Dec 29, 2009 Update: Removed erroneous references to SLES 9 and specific Solaris versions] I'm very pleased to announce that the 11gR2 Database version is certified with Oracle E-Business Suite Release 12 versions 12.0 and 12.1. Existing Apps 12 environments currently running Oracle 10g Release 2 (10.2.0) or Oracle 11g Release 1 (11.1.0) may be upgraded to the 11gR2 Database.  
  • Oracle E-Business Suite Release 12.0.4 or later; or, Oracle E-Business Suite Release 12.1.1 or later
Certified Platforms
  • Linux x86 (Oracle Enterprise Linux 4, 5)
  • Linux x86 (RHEL 4, 5)
  • Linux x86 (SLES 10)
  • Linux x86-64 (Oracle Enterprise Linux 4, 5)
  • Linux x86-64 (RHEL 4, 5)
  • Linux x86-64 (SLES 10)
Pending Platform Certifications Certifications for the following operating system platforms are still pending:
  • Sun Solaris SPARC (64-bit) 
  • Sun Solaris x86-64 (64-bit)
  • IBM AIX Based Systems (64-bit)
  • HP-UX Itanium  
  • HP-UX PA-RISC (64-bit)
  • Microsoft Windows Server (32-bit)
As usual, I can't discuss release schedules for these additional platforms.  You're welcome to monitor or subscribe to this blog for platform-related updates. Database Feature and Option Certifications The following 11gR2 database options are supported for use with Apps 12: Certification of the following database options and features is still underway:
  • Database Vault 11gR2 version
  • Transparent Data Encryption (TDE) Tablespace Encryption 11gR2 version
References Related Articles

Join the discussion

Comments ( 20 )
  • Mahmud Monday, March 8, 2010

    Please how can I download the 11gR2 Database version Oracle E-Business Suite RELAESE 12 from this site. Or beter still I want anyone to please send me the setup file for installation.

  • Steven Chan Tuesday, March 9, 2010


    You can download Oracle software and media packs from http://edelivery.oracle.com.



  • CINDY Wednesday, March 31, 2010

    Hi Steven,

    Now I'm helping to config EBS R12 on Exadata, a little problem on establishing application environment on RAC.

    That's the tnsnames.ora, listener.ora has something wrong, then autoconfig error, as the script can't connect to DB tier.

    Would u like to give some advice on it.

    A little urgent.Thanks in advance.


  • Steven Chan Wednesday, March 31, 2010

    Hi, Cindy,

    Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

    Please forward your Service Request number to me as soon as it's logged; I'll have one of our EBS database specialists work with Support on this.



  • boumiro Wednesday, March 31, 2010


    It's been 3 month since 11gR2 was certified with R12.1.

    Can you please update on certification of the following DB options:

    - Database Vault 11gR2 version

    - Transparent Data Encryption (TDE) Tablespace Encryption 11gR2 version


  • Steven Chan Wednesday, March 31, 2010

    Hi, Boumiro,

    They're still in progress. Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.



  • Michael Taylor Thursday, August 26, 2010

    Hi Steven,

    I hope things are well with you. I just wanted to let you know I created SR 3-2056539691: NEEED SUPER MERGE OF PSU FOR EBS RELEASE 12 because the patched required per Interoperability Notes EBS R12 with Database 11gR2 (Doc ID 1058763.1) will not apply on top of a mandatory prerequisite of 9654983 - Patch Set Update, which is a prerequisite patch for 9318214 PARALLEL INSERT STATEMENT FAILS WITH ORA-00600 [KTPPSE1] ERROR. I was expecting the patches listed in the interoperability note to actually apply cleanly, but this issue has been a common problem for database patch setup updates since 10gR2.



  • Steven Chan Thursday, September 2, 2010

    Hi, Michael,

    Nice to hear from you. Sorry for the delay in responding to this. Coincidentally, I just handled a similar comment from another customer a few days ago. I'm excerpting (and modifying) a portion of that exchange since it applies here, too.

    ... neither CPUs nor PSUs are mandatory for E-Business Suite environments. However, the release process differs for CPUs and PSUs, so our treatment of those differs for EBS environments, too.

    CPUs go through a formal E-Business Suite certification process since: a) we often include EBS content in CPUs; b) we can modify CPUs that cause conflicts in EBS environments; c) CPUs are strongly recommended (but not mandatory) for EBS environments.

    None of those three things are true for Database Patch Set Updates. In addition, there are restrictions on PSU content that prevent us from including certain EBS interop patches in the PSUs. Because of these content restrictions and the key fact that we cannot change the PSUs downstream, this means that we can only change the EBS certified combinations upstream. To identify those changes, we need to redo all already-completed and released certifications.

    This makes it very difficult to certify PSUs due to the complex operational issues I alluded to. For example, since PSU contents are fixed and cannot be modified to accomodate EBS requirements, this means that we would need to recertify every supported database version release with every supported EBS release for every new PSU.

    Supported database releases: 6

    Supported EBS releases: 11

    Supported ATG releases per EBS release (N and N-1): 2

    EBS combinations to test every quarter: 6* 11 * 2 = 132

    Number of EBS products to test: 240

    Supported EBS server-based platforms: 44

    Product x db x EBS release combinations to test: 132 * 240 * 44 = 1.4 million

    And this is before we start to consider the additional factors like EBS certified combinations with database options such as DB Vault, Real Application Clusters, Transparent Data Encyption, and so on. These can be used in any combination, and we currently formally test at least 5 major options, so the number of permutations to be tested is at least 5 factorial (and likely more) -- meaning that every quarter the permutations would exceed 1.4 million *5! = 167 million potential testbeds.

    From an EBS certification standpoint, it is currently not feasible to certify PSUs formally with the constraints noted above within the timeframe that's available. Naturally, we do test new PSUs with a selected number of EBS platforms and releases every time. However, given our inability to modify PSUs downstream, the onus still remains upon the Server Technologies division to provide new MLRs that resolve possible conflicts between patches in your environment and new PSUs.

    That said, you've raised a concern that is shared by other customers. As always, I'll ensure that your feedback is shared with our PSU team.



  • Jennifer Chen Friday, September 3, 2010

    Hi Steven,

    Very interesting. Just curious do you also test AS10gR2, R3 CPUs' interoperabality externally and internally with EBS and modify them if they cause conflicts in EBS? We haven't have many problems lately on AS10g/EBS CPUs.

    Thanks for taking the time to clarify these kinds of issues for us.

    Best Regards,


  • Steven Chan Friday, September 3, 2010

    Hi, Jennifer,

    We test all CPUs with the base E-Business Suite 11i and 12 configurations. Specifically, we test all new CPUs with, 12.0.4, sometimes 12.0.6, 12.1.1, sometimes 12.1.2, and now 12.1.3. These are tested on all platforms.

    We do not test these base configurations with EBS + externally-integrated components (e.g. SSO, OID, Discoverer). There are just too many external components, versions, and combinations. External component product teams are required to test their products with CPUs if applicable (that falls outside of my EBS teams' mandate). For example, if a CPU has, say, Single Sign-On-related fixes, then the Single Sign-On team is responsible to testing their product with the CPU.



  • Michael Schemer Sunday, October 3, 2010


    Is the 11gR2 feature RAC One Node available/certified for use with EBS 12 or 12.1?



  • Brian Aldridge Monday, October 4, 2010


    On behalf of NetLogic Microsystems Inc SR 3-2143283161 which was transferred to me and have not been able to find a definit answer,

    We want to use the Clusterware product with Single database instance for the EBIS R12.1.2.

    Does the EBIS R12.1.2 with Single database instance on a clusterware is certified?


    Support has found the following related documentation but not sure:

    Note 466649.1 (Using Oracle 11g Release 1 ( Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 12) is already exist.

    Note 340859.1 Upgrading Oracle Applications 11i Database to 10g with Physical Standby in Place

    For an overview of implementing and maintaining Data Guard Redo Apply (physical standby) with the Oracle Applications, including detailed steps for a non-RAC implementation, please see OracleMetaLink note 216212.1.


    Customer's statement:


    I just read the Steven Chan's blog via your link. The note explains with two node RAC.

    But our requirement is :

    a). We don't want to use the RAC. Again We DON'T want to use RAC. Since it is a costly for us.

    b). But we want to use the Clusterware product with Single database instance for the EBIS R12.1.2.

    Does the EBIS R12.1.2 with Single database instance on a clusterware is certified?

    Please confirm

  • Steven Chan Monday, October 4, 2010


    RAC ONE Node can be used as a cold failover solution for E-Business Suite environments, but we don't support live node migration. We do not explicitly certify or document this configuration, so customers interested in using this technology with the E-Business Suite are advised to run proof-of-concept tests to ensure that it meets their requirements.



  • Steven Chan Monday, October 4, 2010

    Hi, Brian,

    Yes, Clusterware can be used with the E-Business Suite without RAC. We don't publish EBS-specific documentation for that configuration. Customers can use the generic Clusterware documentation to implement this in their E-Business Suite environment.



  • Abhijit Kulkarni Thursday, October 7, 2010

    Hi Steven

    Now, since 11gR2 Grid Infrastructure is certified with EBS R12 , Is ACFS certified to use for shred app tier on Oracle EBS 12 on Linux ?

  • Steven Chan Thursday, October 7, 2010

    Hi, Abhijit,

    I'm afraid that the Fusion Middleware team has explicitly stated that they

    have no current plans to certify or support Oracle Application Server 10g

    components on the ACFS file system.

    Oracle E-Business Suite Release 12 is built on Oracle Application Server

    10g, of course. So, if the Fusion Middleware team doesn't support the use

    of ACFS with Oracle Application Server 10g, neither can the E-Business Suite


    Customers interested in running Oracle Application Server 10g (and the

    E-Business Suite) on ACFS are encouraged to log SRs against the Fusion

    Middleware product to request this certification. If sufficient numbers of

    customers request it, they may consider it.



  • Sivathanu Wednesday, October 20, 2010

    Hi Steven

    On Oracle 11G R2 clusterware, Creating the EBIS R12.x database under ACFS is supported/certified?

    Please let us know.



  • Steven Chan Thursday, October 28, 2010

    Hi, Sivathanu,

    Yes, ACFS has been certified with the Oracle 11gR2 database. You can refer to the documentation for those products, respectively, for details. That certification carries through to E-Business Suite environments running on that database.



  • guest Wednesday, September 21, 2011

    Dear sir,

    is there any document availble for step by step upgrade of r12 12.1.1(11.1.07) database to 11gr2.

    I would be thankful to you.


    muhammad ali

    shaukat khanum cancer hospital

  • Steven Chan Wednesday, September 21, 2011

    Hello, Muhammad,

    See the documents listed in the "References" section in the article above. Best of luck with your upgrade.



Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.

Recent Content