Tuesday Dec 15, 2015

Reminder: Error Correction Support Ended for Database 11.2.0.3

E-Business Suite customers must ensure that their database remains on a level that is covered by Error Correction Support (ECS) -- i.e. while you can get new patches, Critical Patch Updates (CPU), and Patch Set Updates (PSU).  We've covered this in detail here:

The following Note lists Error Correction Support dates for all database patchsets for all database releases:

That Note shows that patching ended for the 11.2.0.3 Database patchset on August 27, 2015

All EBS customers should upgrade to a later patchset or database release.  As of today, options include upgrading to the 11.2.0.4 patchset or Database 12c 12.1.0.2.

Related Articles

Monday Nov 30, 2015

Database 11.2.0.4 Certified with HP-UX and EBS 12.1.3

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 12.1.1 or later updates to the 12.1 code line on the following additional platform:

  • HP-UX PA-RISC (64-bit) (11.31)
This announcement for Oracle E-Business Suite R12 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 12 Database Instances
  • Transportable

References

Related Articles



Tuesday Nov 03, 2015

DSTv25 Timezone Patches Available for E-Business Suite

Hourglass iconIf your E-Business Suite Release 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 June 2015 and released as DSTv24.

DSTv25 is now available and certified with Oracle E-Business Suite Release 12.2 and 12.1. The DSTv25 update includes the timezone information from the IANA tzdata 2015g.  It 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 DSTv25 timezone definition file is cumulative and includes all DST changes released in earlier time zone definition files. DSTv25 includes changes to the following timezones since the DSTv24 release:

  • Africa/Casablanca
  • Africa/El_Aaiun
  • America/Montevideo
  • Asia/Pyongyang
  • Europe/Istanbul
  • Pacific/Fiji
  • Turkey
  • 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.

Proactive backports of DST upgrade patches to all Oracle E-Business Suite tiers and platforms are not created and supplied by default. If you need this DST release and an appropriate patch is not currently available, raise a service request through support providing a business case with your version requirements.

The following Note identifies the various components in your E-Business Suite environment that may need DST patches:

Monday Nov 02, 2015

DB 12.1.0.2 Certified with EBS 12.2 on Windows x64 (64-bit)

As a follow up to a prior announcement, Oracle Database 12c Release 1 (12.1.0.2) is now certified with Oracle E-Business Suite Release 12.2 (12.2.3 and higher) on Microsoft Windows Server 2008 R2 and 2012 R2 (Windows x64).

This announcement includes:

  • Oracle Database 12cR1 Version 12.1.0.2
  • Oracle Database In-Memory 12cR1 Version 12.1.0.2
  • Oracle Database 12cR1 Version 12.1.0.2 Real Application Clusters (RAC)
  • TDE Column Encryption with Oracle Database 12cR1 Version 12.1.0.2
  • TDE Tablespace Encryption with Oracle Database 12cR1 Version 12.1.0.2
  • Advanced Security Option (ASO)/Advanced Networking Option with Oracle Database 12cR1 Version 12.1.0.2 (ANO)
  • Export/Import and Transportable Database Data Migration Processes with Oracle Database 12cR1 Version 12.1.0.2


The following are not yet certified and will be announced at a later date once completed:

  • Oracle Multitenant 12cR1 Version 12.1.0.2
  • Oracle Database Vault 12cR1 Version 12.1.0.2
  • Transportable Tablespaces Data Migration Process

Please review the documents below for all requirements and additional details:

Please refer to the platform specific Oracle Database Installation Guides for operating system and other prerequisites.
Please refer to Oracle Database 12c Release 1 (12.1.0.2) New Features Guide 12c Release 1 (12.1) and Oracle Database Administrator's Guide for more information regarding the "In-Memory Column Store" feature.

Monday Oct 26, 2015

Oracle Data Guard 11.2.0.4 with RAC Certified with EBS 12.2

I'm pleased to announce an update to the certification of Oracle Data Guard 11.2.0.4 with Oracle E-Business Suite 12.2. This certification now includes databases deployed with Real Application Clusters (RAC).  

Certification with Oracle Data Guard 11.2.0.4 provides you the ability to create a Physical Standby Database for Oracle E-Business Suite 12.2 environments.  The creation of a Physical Standby Database is a key component of creating a disaster recovery site for Oracle E-Business Suite.

Detailed steps for setting up a 11.2.0.4 Physical Standby Database for Oracle E-Business Suite 12.2 are provided in the following My Oracle Support Note:

Oracle E-Business Suite Data Guard Certifications

The following matrix provides an overview of what's currently certified and what's planned for Oracle E-Business Suite 12.2 and 12.1.3 and Oracle Data Guard 11.2.0.4 and 12.1.0.2:


Oracle Data Guard 11.2.0.4 Oracle Data Guard 12.1.0.2
Oracle E-Business Suite 12.2 Certified, MOS Note 1491855.1 Certified*, MOS Note 1963472.1
Oracle E-Business Suite 12.1.3 Certified, MOS Note 1070033.1 Certified*, MOS Note 1900663.1

*For single node databases only.  Certification with RAC configurations is pending.

**Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog.

How to Find the Latest Certification Information

This blog is great for announcing certifications as they happen, but for ongoing updates and the latest information on certifications, your single source of truth is the Certifications tab in My Oracle Support.  From the Certifications tab on My Oracle Support, you can search for certified combinations of products with specific Oracle E-Business Suite versions.  For example:

Step 1.  Log in to My Oracle Support

Step 2. Click on the Certifications tab

Step 3.  Add your search criteria.  For example:  Add Oracle E-Business Suite to the Product List, add Release 12.2.4 to the Release List and optionally add your platform to the Platform List.

Step 4.Click Check certifications with another product

Step 5.  Add Data Guard to the Product List and optionally add the version to the Release List

The above search will list all versions of data guard currently certified as shown in the following screenshot:


References

Monday Oct 19, 2015

Should EBS Customers Use Database 12.1.0.2 or 12.1.01?

E-Business Suite customers must ensure that their database remains on a level that is covered by Error Correction Support (ECS) -- i.e. a level where you can get new patches, Critical Patch Updates (CPU), and Patch Set Updates (PSU).  We've covered this in detail here:

The following Note lists Error Correction Support dates for all database patchsets for all database releases:

That Note shows that patching ends for the 12.1.0.1 Database patchset on August 31, 2016.  All EBS customers should upgrade to a later patchset or database release before then.

Even though Database 12.1.0.1 is still under Error Correction Support, we recommend that all EBS customers currently running Database 12c 12.1.0.1 upgrade to the Database 12.1.0.2 patch set.

Why upgrade?

Better end-user experience.  Database 12.1.0.2 contains important updates for security, stability, and performance.  These updates improve the experience of your end-users.

Easier for system administrators.  We have been working closely with many EBS 12.2 customers.  We have found that the Database 12.1.0.2 patch set streamlines upgrades to EBS 12.2 by reducing the number of additional interoperability patches are required.  Fewer patches mean that upgrades take less time, are less-complex, and less risky.

Minimum baseline for future EBS+Database 12c Certifications.  It is very complex to keep multiple EBS codelines compatible with multiple database releases.  All future EBS 12.2 patches will certified against Database 12.1.0.2 rather than Database 12.1.0.1.  This includes updates to the core AD and TXK system administration tools. 

Faster resolution for database issues. You can still request patches for Database 12.1.0.1 until August 31, 2016, but they will not be produced proactively, so there might be a delay in getting them to you.

Related Articles

Monday Sep 14, 2015

Database Migration using 12cR1 Transportable Database Certified for EBS 12.1

Database migration across platforms of the same "endian" (byte ordering) formats using the Transportable Database (TDB) process is now certified for Oracle E-Business Suite Release 12.1 with Oracle Database 12c Release 1 (12.1.0).

The "endian-ness" of platforms can be checked by querying the view V$TRANSPORTABLE_PLATFORM using SQL*Plus (connected as SYSDBA):

    SQL> select platform_name, endian_format from v$transportable_platform;  

The following is a list of relevant platforms certified for Oracle E-Business Suite Release 12 (12.1) with Oracle Database 12c Release 1 on the database tier:

Big Endian Platforms
Little Endian Platforms
 Oracle Solaris on SPARC
 Linux x86-64
 HP-UX Itanium
 Oracle Solaris on x86-64
 IBM AIX on Power Systems
 Microsoft Windows x64*
 IBM: Linux on System z

* Microsoft Windows x64 is not yet certified and will be announced at a later date

Using Transportable Database is the fastest method for migration between platforms of the same endian format. A requirement of this migration process is that the source and target database versions must match (including patch set version), so database upgrades as part of the migration cannot be done.

For migration between platforms of different endian formats, users must use alternative migration methods such as export/import (datapump) or Transportable Tablespaces (TTS).

References

Related Articles

Wednesday Aug 05, 2015

Using Oracle Database In-Memory with Oracle E-Business Suite

Authors: Andy Tremayne and Deepak Bhatnagar, Oracle Development

Database In-Memory is one of a number of options that can be deployed to address Oracle E-Business Suite performance concerns and scalability requirements without the need for any application changes.

We are pleased to announce the publication of a new white paper that can help with this (including links to patches that you will need to apply):

The paper starts by providing strategic advice and guidelines that help you decide which objects to populate into Database In-Memory (DBIM), and how to size the In-Memory Column Store (IMCS). It provides a list of best practices and explains the complexities and limitations of using DISTRIBUTE/DUPLICATE with Oracle RAC.

Database In-Memory diagram

The examples in this paper take a step away from the classic headline feature of analytical reports that you might have been expecting. Instead, they show how DBIM can be applied to three novel use cases:

  • The Order Organizer Form has a huge number of queryable fields that would all need to be indexed for optimal performance. DBIM provides a 10X improvement in the end-user response time.
  • The Initialize Credit Summaries concurrent program is unusual the optimization is based on an INSERT statement. It is also interesting as the example shows why simply populating objects into the IMCS can result in a performance reduction – in this case spilling to disk. Simply populating the objects into DBIM improved the time by 1.5X; further tuning improved on this to provide an overall gain of 3.5X.
  • The Receiving Transaction Processor had two long-running queries that reduced from 7.8 hrs to 4.85 mins representing about a 100X increase in performance. The overall runtime was about 4X faster.

One of the key aspects in the paper is describing how to use Oracle E-Business Suite Application Affinity with Oracle RAC. It describes how to overcome some of the limitations of Non-Engineered Systems (commodity hardware), and explains how it can also be used to benefit Oracle Engineered Systems.

Other References

The Oracle Database In-Memory blog contains a wealth of generic information, technical details, ideas and news on Oracle Database In-Memory from the author of the Oracle White Paper on Oracle Database In-Memory.

Related Articles

Tuesday Aug 04, 2015

Oracle Data Guard 12.1.0.2 Certified with EBS 12.2

I'm pleased to announce the recent certification of Oracle Data Guard 12.1.0.2  with Oracle E-Business Suite 12.2.  You can use Oracle Data Guard 12.1.0.2 to create a Physical Standby Database for Oracle E-Business Suite 12.2 environments.  A Physical Standby Database is a key component for a disaster recovery site for Oracle E-Business Suite.

Detailed steps for setting up a 12.1.0.2 Physical Standby Database for Oracle E-Business Suite 12.2 are provided here:

Oracle E-Business Suite Data Guard Certifications

The following matrix provides an overview of what's currently certified and what's planned for Oracle E-Business Suite 12.2 and 12.1.3 and Oracle Data Guard 12.1.0.2 and 11.2.0.4:


Oracle Data Guard 12.1.0.2 Oracle Data Guard 11.2.0.4
Oracle E-Business Suite 12.2 Certified*, MOS Note 1963472.1
Certified*, MOS Note 1491855.1
Oracle E-Business Suite 12.1.3 Certified*, MOS Note 1900663.1 Certified, MOS Note 1070033.1

*For single node databases only.  Certification with RAC configurations is pending.

Note:  Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog.

How to Find the Latest Certification Information

This blog is great for announcing certifications as they happen, but for ongoing updates and the latest information on certifications, your single source of truth is the Certifications tab in My Oracle Support.  From the Certifications tab on My Oracle Support, you can search for certified combinations of products with specific Oracle E-Business Suite versions.  For example:

Step 1.  Log in to My Oracle Support

Step 2. Click on the Certifications tab

Step 3.  Add your search criteria.  For example:  Add Oracle E-Business Suite to the Product List, add Release 12.2.4 to the Release List and optionally add your platform to the Platform List.

Step 4.Click Check certifications with another product

Step 5.  Add Data Guard to the Product List and optionally add the version to the Release List

The above search will list all versions of data guard currently certified as shown in the following screenshot:


References

Related Articles

Thursday Jul 30, 2015

Database 12.1.0.2 Certified with EBS 11i on Additional Platforms

As a follow up to the prior announcement on February 11th, 2015, Oracle Database 12c Release 1 (12.1.0.2) is now certified with Oracle E-Business Suite Release 11i (11.5.10.2 + ATG_PF.H.delta.7 (RUP 7) and higher) on the following additional platforms:

  • HP-UX Itanium (11.31)
  • IBM AIX on Power Systems (64-bit) (6.1, 7.1*)
  • IBM: Linux on z Systems (RHEL 5,6, SLES 11)*

* 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 includes:

  • Oracle Database 12cR1 Version 12.1.0.2
  • Oracle Database Real Application Clusters (RAC) 12cR1 Version 12.1.0.2
  • TDE Column Encryption with Oracle Database 12cR1 Version 12.1.0.2
  • TDE Tablespace Encryption with Oracle Database 12cR1 Version 12.1.0.2
  • Advanced Security Option (ASO)/Advanced Networking Option (ANO) with Oracle Database 12cR1 Version 12.1.0.2
  • Export/Import Process for EBS 11i with RDBMS 12cR1 Version 12.1.0.2

The following certifications are not planned with Oracle E-Business Suite 11i:

  • Oracle Multitenant 12cR1 Version 12.1.0.2
  • Oracle Database In-Memory 12cR1 Version 12.1.0.2

Please review the documents below for all requirements and additional details:

References

Related Articles

Wednesday Jul 29, 2015

Transportable Database 12c Certified for EBS 12.2 Database Migration

Database migration across platforms of the same "endian" (byte ordering) formats using the Transportable Database (TDB) process is now certified for Oracle E-Business Suite Release 12.2 with Oracle Database 12c Release 1 (12.1.0).

The "endian-ness" of platforms can be checked by querying the view V$TRANSPORTABLE_PLATFORM using SQL*Plus (connected as SYSDBA):

SQL> select platform_name, endian_format from v$transportable_platform;

The following is a list of relevant platforms certified for Oracle E-Business Suite Release 12 (12.2) with Oracle Database 12c Release 1 on the database tier:

Big Endian Platforms
Little Endian Platforms
Oracle Solaris on SPARC
Linux x86-64
HP-UX Itanium
Oracle Solaris on x86-64
IBM AIX on POWER Systems
Microsoft Windows x641
IBM: Linux on z Systems

1 Note: Microsoft Windows x64 is not yet certified and will be announced separately at a later date.

Using Transportable Database is the fastest method for migration between platforms of the same endian format. A requirement of this migration process is that the source and target database versions must match (including patch set version), so database upgrades as part of the migration cannot be done.

For migration between platforms of different endian formats, users must use alternative migration methods such as export/import (datapump).

References

Related Articles


Tuesday Jul 28, 2015

Database 12.1.0.2 Certified with EBS 12.2 on Additional Platforms

As a follow up to our prior announcement, Oracle Database 12c Release 1 (12.1.0.2) is now certified with Oracle E-Business Suite Release 12.2 (12.2.2 and higher) on the following additional platforms:

  • HP-UX Itanium (11.31)
  • IBM AIX on Power Systems (64-bit) (6.1, 7.1)
  • IBM: Linux on z Systems (RHEL 5,6, SLES 11)*

* 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 includes:

  • Oracle Database 12cR1 Version 12.1.0.2
  • Oracle Database In-Memory 12cR1 Version 12.1.0.2
  • Oracle Database 12cR1 Version 12.1.0.2 Real Application Clusters (RAC)
  • TDE Column Encryption with Oracle Database 12cR1 Version 12.1.0.2
  • TDE Tablespace Encryption with Oracle Database 12cR1 Version 12.1.0.2
  • Advanced Security Option (ASO)/Advanced Networking Option with Oracle Database 12cR1 Version 12.1.0.2 (ANO)
  • Export/Import Process with Oracle Database 12cR1 Version 12.1.0.2

The following are not yet certified and will be announced at a later date once completed.

  • Oracle Multitenant 12cR1 Version 12.1.0.2
  • Oracle Database Vault 12cR1 Version 12.1.0.2
  • Transportable Tablespaces Data Migration Process

References

Related Articles


Monday Jul 13, 2015

Oracle Active Data Guard 11.2.0.4, 12.1.01 Certified with EBS 12.1.3

I'm pleased to announce the recent certification of Oracle Active Data Guard 11.2.0.4 and 12.1.0.1 with Oracle E-Business Suite 12.1.3.  Oracle E-Business Suite 12.1.3 certification with Oracle Active Data Guard 11.2.0.4 and 12.1.0.1 provides you the ability to offload some production reporting. We've certified the use of Oracle Discoverer and some Concurrent Manager reporting to run against the Oracle Active Data Guard database instance. 

Detailed steps for setting up Active Data Guard 11.2.0.4 or 12.1.0.1 with Oracle E-Business Suite 12.1.3 are provided in the following My Oracle Support Note:

In addition to Discoverer and Concurrent Manager, you may have other reporting tools that you would like to use with the Oracle Active Data Guard database instance.  In general, you should be able to use the reporting tool if it does not require write access to the Active Data Guard instance. 


Oracle E-Business Suite Active Data Guard Certifications

The following matrix provides an overview of what's currently certified and what's planned for Oracle E-Business Suite 12.2 and 12.1.3 and Oracle Active Data Guard 11.2.0.4, 12.1.0.1 and 12.1.0.2: 


 Active Data Guard 11.2.0.4
 Active Data Guard 12.1.0.1
 Active Data Guard 12.1.0.2
Oracle E-Business Suite 12.1.3
Certified*,MOS Note 1070491.1
Certified*, MOS Note 1070491.1
Pending certification**
Oracle E-Business Suite 12.2.3, 12.2.2
Certified*, MOS Note 1944539.1
Not currently planned for certification
Pending certification**
Oracle E-Business Suite 12.2.4 Pending Certification** Not currently planned for certification Pending certification**

  *For single node databases only.  Certification with Oracle RAC configurations is pending.

**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 the latest in cert.

How to Find the Latest Certification Information

This blog is great for announcing certifications as they happen, but for ongoing updates and the latest information on certifications, your single source of truth is the Certifications tab in My Oracle Support.  From the Certifications tab on My Oracle Support, you can search for certified combinations of products with specific Oracle E-Business Suite versions.  For example:

Step 1.  Log in to My Oracle Support

Step 2. Click on the Certifications tab

Step 3.  Add your search criteria.  For example:  Add Oracle E-Business Suite to the Product List, add Release 12.1.3 to the Release List and optionally add your platform to the Platform List.

Step 4.Click Check certifications with another product

Step 5.  Add Oracle Active Data Guard to the Product List and optionally add the version to the Release List

The above search will list all versions of Oracle Active Data Guard currently certified as shown in the following screenshot:

References

Related Articles

Friday Jul 10, 2015

Oracle Active Data Guard 11.2.0.4 Certified with EBS 12.2.3

I'm pleased to announce the recent certification of Oracle Active Data Guard 11.2.0.4 with Oracle E-Business Suite 12.2.2 and 12.2.3.  Oracle E-Business Suite 12.2.2 and 12.2.3 certification with Oracle Active Data Guard 11.2.0.4 provides you the ability to offload some production reporting. We've certified the use of Oracle Discoverer and some Concurrent Manager reporting to run against the Oracle Active Data Guard database instance. 

Detailed steps for setting up a 11.2.0.4 Active Data Guard for Oracle E-Business Suite 12.2.2 and 12.2.3 are provided in the following My Oracle Support Note:

In addition to Discoverer and Concurrent Manager, you may have other reporting tools that you would like to use with the Oracle Active Data Guard database instance.  In general, you should be able to use the reporting tool if it does not require write access to the Active Data Guard instance. 


Oracle E-Business Suite Active Data Guard Certifications

The following matrix provides an overview of what's currently certified and what's planned for Oracle E-Business Suite 12.2 and 12.1.3 and Oracle Active Data Guard 11.2.0.4, 12.1.0.1 and 12.1.0.2:


 Active Data Guard 11.2.0.4
 Active Data Guard 12.1.0.1
 Active Data Guard 12.1.0.2
Oracle E-Business Suite 12.2.2, 12.2.3
Certified*, MOS Note 1944539.1
Not currently planned for certification
Pending certification**
Oracle E-Business Suite 12.2.4 Pending Certification
Not currently planned for certification
Pending certification**
Oracle E-Business Suite 12.1.3 Certified*, MOS Note 1070491.1
Certified*, MOS Note 1070491.1
Pending certification**

 *For single node databases only.  Certification with Oracle RAC configurations is pending.

**Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog.

How to Find the Latest Certification Information

We've recently added Oracle Active Data Guard as a searchable product for certified combinations with Oracle E-Business Suite.  That's good news for those of you that are looking for the latest information on certified combinations of Oracle E-Business Suite and Active Data Guard.

From the Certifications tab on My Oracle Support, you can search for certified combinations of products, such as Active Data Guard, with specific Oracle E-Business Suite versions.  For example:

Step 1.  Log in to My Oracle Support

Step 2. Click on the Certifications tab

Step 3.  Add your search criteria.  For example:  Add Oracle E-Business Suite to the Product List, add Release 12.2.3 to the Release List and optionally add your platform to the Platform List.

Step 4.Click Check certifications with another product

Step 5.  Add Oracle Active Data Guard to the Product List and optionally add the version to the Release List

The above search will list all versions of Oracle Active Data Guard currently certified as shown in the following screenshot:


References

Related Articles

Monday Jul 06, 2015

Oracle Data Guard 11.2.0.4 Certified with EBS 12.2

I'm pleased to announce the recent certification of Oracle Data Guard 11.2.0.4 with Oracle E-Business Suite 12.2.  Certification with Oracle Data Guard 11.2.0.4 provides you the ability to create a Physical Standby Database for Oracle E-Business Suite 12.2 environments.  The creation of a Physical Standby Database is a key component of creating a disaster recovery site for Oracle E-Business Suite.

Detailed steps for setting up a 11.2.0.4 Physical Standby Database for Oracle E-Business Suite 12.2 are provided in the following My Oracle Support Note:

Oracle E-Business Suite Data Guard Certifications

The following matrix provides an overview of what's currently certified and what's planned for Oracle E-Business Suite 12.2 and 12.1.3 and Oracle Data Guard 11.2.0.4 and 12.1.0.2:


Oracle Data Guard 11.2.0.4 Oracle Data Guard 12.1.0.2
Oracle E-Business Suite 12.2 Certified*, MOS Note 1491855.1 Pending Certification**
Oracle E-Business Suite 12.1.3 Certified, MOS Note 1070033.1 Certified*, MOS Note 1900663.1

*For single node databases only.  Certification with RAC configurations is pending .

**Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog.

How to Find the Latest Certification Information

This blog is great for announcing certifications as they happen, but for ongoing updates and the latest information on certifications, your single source of truth is the Certifications tab in My Oracle Support.  From the Certifications tab on My Oracle Support, you can search for certified combinations of products with specific Oracle E-Business Suite versions.  For example:

Step 1.  Log in to My Oracle Support

Step 2. Click on the Certifications tab

Step 3.  Add your search criteria.  For example:  Add Oracle E-Business Suite to the Product List, add Release 12.2.4 to the Release List and optionally add your platform to the Platform List.

Step 4.Click Check certifications with another product

Step 5.  Add Data Guard to the Product List and optionally add the version to the Release List

The above search will list all versions of data guard currently certified as shown in the following screenshot:


References

Related Articles

Thursday Jul 02, 2015

Oracle Data Guard 12.1.0.2 Certified with EBS 12.1.3

I'm pleased to announce the certification of Oracle Data Guard 12.1.0.2 with Oracle E-Business Suite 12.1.3.  Certification with Oracle Data Guard 12.1.0.2 provides you the ability to create a Physical Standby Database for Oracle E-Business Suite 12.1.3 environments.  The creation of a Physical Standby Database is a key component of creating a disaster recovery site for Oracle E-Business Suite.

Detailed steps for setting up a 12.1.0.2 Physical Standby Database for Oracle E-Business Suite 12.1.3 are provided in the following My Oracle Support Note:

Oracle E-Business Suite Data Guard Certifications

The following matrix provides an overview of what's currently certified and what's planned for Oracle E-Business Suite 12.1.3 and 12.2 and Oracle Data Guard 11.2.0.4 and 12.1.0.2:


Oracle Data Guard 11.2.0.4 Oracle Data Guard 12.1.0.2
Oracle E-Business Suite 12.1.3 Certified, MOS Note 1070033.1 Certified*, MOS Note 1900663.1
Oracle E-Business Suite 12.2 Certified*, MOS Note 1491855.1 Pending Certification**

*For single node databases only.  Certification with RAC configurations is pending .

**Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog.

How to Find the Latest Certification Information

This blog is great for announcing certifications as they happen, but for ongoing updates and the latest information on certifications, your single source of truth is the Certifications tab in My Oracle Support.  From the Certifications tab on My Oracle Support, you can search for certified combinations of products with specific Oracle E-Business Suite versions.  For example:

Step 1.  Log in to My Oracle Support

Step 2. Click on the Certifications tab

Step 3.  Add your search criteria.  For example:  Add Oracle E-Business Suite to the Product List, add Release 12.1.3 to the Release List and optionally add your platform to the Platform List.

Step 4.Click Check certifications with another product

Step 5.  Add Data Guard to the Product List and optionally add the version to the Release List

The above search will list all versions of data guard currently certified as shown in the following screenshot:


References

Related Articles

Thursday Jun 25, 2015

DB 12.1.0.2 Certified with EBS 12.1.3 on Linux on IBM System z

IBM logoOracle Database 12c Release 1 (12.1.0.2) is now certified with Oracle E-Business Suite Release 12.1 (12.1.3) on the following Linux on IBM System z operating systems as a 'database tier only' platform:

Release 12.1 (12.1.3 or higher):

  • 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 11 (64-bit)

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 (see My Oracle Support Certifications for more information). IBM's z systems fully support a mixed platform architecture with distributed Unix and Linux certified application tier servers for customers looking to run Oracle E-Business Suite on System z.
This announcement includes:

  • Oracle Database 12cR1 version 12.1.0.2
  • Oracle Database 12cR1 version 12.1.0.2 Real Application Clusters (RAC)
  • Oracle Database 12cR1 Version 12.1.0.2 Database In-Memory Option
  • Transparent Data Encryption (TDE) Column Encryption using Oracle Database 12cR1 version 12.1.0.2
  • Transparent Data Encryption (TDE) Tablespace Encryption using Oracle Database 12cR1 version 12.1.0.2
  • Advanced Security Option (ASO)/Advanced Networking Option (ANO) with Oracle Database 12cR1 version 12.1.0.2
  • Export/Import Process for Oracle E-Business Suite Release 12.0 or 12.1 with Oracle Database 12cR1 version 12.1.0.2

The following are not yet certified and will be announced on a later date once completed.

  • Oracle Multitenant 12cR1 version 12.1.0.2
  • Oracle Database Vault 12cR1 version 12.1.0.2
  • Transportable Database Data Migration Processes

References

Related Articles


Tuesday Jun 16, 2015

DSTv24 Timezone Patches Available for E-Business Suite

Hourglass iconIf your E-Business Suite Release 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 September 2014 and released as DSTv23.

DSTv24 is now available and certified with Oracle E-Business Suite Release 12.2, 12.1, and 11.5.10.2. The DSTv24 update includes the timezone information from the IANA tzdata 2015d.  It 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 DSTv24 timezone definition file is cumulative and includes all DST changes released in earlier time zone definition files. DSTv24 includes changes to the following timezones since the DSTv23 release:

  • Africa/Cairo,
  • America/Cancun,
  • America/Grand_Turk,
  • America/Santiago,
  • Antarctica/Palmer,
  • Asia/Dacca,
  • Asia/Hovd,
  • Asia/Ulaanbaatar,
  • Asia/Gaza,
  • Asia/Choibalsan,
  • Asia/Hebron,
  • Europe/Minsk,
  • Pacific/Easter,
  • Pacific/Fiji,
  • Egypt,
  • Jamaica,
  • Chile/Continental,
  • Asia/Dhaka,
  • Asia/Ulan_Bator,
  • 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.

Proactive backports of DST upgrade patches to all Oracle E-Business Suite tiers and platforms are not created and supplied by default. If you need this DST release and an appropriate patch is not currently available, raise a service request through support providing a business case with your version requirements.

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

Thursday May 28, 2015

11gR2 Transportable Database Certified for EBS 12.2 Database Migration

Database migration across platforms of the same "endian" (byte ordering) formats using the Transportable Database (TDB) process is now certified for Oracle E-Business Suite Release 12.2 with Oracle Database 11g Release 2 (11.2.0).

The "endian-ness" of platforms can be checked by querying the view V$TRANSPORTABLE_PLATFORM using sqlplus (connected as sysdba):

    SQL> select platform_name, endian_format from v$transportable_platform;

Here's a list of relevant platforms certified for the EBS R12 (12.2) with 11gR2 on the database tier:

 Big Endian Platforms
 Little Endian Platforms
 Oracle Solaris on SPARC  Linux x86-64
 HP-UX Itanium  Oracle Solaris on x86-64
 IBM AIX on POWER Systems  MS Windows x64
 IBM: Linux on System z

Using Transportable Database is the fastest method for migration between platforms of the same endian format. A requirement of this migration process is that the source and target Database versions must match (including patch set version), so database upgrades as part of the migration cannot be done.

For migration between platforms of different endian formats, users must use alternative migration methods such as export/import (datapump).

References

Related Articles

Wednesday Apr 29, 2015

Database Migration Using 12cR1 Transportable Tablespaces Now Certified for EBS 12.1.3

As a follow up to a prior announcement, database migration across platforms of different "endian" or byte ordering formats using the Transportable Tablespaces (TTS) process is now certified for Oracle E-Business Suite Release R12 (12.1.3) with Oracle Database 12c Release 1 (12.1.0) as both the source and target database. The previous announcement covered the use of 11gR2 as the source and 12cR1 as the target database.

Furthermore, this TTS migration process uses the new 12c feature of full transportable export/import to move the entire database to further speed up the migration process. Also, users have the option to use cross platform incremental backup, a way to minimize database downtime and data transfer times.

This migration process requires a patch delivered by EBS Development that is 'Controlled', i.e. it requires a password obtainable through Oracle Support subject to approval. We released the required patch in this manner to assess suitability, potentially monitor customer issues due to the nature of this technology and to gauge uptake.

 The "endian-ness" of platforms can be checked by querying the view V$TRANSPORTABLE_PLATFORM using sqlplus (connected as sysdba):

    SQL> select platform_name, endian_format from v$transportable_platform;

Here's a list of relevant platforms certified for the EBS R12 with 12cR1 on the database tier:

 Big Endian Platforms
 Little Endian Platforms
 Oracle Solaris on SPARC
 Linux x86-64
 HP-UX Itanium
 Oracle Solaris on x86-64
 IBM AIX on Power Systems
 MS Windows x64

For more information, please review the following:

Related Articles


Thursday Mar 19, 2015

Oracle Database 12.1.0.2 Certified with EBS 12.1 on HP-UX Itanium, IBM AIX

As a follow up to a prior announcement, Oracle Database 12c Release 1 (12.1.0.2) is now certified with Oracle E-Business Suite Release 12.1.3 on the following additional platforms:

  • HP-UX Itanium (11.31)
  • IBM AIX on Power Systems (64-bit) (6.1, 7.1)

database 12c download screenshot

Database Feature and Option Certifications

The following database features and options are supported for use:

  • Advanced Compression
  • Advanced Security Option (ASO)/Advanced Networking Option (ANO)
  • Database In-Memory Column Store (IM Column Store)
  • Real Application Clusters (RAC)
  • TDE Column Encryption and TDE Tablespace Encryption
  • Export/Import Process

The following are not yet certified:

  • Oracle Multitenant
  • Oracle Database Vault
  • Transportable Database and Transportable Tablespaces Data Migration Processes

Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. We will post updates here as soon as soon as they're available.   

References


Please refer to the platform specific Oracle Database Installation Guides for operating system and other prerequisites.
Please refer to the Oracle Database 12c Release 1 (12.1.0.2) New Features Guide 12c Release 1 (12.1) and Oracle Database Administrator's Guide for more information regarding the "In-Memory Column Store" feature.

Related Articles


Thursday Feb 26, 2015

Reminder: Upgrade Database 12.1.0.1 to 12.1.0.2 by July 2015

E-Business Suite customers must ensure that their database remains on a level that is covered by Error Correction Support (ECS) -- i.e. while you can get new patches, Critical Patch Updates (CPU), and Patch Set Updates (PSU).  We've covered this in detail here:

The following Note lists Error Correction Support dates for all database patchsets for all database releases:

That Note shows that patching ends for the 12.1.0.1 Database patchset on July 22, 2015. All EBS customers on Database 12.1.0.1 should upgrade to the Database 12c 12.1.0.2 patchset before then. 

Related Articles

Thursday Feb 12, 2015

Database 12.1.0.2 Certified with E-Business Suite 11i

[Sep. 30, 2015 Update: Moved "Data Guard Redo Apply with Physical Standby Database" to the "Certifications Not Planned" section]

I’m pleased to announce that 12.1.0.2, the first patchset for Database 12c is now certified with Oracle E-Business Suite 11i. Be sure to review the 11i interoperability note.

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

Screenshot of Database 12.1.0.2 OTN download page

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

  • 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:

Certifications Not Planned

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

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

Related Articles


Thursday Feb 05, 2015

Reminder: Upgrade Database 10.2.0.5 Before July 2015

[Aug. 11, 2015 update: corrected reference to incorrect database patchset]

E-Business Suite customers must ensure that their database remains on a level that is covered by Error Correction Support (ECS) -- i.e. while you can get new patches, Critical Patch Updates (CPU), and Patch Set Updates (PSU).  We've covered this in detail here:

The following Note lists Error Correction Support dates for all database patchsets for all database releases:

That Note shows that patching ends for the 10.2.0.5 on July 31, 2015. There is additional fine print for Severity 1 fixes and other platforms -- see the Note for details.

All EBS customers should upgrade to a later patchset or database release before then.  As of today, options include upgrading to the 11.2.0.4 patchset or Database 12c 12.1.0.2.

Related Articles


Reminder: Upgrade Database 11.1.0.7 Before August 2015

E-Business Suite customers must ensure that their database remains on a level that is covered by Error Correction Support (ECS) -- i.e. while you can get new patches, Critical Patch Updates (CPU), and Patch Set Updates (PSU).  We've covered this in detail here:

The following Note lists Error Correction Support dates for all database patchsets for all database releases:

That Note shows that patching ends for the 11.1.0.7 Database patchset on August 31, 2015. There is additional fine print for Severity 1 fixes and other platforms -- see the Note for details.

All EBS customers should upgrade to a later patchset or database release before then.  As of today, options include upgrading to the 11.2.0.4 patchset or Database 12c 12.1.0.2.

Related Articles


Reminder: Upgrade Database 11.2.0.3 Before August 2015

E-Business Suite customers must ensure that their database remains on a level that is covered by Error Correction Support (ECS) -- i.e. while you can get new patches, Critical Patch Updates (CPU), and Patch Set Updates (PSU).  We've covered this in detail here:

The following Note lists Error Correction Support dates for all database patchsets for all database releases:

That Note shows that patching ends for the 11.2.0.3 Database patchset on August 27, 2015

All EBS customers should upgrade to a later patchset or database release before then.  As of today, options include upgrading to the 11.2.0.4 patchset or Database 12c 12.1.0.2.

Related Articles


Thursday Jan 08, 2015

Database 12.1.0.2 Certified with E-Business Suite 12.2

I’m pleased to announce that 12.1.0.2, the first patchset for the 12c Database, is now certified with E-Business Suite 12.2.2 and higher. 

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

Oracle E-Business Suite Release 12.2.x
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 (10, 11)*
*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.
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

  • Oracle Multitenant
  • Oracle Database Vault
  • TDE Tablespace Encryption
  • 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 will be posted as soon as soon as they're available.  

EBS 12.2 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 Dec 18, 2014

DB 12.1.0.1 Certified with EBS 11i & R12 on Linux on IBM System z

IBM LogoOracle Database 12c Release 1 (12.1.0.1) is now certified with Oracle E-Business Suite Release 11i, 12.0, and 12.1 on the following Linux on IBM System z operating systems as 'database tier only' platforms:

Release 11i (11.5.10.2 + ATG PF.H.delta.7 (RUP 7) or higher), Release 12.0 (12.0.6 or higher), Release 12.1 (12.1.3 or higher):

  • 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 11 (64-bit)

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 (see My Oracle Support Certifications for more information). IBM's z systems fully support a mixed platform architecture with distributed Unix and Linux certified application tier servers for customers looking to run Oracle E-Business Suite on System z.

This announcement includes:

  • Oracle Database 12cR1 version 12.1.0.1
  • Oracle Database 12cR1 version 12.1.0.1 Real Application Clusters (RAC)
  • Transparent Data Encryption (TDE) Column Encryption using Oracle Database 12cR1 version 12.1.0.1
  • Transparent Data Encryption (TDE) Tablespace Encryption using Oracle Database 12cR1 version 12.1.0.1
  • Advanced Security Option (ASO)/Advanced Networking Option (ANO) with Oracle Database 12cR1 version 12.1.0.1
  • Export/Import Process for Oracle E-Business Suite Release 11i with Oracle Database 12cR1 version 12.1.0.1
  • Export/Import Process for Oracle E-Business Suite Release 12.0 or 12.1 with Oracle Database 12cR1 version 12.1.0.1

Pending Certifications

The following are not yet certified and will be announced on a later date once completed.

  • Oracle Multitenant 12cR1 version 12.1.0.1
  • Oracle Database Vault 12cR1 version 12.1.0.1
  • Transportable Database and Transportable Tablespaces Data Migration Processes

Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.    

References

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

Related Articles

Tuesday Dec 09, 2014

Database 12c 12.1.0.2 Certified With 12.1 On Oracle Solaris on x86-64

As a follow up to our earlier announcement, Oracle Database 12cR1 Version 12.1.0.2 is now certified with Oracle E-Business Suite Release 12 for 12.1 on the following additional platform:

Release 12.1 (12.1.3 and higher):

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

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.

Data12.1.0.2 download screenshot

In addition, the Export/Import process for EBS release 12.0 or 12.1 with Oracle Database 12cR1 Version 12.1.0.2 is now certified.

Certification data in My Oracle Support (http://support.oracle.com) is being updated with this information - please review the documents below for all requirements and additional details:

Related Articles

Friday Nov 21, 2014

Testing Your EBS Environment After Database Upgrades

Customers often ask, "What should I test after I upgrade my EBS database?" Your environment is, by definition, unique to you, with your own architectural configurations, setup data, and customizations.  You should always concentrate your testing efforts on the areas that may differ from our generic EBS tests.  Until now, our generic common-sense answer has always been, "Test what is important to your business."  

Our Quality Assurance group in EBS Development has just published some guidance on the things that you might consider adding to your post-upgrade test plans:

They discuss things such as memory-intensive concurrent requests, compliance with new standards for initialization parameters, custom workflows, and more.

Your feedback is welcome.  I'll make sure that the Note's authors are notified if you drop me an email or post a comment here. 

Related Articles

About

Search

Categories
Archives
« June 2016
SunMonTueWedThuFriSat
   
3
4
5
8
9
10
11
12
13
15
16
17
18
19
20
22
23
24
25
26
27
29
30
  
       
Today