Friday Feb 01, 2013

Grace Period Increased for Applying (some) Database Patchsets

It's crucial to maintain the database in your E-Business Suite environments by applying the latest database patchsets.  Database patchsets contain important security, performance, and stability updates. As of today, the latest database patchset certified with EBS is 11.2.0.3. We strongly recommend that all EBS customers should be running this patchset now.

Oracle Database release roadmap

Until now, whenever a new database patchset was released, you had up to 12 months to apply it.  This is called the grace period.  No new patches for the previous patchset would be released after that 12 month grace period.

Oracle's Server Technologies group has just increased the grace period for the second and later patchsets to two years.

This is easier to understand with an example:

  • 11.2.0.1 was the major release for the 11gR2 codeline.
  • 11.2.0.2 was the first patchset.  You had 12 months to apply that patchset once it was released.
  • 11.2.0.3 was the second patchset.  You now have 24 months to apply that patchset after its release.

For more information about these database support policies, see:

Related Articles

Thursday Apr 05, 2012

Oracle Database 11gR2 11.2.0.3 Certified with E-Business Suite on HP-UX PA-RISC

HP logoAs a follow up to our original announcement, Oracle Database 11g Release 2 (11.2.0.3) is now certified with Oracle E-Business Suite Release 11i and Release 12 on the following HP-UX platforms:

Release 11i (11.5.10.2 + ATG PF.H RUP 6 and higher) :

  • HP-UX PA-RISC (64-bit) (11.31)

Release 12 (12.0.4 and higher, 12.1.1 and higher):

  • HP-UX PA-RISC (64-bit) (11.31)

This announcement for Oracle E-Business Suite 11i and R12 includes:

  • Real Application Clusters (RAC)
  • Oracle Database Vault
  • Transparent Data Encryption (Column Encryption)
  • TDE Tablespace Encryption
  • Advanced Security Option (ASO)/Advanced Networking Option (ANO)
  • Export/Import Process for Oracle E-Business Suite Release 11i and Release 12 Database Instances
  • Transportable Database and Transportable Tablespaces Data Migration Processes for Oracle E-Business Suite Release 11i and Release 12
References

Please also review the platform-specific Oracle Database Installation Guides for operating system and other prerequisites.

Related Articles

Monday Mar 16, 2009

OracleAS 10.1.3.4 Certified on IBM AIX for EBS 12

jcee.color.logo.gif

We're continuing to fill in the platform gaps for some of our recent techstack certifications.  We certified Oracle Application Server 10g 10.1.3.4 with Oracle E-Business Suite Release 12 in December, 2008.  The two exceptions to that certification at the time were for the IBM AIX and HP-UX Itanium operating system platforms.

HP-UX Itanium was later certified in January 2009, and now we're crossing the IBM AIX bridge.  IBM AIX customers running Oracle E-Business Suite Release 12 may now upgrade to OracleAS 10.1.3.4 OC4J directly from OracleAS 10.1.3 or 10.1.3.3.  This certification allows you to upgrade the internal OC4J components in the R12 techstack to take advantage of the latest performance and stability improvements in this incremental patchset.  To make sure that there's no misunderstanding about what can be upgraded, the full name of this patchset is:

[Read More]

Thursday Feb 26, 2009

On Apps Tier Patching and Support: A Primer for E-Business Suite Users

The Oracle Server Technologies division issued some important updates to their support policies in the following document:

I discussed the implications of the database-related policy updates for E-Business Suite users in this recently-published article.  It's time to discuss the implications of these policy updates for E-Business Suite application tier servers and externally-integrated Oracle Application Server instances.  This article also discusses the E-Business Suite application tier certification process and the safety of applying interim Fusion Middleware patches to your Apps environments. 

If you've read the previous article about database patching implications, parts of this new article will sound very familiar.  But stick with us; the implications for E-Business Suite application tier servers are subtly different and it's important that EBS sysadmins get the whole picture for both tiers.

[Read More]

Friday Feb 20, 2009

On Database Patching and Support: A Primer for E-Business Suite Users

The Oracle Server Technologies division has issued some important updates to their support policies in the following document:

These changes affect support policies for the database, Oracle Enterprise Manager, Fusion Middleware, and Collaboration Suite.  These changes are important enough to warrant an in-depth discussion about the implications of the database-related updates for E-Business Suite customers.  This article also discusses the E-Business Suite database certification process and the safety of applying interim patches to your Apps environments.  I'll cover the Apps-specific implications for the other technology products in a future article.

[Read More]

Tuesday Jan 13, 2009

OracleAS 10.1.3.4 Certified on HP-UX Itanium for EBS 12

[Update Mar 16, 2009:  IBM AIX is now certified with this configuration] jcee.color.logo.gif

Oracle E-Business Suite Release 12 runs OracleAS 10.1.2 for Forms-based content and OracleAS 10.1.3 (OC4J) for Java-based content.  Each of these two components can be upgraded separately, so each has its own independent certification cycle.  Just before New Years, we certified Oracle E-Business Suite Release 12 with Oracle Application Server 10g 10.1.3.4 for a subset of our supported operating system platforms

I'm pleased to let you know that HP-UX Itanium has been added to the list of supported platforms for OracleAS 10.1.3.4 (OC4J).  You can upgrade to OracleAS 10.1.3.4 OC4J directly from OracleAS 10.1.3 or 10.1.3.3. This certification allows you to upgrade the OC4J components in your R12 techstack to get take advantage of the latest performance and stability improvements in this incremental patchset. To make sure that there's no misunderstanding about what can be upgraded, the full name of this patchset is:

[Read More]

Monday Dec 29, 2008

OracleAS 10.1.3.4 Certified with E-Business Suite Release 12

[Update Mar 16, 2009:  IBM AIX is now certified with this configuration]

[Update Jan 13, 2009: HP-UX Itanium is now certified with this configuration]

jcee.color.logo.gif

Oracle E-Business Suite Release 12.0 originally shipped with OracleAS 10.1.3 Oracle Containers for J2EE (OC4J) for running its Java-based content.  Regular readers of this blog know that we certified OracleAS 10.1.3.3 with Apps 12 at the start of this year.

In a fitting end to the year, we've now certified Oracle Application Server 10g 10.1.3.4 OC4J with Oracle E-Business Suite Release 12.  You can upgrade to OracleAS 10.1.3.4 OC4J directly from OracleAS 10.1.3 or 10.1.3.3.  This certification allows you to upgrade the OC4J components in your R12 techstack to get take advantage of the latest performance and stability improvements in this incremental patchset.  To make sure that there's no misunderstanding about what can be upgraded, the full name of this patchset is:

It's important to note that either OracleAS 10.1.3.3 or 10.1.3.4 are mandatory prerequisites if you plan to upgrade your Release 12 application tier to the latest certified version of Java 6.

[Read More]

Friday Nov 14, 2008

EBS 12 Certified with OEL + RHEL 4 (64-bit) on Oracle VM

linux-penguin.jpg

[Dec. 31, 2013 update: Note 465915.1 has been withdrawn.  Refer to the Certifications system on My Oracle Support for the latest certified combinations of EBS + Oracle VM]

Filling out our certification matrix for Oracle VM, our Applications Platform Group has certified Oracle E-Business Suite Release 12 on Oracle VM with 64-bit Oracle Enterprise Linux 4 and Red Hat Enterprise Linux 4 on x86-64.

Prerequisites

  • Oracle Enterprise Linux 4.7 (64-bit) on x86-64
    or
    Red Hat Enterprise Linux 4.7 (64-bit) on x86-64
  • Oracle VM 2.1.2 or higher
  • Oracle E-Business Suite Release 12 version 12.0.3 (RUP 3) and higher

Upcoming Certifications

The Applications Platform Group is currently working on certifying Oracle VM with 64-bit OEL/RHEL version 5.  No release schedules are available, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as possible.

References

Related Articles

Tuesday Nov 04, 2008

Maximum Availability Architecture: Oracle E-Business Suite Release 12

I'm highlighting OpenWorld 2008 presentations that cover some of the most popular E-Business Suite technology stack topics. A catalog of all of the Applications Technology track sessions with links to the presentations is available here:

Humana's recent OpenWorld case study gives a customer-centric view of how they implemented a high-availability architecture for their E-Business Suite environment.  Lyn Pratt and Richard Exley from Oracle's Server Technologies MAA Group and Metin Yilmaz from Oracle Support complemented that case study with a discussion of the various options for ensuring high availability and business continuity via a disaster recover site for your E-Business Suite environment:

Physical architecture diagram showing target architecture for an E-Business Suite Release 12 disaster recovery deployment

[Read More]

Wednesday Aug 06, 2008

In-Depth: Using Third-Party Identity Managers with E-Business Suite Release 12

This article is an updated R12 version of an earlier one written for Oracle E-Business Suite Release 11i.

Like most of our customers, you probably already have a corporate identity management system in place. And, you've probably not been enjoying the experience of redundantly administering the same user in your corporate identity management system as well as the E-Business Suite. If this describes your environment, this in-depth article about integrating Oracle E-Business Suite Release 12, Oracle Single Sign-On and Oracle Internet Directory with third-party identity management systems will show you a better way of managing your EBS users.

[Read More]

Thursday May 29, 2008

Master DST + Time Zone Documentation for Release 12

[May 30, 2008 update: Corrected typo and Note number.  Argh.  TGIF...]

Time is out of joint; O cursed spite / That ever I was born to set it right!

~ Shakespeare, Hamlet

When E-Business Suite Release 12.0.0 was originally released last year, it included the latest available support for all of the world time zones.  Since then, a number of countries and regions have changed their time zone definitions, including:

Country / Region
Effective Date
United States / Canada
11-Mar-2007
New Zealand / Chatham Islands
30-Sep-2007
Egypt
7-Sep-2007
Brazil
14-Oct-2007
Venezuela
9-Dec-2007
Argentina
30-Dec-2007
Australian Capital Territory
New South Wales
South Australia
Victoria
Tasmania
6-Apr-2008

If you do business with these countries or others that have changed their time zone or Daylight Saving Time (DST) definitions recently, your E-Business Suite Release 12 environment may require patching.

For details, see:
Related Articles

Saturday May 17, 2008

Release Update Packs 12.0.5 for Financials and HRMS Now Available

[July 2, 2008 Update: Removed references to specific numbers of issues fixed.]

This announcement isn't really directly-related to the E-Business Suite technology stack, but it can't hurt to highlight this news here since it affects so many of our readers.   Oracle Financials and Oracle Human Resources Management System (HRMS) have released two new product family Release Update Packs for E-Business Release 12.0.5.  These cumulative product family RUPs include error corrections, statutory/regulatory updates, and functionality enhancements that were made available after the initial release of Oracle E-Business Suites 12.0.

The naming convention for E-Business Suite Release 12 until now has been that a "Release Update Pack" comprises bug fixes for all product families.  These were called Consolidated Updates in Release 11i. 

This is the first time I've seen the term "Release Update Pack" used to refer to fixes for a specific product family for Release 12.  You should be aware that these latest 12.0.5 RUPs don't include fixes for any other E-Business Suite application modules except Financials or HRMS.  Regardless of what they're called, R12 sysadmins can now download two new patchsets:


Oracle Financials Release Update Pack 12.0.5

This patch can be downloaded as Patch 6836355, and its contents are documented in Oracle Financials Software Updates, Release Update Pack 6 (Metalink Note 565898.1).

Oracle HRMS Release Update Pack 12.0.5

This patch can be downloaded as Patch 6610000, and its contents are documented in Oracle HRMS Software Updates, Release Update Pack 5 (Metalink Note 565977.1).


References

New functionality for both RUPs is described in:
Related Articles

Friday May 16, 2008

WinXP Service Pack 3 Certified with E-Business Suite

Microsoft Windows XP Service Pack 3 (SP3) is now certified with Oracle Oracle E-Business Suite Releases 11i and 12.

WinXP SP3 Download Screenshot: Screenshot of Microsoft Windows XP Service Pack 3 download overview page

Simply Business As Usual

For Oracle E-Business Suite users, the base desktop client requirements are the same as for Windows XP Service Pack 2 (SP2).  Customers already on WinXP SP2 can move seamlessly to the latest Service Pack 3.

All certified browsers --IE 6, IE7, Firefox -- are certified with the E-Business Suite on WinXP SP3.  Likewise, all certified Java clients -- JInitiator and the native Sun Java Runtime Engine (JRE) plug-in -- are also certified to work with the E-Business Suite on  WinXP SP3.

References
Related Articles

Thursday May 15, 2008

WebCenter 10g 10.1.3.3 Certified with E-Business Suite Release 12

My colleagues over at the Fusion Middleware Best Practices Center recently posted a Developer Preview of an Oracle By Example tutorial for using WebCenter 10g with the E-Business Suite; this was a subset of our unpublished official documentation.  The preview period is over at last:  I'm pleased to announce that WebCenter 10g 10.1.3.3 is now officially certified and supported for use with E-Business Suite Release 12.

CreateApps: Screenshot of Oracle JDeveloper showing the initial dialog box for creating a new WebCenter application

Integrating Standalone Websites With Apps 12

Oracle WebCenter is a suite of development tools that can be used to build web-based applications using the latest technologies such as SOA, JSR-168, and WSRP.  The Oracle WebCenter Framework allows you integrate the following E-Business Suite Release 12 portlets into a custom web-based application:
  • Applications Navigator (menu of E-Business Suite functions)
  • Applications Worklist (showing Workflow notifications)
  • Applications Favorites (for bookmarking specific Apps functions)
JDev Portlets: Screenshot of Oracle JDeveloper IDE page showing list of E-Business Suite Release 12 WSRP portlets

What's Notable About This Certification?

This certification is a bit of a departure from our usual technology stack certifications for the E-Business Suite.  Our typical certification involves, say, upgrading your E-Business Suite environment to the latest new database, or integrating it with an external component like Single Sign-On.

This new certification documents a step-by-step process for building and deploying a WebCenter application using the Oracle Applications Framework WSRP producer.  You can build an Applications Development Framework (ADF) application in the Oracle JDeveloper integrated development environment and deploy the application to your end-users via Oracle WebCenter.

Our newly-documented procedure supports E-Business Suite environments that have been integrated with Oracle Single Sign-On (SSO), as well as steps for E-Business Suite configuration and the migration of Oracle Internet Directory (OID) policies.  It also includes detailed steps for deploying the ADF application to a WebCenter OC4J instance and running the application there. 

For full details, see:
Certified Platforms
  • Linux x86-32
  • Linux x86-64
  • Sun Solaris SPARC
  • HP-UX PA-RISC
  • HP-UX Itanium
  • IBM AIX
  • Microsoft Windows 2003
Related Articles

Tuesday May 13, 2008

Oracle Database Vault 10.2.0.3 Certified with Apps 12

I am very pleased to announce that Oracle Database Vault 10.2.0.3 is now certified with E-Business Suite Release 12 on Linux-x86 platforms. This certification provides an upgrade path for current Database Vault-enabled EBS 11i instances to R12.

Database Vault example: Diagram showing how Database Vault prevents a privileged DBA user from accessing application data, while allowing the authorized Realm owner to access the same data


What is Oracle Database Vault?

A key challenge for security administrators is protecting enterprise data from insider attacks.  Oracle Database Vault
is an optional database feature that can help you defend against that class of threats, as well as build internal controls to help meet regulatory requirements for privacy and segregation of duties.

Oracle Database Vault can prevent highly privileged users, including powerful application DBAs and others, from accessing sensitive applications and data in Oracle databases outside their authorized responsibilities. You can use customizable Realms and rules to ensure that users, even administrators, have access only to what they need to do their job.

For more details about the prepackaged Realms we've created for E-Business Suite environments, see:

Certified Platforms

  • Linux x86-32
[Editor Note:  Due to a couple of things that I can't discuss publicly here, it is likely that DB Vault + R12 certifications for additional operating system platforms may be based on Database Vault 10.2.0.4. If you're not running Linux and/or upgrading from Apps 11i with DB Vault 10.2.0.3 already enabled, you may wish to reflect on how this fits into your implementation and upgrade plans. More details will be forthcoming. You're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.]

Prerequisites
  1. Oracle E-Business Suite Release Update Pack 12.0.4
  2. Oracle Database Vault 10.2.0.3
  3. Oracle Database Release 10gR2 (10.2.0.3)

References

Related Articles

The above 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 decisions.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle. 

Tuesday Apr 29, 2008

Implications of OracleAS Support Policies for Apps R12 Environments

Oracle E-Business Suite Release 12 was built with the latest Oracle Application Server components available at the time of its release.

mzr12tech:


Whilst this is a good thing, it does mean that Apps DBAs need to be more aware of what is going on in the Oracle Application Server 10g (AS10g) world with regards to the latter's support policies.

Evaluating Impacts on the Release 12 10.1.3 ORACLE_HOME


One example of the importance of this concept is a notice in the January 2008 Critical Patch Update (CPU):

Some customers may have missed or not realized the significance for E-Business Suite environments.  It states:-

CPUJan2008 is the terminal CPU for: 10.1.3.0 Oracle Application Server


This means that in order to be able to apply all April 2008 CPU patches to E-Business Suite R12 environments, you MUST upgrade to AS 10.1.3.3.0 as described in :



Just to clarify: Oracle Application Server 10g 10.1.3.0.0 will continue to be supported for E-Business Suite Release 12 customers. However, the latest April 2008 Critical Patch Updates are not available for Oracle Application Server 10g 10.1.3.0.0.  Given my recommendation to always apply the latest CPU patches, I suggest that you upgrade your E-Business Suite Release 12 environment to Oracle Application Server 10g 10.1.3.3 if you have not done so already.

Evaluating Impacts on the Release 12 10.1.2 ORACLE_HOME


The same situation applies to the 10.1.2 ORACLE_HOMEs as well.  "Critical Patch Update April 2008 Availability Information for Oracle Database and Fusion Middleware Products" (Metalink Note 552248.1) states:



... the terminal CPU for 10.1.2.2 is scheduled for CPUJan2009


The direct implication is that eBiz customers will likely need to upgrade their 10.1.2 ORACLE_HOMEs by April 2009 to keep up-to-date with Critical Patch Updates.


Taking Time Out to Study the Documentation


Keeping your environments up to date with the latest Critical Patch Updates is an essential part of an Apps DBAs role, so it is important to take some "quiet time" in your busy schedule to carefully read through the CPU patch documentation when planning your patch rollout.  (I sometimes find myself sitting in the restaurant with a coffee if I need to read through a load of documents; the boss sometimes pays for the coffee as well!)   Whilst we do try to make the documentation as easy and concise as possible, I am sure you will let us know how it can be improved if you find it lacking.

References


Related Articles


Monday Apr 28, 2008

Five Key Resources for Upgrading to E-Business Suite Release 12

[July 16, 2008: Added two more vital resources to this list, instantly rendering the title of this article inaccurate.]

[May 14, 2008 Update:  It turns out that the original diagram from Eugene's presentation could use some refining.  Diagram replaced with an excerpt from the Official R12 upgrade guide itself.]

[Apr 29, 2008 Update:  The diagram below is excerpted from Eugene Weinstein's excellent OpenWorld 2007 presentation describing Oracle's own R12 upgrade.  That presentation was released prior to our recent certification of the 11g Database with Release 11i, which is why there's no reference to that database version below.  


As of today,  the 11g Database is certified with Release 11i but not with Release 12.  The R12 certification with the 11g Database is still underway now, and -- as usual, I don't have any dates for this certification yet.  If you upgrade your Apps 11i environment to the 11g DB today, your upgrade to Release 12 will have to wait until the latter is certified with the 11g DB, too.]

A remarkable aspect of this year's OAUG Collaborate 2008 conference was the abundance of customer-presented sessions devoted to E-Business Suite Release 12 upgrades.  I stopped counting after the first dozen sessions.  I wish I could have cloned myself to attend all of them.

Upgrade Paths Table: Table of Release 12 upgrade paths from E-business Suite 11.0, 11.5.1 to 11.5.7, and 11.5.8 to 11.5.10

Despite the plethora of customer case studies and other materials, I got the impression that some of you may be wondering where to start.  Here's a round-up of the key Oracle resources to help you plan and execute your Release 12 upgrade:
  1. Whitepapers about R12 functional benefits
    As a reader of this blog, your focus is likely on E-Business Suite technology more than on the applications modules' functionality itself.  Remember, however, that upgrading to Release 12 should be primarily driven by the improvements to business processes that R12's new capabilities offer.  The site above has whitepapers that your end-users can review to build their own business cases for the upgrade (e.g. "The Business Value of Upgrading to Oracle E-Business Suite Financials Release 12").
  2. Oracle Applications Upgrade Guide: Release 11i to Release 12 (PDF, 1.6 MB)
    This is the official, authoritative technical upgrade manual from Oracle Applications Development. This is part of the official Release 12 Documentation Library (Oracle Technology Network).
  3. Oracle Maintenance Wizard
    Oracle Support has worked jointly with Oracle Applications Development to produce this essential tool which produces a personalized 11i to R12 upgrade plan -- complete with detailed patching recommendations -- based upon your existing 11i environment.  Highly recommended.

  4. Oracle E-Business Suite Upgrade Resources Roadmap (Note 461705.1)
    Oracle provides a massive (and sometimes intimidating) amount of documentation to support your R12 upgrade.  This roadmap helps organize that documentation into four phases:  Evaluation, Planning, Execution, and Optimization.  This is the one-stop Metalink Note for links to Release Notes, READMEs, Release Content Documents, Upgrade Notes for specific platforms, and much, much more.

  5. R12 Install/Upgrade Forum (Oracle Technology Network)
    Amazingly, this OTN peer-supported discussion forum can sometimes yield answers to R12 upgrade questions faster than a formally-logged Service Request. This forum is monitored by Oracle Applications ACEs such as Hussein Sawwan, Michael Taylor, and Fadi Hasweh as well as Oracle Development (I'm one of the Oracle co-moderators of this forum).  This should be your first stop if you're having any technical issues with your upgrade.  If your question isn't answered here, then logging an SR with Metalink is the next step.

  6. Best Practices for Adopting Oracle E-Business Suite Release 12 (Metalink Note 580299.1)
    This whitepaper from Oracle Development pulls together a diverse range of tips and practical suggestions for implementation, preparation and cleanup, and product-specific considerations for the R12 versions of Oracle Financials and other products. Highly recommended.

  7. Case Study: Oracle's Own Oracle E-Business Suite Release 12 Upgrade
    In addition to being a useful primer about R12, this excellent presentation summarizes practical tips and technical insights from the Oracle internal team that upgraded Oracle's own E-Business Suite Global Single Instance from Release 11i to 12. As you'd expect, and their notes represent an insider's glimpse into how an organization with access to the most-skilled EBS talent on the planet performed this upgrade. Highly recommended.
Related Articles

Monday Apr 21, 2008

What Happened to E-Business Suite Release 12.0.5?

[May 29, 2008 update:  They don't meet the definition of a Release Update Pack that's been used for R12 so far, but two 12.0.5 product family updates for the Financials and HRMS product families are now available.  See this article for details.]


Up until now, a new E-Business Suite Release 12.0.x Release Update Pack (RUP) has been released in the same general time-frame as each new Oracle Critical Patch Update (CPU).  For example, the January 2008 Critical Patch Update was released concurrently with the E-Business Suite 12.0.4 Release Update Pack.

E-Business Suite 12.0.4 Patch 6435000: Screenshot of download site for E-Business Suite Release 12.0.4 Release Update Pack Patch 6435000

This pattern changed with the recent Oracle Critical Patch Update for April 2008.  The April 2008 CPU was not released concurrently with a corresponding E-Business Suite Release 12.0.5 Release Update Pack.  Sharp-eyed readers have asked whether an upcoming Release 12.0.5 is still in the pipeline.

Here's an update on our plans, based on what was being shared in various sessions at last week's Collaborate conference (notably, Cliff Godwin's sessions):  As of today, it appears that there are no plans for Release 12.0.5.  Instead, it appears that new Family Packs for Financials and Human Resources (HRMS) are planned for customers currently on the 12.0.x codeline.

It's important to note that this is breaking news and is still subject to change.  As usual, I'm afraid that I don't have any information about dates for these updates.  I'll provide more details about our plans for these forthcoming updates as soon as they're available.

Related Articles
The above 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 decisions.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle. 

Wednesday Apr 09, 2008

10gR2 10.2.0.3 DB Certified on Windows Server 2003 x64 for Apps 12

The E-Business Suite Release 12 is now certified with Oracle Database Server 10gR2 Version 10.2.0.3 on Microsoft Windows Server 2003 x64 (AMD64/EM64T).

Microsoft Windows Server 2003 x64 Logo:

Microsoft Windows Server 2003 x64 (AMD64/EM64T) is supported only on the database tier for Release 12 (these types of configurations were previously called a "split configuration" in Release 11i environments).  The E-Business Suite Release 12 application tier must be on a supported platform.

To deploy this configuration on a Microsoft Windows Server 2003 x64 (AMD64/EM64T) database server, see:
More Certification Information

For the definitive list of all certified platforms, you can refer to to Oracle's Certify database:  E-Business Suite Split Configuration Database Tier platform Certified Combinations. From the Certify main page select: View Certifications by Product -> E-Business Suite -> E-Business Suite 11i or Earlier ->
Database Tier Only.

Related Articles

Thursday Apr 03, 2008

Changing Application Tier Platforms for E-Business Suite Release 12

Here's another significant piece of news:  it's now possible to migrate your E-Business Suite Release 12 application tier servers from one operating system platform to another.  We're pleased to announce the availability of our new Oracle Applications Platform Migration Methodology for E-Business Suite Release 12.

This process provides a way to quickly and easily move an existing Oracle E-Business Suite middle tier (applications tier) system to a different platform.  The migration utility retains the exact E-Business Suite patch level; no APPL_TOP or Database synchronization is necessary.  This allows you to retain existing customizations.

Considerations

  • This migration methodology requires E-Business Suite 12.0.4 or higher
  • This methodology applies to the Application Tier (middle tier) only.  The database tier is not covered by this process.
  • Migration to Windows-based target servers is not supported at this time
Certified Target Platforms
  • Linux x86-32 (32-bit)
  • Linux x86-64 (64-bit)
  • HP-UX Itanium
  • HP-UX PA-RISC
  • IBM AIX
  • Sun SPARC Solaris
References
Related Articles

Wednesday Apr 02, 2008

Apps Release 12.0.4 Rapid Install Now Available

Climbing back into the blogging saddle after a five weeks abroad feels distinctly odd.  Here's something noteworthy from my beleaguered inbox:

12.0.4 eDelivery screenshot: Screenshot of Oracle Electronic Delivery download page for Apps 12.0.4 Rapid Install

Ever since the initial release of E-Business Suite Release 12.0, we've been putting out quarterly Release Update Packs (RUP) that you can apply on top of your base installation.  So far, we've released Release Update Packs 12.0.1, 12.0.2, 12.0.3, and 12.0.4.  The latest Release Update Pack 4 included more than 10,000 fixes and 100 functionality enhancements after the initial release of 12.0.

Although convenient, applying all of these individual Release Update Packs can be time-consuming.  Recognising that, we've now released a new version of E-Business Suite 12.0.4.  This brand-new release includes a repackaged Rapid Install that makes it possible to upgrade existing 11.5.8, 11.5.9 (Base, CU1, CU2), and 11.5.10 (base, CU1, CU2) systems directly to the Release Update Pack 4 level. 

Release 12.0.4 is now available for download for both new and upgrading customers on all supported languages through Oracle Electronic Product Delivery (EPD) and the Oracle Store.  You can check EPD for specific platform downloads, which are updated regularly.

What's New in Release Update Pack 4?

As noted in my previous article about Release 12 Update 4, this RUP contains fixes for the following product families, with details in the
corresponding Metalink Notes:
Includes January 2008 Critical Patch Updates

Just like the previous Apps 12.0.1 Release Update Pack, Apps 12.0.2 Release Update Pack, and Apps 12.0.3 Release Update Pack, there's a gem buried in all of this:  the Apps 12.0.4 Release Update Patch includes all of the security fixes released in the January 2008 Critical Update Patch (CPUJan2008).

Related

Tuesday Feb 19, 2008

Optimizing R12 Performance via OC4J Load-Balancing

Oracle Application Server provides features that allow customers to load balance their middle tier deployments.  OC4J Clustering in OracleAS 10g is one such deployment that is widely used in load balanced configurations.

Starting with Oracle E-Business Suite Release 12.0.2 (Release Update Pack 2), we support OC4J Clustering as part of AutoConfig's load balancing deployment options. This configuration option is supported for the OC4J instance running out of R12's 10.1.3 ORACLE_HOME.

Clustering Model

Oracle Application Server 10g 10.1.3 supports various models for OC4J clustering:
  • Dynamic node discovery
  • Static discovery servers
  • Cross topology gateways
  • Manual node configuration.
E-Business Suite Release 12 uses the manual node configuration model, which is also referred to as static node-to-node communication. Node and port information is manually specified in this mode. Configuration details are managed by Autoconfig, which handles all necessary settings in the R12 configuration files.

Figure-1 static node-to-node communication model

static-communication:

Deployment Options


Release 12 supports the following deployment options with OC4J clustering:
  1. Single Web Entry Point
  2. Multiple Web Entry Points

Prerequisites

  1. Oracle Applications Technology Stack Patch Set 2 5917601 or higher.
    • This Patch Set is included in the R12.ATG_PF.A.DELTA.2 5917344 and the Release 12.0.2 (Release Update Pack 2)
  2. A correctly-configured hardware load balancer

Configuring OC4J Load Balancing

Configuring both deployment options requires:
  1. Changing the E-Business Suite Context file using the Context File Editor
  2. Running AutoConfig
  3. Restarting the application tier server processes.
Single Web Entry Point

In this deployment option, there is single web entry point for the OC4J applications - oacore, forms and oafm services are configured to run on all or some of the application tier nodes.

Figure-2: Deployment model with Single Web Entry point and OC4J application running on all the nodes

SingleWebEntry: Architecture diagram showing an E-Business Suite environment with two application tier servers and a single webentry point

Multiple Web Entry Points

In this deployment option, there are multiple web entry points with OC4J applications running on selected application tier nodes.

Figure-3: Deployment model with Multiple Web Entry points and OC4J applications running on selected nodes

multipleweb: Architecture diagram showing a multinode Apps environment

References
Related Articles

Friday Jan 25, 2008

Java 6 Certified with E-Business Suite Release 12

I'm pleased to announce that Java 6.0 Update 2 has been certified with Oracle E-Business Suite Release 12.

Sun Java SE Download page screenshot: Screenshot of Sun Java SE download page

A Rose by Any Other Name

Before getting into the details about this new certification, it's unavoidable that I spend some time on terminology.  Apparently, the latest iteration of the full name of this product family delivered by Sun Microsystems is:
  • Sun Java Platform, Standard Edition 6
  • Short form:  Java SE 6
The full name of the specific product within this family that we require for E-Business Suite application tier servers is:
  • Java Standard Edition Development Kit 6
  • Short form:  JDK 6
This release version is called JDK 6, 1.6, or 1.6.0.  All three version numbers are equivalent to each other.  When the base release is updated, the version number looks like one of the following (which are all equivalent): 
  • JDK 6 Update 2
  • JDK 6u2
  • 1.6.0_2
The previous release was Java 2 Platform, Standard Edition 5.0, with the short form being J2SE 5.0Other related terms equated over the years with this product family are Java SE Development Kit (JDK), and Java 2 Enterprise Edition Software Development Kit (J2SDK). 

For simplicity, for the remainder of this article (and in our official certification documentation), we'll use the term JDK 6.

What's New?

E-Business Suite Release 12.0.0 to 12.0.4 are delivered with:
  • Java SE Development Kit (JDK) Version 5.0 Update 8 for the application tier
  • Java SE Runtime Environment (JRE) Version 1.5 Update 8 for AutoConfig running on the database tier 
With this latest certification, all Release 12 environments may be upgraded to Java 6, formally known as:
  • Java SE Development Kit (JDK) Version 6.0 Update 2
Why Bother Upgrading?

Along with Oracle Forms, Java lies at the heart of the Oracle E-Business Suite.  Small improvements in Java can have significant effects on the performance and stability of the E-Business Suite.  As a notable side-benefit, later versions of Java have improved built-in and third-party tools for JVM performance monitoring and tuning.

Our standing recommendation is that you always stay current with the latest available Java update provided by your operating system vendor. 

Due to issues found with earlier updates of JDK 6.0, we recommend against using any Java 6 releases prior to JDK 1.6.0_02 with the E-Business Suite Release 12.

Prerequisites
It's important to note that OracleAS 10.1.3.3.0 is a mandatory prerequisite if you plan to upgrade your Release 12 application tier to the latest certified version of Java 6.

Documentation
Related Articles

Thursday Jan 24, 2008

OracleAS 10.1.3.3 Certified with E-Business Suite Release 12

The E-Business Suite Release 12 technology stack includes OracleAS 10.1.2 for Forms and OracleAS 10.1.3 OC4J for running Java-based content.  Release 12 users can already upgrade Oracle Forms to a newer version, so I'm pleased to announce that it's now possible to upgrade the OC4J components to the latest version of OracleAS 10g 10.1.3.3.0.  This latest certification allows Apps 12 users to take advantage of performance and stability improvements in the latest OracleAS 10g OC4J release.

[Read More]

Single Sign-On 10g 10.1.4.2 Certified with Release 12

New Apps certifications are just flying out of our labs this week.  I'm pleased to announce that the latest versions of Single Sign-On and Oracle Internet Directory 10g 10.1.4.2 are now certified with the E-Business Suite Release 12.  Existing Release 12 environments using earlier versions of SSO & OID 10g may be upgraded to 10.1.4.2.[Read More]

Wednesday Jan 23, 2008

Hidden Features Revealed: Technology Inventory Utility for Apps 12

[Oct 24, 2008 Update: It turns out that this utility is documented in Chapter 5 of the "System Administrator's Guide - Maintenance." Who knew? So much documentation, so little time.]

[Editor:  One of the best-kept secrets in the Release 12 technology stack is an undocumented utility for generating reports about your servers.  This tool is a useful complement to the R12 Diagnostic Tools, and a handy way of getting a snapshot of the different ORACLE_HOMEs for a given node in your environment.  In this article, Prasad gives a quick rundown on using this hidden tool.]


The Technology Inventory Utility for Release 12 is a perl utility that uses the perl infrastructure installed with the Oracle E-Business Suite R12 technology stack. Here's a screenshot of the first few lines of the report (there's much more -- see the samples linked, below):

Technology Inventory Utility Sample Screenshot: Screenshot of sample Technology Inventory Utility report for E-Business Suite Release 12

This utility is available with the Release Update Pack 12.0.3 and higher. If you don't wish to apply that entire RUP, this utility can be applied via the latest Autoconfig patchset:

How to run the utility

On each of the Applications tier nodes:
  1. Source the env file on each of the Applications tier node
  2. Run the following command (all on a single line):

    $ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl
    -txktop=$APPLTMP
    -outfile=$APPLTMP/Report_Inventory.html


  3. Enter the apps password at the prompt
  4. Check the report generated in the location specified in the outfile argument of the command above.
The report generated by this utility is HTML by default. A text report also can be generated using a command line option.

On each of the DB tier nodes:
  1. Source the env file on each of the DB tier node
  2. Run the following command (all on a single line):

    $ADPERLPRG $ORACLE_HOME/appsutil/bin/TXKScript.pl 
    -script=$ORACLE_HOME/appsutil/bin/txkInventory.pl
    -txktop=$ORACLE_HOME/appsutil/temp
    -contextfile=$CONTEXT_FILE
    -outfile=$ORACLE_HOME/appsutil/temp/rep.html

  3. Enter the apps password at the prompt
  4. Check the report generated in the location specified in the outfile argument of the command above.
Information in the Report

This utility generates three different tables with node-specific information.

Overview of your system
  • Time stamp, Host name,Enabled services(depending on the node type, the following services will be displayed - Root Service, Web Entry Point Services, Web Application Services, Other Services)
  • Instance name, Platform, OS release,DB Host
  • Context file location,Report file location
List of Component Versions and Properties

The information listed here depends on the node type.

For a middle-tier HTTP service, versions of the following components are listed:
    • Oracle Application Server, Sun JDK, JDK on HTTP server node, AOLJ, BC4J, BI Beans, HTTP client, Java object cache, JRAD libraries, MDS, OA Framework, Oracle Help for Web, Oracle XML driver, UIX, OJSP, JDK version used by AD utilities on HTTP node, DB client(RSF) in 10.1.3 the Oracle Home, OWA packages
For a middle-tier Forms service, versions of the following components are listed:
    • 10g Developer, DB client(RSF) in the 10.1.2 Oracle Home, Forms run time configuration, JDK used by AD utilities in the Forms service node, Oracle Applciation Server patchset
For a middle-tier Concurrent Processing service, versions of the following components are listed:
    • JDK and JDK used by the AD utilities
For the DB-tier service, the following information is generated:
    • Database version, DB patchset version
    • init.ora parameters set by Autoconfig
    • If the node is RAC enabled or not
List of Applied Patches

The Code Inventory table list the one-off patches applied on each of the Oracle Home based on the node type.
    • For a middle-tier node - list of the one-off patches and the date they were applied on the C-Oracle Home ( 10.1.2), on the Java Oracle Home ( 10.1.3 OC4J)

    • For a DB tier node - list of the one-off patches and the date they were applied on the DB Oracle Home.
Sample Reports

Two samples of the database tier and application tier reports are available here:
Related Articles

Wednesday Jan 16, 2008

Apps Technology 12.0.4 Update Now Available

In conjunction with this week's release of the Applications 12.0.4 Release Update  Pack, the fourth major update for the Apps Release 12 technology stack is now available for download from Metalink:
Apps Technology 12.0.4 Update screenshot: Screenshot of download page for Apps Technology 12.0.4 techstack patch 6272680 update

Family Pack Updates vs. Release Update Packs

New readers might have missed previous discussions about naming standards. To recap:  in Release 11i, we have these things called Rollup Patches, which inexplicably became known as "RUPs."  Release 11i Rollup Patches contain patches for a single product family (e.g. ATG Family Pack H Rollup 4).

In Release 12, we're now shipping these things called Release Update Packs.  Given the way that neologisms form, it's inevitable that these will be called "RUPs" too.  The difference is that the R12 Release Update Packs combine patches created across several E-Business Suite product families. 

The patch that we're announcing today only includes updates for the Applications Technology family of products, that is, the technology stack for the E-Business Suite Release 12.  This patch does not include updates to the functional applications like Financials or HRMS.  For information about the broader Apps 12.0.4 Release Update Pack, see:
This ATG rollup patch includes all fixes released on top of ATG Family Pack A, including those released in the following updates:
Since this is the fourth update to the Release 12 technology stack, its official (admittedly cryptic) name is: R12.ATG_PF.A.DELTA.4.

Prerequisites

This ATG Family Pack update can be applied on top of the following:
What's Been Fixed?

This update contains fixes for the following areas:
  • Oracle Application Object Library (AOL)
  • Oracle Applications Manager (OAM)
  • Oracle CRM Applications Foundation
  • Oracle Report Manager
  • Oracle Applications Technology Stack
  • Oracle Web Applications Desktop Integrator (WebADI)
  • Oracle Workflow
  • Oracle XML Publisher
  • Oracle e-Commerce Gateway
For a complete list of the contents of this update, see:
Related

Tuesday Jan 15, 2008

Apps Release 12.0.4 Release Update Pack Now Available

The fourth major update for Apps Release 12 is now available for download from Metalink:

E-Business Suite 12.0.4 Patch 6435000: Screenshot of download site for E-Business Suite Release 12.0.4 Release Update Pack Patch 6435000

A RUP by Any Other Name...

To revisit oft-confused terminology once again:  In Release 11i, we have these things called Rollup Patches, which inexplicably became known as "RUPs."  Release 11i Rollup Patches contain patches for a single product family (e.g. ATG Family Pack H Rollup 4).

In Release 12, we're now shipping these things called Release Update Packs.  Given the way that neologisms form, it's inevitable that these will be called "RUPs" too.  The difference is that the R12 Release Update Packs combine patches created across several E-Business Suite product families.

If you're paying attention, it should be dawning on you about now that "Release Update Packs" in Release 12 are the equivalent of "Consolidated Updates" in Release 11i.  These are big, important patches.

What's New in Release Update Pack 4?

Regardless of what it's called, the fourth Release Update Pack for Release 12 contains fixes for the following product families, with details in the corresponding Metalink Notes:
Includes January 2008 Critical Patch Updates

Just like the previous Apps 12.0.1 Release Update Pack, Apps 12.0.2 Release Update Pack, and Apps 12.0.3 Release Update Pack, there's a gem buried in all of this:  the Apps 12.0.4 Release Update Patch includes all of the security fixes released in the January 2008 Critical Update Patch (CPUJan2008).

Upgrading the Whole Thing or Just Specific Parts?

If you're looking for the latest new functionality, fixes, and updates for all Release 12 functional applications and the E-Business Suite's technology stack, apply the Apps 12.0.4 Release Update Pack.

You can also update specific Apps functional applications (such as Financials, Supply Chain Planning, or Human Resources).  See the Metalink Notes for each of the individual products listed above.

If you're just interested in getting the latest Apps technology stack updates and don't wish to update your functional applications, you can apply just the Oracle Applications Technology Software Update 12.0.4 (Patch 6272680), also known as R12.ATG_PF.A.DELTA.4.

I'll highlight details about new Applications Technology Stack features and updates in Apps 12.0.4 in an upcoming article tomorrow.

Related

Friday Dec 28, 2007

Essential Debugging Tools For Apps 12

E-Business Suite Release 12 includes Oracle Application Server 10g components for Forms and Java, each hosted in their own ORACLE_HOMEs.  A couple of colleagues in my team have published a pair of complementary Metalink Notes about debugging, diagnostic, and tracing tools in E-Business Suite Release 12.  It's high time that I got around to profiling those notes here.

Release 12 Techstack Overview: Overview of three-tier logical architecture for E-Business Suite Release 12, including the database, application server, and desktop tiers. 

Debugging Java Components in Release 12

The first Note highlights a series of Java-related problem scenarios that you might encounter with Release 12:
This useful document highlights possible symptoms, log files, useful scripts and other tools that can be used to change logging levels to track down issues with:
  • Oracle Process Manager and Notification Server (OPMN)
  • Oracle HTTP Server (Apache)
  • Oracle Containers for J2EE (OC4J)
  • Configured Application Modules, including:
    • OACORE - Core Application Modules
    • OAFM - Oracle Transport Agent, MapViewer
    • FORMS - Forms (using Servlet Mode)
Some common problem scenarios highlighted:
  • OPMN errors at startup
  • HTTP Server fails at startup
  • OC4J Applications Modules (e.g. oacore, forms, oafm) fail at startup
  • HTML requests complete but Java requests fail
  • HTML and Java requests complete but Applications Login page fails
  • Applications Login page is displayed but login fails
It also provides pointers to ways of monitoring or debugging the following components:
  • OPMN
  • Java Object Cache Monitor
  • Applications Server Forms Servlets
  • Class Loaders
The Note wraps up with useful summaries of all of the relevant log files used by OPMN, Oracle HTTP Server (OHS), and the various J2EE Applications modules.

Debugging Forms Components in Release 12

The second Note covers the Forms part of that territory:
This document highlights techniques for using Forms Trace as part of your diagnostic toolkit.  Forms Trace offers detailed data collection and other features to help drill down into Forms runtime problems.  The Note covers:
  • Activating Forms Trace via Application profiles
  • Defining Trace Groups to isolate problems more efficiently
  • Tips on interpreting Trace Files
  • Tips on using the legacy Forms Runtime Diagnostics (FRD) utility
Both of these documents are useful additions to any R12 sysadmin's toolkit.  If you have feedback or questions about these documents, feel free to post your thoughts here.  If we're lucky, you might get a chance to interact directly with the Notes' authors.

Related Articles

Wednesday Dec 19, 2007

Linux Itanium and Windows Itanium Certified for Release 12 Database Tier

The E-Business Suite Release 12 is now certified with Oracle Database Server 10gR2 version 10.2.0.3 on Linux Itanium and Windows Itanium platforms.

Itanium Chip:

This is a database tier-only certification (previously known in Release 11i as a "split configuration") where the application tier must be on a supported E-Business Suite platform.

Prerequisites
References
Related Articles

About

Search

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