11gR2 11.2.0.2 Database Certified with E-Business Suite

[Jan 20, 2011 Update: Removed erroneous Linux x86-64 SLES 9 database tier reference]

[Nov 18, 2010 Update: Added HP-UX Itanium to the EBS 11i list of pending certifications]


We certified the 11gR2 11.2.0.1 Database with E-Business Suite 11i and EBS 12 late in 2009.  It's taken a little longer than we had hoped to certify 11.2.0.2, the first patchset for the 11gR2 Database.  The reasons: the release cycle for 11.2.0.2 overlapped with our EBS 12.1.3 release cycle, and some of the ports for this patchset weren't released until just before Halloween.  Our Server Technologies team is as-yet working on other ports, too.

I know that some of you have been eager to apply this latest patchset to your E-Business Suite databases, so I'm very pleased to announce that Oracle Database 11gR2 Patchset 1 Version 11.2.0.2 is now certified with the E-Business Suite. 

Screenshot of 11-2-0-2 11gR2 database patchset 1 Patchset 10098816 download page db_11202_screenshot.png

Oracle E-Business Suite Release 11i
Prerequisites
  • Oracle E-Business Suite Release 11.5.10.2
Certified Platforms
  • Linux x86 (Oracle Linux 4, 5)
  • Linux x86 (RHEL 4, 5)
  • Linux x86 (SLES 10)
  • Linux x86-64 (Oracle Linux 4, 5) -- Database-tier only
  • Linux x86-64 (RHEL 4, 5) -- Database-tier only
  • Linux x86-64 (SLES 10--Database-tier only)
  • Oracle Solaris on SPARC (64-bit) (10)
  • Oracle Solaris on x86-64 (64-bit) (10) -- Database-tier only
Pending Platform Certifications
  • Microsoft Windows Server (32-bit)
  • Microsoft Windows Server (64-bit)
  • HP-UX PA-RISC (64-bit)
  • HP-UX Itanium
  • IBM: Linux on System z 
  • IBM AIX on Power Systems
Oracle E-Business Suite Release 12
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 Linux 4, 5)
  • Linux x86 (RHEL 4, 5)
  • Linux x86 (SLES 10)
  • Linux x86-64 (Oracle Linux 4, 5)
  • Linux x86-64 (RHEL 4, 5)
  • Linux x86-64 (SLES 10)
  • Oracle Solaris on SPARC (64-bit) (10)
  • Oracle Solaris on x86-64 (64-bit) (10)  -- Database-tier only
Pending Platform Certifications
  • Microsoft Windows Server (32-bit)
  • Microsoft Windows Server (64-bit)
  • HP-UX PA-RISC (64-bit)
  • IBM: Linux on System z
  • IBM AIX on Power Systems
  • HP-UX Itanium
Database Feature and Option Certifications
The following 11gR2 11.2.0.2 database options and features are supported for use:
Certification of the following database options and features is still underway:
  • Transparent Data Encryption (TDE) Tablespace Encryption 11gR2 version 11.2.0.2
About the pending certifications

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.    

EBS 11i References
EBS 12 References
Related Articles
The preceding is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.

Comments:

Hi Steve,

It's wonderful, but I can't find such 11i certification in MOS cert list.
Actually, I can't find any 11i certification, that's quite strange, isn't it?

Thanks,
Mary

Posted by Mary on November 15, 2010 at 01:32 PM PST #

Thanks Steven,

1 day too late! I just handed over an upgraded 11.5.10.2 system at 11.2.0.1 for UAT yesterday. Ho hum.

There's an asterix next to the Linux x86-64 (RHEL 4, 5)* platform under the 11.5.10.2 section. Is there some sort of exception for this platform that's not noted?

Thanks
Des

Posted by Des Collins on November 15, 2010 at 03:29 PM PST #

11.2.0.2 isn't listed for Itanium HP-UX against 11.5.10 but is against R12, I'm guessing this is just an oversight and is pending?

Posted by Rob on November 15, 2010 at 06:06 PM PST #

Hi Steve,

I don't see "HP-UX Itanium" for EBS 11i in either certified or pending certification list of platforms !

Thanks
Naveen

Posted by Naveen Garg on November 15, 2010 at 07:53 PM PST #

Steve,

I saw someone else post this as well, I can't find 11i certification in MOS as well ! I had to go to the classic certification search to look for 11i certification information.

Thanks
Naveen

Posted by Naveen Garg on November 15, 2010 at 07:55 PM PST #

Awesome news.

Unless we come across some features / fixes in 11.2.0.2 that aren't in 11.2.0.1, I expect it'll be middle of next year before I get our production EBS instance upgraded, as a stepping stone to getting R12 in place, but I'm glad this is one less thing I need to worry about.

Many thanks to the certification group.

I realize you can't specify dates due to Revenue Recognition rules, but is RHEL 6 / OEL 6 certification for R11 on the list or will that be restricted to R12?

(yes, I realize the DB isn't supported on RHEL/OEL 6 yet, but I don't want to run out of things to upgrade

Posted by Jay Weinshenker on November 16, 2010 at 03:14 AM PST #

Hi, Des,

Sorry about the timing. Perhaps you could reconceptualize that as a form of job security in uncertain times.

Thanks also for catching the unexplained asterisk. Those represent database-tier only certifications in our internal notes. I've revised the platform list above.

Regards,
Steven

Posted by Steven Chan on November 16, 2010 at 03:34 AM PST #

Hi, Mary,

Our My Oracle Support team just rolled out a new beta version of the Certify system. The new version contains only Oracle E-Business Suite Release 12 information right now. We weren't able to complete our validation of over 17,000 rows of data before the rollout, so we approved only the R12 data for inclusion in the new system.

The old Certify system is also running in parallel on My Oracle Support (click the link at the top of the new Certify system's screen). The Oracle E-Business Suite Release 11i information is still accurately represented in the old system.

Once we've finished reviewing all of the Oracle E-Business Suite Release 11i data in the new Certify system, you'll be able to use the new one to search for both EBS 11i and 12 certification data.

Regards,
Steven

Posted by Steven Chan on November 16, 2010 at 03:37 AM PST #

Jay-
Discussions regarding OL6/RHEL6 support are underway but plans are not finalized, so we will need to get back to you.

Also, feel free to email me directly in a couple of weeks (say after the Thanksgiving holiday) if you don't hear from me.

-Terri

Posted by Terri Noyes on November 16, 2010 at 08:20 AM PST #

Rob, Naveen,

Indeed, that was an oversight. Our Platforms team confirms that this is in the pipeline. Thanks for catching that; article updated.

Regards,
Steven

Posted by Steven Chan on November 18, 2010 at 05:54 AM PST #

Hi Steven ,
We have RAC on 11gR1 , plainning to upgrade to 11gR2 .
I saw your certification update for R12. RDBMS is certified for 11.2.0.2 , however RAC certification is still at
11.2.0.1 .
Can you please confirm if R12 is certified for RAC 11.2.0.2 as well .

Thank you very much .

Praveen

Posted by Praveen Nallapu on November 19, 2010 at 04:39 AM PST #

Hi, Praveen,

>...however RAC certification is still at 11.2.0.1

The article above is correct; I'd neglected to update that line on my Certification tab. Fixed now.

Regards,
Steven

Posted by Steven Chan on November 22, 2010 at 02:41 AM PST #

Terry,

Don't know your email address and my guess for yours bounced. Please let me know OEL / RHEL 6 support plans if/when you can say.

Thanks!
J

Posted by Jay Weinshenker on November 28, 2010 at 11:46 PM PST #

[Editor -- I've obfuscated Terri's email ID since spammers harvest these blogs regularly]

Jay-
It is terri dot noyes at oracle.com. So, I believe you are asking for Release 11i. When DBMS 11.2.0.2 becomes available on Oracle Linux 6, we do not at this time intend to go back and certify 11i because it is in extended support. Our focus for new support will be on Release 12+ and Oracle Linux 6.

-Terri

Posted by Terri Noyes on November 30, 2010 at 06:59 AM PST #

When we try to run dbua to upgrade an existing oracle 10g database to oracle 11g (11.2.0.2.0) on HP-UX Itanium(11.31) we get the following message
at the 2nd screen of DBUA : 'null'
We have logged a SR and the SR# is 3-2468687561 and it seems it is a bug (10284582) and it is still being worked by Development, Can you please expedite the development process.

Posted by AJ on December 02, 2010 at 12:54 AM PST #

AJ,

I'm sorry to hear that you've encountered an issue with your upgrade.

I've asked our Applications Platforms Engineering team to follow up with the Support Engineer assigned to your SR to assist. Please monitor your SR for updates.

Regards,
Steven

Posted by Steven Chan on December 02, 2010 at 01:46 AM PST #

11.2.0.2 is not yet certified on HP-UX Itanium.

Read the blog article above for the list of platforms currently certified with 11.2.0.2

Posted by Peter P. Shih on December 02, 2010 at 01:58 AM PST #

And also it would be very useful if MOS would provide version level certification matrix instead of Release level Ex:

Oracle Server - Enterprise Edition 11.2.0.2 /HP-UX Itanium / 11.31 - Not certified ( we are using html based MOS version).

Posted by AJ on December 02, 2010 at 02:24 AM PST #

Hi Steve,

We just upgraded a test instance to 11.2.0.2 and it went very smoothly. We hope to go live in January.

Question about the pfile -

The database is currently running with a pfile. It seems like we should be running an spfile with 11gR2. Obviously, it is very easy to convert a pfile to an spfile (with the create spfile command). But the code in the adstrdb.sql script says "start pfile=...".

How do we change the database startup script to use the spfile and how do we get that change to survive when we run autoconfig?

Or are spfiles not recommended with 11i and 11g ?

Thanks,
Alan

Posted by Alan Rosenthal on December 06, 2010 at 12:49 PM PST #

Hi, Alan,

Congratulations on your successful test upgrade.

I'm afraid that I don't have any opinions about spfiles or AutoConfig implications associated with them. Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our AutoConfig specialists engaged.

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

Good luck with your upcoming production rollout.

Regards,
Steven

Posted by Steven Chan on December 07, 2010 at 01:04 AM PST #

Steven,
Forgive my taking the liberty of trying to answer Alan's question here....just thought I'd help

Alan,
It would appear that the template that controls the adstrtdb.sql file is rather old

REM $Header: adstrtdb.sql 115.5 2005/06/16 09:48:36 sridhsub ship $

I'd be surprised if oracle recommends not to use an spfile for 11.2 - given the documentation for 11.2 recommends it.

To answer your question though - you can create a custom template -- and remove the pfile reference therein.

Here's what you'd do

1) cd $ORACLE_HOME/appsutil/template
2) mkdir custom (if you don't already have a directory named custom)
3) cp -pi $ORACLE_HOME/appsutil/template/adstrtdb.sql $ORACLE_HOME/appsutil/template/custom
4) Edit the template under custom - comment out line "startup pfile=" using REM and create a new line with just startup

REM startup pfile=%s_db_oh%/dbs/init%s_dbSid%.ora
startup

5) Run Autoconfig -- your custom template will be used

Of course - next time you unzip appsutil (around a rapidclone/techstack patch) you'll have to reapply this customization.

Good luck w/ your upgrade...

--Rajesh

Posted by Rajesh Aialavajjala on December 08, 2010 at 02:30 AM PST #

Hi Steve,

As per the note 1058763.1 the minimum R12.1 application supported for 11.2.0.2 is R12.1.1. But in the same note it points to a pre-requisite patch 10024524, which should be applied on top of VCP 12.1.3 PATCH 9482453:R12.SCP_PF.B. The pre-requisite for the patch VCP 12.1.3 PATCH 9482453:R12.SCP_PF.B is R12.1.2.

This is quite confusing and shows that 11.2.0.2 is supported from R12.1.2 and later not from R12.1.1

Could you please verify and confirm what is the minimum supported R12.1 application for 11.2.0.2 upgrade.

Thanks,
...basha

Posted by Abdul Hameed on December 21, 2010 at 06:10 PM PST #

Hi, Abdul,

I've asked the team that owns this document to review this. Do you have an open Service Request for this? If yes, they can work directly with the Support engineer assigned to your SR to get the answer to you.

Regards,
Steven

Posted by Steven Chan on December 27, 2010 at 05:42 AM PST #

Hi Steve,

In considering a database upgrade from 10.2.0.4 to 11.2.0.2 AND an apps upgrade from 12.0.4 to 12.1.3 at the same time, would your teams recommendation be to do the apps upgrade first or Database upgrade first?

Thanks
Neil

Posted by Neil on January 19, 2011 at 08:36 AM PST #

Hi, Neil,

I polled our senior architects, and your question triggered an interesting internal discussion in Development about precedence of steps. As a direct result of your question, I expect one of my fellow bloggers to write an article about this soon.

In advance of that article:

You can do the database and 12.1.3 upgrades in either order. You can do them in a single or separate downtimes. We haven't benchmarked the total cycle times for the different orders, but our general assessment is that it would be faster to do the database upgrade first, and then the 12.1.3 upgrade.

Our recommendation is to do the database upgrade first, and then the 12.1.3 upgrade. That will provide you with an intermediate certified step if multiple downtimes are needed. The 12.1.3 Maintenance Pack Installation Guide is the relevant documentation to follow for this.

Good luck with your upgrade.

Regards,
Steven

Posted by Steven Chan on January 21, 2011 at 01:29 AM PST #

Hi Steven,

Based on the above article do you know what the certification status is for 11.5.10.2 with 11G R2 in a split configuration deployment (RDBMS : HPUX Itanium, Apps : RHEL5) ?

Is certification still pending for HP-UX Itanium?

regards,

Damien

Posted by Damien on February 04, 2011 at 12:08 AM PST #

Hi, Damien,

It's certified. See:

E-Business Suite Certified with DB 11.2.0.2 on HP-UX Itanium and IBM AIX on Power
http://blogs.oracle.com/stevenChan/2010/12/e-business_suite_certified_with_db_11202_on_hp-ux.html

Regards,
Steven

Posted by Steven Chan on February 07, 2011 at 01:14 AM PST #

Hi Steven,

I look forward for an answer to the query raised by Abdul
posted here on December 8, 2010 10:30 .

Regards
Shahin

Posted by shahin on February 21, 2011 at 03:09 PM PST #

Hi, Shahin,

Abdul didn't follow up on this, so we couldn't investigate further. If you have the same question, I'd suggest the same thing: please log a Service Request for this to get one of our specialists engaged. You're welcome to send me the SR number if your SR gets stuck for some reason.

Regards,
Steven

Posted by Steven Chan on February 22, 2011 at 04:01 AM PST #

Hi Steven,

I have a question regarding the certification of 11.2.0.2.3 with 11.5.10.2 on IBM AIX platoform. Since this 11.2.0.2.3 is just released and wanted to check if this is certified.
As per the Metalink Note: 1147107.1, it clearly says that "Oracle Database Patch Set Updates may be safely applied to Oracle E-Business Suite Release 11i" but when I opened a SR with Oracle, they said, it is not certified. lot of confusions.

Please help !

Thanks,

Posted by guest on July 24, 2011 at 08:30 PM PDT #

Hi, Guest,

We certify fourth-digit database patchsets with EBS. For example, we have already certified 11.2.0.2 with both EBS 11i and 12.

You can safely apply fifth-digit patchsets to EBS environments without any formal certification statements from us. This same policy applies to Critical Patch Updates and Patch Set Updates; see:

Can E-Business Users Apply Database Patch Set Updates? (Oracle E-Business Suite Technology)
http://blogs.oracle.com/stevenChan/entry/can_ebs_users_apply_database_patch_set_updates

Regards,
Steven

Posted by Steven Chan on July 26, 2011 at 02:52 AM PDT #

Hi Steven,

We want to upgrade our Oracle EBS 11i (11.5.10) to 11.5.10.2 with Database 11gR2.

Reg upgrade of the Database to 11gR2, I will follow Note:881505.1 (Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0.2))

I would like to know if I can use Manual Upgrade method to upgrade the database to 11gR2 as documented in Note:837570.1(Complete Checklist for Manual Upgrades to 11gR2)

Is DBUA the only supported method for Oracle EBS Database Upgrade?

Please advice.

Rgds,
Thiru

Posted by guest on August 03, 2011 at 05:25 AM PDT #

Hi, Thiru,

You should follow Note 881505.1. These upgrade instructions are specifically designed for EBS environments.

Regards,
Steven

Posted by Steven Chan on August 04, 2011 at 02:43 AM PDT #

Hi Steve,
we have EBS1213 installed on APP Tier 32 bits Linux 5.6
while DB installed at 64 bits Linux. due to 32 bits JVM limitation, we want to migrate the app tier to 64 bits machine. here are what we try to do:
1) clone db in 64 bit new server
2) installed EBS1213 APP Tier on a new server
3) remove the APPL_TOP and COMMON_TOP and copied the exist 32 bits appl_top and common_top to the 64 bits, then clone the new APP_tie

is it possible? we are running into the issues when we install the APP tier conenct to the extist DB ...

can you please provide some inside how to do this without issues?
this EBS env is used for configurator , consumer a lot of memory,
while 32 bits JVM has 4Gb max RAM.

Thanks

Posted by guest on August 27, 2011 at 06:08 AM PDT #

Hello -
It sounds to me like you already have your DB tier on 64-bit Linux, so not much needs to be done there.
What you'll have to do is basically follow the app tier portion of the 32-bit to 64-bit Linux migration doc 471566.1 - this doc needs to be updated for 12.1, but its basic procedure is valid. Essentially you have to make sure you have all pre-requisites met on the source and target systems, following the R12 rapid clone doc (406982.1) and the 12.1.1 IUN for Linux x86-64 (761566.1).
You would then copy the app tier file system over to the target, update a few env variables (see Note 471566.1), then run adadmin to relink and regenerate files.
Regards,
John

Posted by John Abraham on August 30, 2011 at 06:46 AM PDT #

Hello Steve ,

Please Confirmed list of patches for EBS 11.5.10.2 for integration with VCP 12.1.3 and Demantra 7.3.1

Posted by guest on January 15, 2012 at 04:58 PM PST #

Hello, Guest,

I'm afraid that Demantra certifications are handled directly by the Demantra team themselves. I don't have any visibility into that product's requirements.

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

Regards,
Steven

Posted by Steven Chan on January 17, 2012 at 03:48 AM PST #

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
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today