11gR2 Database Certified with E-Business Suite 12

[Nov 15 2010 Update:  11gR2 11.2.0.2 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 11.2.0.1 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.

11gR2OUILaunch.png
Prerequisites
  • 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 11.2.0.1 database options are supported for use with Apps 12:
Certification of the following database options and features is still underway:
  • Database Vault 11gR2 version 11.2.0.1
  • Transparent Data Encryption (TDE) Tablespace Encryption 11gR2 version 11.2.0.1
References
Related Articles
Comments:

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

Posted by Mahmud on March 07, 2010 at 04:43 PM PST #

Mahmud,

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

Regards,
Steven

Posted by Steven Chan on March 09, 2010 at 02:24 AM PST #

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.

cindy.yang@oracle.com

Posted by CINDY on March 30, 2010 at 09:19 PM PDT #

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.

Regards,
Steven

Posted by Steven Chan on March 31, 2010 at 01:46 AM PDT #

Steven,
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 11.2.0.1
- Transparent Data Encryption (TDE) Tablespace Encryption 11gR2 version 11.2.0.1

Thanks.

Posted by boumiro on March 31, 2010 at 03:16 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on March 31, 2010 at 05:58 AM PDT #

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 11.2.0.1.2 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 - 11.2.0.1.2 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.

Regards,
-Michael

Posted by Michael Taylor on August 26, 2010 at 01:44 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on September 02, 2010 at 02:58 AM PDT #

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,
Jennifer.

Posted by Jennifer Chen on September 03, 2010 at 02:37 AM PDT #

Hi, Jennifer,

We test all CPUs with the base E-Business Suite 11i and 12 configurations. Specifically, we test all new CPUs with 11.5.10.2, 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.

Regards,
Steven

Posted by Steven Chan on September 03, 2010 at 04:50 AM PDT #

Steven,

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

Regards,
Michael

Posted by Michael Schemer on October 03, 2010 at 05:02 AM PDT #

Hi,
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 (11.1.0.7) 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:
Hi
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

Posted by Brian Aldridge on October 03, 2010 at 11:53 PM PDT #

Michael,

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.

Regards,
Steven

Posted by Steven Chan on October 04, 2010 at 12:43 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on October 04, 2010 at 12:55 AM PDT #

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 ?

Posted by Abhijit Kulkarni on October 06, 2010 at 09:49 PM PDT #

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
division.

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.

Regards,
Steven

Posted by Steven Chan on October 07, 2010 at 02:15 AM PDT #

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

Please let us know.

Regards
Sivathanu

Posted by Sivathanu on October 20, 2010 at 04:12 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on October 28, 2010 at 06:59 AM PDT #

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.

Regards
muhammad ali
shaukat khanum cancer hospital

Posted by guest on September 21, 2011 at 01:18 AM PDT #

Hello, Muhammad,

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

Regards,
Steven

Posted by Steven Chan on September 21, 2011 at 04:03 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today