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


    Saturday Oct 22, 2011

    Latest DSTv17 Timezone Patches Available for E-Business Suite R11i

    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. 

    DSTv17 is now available and certified with Oracle E-Business Suite Release 11i. The DSTv17 update includes the timezone information from Olson tzdata 2011j. 

    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

    For more details about the timezones affected by the DSTv17 update, see:

    Monday Oct 17, 2011

    Latest DSTv16 Timezone Patches Available for E-Business Suite 11i

    Hourglass iconWe announced the certification of the DSTv16 update with E-Business Suite 12 last August.  The second part of that certification with EBS 11i is now available. The DSTv16 update includes the timezone information from Olson tzdata 2011g.

    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

    For more details about the timezones affected by the DSTv16 update, see:

    Related Articles


    Friday Oct 14, 2011

    Latest DSTv17 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 August 2011 and released as DSTv16.

    DSTv17 is now available and certified with Oracle E-Business Suite Release 12. The DSTv17 update includes the timezone information from Olson tzdata 2011j. 

    DSTv17 is an interim release.  Its primary purpose is to include the new DST rules for Russia which take effect from 30th October 2011.  At this time the clocks will not move back one hour but will remain on "summer time" instead.

    Patches for this release are available on a request-only basis.  If you require this patch for your operating system/patch configuration, you must request it explicitly from Oracle Support.

    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

    We last discussed the DSTv16 patches on this blog. The latest DSTv17 timezone definition file is cumulative and includes all DST changes released in earlier time zone definition files. DSTv17 includes changes to the following timezones since the DSTv16 release:

    • Africa/Nairobi,
    • Africa/Dar_es_Salaam,
    • Africa/Kampala,
    • America/St_Johns,
    • America/Goose_Bay,
    • America/Resolute,
    • Asia/Yekaterinburg,
    • Asia/Omsk,
    • Asia/Novosibirsk,
    • Asia/Krasnoyarsk,
    • Asia/Irkutsk,
    • Asia/Yakutsk,
    • Asia/Vladivostok,
    • Asia/Magadan,
    • Asia/Kamchatka,
    • Asia/Anadyr,
    • Asia/Sakhalin,
    • America/Metlakatla,
    • Europe/Kaliningrad,
    • Europe/Moscow,
    • Europe/Samara,
    • Europe/Volgograd,
    • Pacific/Apia,
    • Canada/Newfoundland,
    • W-SU

    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:

    What happened to EBS 11i?

    The certification of DST v17 with Oracle E-Business Suite Release 11i is still in progress.  Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates. You're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.    

    Related Articles

    Wednesday Aug 31, 2011

    Using Single Client Access Name (SCAN) Listeners with Oracle E-Business Suite

    [July 30, 2012 update: Corrected Note reference to 823586.1]

    [Sept. 2, 2011 update:  Our Maximum Availability Architecture architects have pointed out two additional considerations that are documented in our existing documentation:  1)  Although SCAN listener is supported with EBS 12, if scan_name resolves in DNS to IP1 and IP2, the client-side 10.1.2 network code does not use round robin on the underlyng IPs if the first IP fails.  An Autoconfig solution for this is being tracked through bug 10427234. The only existing workaround is to create custom TNS aliases configured with multiple SCAN IP addresses (Note 823587.1); 2) EBS does support use SCAN functionality, it cannot make complete use of the SCAN since the EBS clients are pre-11.2.  For more details, see this Exadata whitepaper.]

    Oracle database 11g logoSingle Client Access Name (SCAN) is a new feature of Oracle Real Applications Clusters (RAC) 11g Release that provides a single name for the clients to access Oracle Database running in a cluster.  The benefit of the SCAN Listener is that the client's connection data does not need to changed if you add or delete a node from a cluster.

    The Single Client Access Name is configured during the installation of Oracle Grid Infrastructure. Once configured, application tier connection descriptors just specify the SCAN name rather than all the [virtual] hosts in the cluster.

    Without the Single Client Access Name, the descriptor for a two-node cluster would be

    VISION =
    (DESCRIPTION=
    (ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=tcp)(HOST=C1-vip)(PORT=1521))
    (ADDRESS=(PROTOCOL=tcp)(HOST=C2-vip)(PORT=1521)))
    (CONNECT_DATA=(SERVICE_NAME=VISION)))  

    With the Single Client Access Name, just the SCAN name needs to be specified:

    VISION = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=C-SCAN)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VISION)))

    The benefit of the Single Client Access Name becomes apparent as the number of nodes in the cluster increases.

    Which E-Business Suite releases can be used with SCAN Listeners?

    You can configure E-Business Suite Release 11i and 12 environments to take advantage of Single Client Access Name functionality.  The use of SCAN Listener is optional.

    EBS 11i

    AutoConfig in E-Business Suite 11i does not  support automated handling of SCAN Listeners.  If you would like to use SCAN Listeners with EBS 11i environments, a manual setup process is described in:

    EBS 12

    AutoConfig in Oracle E-Business Suite Release 12 supports automated handling of SCAN Listeners.  If you would like to use SCAN Listeners with EBS 12 environments, see:

    References

      Related Articles


      Tuesday Aug 23, 2011

      Managing EBS 12 Physical Standby Databases with Oracle Data Guard Broker

      [Aug. 8, 2012 Update: Added additional details about logical standby and Oracle Streams]

      [Aug. 24, 2011 update: Clarified description of AutoConfig dependency when enabling EBS failover environments]

      Oracle Data Guard allows you to create standby databases for disaster recovery.  Oracle Data Guard Broker provides an easy interface to configure standby databases and to perform role transitions with a single command for switchover and failover.  It logically groups the primary and standby databases into a broker configuration that allows the broker to manage and monitor them together as an integrated unit. Oracle Data Guard Broker can automate the following operations:

      • Creation of Data Guard configurations incorporating a primary database, a new or existing (physical or logical) standby database, log transport services, and log apply services, where any of the databases could be Real Application Clusters (RAC) databases.
      • Adding up to 8 additional new or existing (physical or logical, RAC, or non-RAC) standby databases to each existing Data Guard configuration, for a total of one primary database, and from 1 to 9 standby databases in the same configuration.
      • Managing an entire Data Guard configuration, including all databases, log transport services, and log apply services, through a client connection to any database in the configuration.
      • Invoking switchover or failover with a single command to initiate and control complex role changes across all databases in the configuration.
      • Monitoring the status of the entire configuration, capturing diagnostic information, reporting statistics such as the log apply rate and the redo generation rate, and detecting problems quickly with centralized monitoring, testing, and performance tools.

      Oracle Data Guard architecture overview diagram

      There are two interfaces to manage broker configurations:

      1. Oracle Enterprise Manager (Graphical User Interface)
      2. Data Guard command-line interface (DGMGRL).

      If you've implemented standby databases as part of your EBS disaster recovery or business continuity strategy, we'd recommend that you consider using Data Guard Broker, too.  We've provided step-by-step configuration instructions to use the Data Guard Broker [DGMGRL]  tool to manage Physical Standby databases for E-Business Suite Release 12. For detailed instructions, see:

      Failover with E-Business Suite environments is not automatic.  E-Business Suite environments must be failed over manually due to the need to run AutoConfig to reconfigure services on the failover site.

      What about logical standby or Oracle Streams?

      Neither logical standby nor Oracle Streams can be used for replicating E-Business Suite databases.  As documented in Maximum Availability Architecture and Oracle E-Business Suite Release 11i (Note 403347.1):

      The process that mines the redo to create SQL statements for a logical standby cannot handle all data types and actions provided by the Oracle database.  The E-Business Suite uses some of those “unsupported” data types.  Thus, the Applications development group does not support the use of logical standby for an E-Business Suite implementation.

      References

      Related Articles

      Tuesday Aug 09, 2011

      Latest DSTv16 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 January 2011 and released as DSTv15.

      DSTv16 is now available and certified with Oracle E-Business Suite Release 12. The DSTv16 update includes the timezone information from Olson tzdata 2011g. 

      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

      We last discussed the DSTv15 patches on this blog. The latest DSTv16 timezone definition file is cumulative and includes all DST changes released in earlier time zone definition files. DSTv16 includes changes to the following timezones since the DSTv15 release:

      • Africa/Cairo
      • Africa/Casablanca
      • America/Juneau
      • America/Havana
      • America/Santiago
      • Asia/Amman
      • Atlantic/Stanley
      • Europe/Istanbul
      • Pacific/Honolulu
      • Pacific/Easter
      • Pacific/Apia
      • Egypt
      • Cuba
      • Chile/Continental
      • Turkey
      • US/Hawaii
      • Chile/EasterIsland
      • Asia/Istanbul

      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:

      What happened to EBS 11i?

      The certification of DST v16 with Oracle E-Business Suite Release 11i is still in progress.  Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates. You're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.    

      Related Articles

      Friday Jul 22, 2011

      Reminder: Database 11.1.0.7 Premier Support ends August 2012

      It's deja vu all over again.  Since I covered the Error Correction Support (ECS) dates for the 11gR2 Database a few days ago, it's also worth reminding you of an important support milestone for the 11gR2 Database codeline.

      Premier Support for Oracle Database 11gR1 (11.1) ends on August 31, 2012.  Extended Support for 11.1 continues to the end of August 2015. These support timelines are covered in the Lifetime Support Policy for Oracle Technology Products.

      The 11.1.0.7 patchset is the terminal patchset for the 11gR1 database codeline.  If you're still on the 11.1.0.6 patchset, you should note that Error Correction Support for that ended on September 18, 2009, as detailed here:

      If you're not already on 11.2.0.2, we recommend that all Apps customers make plans for a database upgrade soon.

      No support exceptions for EBS users

      Remember that all Oracle Database support timelines apply to E-Business Suite environments.  There are no special support exemptions for EBS environments.  For an in-depth discussion about how database support timelines affect EBS customers, see:

      Related Articles

      Tuesday Jul 19, 2011

      Reminder: Database 11.2.0.1 Error Correction Support ends Sept. 2011

      The Server Technologies division supports the previous release for 12 months after the release of the latest patchset.  The 11.2.0.2 Database patchset was released in Sept 2010.  This means that 11gR2 Database patches produced after September 13, 2011 will require the 11.2.0.2 patchset as a prerequisite.  For more details about patching timelines for individual database patchsets, see:
      If you're not already on 11.2.0.2, we recommend that all Apps customers make plans for a database upgrade soon.

      No support exceptions for EBS users

      Remember that all Oracle Database support timelines apply to E-Business Suite environments.  There are no special support exemptions for EBS environments.  For an in-depth discussion about how database support timelines affect EBS customers, see:
      Related Articles

      Thursday Jul 14, 2011

      Using Audit Vault with Oracle E-Business Suite

      Oracle Audit Vault is a database option that automates the collection and consolidation of audit data to support regulatory compliance and reduce security risks.  Audit Vault provides compliance and entitle reports, alert notifications, and centralized audit policy management.  Audit Vault provides compliance reports to address regulatory requirements for database activity monitoring and auditing for:
      • Sarbanes-Oxley (SOX) Act
      • Health Insurance Portability and Accountability Act (HIPAA)
      • Payment Card Industry (PCI) Data Security Standards (DSS)

      Conceptual diagram showing audit data tracked by Oracle Audit Vault

       From the Oracle Audit Vault FAQ:

      Audit Vault extracts audit records produced by the database's native audit facility so no special certification is required by the application since it is transparent. Any packaged application such as Oracle E-Business Suite, PSFT, Siebel, and SAP work seamlessly with Audit Vault to collect the native audit records.

      E-Business Suite suggests that auditing and monitoring of privileged users, user sessions, database links, and database changes is a key element in monitoring and securing your applications. Please see Metalink Note 189367.1. Audit Vault supports all versions of E-Business Suite that sit on top of Oracle database versions 9.2.x forward.

      In addition, the Oracle database column, client_identifier, can be used to pass the end application user to the native audit record. E-Business Suite updates client_identifier automatically starting with version 12 of the application, PeopleTools starting with 8.50, and SAP kernal version starting with 7.10. The client_identifier value can be used in the Audit Vault reports to view the application user, OS user, and database connection user information for forensic analysis.

      No special setups required for EBS

      In other words, you can use Audit Vault's generic documentation for E-Business Suite databases.  No special EBS-specific documentation or setups are required to enable Audit Vault in EBS instances.

      Related Articles


      Monday Jul 11, 2011

      Secure Enterprise Search 11.1.2.2 Certified with E-Business Suite 12

      Oracle Secure Enterprise Search 11g 11.1.2.2 is now certified with Oracle E-Business Suite Release 12 (12.1.3 and higher).  Secure Enterprise Search (SES) is an optional add-on to provides additional search capabilities for R12.  Apps users can search for E-Business Suite data using a unified search engine, with search results displayed based upon their Applications responsibilities. 

      Screenshot of Asset Inquiry screen using Secure Enterprise Search with EBS

      Certified Platforms

      Oracle Secure Enterprise Search must be installed on an SES-certified platform while integrating with Oracle E-Business Suite 12.1.3 running on a fully-certified E-Business Suite platform.  It's a bit complex to show the interplay of SES certifications against E-Business Suite certifications here.  You can refer to the Certifications section of My Oracle Support to review both E-Business Suite and Secure Enterprise Search certified configurations.

      References

      Related Articles


      Thursday May 26, 2011

      Database 11.2.0.2 Certified with EBS R12 on IBM: Linux on System z

      As a follow-on to our original announcement, Oracle Database 11g Release 2 (11.2.0.2) is now certified with Oracle E-Business Suite Release 12 (12.0.4 and higher, 12.1.2 and higher) on the following Linux on System z platforms:

      Release 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)

      Release 12.0 (12.0.4 or 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)

      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. Starting with Release 12.1.2, Linux on System z became a fully certified platform.

      Database Feature and Option Certifications
      The following 11gR2 11.2.0.2 database options and features are supported for use:

      EBS 12 References
      Related Articles

      About

      Search

      Categories
      Archives
      « March 2015
      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