Wednesday Mar 05, 2014

Oracle Database 11.2.0.4 Certified with E-Business Suite 12.2

I'm very happy to announce the certification of Oracle Database 11.2.0.4 with Oracle E-Business Suite 12.2. 

To begin planning your database upgrade to 11.2.0.4, you should review our documentation in this order:

  1. Interoperability Notes: Oracle E-Business Suite 12.2 with Oracle Database 11g Release 2 (Note 1623879.1) 

  2. R12.2 Consolidated List of Patches and Technology Bug Fixes (Note 1594274.1) .  The interoperability note references this note.  It is crucial that you review all requirements in Section 2.2, "Database 11.2.0.4 Patches and Bug Numbers" of this note.

  3. Database Initialization Parameters for Oracle E-Business Suite Release 12 (Note 396009.1).  Make certain that you review Section 4, "Release-Specific Database Initialization Parameters For Oracle 11gR2" and Section 6, "Additional Database Initialization Parameters for Oracle E-Business Suite Release 12.2".

What does this mean if you are upgrading to R12.2?

  • This upgrade is highly recommended for all EBS 12.2 environments.

  • If you are just beginning your upgrade to R12.2 project, you should consider upgrading to Oracle Database 11.2.0.4 now. 

  • If your are currently in the midst of your R12.2 upgrade, you may continue as planned with Oracle Database 11.2.0.3 and upgrade to 11.2.0.4 as your R12.2 upgrade project and test plans permit.

  • If your go-live date is soon, you may choose to continue as planned with Oracle Database 11.2.0.3 and upgrade to 11.2.0.4 after you go-live with 12.2.

It may be useful to review the the Oracle Database 11gR2 support policies and dates as part of your decision-making process:

Prerequisites

  • 12.2.2 and higher
Certified Platforms
  • Linux x86-64 (Oracle Linux 5, 6)
  • Linux x86-64 (RH 5, 6)
  • Linux x86-64 (SLES 10, 11)
  • Oracle Solaris on SPARC (64-bit)  (10, 11)
  • Oracle Solaris on x86-64 (64-bit) (10, 11) -  Database tier only
  • IBM AIX on Power Systems (64-bit) (6.1, 7.1)
  • HP-UX Itanium (11.31)
Pending Platform Certifications
  • Microsoft Windows x64 (64-bit)
  • IBM: Linux on System z 
Database Feature and Option Certifications
The following database features and options are certified:

Pending Database Feature and Option Certifications

  • Database Vault

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.    

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.

Friday Feb 14, 2014

Oracle Database 11.2.0.4 Certified with EBS 11i on Additional HP Platforms

HP logoAs a follow up to the prior announcements on November 20th 2013, Oracle Database 11g Release 2 (11.2.0.4) is now certified with Oracle E-Business Suite Release 11i (11.5.10.2 + ATG PF.H RUP 6 and higher) on the following additional platforms:

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

1 : This is a 'database tier only' or 'split tier configuration' certification where the application tier must be on a fully certified E-Business Suite platform.

This announcement for Oracle E-Business Suite 11i includes:
  • Oracle Database 11gR2 version 11.2.0.4
  • Oracle Database 11gR2 version 11.2.0.4 Real Application Clusters (RAC)
  • Oracle Database Vault 11gR2 version 11.2.0.4
  • Transparent Data Encryption (Column Encryption) using Oracle Database 11gR2 version 11.2.0.4
  • TDE Tablespace Encryption using Oracle Database 11gR2 version 11.2.0.4
  • Advanced Security Option (ASO)/Advanced Networking Option (ANO) with Oracle Database 11gR2 version 11.2.0.4
  • 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.

Friday Jan 17, 2014

EBS 12.2 Certified with Database 11.2.0.3 for Additional "Database Tier-only" Platforms

I am pleased to announce that Oracle E-Business Suite Release 12.2 (12.2.2 or higher) is now certified with the Oracle Database 11gR2 (11.2.0.3) for the Linux on IBM System z and Oracle Solaris on x86-64 platforms running on the database tier with the following OS versions:

For Oracle Solaris on x86-64:

  • Oracle Solaris 10 on x86-64 (64-bit)
  • Oracle Solaris 11 on x86-64 (64-bit)

For Linux on IBM System z:

  • Red Hat Enterprise Linux (RHEL) version 5 (64-bit)
  • Red Hat Enterprise Linux (RHEL) version 6 (64-bit)
  • Novell SUSE Linux Enterprise Server (SLES) version 10 (64-bit)
  • Novell SUSE Linux Enterprise Server (SLES) version 11 (64-bit)

The application tier of the E-Business Suite 12.2 is not certified with the above platforms, only the database tier; customers must run the application tier on fully certified platforms using the 12.2 software provided as part of our release (see 'Oracle E-Business Suite 12.2 Now Available').

This announcement for E-Business Suite Release 12.2 includes the following (as well as other features and options):

  • Oracle Database 11gR2 version 11.2.0.3
  • Oracle Database Real Application Clusters (RAC) 11gR2 version 11.2.0.3
  • Oracle Database Vault 11gR2 version 11.2.0.3
  • Transparent Data Encryption (TDE) Column Encryption using Oracle Database 11gR2 version 11.2.0.3
  • TDE Tablespace Encryption using Oracle Database 11gR2 version 11.2.0.3
  • Advanced Security Option (ASO)/Advanced Networking Option (ANO) with Oracle Database 11gR2 version 11.2.0.3
  • Export/Import Process for Oracle E-Business Suite Release 12 Database Instances

References

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

Friday Dec 06, 2013

11.2.0.4 Database Certified with E-Business Suite on 11 New Platforms

As a follow up to our prior announcements, Oracle Database 11g Release 2 (11.2.0.4) is now certified with Oracle E-Business Suite Release 11i and Release 12 on the following additional platforms:

EBS Release 12.1 (12.1.1 or higher):

  • Oracle Solaris on SPARC (64-bit) (10, 11)
  • Oracle Solaris on x86-64 (64-bit) (10)1
  • HP-UX Itanium (11.31)
  • IBM AIX on Power Systems (64-bit) (5.3, 6.1, 7.1)
EBS Release 12.0 (12.0.4 or higher):
  • Oracle Solaris on SPARC (64-bit) (10)
  • Oracle Solaris on x86-64 (64-bit) (10)1
  • HP-UX Itanium (11.31)
  • IBM AIX on Power Systems (64-bit) (5.3, 6.1, 7.12)

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

  • Oracle Solaris on SPARC (64-bit) (10, 111)
  • Oracle Solaris on x86-64 (64-bit) (10)1
  • IBM AIX on Power Systems (64-bit) (5.3, 6.1)

1 : This is a 'database tier only' or 'split tier configuration' certification where the application tier must be on a fully certified E-Business Suite platform.
2 : Certified for 12.0.6

This announcement for Oracle E-Business Suite R12 and 11i includes:
  • Oracle Database 11gR2 version 11.2.0.4
  • Oracle Database 11gR2 version 11.2.0.4 Real Application Clusters (RAC)
  • Oracle Database Vault 11gR2 version 11.2.0.4
  • Transparent Data Encryption (Column Encryption) using Oracle Database 11gR2 version 11.2.0.4
  • TDE Tablespace Encryption using Oracle Database 11gR2 version 11.2.0.4
  • Advanced Security Option (ASO)/Advanced Networking Option (ANO) with Oracle Database 11gR2 version 11.2.0.4
  • 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
Where can I find more information?

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

Related Articles

Thursday Nov 21, 2013

Can You Use Third-Party Tools to Modify Your EBS Database?

In short: no. But it's possible to give a more-nuanced answer for one scenario where they might be useful.

Our official policy on direct modifications to EBS databases

Every Oracle E-Business Suite manual in our documentation library contains this warning (emphasis added):

Do Not Use Database Tools to Modify Oracle E-Business Suite Data

Oracle STRONGLY RECOMMENDS that you never use SQL*Plus, Oracle Data Browser, database triggers, or any other tool to modify Oracle E-Business Suite data unless otherwise instructed.

Oracle provides powerful tools you can use to create, store, change, retrieve, and maintain information in an Oracle database. But if you use Oracle tools such as SQL*Plus to modify Oracle E-Business Suite data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data.

Because Oracle E-Business Suite tables are interrelated, any change you make using an Oracle E-Business Suite form can update many tables at once. But when you modify Oracle E-Business Suite data using anything other than Oracle E-Business Suite, you may change a row in one table without making corresponding changes in related tables. If your tables get out of synchronization with each other, you risk retrieving erroneous information and you risk unpredictable results throughout Oracle E-Business Suite.

When you use Oracle E-Business Suite to modify your data, Oracle E-Business Suite automatically checks that your changes are valid. Oracle E-Business Suite also keeps track of who changes information. If you enter information into database tables using database tools, you may store invalid information. You also lose the ability to track who has changed your information because SQL*Plus and other database tools do not keep a record of changes.

Can data corruption really occur?

Yes. Even if you're using SQL*Plus, which is obviously not a third-party tool, you run the risk of corrupting your EBS database.  This is true for all tools that modify an EBS database directly.

What about third-party data archiving and purging tools?

Some third-party tools reduce the size of EBS databases by deleting data.  Some use database links, aliases, and other approaches to separate older data into other databases.

These tools can be useful for reducing the size of a production database for development purposes.  It generally doesn't matter if these smaller sandbox or testbed databases have referential integrity violations.

You should never use these tools to reduce the size of your production EBS database.

Why are these tools dangerous?  They claim that they're safe.

The E-Business Suite data model is partially documented here:

Unfortunately, that manual is not comprehensive. Third-party tools that rely on it to determine data relationships in the EBS data model will miss important dependencies.

EBS data dependencies are implemented through seed data, business logic, and other undocumented areas.  These hidden and undocumented dependencies mean that only current EBS Development staff are qualified to determine whether data can be safely removed. 

It is certain that third-party tools will violate EBS database referential integrity in some manner.  This is true even for third-party tools that are produced by people who used to work for Oracle EBS development.  EBS products continue to evolve and new dependencies are introduced on a regular basis.  These new dependencies may be undocumented.

What are the support implications of using third-party tools?

Oracle regards the use of third-party database tools to be customizations. Oracle's official policy is detailed here:

You should also review the support implications for using third-party tools.  They boil down to this:

  • Issues that are isolated to the E-Business Suite will be investigated by E-Business Suite Development.
  • Issues that are isolated to third-party tools should be directed to the third-party vendor.
  • E-Business Suite Development will provide E-Business Suite Development patches for issues that can be reproduced in environments built using E-Business Suite documented procedures and tools.
  • If the third-party vendor cannot resolve issues isolated to their tools, you should restore from a backup and revert to using Oracle’s documented tools and procedures.

Related Articles


Friday Sep 27, 2013

11.2.0.4 Database Certified with E-Business Suite

I’m pleased to announce that 11.2.0.4, the terminal patchset for the 11gR2 Database is now certified with Oracle E-Business Suite. Be sure to review the interoperability notes for R11i and R12 for the most up-to-date requirements for deployment.

Database support implications may also be reviewed in the database patching and support article.


Oracle E-Business Suite Release 11i

Prerequisites
  • 11.5.10.2 + ATG PF.H RUP 6 and higher
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)
Pending Platform Certifications
  • Oracle Solaris on SPARC
  • Oracle Solaris on x86-64 (64-bit)
  • IBM AIX on Power Systems
  • HP-UX Itanium
  • Microsoft Windows Server (32-bit)
  • Microsoft Windows x64 (64-bit)
  • HP-UX PA-RISC (64-bit)
  • IBM: Linux on System z 
Oracle E-Business Suite Release 12.0.4 and higher
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)
Pending Certifications
  • Oracle Solaris on SPARC 
  • Oracle Solaris on x86-64
  • IBM AIX on Power Systems (64-bit)
  • HP-UX Itanium
  • Microsoft Windows Server (32-bit)
  • Microsoft Windows x64 (64-bit)
  • HP-UX PA-RISC (64-bit)
  • IBM: Linux on System z
Oracle E-Business Suite Release 12.1.1 and higher
Certified Platforms
  • Linux x86 (Oracle Linux 4, 5, 6)
  • Linux x86 (RHEL 4, 5, 6)
  • Linux x86 (SLES 10)
  • Linux x86-64 (Oracle Linux 4, 5, 6)
  • Linux x86-64 (RHEL 4, 5, 6)
  • Linux x86-64 (SLES 10, 11)
Pending Certifications
  • Oracle Solaris on SPARC 
  • Oracle Solaris on x86-64
  • IBM AIX on Power Systems (64-bit)
  • HP-UX Itanium
  • Microsoft Windows Server (32-bit)
  • Microsoft Windows x64 (64-bit)
  • HP-UX PA-RISC (64-bit)
  • IBM: Linux on System z
Database Feature and Option Certifications
The following database options and features are supported for use:
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.

12.1.0.1 Database Certified with Oracle E-Business Suite

(Feb 19, 2014 Update: Article has been updated to correctly reflect Active Data Guard and Data Guard as pending certifications.)

I’m pleased to announce that 12.1.0.1, the base release for the 12c Database is now certified. Be sure to review the interoperability notes for R11i and R12 for the most up-to-date requirements for deployment.

Database support implications may also be reviewed in the database patching and support article.


Oracle E-Business Suite Release 11i

Prerequisites
  • 11.5.10.2 + ATG PF.H RUP 7 and higher
Certified Platforms
  • Linux x86-64 (Oracle Linux 5) -- Database-tier only
  • Linux x86-64 (RHEL 5) -- 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 x64 (64-bit)
  • IBM AIX on Power Systems (64-bit)
  • HP-UX Itanium
  • IBM: Linux on System z 
Oracle E-Business Suite Release 12.0.6 and higher
Certified Platforms
  • Linux x86-64 (Oracle Linux 5)
  • Linux x86-64 (RHEL 5)
  • Oracle Solaris on SPARC (64-bit) (10)
  • Oracle Solaris on x86-64 (64-bit) (10) -- Database-tier only
Pending Platform Certifications
  • Microsoft Windows x64 (64-bit)
  • IBM AIX on Power Systems (64-bit)
  • HP-UX Itanium
  • IBM: Linux on System z 
    Oracle E-Business Suite Release 12.1.3 and higher
    Certified Platforms
    • Linux x86-64 (Oracle Linux 5, 6)
    • Linux x86-64 (RHEL 5, 6)
    • Linux x86-64 (SLES 11)
    • Oracle Solaris on SPARC (64-bit) (10, 11)
    • Oracle Solaris on x86-64 (64-bit) (10, 11) -- Database-tier only
    Pending Platform Certifications
    • Microsoft Windows x64 (64-bit)
    • IBM AIX on Power Systems (64-bit)
    • HP-UX Itanium
    • IBM: Linux on System z 
    Database Feature and Option Certifications
    The following database options and features are supported for use:

    Pending Feature/Option Certifications

    • Active Data Guard
    • Data Guard Redo Apply with Physical Standby Databases
    • Oracle Multitenant
    • Oracle Database Vault
    • Transportable Database and Transportable Tablespaces data migration processes

    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.

    Thursday Aug 01, 2013

    New Source Database Added for EBS 12 + 11gR2 Transportable Tablespaces

    The Transportable Tablespaces (TTS) process was originally certified for the migration of E-Business Suite R12 databases going from a source database of 11gR1 or 11gR2 to a target of 11gR2.

    This requirement has now been expanded to include a source database of 10gR2 (10.2.0.5) - this will potentially save time for existing 10gR2 customers as they can remove on a crucial upgrade step prior to performing the platform migration.

    Transportable Tablespaces supported options

    The migration process requires an updated Controlled patch delivered by the Oracle E-Business Suite Platform Engineering team, i.e. it requires a password obtainable from Oracle Support. We released the patch in this manner to gauge uptake, and help identify and monitor any customer issues due to the nature of this technology. This patch has been updated to now include supporting 10gR2 as a source database.

    Does it meet your requirements?

    Note that for migration across platforms of the same "endian" format, users are advised to use the Transportable Database (TDB) migration process instead for large databases. The "endian-ness" target platforms can be verified by querying the view V$DB_TRANSPORTABLE_PLATFORM using SQL*Plus (connected as sysdba) on the source platform:

    SQL>select platform_name from v$db_transportable_platform;

    If the intended target platform does not appear in the output, it means that it is of a different endian format from the source. Consequently. database migration will need to be performed via Transportable Tablespaces (for large databases) or export/import.

    The use of Transportable Tablespaces can greatly speed up the migration of the data portion of the database. However, it does not affect metadata, which must still be migrated using export/import. We recommend that users initially perform a test migration on their database, using export/import with the 'metrics=y' parameter. This will help identify the relative amounts of data and metadata, and provide a basis for assessing likely gains in timing. In general, the larger the amount of data (compared to metadata), the greater the reduction in downtime that can be expected from using TTS as a migration process.

    For smaller databases or for those that have relatively small data compared to metadata, TTS will not be as beneficial for cross endian migration and the use of export/import (datapump) for the whole database is recommended.

    Where can I find more information?

    Related Articles

    Tuesday Jul 09, 2013

    Latest DSTv20 Timezone Patches Available for E-Business Suite

    Hourglass iconIf your E-Business Suite Release 11i, 12.0, or 12.1 environment is configured to support Daylight Saving Time (DST) or international time zones, it's important to keep your timezone definition files up-to-date. They were last changed in January 2013 and released as DSTv19.

    DSTv20 is now available and certified with Oracle E-Business Suite Release 11i, 12.0, and 12.1. The DSTv20 update includes the timezone information from Olson tzdata 2012j and is cumulative: it includes all previous Oracle DST updates. 

    Is Your Apps Environment Affected?

    When a country or region changes DST rules or their time zone definitions, your Oracle E-Business Suite environment will require patching if:

    • Your Oracle E-Business Suite environment is located in the affected country or region OR
    • Your Oracle E-Business Suite environment is located outside the affected country or region but you conduct business or have customers or suppliers in the affected country or region

    The latest DSTv20 timezone definition file is cumulative and includes all DST changes released in earlier time zone definition files. DSTv20 includes changes to the following timezones since the DSTv19 release:

    • Africa/Casablanca,
    • America/Port-au-Prince,
    • America/Santiago,
    • America/Asuncion,
    • Antarctica/Palmer,
    • Asia/Gaza,
    • Asia/Hebron,
    • Pacific/Easter,
    • Chile/Continental,
    • Chile/EasterIsland

    What Patches Are Required?

    In case you haven't been following our previous time zone or Daylight Saving Time (DST)-related articles, international timezone definitions for E-Business Suite environments are captured in a series of patches for the database and application tier servers in your environment. The actual scope and number of patches that need to be applied depend on whether you've applied previous DST or timezone-related patches. Some sysadmins have remarked to me that it generally takes more time to read the various timezone documents than it takes to apply these patches, but your mileage may vary.

    We've published the following Notes which identify the various components in your E-Business Suite environment that may need DST patches:


    Tuesday Jul 02, 2013

    Plans for Certifying Oracle Database 12c with E-Business Suite

    Oracle Database 12c Logo

    [Oct. 24, 2013 Update: Database 12.1.0.1 is certified with the E-Business Suite]

    The Oracle Database 12c is now officially released.  We're as excited about this new database release as you are. 

    In fact, we've been testing a wide variety of E-Business Suite releases and configurations with internal DB 12c betas for some time.  This testing is going well, but as usual, Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates

    You're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.   


    Tuesday Feb 12, 2013

    New Source Databases Added for Transportable Tablespaces + EBS 11i

    The Transportable Tablespace (TTS) process was originally certified for migrating E-Business Suite 11i databases across different "endian" (byte ordering) formats from 11gR2 source databases to 11g2 target databases.

    This certification has now been expanded to include two new source database releases:

    • Database 11gR1 11.1.0.7
    • Database 10gR2 10.2.0.5

    Endian formats supported

    Obtaining this patch

    This migration process requires a Controlled patch delivered by the Oracle E-Business Suite Platform Engineering team, i.e. it requires a password obtainable from Oracle Support. We released the patch in this manner to gauge uptake, and help identify and monitor any customer issues due to the nature of this technology. 

    Does it meet your requirements?

    Note that for migration across platforms of the same "endian" format, users are advised to use the Transportable Database (TDB) migration process instead for large databases. The "endian-ness" target platforms can be verified by querying the view V$DB_TRANSPORTABLE_PLATFORM using SQL*Plus (connected as sysdba) on the source platform:

    SQL>select platform_name from v$db_transportable_platform;

    If the intended target platform does not appear in the output, it means that it is of a different endian format from the source. Consequently. database migration will need to be performed via Transportable Tablespaces (for large databases) or export/import.

    The use of Transportable Tablespaces can greatly speed up the migration of the data portion of the database. However, it does not affect metadata, which must still be migrated using export/import. We recommend that users initially perform a test migration on their database, using export/import with the 'metrics=y' parameter. This will help identify the relative amounts of data and metadata, and provide a basis for assessing likely gains in timing. In general, the larger the amount of data (compared to metadata), the greater the reduction in downtime that can be expected from using XTTS as a migration process.

    Where can I find more information?

    Related Articles

    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

    Monday Jan 28, 2013

    Latest DSTv19 Timezone Patches Available for E-Business Suite

    Hourglass iconIf your E-Business Suite Release 11i or 12 environment is configured to support Daylight Saving Time (DST) or international time zones, it's important to keep your timezone definition files up-to-date. They were last changed in July 2012 and released as DSTv18.

    DSTv19 is now available and certified with Oracle E-Business Suite Release 11i and 12. The DSTv19 update includes the timezone information from Olson tzdata 2012j and is cumulative: it includes all previous Oracle DST updates. 

    Is Your Apps Environment Affected?

    When a country or region changes DST rules or their time zone definitions, your Oracle E-Business Suite environment will require patching if:

    • Your Oracle E-Business Suite environment is located in the affected country or region OR
    • Your Oracle E-Business Suite environment is located outside the affected country or region but you conduct business or have customers or suppliers in the affected country or region

    The latest DSTv19 timezone definition file is cumulative and includes all DST changes released in earlier time zone definition files. DSTv19 includes changes to the following timezones since the DSTv18 release:

    • Africa/Tripoli,
    • Africa/Casablanca,
    • America/Bahia,
    • America/Havana,
    • America/Araguaina,
    • Asia/Jerusalem,
    • Asia/Amman,
    • Asia/Gaza,
    • Asia/Hebron,
    • Pacific/Fiji,
    • Pacific/Apia,
    • Pacific/Fakaofo,
    • Libya,
    • Cuba,
    • Asia/Tel_Aviv,
    • Israel

      What Patches Are Required?

      In case you haven't been following our previous time zone or Daylight Saving Time (DST)-related articles, international timezone definitions for E-Business Suite environments are captured in a series of patches for the database and application tier servers in your environment. The actual scope and number of patches that need to be applied depend on whether you've applied previous DST or timezone-related patches. Some sysadmins have remarked to me that it generally takes more time to read the various timezone documents than it takes to apply these patches, but your mileage may vary.

      We've published the following Notes which identify the various components in your E-Business Suite environment that may need DST patches:


      Thursday Aug 16, 2012

      Oracle Database 11.2.0.3 Certified with EBS 12.0 on Windows Server 2008 R2

      As a follow up to our previous related certification, Oracle Database 11g Release 2 (11.2.0.3) is now certified with Oracle E-Business Suite Release 12 (12.0.4 and higher) on Microsoft Windows Server 2008 R2 (x64). Note that for Release 12.0, this platform is a 'database tier only' platform where the application tier must reside on a different fully certified E-Business Suite R12 platform.

      This announcement for Oracle E-Business Suite 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

      Where can I find more information?

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

      Tuesday Aug 14, 2012

      Oracle 10gR2 10.2.0.5 Certified with EBS on Windows Itanium

      As a follow-on to the original certification announcement, Oracle Database 10gR2 Patch Set 10.2.0.5.0 is now certified with Oracle E-Business Suite Release 11i and Release 12 (12.0, 12.1) on Microsoft Windows Itanium (64-bit) 2003.

      Note: This is a database-tier only certification (previously known as a 'split configuration database tier' certification) where the application tier must be on a fully certified E-Business Suite platform.

      The 10.2.0.5.0 patchset is the terminal release of the Oracle Database on this platform - users should review the following Support Note for more information:

      Certified Database Options and Features

      • Real Application Clusters 
      • Database Vault  
      • Transparent Data Encryption (TDE) Column Encryption
      • Advanced Security Option / Advanced Networking Option
      • Export/Import Process for Oracle E-Business Suite Release 1
      • Transportable Database Data Migration Process for Oracle E-Business Suite Release 12

      References

      Thursday Jul 19, 2012

      Latest DSTv18 Timezone Patches Available for E-Business Suite R12

      Hourglass iconIf your E-Business Suite Release 11i or 12 environment is configured to support Daylight Saving Time (DST) or international time zones, it's important to keep your timezone definition files up-to-date. They were last changed in October 2011 and released as DSTv17.

      DSTv18 is now available and certified with Oracle E-Business Suite Release 12. The DSTv18 update includes the timezone information from Olson tzdata 2012c. 

      Is Your Apps Environment Affected?

      When a country or region changes DST rules or their time zone definitions, your Oracle E-Business Suite environment will require patching if:

      • Your Oracle E-Business Suite environment is located in the affected country or region OR
      • Your Oracle E-Business Suite environment is located outside the affected country or region but you conduct business or have customers or suppliers in the affected country or region

      The latest DSTv18 timezone definition file is cumulative and includes all DST changes released in earlier time zone definition files. DSTv18 includes changes to the following timezones since the DSTv17 release:

      • Africa/Casablanca,
      • America/Bahia,
      • America/Havana,
      • America/Port-au-Prince,
      • America/Santiago,
      • America/Blanc-Sablon,
      • Antarctica/Casey,
      • Antarctica/Davis,
      • Antarctica/Palmer,
      • Asia/Yerevan,
      • Asia/Gaza,
      • Asia/Damascus,
      • Atlantic/Stanley,
      • Europe/Minsk,
      • Pacific/Easter,
      • Pacific/Fiji,
      • Pacific/Fakaofo,
      • Cuba,
      • Chile/Continental,
      • Chile/EasterIsland

      What Patches Are Required?

      In case you haven't been following our previous time zone or Daylight Saving Time (DST)-related articles, international timezone definitions for E-Business Suite environments are captured in a series of patches for the database and application tier servers in your environment. The actual scope and number of patches that need to be applied depend on whether you've applied previous DST or timezone-related patches. Some sysadmins have remarked to me that it generally takes more time to read the various timezone documents than it takes to apply these patches, but your mileage may vary.

      We've published the following Notes which identify the various components in your E-Business Suite environment that may need DST patches:

      Related Articles

      Friday May 04, 2012

      Quarterly E-Business Suite Upgrade Recommendations: May 2012 Edition

      I've previously published advice on the general priorities for applying EBS updates.  But what are your top priorities for major upgrades to EBS and its technology stack components?

      Here is a summary of our latest upgrade recommendations for E-Business Suite updates and technology stack components.  These quarterly recommendations are based upon the latest updates to Oracle's product strategies, support deadlines, and newly-certified releases. 

      Upgrade Recommendations for May 2012

      1. EBS 11i users should upgrade to 12.1.3, or -- if staying on 11i -- should be on the minimum 11i patching baseline,

      2. EBS 12.0 users should upgrade to 12.1.3, or -- if staying on 12.0 -- should be on the minimum 12.0 patching baseline,

      3. EBS 12.1 users should upgrade to 12.1.3.

      4. Oracle Database 10gR2 and 11gR1 users should upgrade to 11gR2 11.2.0.3.

      5. EBS 12 users of Oracle Single Sign-On 10g users should migrate to Oracle Access Manager 11g 11.1.1.5.

      6. EBS 11i users of  Oracle Single Sign-On 10g users should migrate to Oracle Access Manager 10g 10.1.4.3.

      7. Oracle Internet Directory 10g users should upgrade to Oracle Internet Directory 11g 11.1.1.5.

      8. Oracle Discoverer users should migrate to Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications (OBIA), or Discoverer 11g 11.1.1.6.

      9. Oracle Portal 10g users should migrate to Oracle WebCenter 11g 11.1.1.6 or upgrade to Portal 11g 11.1.1.6.

      10. All Windows desktop users should migrate from JInitiator and older Java releases to JRE 1.6.0_32 or later 1.6 updates.

      11. All Firefox users should upgrade to Firefox Extended Support Release 10.

      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

      Thursday Mar 22, 2012

      Oracle Database 11gR2 11.2.0.3 Certified with E-Business Suite on Windows

      Wndows LogoAs a follow up to our original certification 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 Microsoft Windows operating systems:

      Release 12.1 (12.1.1 and higher)

      • Microsoft Windows Server (32-bit) (2003, 2008)
      • Microsoft Windows x64 (64-bit) (20031, 20081, 2008 R22)

      Release 12.0 (12.0.4 and higher)

      • Microsoft Windows Server (32-bit) (2003)
      • Microsoft Windows x64 (64-bit) (2003, 2008)1
      Release 11i (11.5.10.2 + ATG PF.H RUP 6 and higher)
      • Microsoft Windows Server (32-bit) (2003, 20081)
      • Microsoft Windows x64 (64-bit) (2003, 2008, 2008 R2)1

      Notes

      1: This OS is a 'database tier only' or 'split tier configuration' platform where the application tier must be on a fully certified E-Business Suite platform.
      2: This OS is a 'database tier only' platform for Release 11i. For 12.1.1 or higher, it is also supported on the application tier via the migration process outlined in My Oracle Support Document 1188535.1.

      Pending Certification

      • E-Business Suite 12.0 with 11.2.0.3 Split Tier Certification on Microsoft Windows x64 (64-bit) (2008 R2) is in progress and will be announced separately.

      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 19, 2012

      Webcast Replay Available: E-Business Suite Data Protection

      I am pleased to release the replay and presentation for the latest ATG Live Webcast:

      E-Business Suite Data Protection (Presentation)

      Screenshot of E-Business Suite Data Access auditing


      Robert Armstrong, Product Strategy Security Architect and Eric Bing, Senior Director discussed the best practices and recommendations for securing your E-Business Suite data.

      Finding other recorded ATG webcasts

      The catalog of ATG Live Webcast replays, presentations, and all ATG training materials is available in this blog's Webcasts and Training section.

      Friday Mar 09, 2012

      Database 10gR2 10.2.0.5 Certified with EBS 12 on Itanium, Linux on Power

      As a follow up to our original certification announcement, Oracle Database 10gR2 Patch Set 10.2.0.5.0 is now certified with Oracle E-Business Suite Release 12 (12.0.4 and higher, 12.1.1 and higher) on the following additional database tier only platforms:

      • IBM: Linux on Power Systems (RHEL 5, SLES 10)
      • Linux Itanium (RHEL 5, SLES 10)

      These are database tier only (or split tier configuration) platforms where the application tier must reside on a different fully certified E-Business Suite R12 Platform.

      Screenshot of download page for 10.2.0.5 patchset

      Terminal patchset release for 10gR2 Database

      The 10.2.0.5 patchset is the terminal release of the Oracle Database on these platforms - users should review the following Support Notes for more information:

      Certified Database Options and Features

      This announcement includes:

      • Real Application Clusters
      • Database Vault 
      • Transparent Data Encryption (TDE) Column Encryption
      • Advanced Security Option / Advanced Networking Option
      • Export/Import Process for Oracle E-Business Suite Release 1
      • Transportable Database Data Migration Process for Oracle E-Business Suite Release 12

      Please refer the documents below for information pertaining to this certification. Updates to My Oracle Support's Certification data are in progress for this certification.

      References

      Related Articles

      Tuesday Feb 21, 2012

      ATG Live Webcast: E-Business Suite Data Protection

      How do you address the security challenges within an E-Business Suite database? How should you make the best use of auditing, separation of duties, and other Oracle technologies with Oracle E-Business Suite? Join us for this week's ATG Live Webcast on Feb. 23, 2012:

      E-Business Suite Data Protection

      Join Robert Armstrong, Product Strategy Security Architect and Eric Bing, Senior Director, as they discuss the best practices and recommendations for securing your E-Business Suite data. The agenda for the E-Business Suite Data Protection webcast includes the following topics:

      • E-Business Suite Security Challenges
      • Auditing in E-Business Suite
      • Separation of Duties
      • Other Oracle Technologies for Data Security

      Screenshot of E-Business Suite Data Access auditing

      Date:               Thursday, February 23, 2012

      Time:              8:00 AM - 9:00 AM Pacific Standard Time
      Presenters:  Robert Armstrong, Product Strategy Security Architect
                              Eric Bing, Senior Director

      Webcast Registration Link (Preregistration is optional but encouraged)

      To hear the audio feed:
          Domestic Participant Dial-In Number:           1-877-697-8128
          International Participant Dial-In Number:      1-706-634-9568
          Dial-In Passcode:                                              99336

      To see the presentation:
          The Direct Access Web Conference details are:
          Website URL: https://ouweb.webex.com
          Meeting Number:  593089134

      If you miss the webcast, or you have missed any webcast, don't worry -- we'll post links to the recording as soon as it's available from Oracle University.  You can monitor this blog for pointers to the replay. And, you can find our archive of our past webcasts and training here.

      If you have any questions or comments, feel free to email Bill Sawyer (Senior Manager, Applications Technology Curriculum) at BilldotSawyer-AT-Oracle-DOT-com.

      Tuesday Feb 14, 2012

      11gR2 11.2.0.3 Certified with EBS 12.1 on Oracle Solaris 11 (x86-64)

      Solaris logoAs a follow up to our original certification announcement, Oracle E-Business Suite Release 12.1 is now certified with the Oracle Database 11gR2 version 11.2.0.3 for Oracle Solaris 11 on x86-64 running on the database tier for the following platform and version:

      Release 12.1 (12.1.1 or higher) with Database version 11.2.0.3:

      • Oracle Solaris on x86-64 (64-bit) (11)
      The application tier of the E-Business Suite is not certified with Oracle Solaris 11 on x86-64. Customers must run the application tier on a different platform such as Oracle Solaris on SPARC.

      This announcement for E-Business Suite Release 12.1 includes the following (as well as other features and options):

      • 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

      Where can I find more information?

      Please also review the Oracle Database Installation Guide 11g Release 2 (11.2) for Oracle Solaris for operating system and other prerequisites.

      11gR2 11.2.0.3 Database Certified with EBS on IBM: Linux on System z

      As a follow up to our original certification announcement, Oracle Database 11g Release 2 version 11.2.0.3 is now certified with Oracle E-Business Suite Release 11i and Release 12 on the following Linux on IBM System z operating systems:

      IBM LogoRelease 12.1 (12.1.2 or higher):

      • Red Hat Enterprise Linux (RHEL) version 5 (64-bit)
      • Novell SUSE Linux Enterprise Server (SLES) version 10 (64-bit)
      • Novell SUSE Linux Enterprise Server (SLES) version 11 (64-bit)1

      Release 12.0 (12.0.4 or higher)1:

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

      • Red Hat Enterprise Linux (RHEL) version 5 (64-bit)
      • Red Hat Enterprise Linux (RHEL) version 4 (64-bit)
      • Novell SUSE Linux Enterprise Server (SLES) version 10 (64-bit)

      1This is a 'database tier only' or 'split tier configuration' certification where the application tier must be on a fully certified E-Business Suite platform.

      This announcement 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

      Where can I find more information?

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

      Related Articles


      Friday Jan 06, 2012

      Enabling Case-Sensitive Passwords with E-Business Release 12

      Password security and complexity is often a concern for security and audit teams.  With the recent release of patch 12964564, Oracle E-Business Suite Release 12.1.1 with a minimum database level of 11gR1 now supports password case sensitivity.  Let's review this database feature in greater detail.  

      Password case sensitivity was introduced with Oracle Database 11gR1.  Passwords were not case sensitive in earlier versions.  For Oracle database versions prior to 11gR1, the passwords "Manager", "MANAGER", and "manager" were all equivalent.  In an 11gR1 database and higher with password case sensitivity turned on, each of these passwords, "Manager", "MANAGER" and "manager" are unique passwords with unique hash values.  

      Password case sensitivity is turned on by default for any newly created 11gR1 or higher database .  The database parameter for this feature is SEC_CASE_SENSITIVE_LOGON:

      • When this parameter is set to TRUE, password case sensitivity is enabled.
      • When set to FALSE, it is disabled.  
      The DBA_USERS view now has a PASSWORD_VERSIONS column that indicates the database release in which the password was created or last modified. 

      If you have migrated from a prior database version to 11gR1 and SEC_CASE_SENSITIVE_LOGON is set to true, the default behavior is as follows:
      • Existing users must first initiate a password change for password case sensitivity to be enforced
      • New users created in the 11g database will automatically use password case sensitivity 

      The following example on a generic database -- not an E-Business Suite database -- illustrates how the password case sensitivity feature works in 11g.

      First, a new user, "newuser1",  is created in an 11g database.

      Next, information from the DBA_USERS view is displayed.

      The following shows behavior of a migrated 10g user, "system" and an newly created 11g user, "newuser1" when password case sensitivity is disabled.

      Finally, the following  shows behavior of a migrated 10g user, "system" and an newly created 11g user, "newuser1" when password case sensitivity is enabled.


      For instructions on how to enable password case sensitivity with EBS R12.1.1 running on the 11gR1 Database and higher, please refer to the following MOS documentation:

      Related Articles

      Wednesday Jan 04, 2012

      Oracle Database 10gR2 10.2.0.5 Certified with EBS 11i on Tru64, Linux on Power, Linux Itanium

      As a follow-on to the original certification announcement, Oracle Database 10gR2 Patch Set 10.2.0.5.0 is now certified with Oracle E-Business Suite Release 11i on the following additional platforms:

      • HP Tru64 (5.1b)
      • IBM: Linux on POWER Systems (Red Hat Enterprise Linux 4, 5; SLES 9, 10)1
      • Linux Itanum (Red Hat Enterprise Linux 3, 4, 5; SLES 9, 10)1

      Notes:
      1 This is a database tier only (previously known as a split tier) certification where the application tier must be on a different fully certified E-Business Suite 11i platform.

      Certification of 10.2.0.5 on Windows Itanium is still in progress and will be announced separately. 

      This announcement includes:

      • For EBS 11i version 11.5.10 CU2+ATG_PF.H.delta.6 (RUP 6) and higher:
        • Real Application Clusters
        • Oracle Database Vault 
        • TDE Column Encryption
        • Advanced Security Option/Advanced Networking Option (ANO/ASO)
        • Export/Import Process for Oracle E-Business Suite Release 11i
        • Transportable Database and Transportable Tablespaces Data Migration Processes for Oracle E-Business Suite Release 11i

      Please refer to the original announcement for additional information pertaining to this certification.

      Upgrade to 11gR2 Database instead of patching 10gR2

      It's always helpful to check the latest Lifetime Support Policy documents when considering your upgrade options.  As a guiding principle, you should upgrade to the database release that gives you the longest supported timeline.

      Oracle Database 10gR2 is now in Extended Support through July 2013.  In general, if you're applying database-level updates to your Oracle E-Business Suite Release 11i environment, you'll get a better return on your investment of time if you upgrade directly to the latest 11gR2 database release.  Premier Support for 11gR2 runs through January 2015, and Extended Support runs through January 2018.

      References

      Wednesday Dec 28, 2011

      EBS R12 Certified with Database 11gR2 on SLES 11

      SUSE Linux logoOracle E-Business Suite Release 12 is now certified with the Oracle Database 11gR2 on SUSE Linux Enterprise Server (SLES) 11 running on the database tier for the following platforms and versions:

      Release 12 (12.0.4 and higher, 12.1.1 and higher) with Database versions 11.2.0.2 and 11.2.0.3:

      • Linux x86-64 (SLES 11)
      Release 12 (12.0.4 and higher, 12.1.2 and higher) with Database version 11.2.0.2:
      • IBM: Linux on System z (SLES 11)

      The certification of R12 with 11.2.0.3 on IBM: Linux on System z (including SLES 11) is in progress.

      These certifications cover the above 64-bit operating systems.  There are no plans to certify 32-bit SLES 11 (Linux x86).

      Database Tier Only

      These certifications cover only the E-Business Suite database tier.  The application tier of the E-Business Suite is not certified with SLES 11.  Customers must run the application tier on a different certified operating system (such as SLES 10). If you plan to use SLES 11 for an EBS application tier server, please contact me to discuss your business case.

      Other Database Options Certified

      This announcement for Oracle E-Business Suite R12 includes the following (as well as other features and options):

      • 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 12 Database Instances
      • Transportable Database and Transportable Tablespaces Data Migration Processes for Oracle E-Business Suite Release 12
      References

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

      Related Articles

      Wednesday Dec 14, 2011

      E-Business Suite Certified on 11gR2 11.2.0.3 on IBM AIX on Power Systems

      As a follow up to our initial certification 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 IBM AIX on Power Systems operating systems:

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

      • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
      Release 12 (12.0.4 and higher, 12.1.1 and higher):
      • IBM AIX on Power Systems (64-bit) (5.3, 6.1, 7.11)

      1: For 12.0, this OS version requires RUP 6 (12.0.6)

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

      • Oracle Database 11gR2 version 11.2.0.3
      • Oracle Database 11gR2 version 11.2.0.3 Real Application Clusters (RAC)
      • Oracle Database Vault 11gR2 version 11.2.0.3
      • Transparent Data Encryption (Column Encryption) using Oracle Database 11gR2 version 11.2.0.3
      • TDE Tablespace Encryption using Oracle Database 11gR2 version 11.2.0.3
      • Advanced Security Option (ASO)/Advanced Networking Option (ANO) with Oracle Database 11gR2 version 11.2.0.3
      • 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 Nov 14, 2011

      11gR2 11.2.0.3 Database Certified with E-Business Suite

      [Nov 15, 2011 Update: Added TDE Tablespace and Column Encryption to the list of certified options]

      The 11gR2 11.2.0.2 Database was certified with E-Business Suite (EBS) 11i and EBS 12 almost one year ago today.  I’m pleased to announce that 11.2.0.3, the second patchset for the 11gR2 Database is now certified. Be sure to review the interoperability notes for R11i and R12 for the most up-to-date requirements for deployment.

      This certification announcement is important as you plan upgrades to the technology stack for your environment. For additional upgrade direction, please refer to the recently published EBS upgrade recommendations article. Database support implications may also be reviewed in the database patching and support article.


      Oracle E-Business Suite Release 11i

      Prerequisites
      • 11.5.10.2 + ATG PF.H RUP 6 and higher
      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.3 database options and features are supported for use:
      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.

      Tuesday Nov 01, 2011

      11gR2 Transportable Tablespaces Certified for EBS 11i

      Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process is now certified for Oracle E-Business Suite Release 11i (11.5.10.2) with Oracle Database 11g Release 2.

      Small endian to big endian platform migrations

      Obtaining this patch

      This migration process requires a "Controlled" patch delivered by the Oracle E-Business Suite Platform Engineering team, i.e. it requires a password obtainable from Oracle Support. We released the patch in this manner to gauge uptake, and help identify and monitor any customer issues due to the nature of this technology. In addition to the requirement for 11.5.10.2 as the Release 11i version, TTS migration requires both the source machine and target machine databases to be 11gR2.

      Does it meet your requirements?

      Note that for migration across platforms of the same "endian" format, users are advised to use the Transportable Database (TDB) migration process instead for large databases. The "endian-ness" target platforms can be verified by querying the view V$DB_TRANSPORTABLE_PLATFORM using SQL*Plus (connected as sysdba) on the source platform:

      SQL>select platform_name from v$db_transportable_platform;

      If the intended target platform does not appear in the output, it means that it is of a different endian format from the source. Consequently. database migration will need to be performed via Transportable Tablespaces (for large databases) or export/import.

      The use of Transportable Tablespaces can greatly speed up the migration of the data portion of the database. However, it does not affect metadata, which must still be migrated using export/import. We recommend that users initially perform a test migration on their database, using export/import with the 'metrics=y' parameter. This will help identify the relative amounts of data and metadata, and provide a basis for assessing likely gains in timing. In general, the larger the amount of data (compared to metadata), the greater the reduction in downtime that can be expected from using XTTS as a migration process.

      Where can I find more information?

      Related Articles


      About

      Search

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