Tuesday Feb 14, 2017

Updated: Database Partitioning with EBS Whitepaper

Partitioning allows a single database table and its associated indexes to be broken into smaller components depending on the table and choice of index partitioning methods.  This can sometimes improve performance of large EBS databases significantly. Several E-Business Suite modules take advantage of database partitioning right out of the box, and custom partitioning is also possible.

Our Applications Performance Group has just released a major update to their best-practices white paper on EBS database partitioning:

Partitioning diagram

The new white paper covers:

  • Partitioning fundamentals and references to key partitioning resources
  • Relationship between partitioning and compression
  • Principles for effective partitioning of EBS tables
  • Definitions of seeded vs. custom partitioning
  • Benefits of partitioning
  • Considerations when evaluating partition designs
  • Identifying objects that might be good candidates for partitioning
  • Implementing and testing partitioning
  • And most useful: lots of concrete examples with benchmarks!

Over 90% of this whitepaper has been rewritten, so you should check out this new edition even if you've downloaded an earlier version.

Related Articles

Wednesday Feb 08, 2017

Database 12.1 Extended Support Fee Waived through July 2019

Oracle's Lifetime Support policy has three phases:  Premier Support, Extended Support, and Sustaining Support.  For details about coverage during each phase, see:

You can purchase a support plan for your licensed products to obtain Premier Support.  There is an additional fee for Extended Support. 

Premier Support for Database 12.1 runs to July 31, 2018. Extended Support for Database 12.1 runs to July 31, 2021. The Extended Support fee for Oracle Database 12c 12.1 has been waived to July 31, 2019.  See:

Related Articles


Tuesday Feb 07, 2017

Database 11.2 Extended Support Fee Waived through December 2018

Oracle's Lifetime Support policy has three phases:  Premier Support, Extended Support, and Sustaining Support.  For details about coverage during each phase, see:

You can purchase a support plan for your licensed products to obtain Premier Support.  There is an additional fee for Extended Support. 

Extended Support for Database 11.2 runs to December 31, 2020. The Extended Support fee for Oracle Database 11gR2 11.2 has been waived to December 31, 2018.  See:

Related Articles


Thursday Feb 02, 2017

Updated: EBS 12.1 + Transportable Tablespaces with Incremental Backup Option

Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process has been certified for Oracle E-Business Suite Release R12.1 for several years. 

This certification has recently been updated to cover the use of the incremental backup option with Database 11.2.0.4 as a source.

Transportable Tablespaces

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 sqlplus (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 and Transportable Tablespaces (for large databases) or export/import should be used for database migration.

The use of Transportable Tablespaces can greatly speed up the migration of the data portion of the database - it does not affect metadata which must still be migrated using export/import. We recommend that users initially perform a test migration with export/import on their database with the 'metrics=y' parameter to find out the relative size of data vs metadata in their database and to have a basis to compare any gains in timing. Generally speaking, the larger the relative size of data (as compared to metadata), the more likely it would be that XTTS is suitable to reduce downtime.

Thursday Jan 12, 2017

GoldenGate 12c Certified with E-Business Suite 12.2

Oracle GoldenGate provides real-time capture, transformation, routing, and delivery of database transactions across heterogeneous systems.  The GoldenGate Administrator's Guide shows six supported topologies for generic databases.  Oracle GoldenGate 12c is now certified for a subset of three of those methods in Oracle E-Business Suite Release 12.2 environments:

  1. Unidirectional (Reporting Instance):  From the E-Business Suite to a reporting instance
  2. Broadcast (Data Distribution): From the E-Business Suite to multiple external databases
  3. Consolidation (Data Warehouse/Mart/Store): From multiple sources, including the E-Business Suite, into a single external database
Three supported GoldenGate topologies in E-Business Suite environments

Procedures for replicating information from E-Business Suite 12.2 using GoldenGate to a secondary system are documented in:

Unidirectional  reporting only

Certified Combinations

  • EBS 12.2.5 and later 12.2.x releases
  • Database 12.1.0.2 or 11.2.0.4
  • GoldenGate 12.1.2 and later 12.x releases

Replication to a Non-Editioned Target Database

EBS 12.2's Online Patching architecture has significant implications for data replication solutions implemented using Oracle GoldenGate. The Note above describes how to set up a unidirectional configuration of Oracle GoldenGate replication from an Oracle E-Business Suite Release 12.2 source database to a non-editioned target database.

Using GoldenGate with EBS 12.2 environments is significantly different from previous EBS releases.  If you are upgrading your GoldenGate + EBS 12.1 environment to EBS 12.2, and you must plan carefully for the new integration steps detailed in the documentation above.

Only Unidirectional replication for EBS

GoldenGate is an extremely powerful solution, and one of its most-interesting features is the ability to provide data replication in both directions.  In some generic scenarios, you can choose to make alterations to replicated data on the external instance and have those changes updated back in the source database.

Bidirectional replication is not permitted for E-Business Suite environments.  You can use GoldenGate to replicate EBS data to an external database, but you cannot move that altered data back into the EBS database.  GoldenGate's ability to read data in EBS databases is certified, but it must not be used to write to EBS databases.

"How" But Not "What"

GoldenGate is akin to a scalpel.  You're free to use it, but you must learn how to perform open heart surgery yourself.

The document above describes how to use GoldenGate to replicate data from the E-Business Suite to another system.  It doesn't provide any guidance about which database objects to replicate.

The E-Business Suite data model is vast, as you'd expect of something that has supports the integrated functioning of over 200 functional product modules.  GoldenGate is a development tool, and like all development tools, requires an expert-level understanding of the E-Business Suite data model for successful use.  Here's a good EBS data model resource:

Not Certified for EBS Migrations and Upgrades

GoldenGate is not certified for:

  • Upgrading E-Business Suite databases from one version to another
  • Migrating E-Business Suite databases from one operating system platform to another

Why not?  Oracle GoldenGate does not currently support the replication of all of the datatypes that are used by the E-Business Suite.  In addition, GoldenGate relies upon tables with primary keys for replication. EBS has over 10,000 tables without primary keys.  That means that attempting to use GoldenGate to migrate or upgrade an entire E-Business Suite database requires a combination of GoldenGate and other manual steps to preserve referential integrity.

Oracle does not currently have any plans to produce a certified or automated method of using GoldenGate for E-Business Suite upgrades or platform migrations.

EBS 12.2 customers should use our documented procedures for upgrades and migrations.  

Related Articles

Friday Dec 16, 2016

Does Oracle E-Business Suite Require Oracle Database Enterprise Edition?

Yes.  All versions of Oracle E-Business Suite require Oracle Database Enterprise Edition.  Oracle Database Enterprise Edition is a mandatory requirement for EBS 12.2, 12.1 and older EBS releases. This applies to all Oracle Database releases, including Database 12.1, 11.2, and older Database releases certified with EBS.

It is not possible to run Oracle E-Business Suite with other Oracle Database editions, including:

  • Oracle Database Standard Edition One (Database SE1)
  • Oracle Database Standard Edition (Database SE)
  • Oracle Database Express Edition (Database XE)
  • Oracle Database Personal Edition (Database PE)

Why is Oracle Database Enterprise Edition a mandatory prerequisite for EBS today?

The Oracle E-Business Suite is designed to support a wide range of deployment architectures, from small single-office instances to highly-secure, highly-available Global Single Instance deployments.  To support these architectures, the E-Business Suite uses a broad range of database features and extra cost options such as Advanced Queuing, Data Guard, Virtual Private Databases, Secure Application Roles, Fine-Grained Auditing, Advanced Security, Label Security, Materialized Views, Database Vault, Partitioning, OLAP, Advanced Compression, Connection Manager, and more.

Will Oracle Database Enterprise Edition always be a mandatory prerequisite?

It is expected that Oracle Database Enterprise Edition will be a mandatory prerequisite for all future Oracle E-Business Suite releases and Database release combinations.

The Enterprise Edition is the only Database edition that includes all of those components. Enterprise Edition is the only Database edition certified and supported for use with E-Business Suite environments

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 Dec 13, 2016

Does Flashback Data Archive work with EBS?

Flashback Data Archive is a group of Oracle Database features that that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery. Oracle Flashback features use the Automatic Undo Management (AUM) system to obtain metadata and historical data for transactions. They rely on undo data, which are records of the effects of individual transactions.

Flashback Data Archive was formerly known as Total Recall.  Flashback Data Archive is licenced via the Oracle Advanced Compression (ACO) database option.

Oracle Flashback Data Archive diagram

Oracle Flashback is not explicitly certified with the E-Business Suite, but it is supported.  We do not currently publish any Best Practices whitepapers with guidance on how to use Flashback Data Archive with EBS.  The generic Oracle Flashback Technology documentation is applicable to E-Business Suite databases.

Related Articles

Friday Dec 02, 2016

Database Vault 12.1.0.2 Certified with EBS 12.1 and 12.2

Oracle Database Vault allows security administrators to protect a database from privileged account access to application data.  Database objects can be placed in protected realms, which can be accessed only if a specific set of conditions are met.

We are pleased to announce that Oracle Database Vault 12c 12.1.0.2 is now certified with Oracle E-Business Suite Release 12.2 and 12.1. To integrate Oracle Database Vault 12c with Oracle E-Business Suite Release 12.2 or 12.1, follow the instructions in the corresponding My Oracle Support Knowledge Document:



Note:  We deliver a default realm via two different patches for Oracle E-Business Suite 12.2 and 12.1 .  You may use the default realm as-is or choose a subset.

Pending Certifications with External Integrations

The following two configurations are still underway and pending:

  • Single Sign-On Integration with Oracle Access Manager
  • Oracle Discoverer

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

Related Articles

Tuesday Nov 15, 2016

DSTv28 Timezone Patches Available for E-Business Suite 12.1 and 12.2

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 October 2016 and released as DSTv27.

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

  • Asia/Rangoon
  • Asia/Istanbul
  • Europe/Istanbul
  • Turkey

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:

What is the business impact of not applying these patches?

Timezone patches update the database and other libraries that manage time. They ensure that those libraries contain the correct dates and times for the changeover between Daylight Savings Time and non-Daylight Savings Time.

Time is used to record events, particularly financial transactions.  Time is also used to synchronize transactions between different systems.  Some organizations’ business transactions are more-sensitive to timezone changes than others. 

If you do not apply a timezone patch, and do business with a region that has changed their timezone definitions, and record a transaction that occurs at the boundary between the “old” and the “new” time, then the transaction may be recorded incorrectly. That transaction's timestamp may be off by an hour. 

For example:

  • An order is placed for a customer in a country which changed their DST dates in DST v27
  • The old Daylight Savings Time expiration date was Nov. 2
  • The new Daylight Savings Time expiration date is now October 31
  • An order is set to ship at 12am on November 1st
  • Under the old Daylight Savings Time rules, the revenue would be recorded for November
  • Under the new Daylight Savings Time rules, the revenue would be recorded for October

Related Article

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.   


Tuesday Nov 01, 2016

Which Oracle Database Patchsets Can Be Used With EBS?

Oracle versions numbers can be very long.  Complicating matters further, different product families within Oracle use the version hierarchy differently.  This can make it confusing to determine whether a specific product update has been certified with Oracle E-Business Suite.

Oracle Database update numbers can be daunting.  However, it might be reassuring to learn that the fifth-level digit in Oracle Database version is not relevant to E-Business Suite certifications.  In other words, you can apply any database patchsets that have been certified at the fourth-level digit. 

For example, we have certified EBS 12.2 with Database 12.1.0.2. All of the following Oracle Database patchsets will work with EBS 12.2:

  • Oracle Database 12.1.0.2.0 (documented certification)
  • Oracle Database 12.1.0.2.160419 (April 2016 Database Proactive Bundle Patch)
  • Oracle Database 12.1.0.2.160719 (July 2016 Database Proactive Bundle Patch)

This is sometimes shown in our documentation in either of the following ways:

  • Oracle Database 12.1.0.2
  • Oracle Database 12.1.0.2.x

The absence of a fifth-digit or the presence of an 'X' in the fifth digit's place means any fifth-digit level updates may be applied to an Oracle Database for EBS 12.2 without requiring a new certification.  This applies to all environments, including test and production environments.

Related Articles

Monday Oct 10, 2016

DSTv27 Timezone Patches Available for E-Business Suite 12.2

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 November 2015 and released as DSTv25.

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

  • Asia/Novosibirsk
  • America/Cayman
  • Asia/Chita
  • Asia/Tehran,
  • Haiti,
  • Palestine,
  • Azerbaijan,
  • Chile
  • America/Caracas
  • Asia/Magadan

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:

What is the business impact of not applying these patches?

Timezone patches update the database and other libraries that manage time. They ensure that those libraries contain the correct dates and times for the changeover between Daylight Savings Time and non-Daylight Savings Time.

Time is used to record events, particularly financial transactions.  Time is also used to synchronize transactions between different systems.  Some organizations’ business transactions are more-sensitive to timezone changes than others. 

If you do not apply a timezone patch, and do business with a region that has changed their timezone definitions, and record a transaction that occurs at the boundary between the “old” and the “new” time, then the transaction may be recorded incorrectly. That transaction's timestamp may be off by an hour. 

For example:

  • An order is placed for a customer in a country which changed their DST dates in DST v27
  • The old Daylight Savings Time expiration date was Nov. 2
  • The new Daylight Savings Time expiration date is now October 31
  • An order is set to ship at 12am on November 1st
  • Under the old Daylight Savings Time rules, the revenue would be recorded for November
  • Under the new Daylight Savings Time rules, the revenue would be recorded for October

Related Article

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.   


Wednesday Sep 28, 2016

DSTv27 Timezone Patches Available for E-Business Suite 12.1

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 November 2015 and released as DSTv25.

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

  • Asia/Novosibirsk
  • America/Cayman
  • Asia/Chita
  • Asia/Tehran,
  • Haiti,
  • Palestine,
  • Azerbaijan,
  • Chile
  • America/Caracas
  • Asia/Magadan

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:

Pending Certification 

Our certification of this DST timezone patch with Oracle E-Business Suite 12.2 is currently underway.

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.   


Monday Sep 12, 2016

Offloading EBS 12.2 Reporting Using Active Data Guard 12.1.0.2

Oracle Active Data Guard 12.1.0.2 is now certified with Oracle E-Business Suite 12.2.  This certification supports the ability to offload some production reporting from your production EBS 12.2 environment to an Active Data Guard instance. For example, you can use Oracle Discoverer and Concurrent Manager to run selected reports against an Oracle Active Data Guard physical standby database instance. 

Detailed steps for setting up Active Data Guard 12.1.0.2 with Oracle E-Business Suite 12.2 are provided in the following My Oracle Support Note:

Active Data Guard ADG 12.1.0.2 + EBS

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. 

Pending Certifications

This certification covers non-RAC instances only.  Updates for environments that use Real Application Clusters are still 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. I'll post updates here as soon as soon as they're available.

Related Articles

Thursday Aug 04, 2016

EBS 12.2 DB Migration Using 12cR1 Transportable Tablespaces Now Certified

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 12.2 (12.2.3 or higher) with Oracle Database 12c Release 1 (12.1.0).

This certification requires that the source database be 11gR2 (11.2.0.4) or 12cR1 (12.1.0.2) and the target database be 12cR1 (12.1.0.2). This 12.2/12cR1 database migration process utilizes the 'full transportable export/import' feature of 12c to greatly speed up the migration while also offering the optional use of incremental backup.

This migration process requires a patch delivered by the EBS Platform Engineering team which is now generally available on MOS for use by EBS customers.

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
 Little Endian
 Oracle Solaris on SPARC
 Linux x86-64
 HP-UX Itanium
 Windows x64
 IBM AIX on Power Systems
 Oracle Solaris on x86-64
 IBM: Linux on System z

The use of Transportable Tablespaces may greatly speed up the migration of the data portion of the database - it does not affect metadata which must still be migrated using export/import. Smaller databases (less than 1TB) may see little gain from the use of Transportable Tablespaces, and other techniques like export/import will be simpler and likely faster.

For smaller databases, we highly recommend that users initially perform a test migration with export/import on their database with the 'metrics=y' parameter to find out the relative size of data vs metadata in their database and to have a basis to compare any gains in timing. Generally speaking, the larger the relative size of data (as compared to metadata), the more likely it would be that TTS is suitable as a migration process to reduce downtime.

Database migration between platforms of the same endian format should use the 'Transportable Database' process or Rapid Clone if migrating between the same platform.

References

Related Articles

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

About

Search


Categories
Archives
« February 2017
SunMonTueWedThuFriSat
   
4
5
11
12
18
19
20
25
26
27
28
    
       
Today