Tuesday Nov 01, 2011

11gR2 Transportable Tablespaces Certified for EBS 11i

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

Small endian to big endian platform migrations

Obtaining this patch

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

Does it meet your requirements?

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

SQL>select platform_name from v$db_transportable_platform;

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

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

Where can I find more information?

Related Articles


Saturday Oct 22, 2011

Latest DSTv17 Timezone Patches Available for E-Business Suite R11i

Hourglass iconIf your E-Business Suite Release 11i or 12 environment is configured to support Daylight Saving Time (DST) or international time zones, it's important to keep your timezone definition files up-to-date. 

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

Is Your Apps Environment Affected?

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

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

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

Monday Oct 17, 2011

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

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

Is Your Apps Environment Affected?

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

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

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

Related Articles


Friday Oct 14, 2011

Latest DSTv17 Timezone Patches Available for E-Business Suite R12

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

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

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

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

Is Your Apps Environment Affected?

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

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

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

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

What Patches Are Required?

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

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

What happened to EBS 11i?

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

Related Articles

Wednesday Aug 31, 2011

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

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

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

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

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

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

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

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

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

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

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

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

EBS 11i

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

EBS 12

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

References

    Related Articles


    Tuesday Aug 23, 2011

    Managing EBS 12 Physical Standby Databases with Oracle Data Guard Broker

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

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

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

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

    Oracle Data Guard architecture overview diagram

    There are two interfaces to manage broker configurations:

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

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

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

    What about logical standby or Oracle Streams?

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

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

    References

    Related Articles

    Tuesday Aug 09, 2011

    Latest DSTv16 Timezone Patches Available for E-Business Suite R12

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

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

    Is Your Apps Environment Affected?

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

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

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

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

    What Patches Are Required?

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

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

    What happened to EBS 11i?

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

    Related Articles

    Friday Jul 22, 2011

    Reminder: Database 11.1.0.7 Premier Support ends August 2012

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

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

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

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

    No support exceptions for EBS users

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

    Related Articles

    Tuesday Jul 19, 2011

    Reminder: Database 11.2.0.1 Error Correction Support ends Sept. 2011

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

    No support exceptions for EBS users

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

    Thursday Jul 14, 2011

    Using Audit Vault with Oracle E-Business Suite

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

    Conceptual diagram showing audit data tracked by Oracle Audit Vault

     From the Oracle Audit Vault FAQ:

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

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

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

    No special setups required for EBS

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

    Related Articles


    Monday Jul 11, 2011

    Secure Enterprise Search 11.1.2.2 Certified with E-Business Suite 12

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

    Screenshot of Asset Inquiry screen using Secure Enterprise Search with EBS

    Certified Platforms

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

    References

    Related Articles


    Thursday May 26, 2011

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

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

    Release 12.1 (12.1.2 or higher):

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

    Release 12.0 (12.0.4 or higher)1:

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

    1: This is a 'database tier only' or 'split tier configuration' certification where the application tier must be on a fully certified E-Business Suite platform. Starting with Release 12.1.2, Linux on System z became a fully certified platform.

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

    EBS 12 References
    Related Articles

    Wednesday May 25, 2011

    Database 11.2.0.2 Certified with EBS on HP-UX

    As a follow-on to our original announcement, Oracle Database 11g Release 2 (11.2.0.2) is now certified with Oracle E-Business Suite Release 12 (12.0.4 and higher, 12.1.1 and higher) and 11i (11.5.10.2 + ATG PF.H RUP 6 and higher)on the following additional platforms:

    Release 12:

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

    Release 11i:

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

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

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

    Certification of the following database options and features is still underway:
    • Transparent Data Encryption (TDE) Tablespace Encryption 11gR2 version 11.2.0.2
    EBS 11i References
    EBS 12 References

    Related Articles

    Tuesday May 17, 2011

    Database Migration using 11gR2 Transportable Tablespaces Now Certified for EBS 12

    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 R12 (12.0.4 and higher, 12.1.1 and higher) with Oracle Database 11g Release 2.

    Small endian to big endian platform mappings

    Obtaining the Required EBS Patch

    This migration process requires a patch delivered by the E-Business Suite Platform Engineering team that is 'Controlled', i.e. it requires a password obtainable from Development through Oracle Support. We released the required patch in this manner to potentially monitor customer issues (due to the nature of this technology), to gauge suitability and to monitor uptake. Customers may be required to fill out a questionnaire as part of an evaluation and approval process.

    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.

    References

    Related Articles


    Monday May 16, 2011

    TDE Tablespace Encryption 11.2.0.2 Certified with E-Business Suite

    Oracle Advanced Security is an optional licenced Oracle 11g Database add-on. Oracle Advanced Security Transparent Data Encryption (TDE) offers two different features: column encryption and tablespace encryption. TDE Tablespace Encryption 11.2.0.2 is now certified with Oracle E-Business Suite Release 11i (11.5.10.2 + ATG PF.H RUP 6 and higher) and Release 12 (Releases 12.0.6 and higher and 12.1.1 and higher).

    What is Transparent Data Encryption (TDE) ?

    Oracle Advanced Security Transparent Data Encryption (TDE) allows you to protect data at rest. TDE helps address privacy and PCI requirements by encrypting personally identifiable information (PII) such as Social Security numbers and credit card numbers.

    TDE is completely transparent to existing applications with no triggers, views or other application changes required. Data is transparently encrypted when written to disk and transparently decrypted after an application user has successfully authenticated and passed all authorization checks. Authorization checks include verifying the user has the necessary select and update privileges on the application table and checking Database Vault, Label Security and Virtual Private Database enforcement policies.

    Existing database backup routines will continue to work, with the data at rest remaining encrypted in the backup. For encryption of entire database backups, TDE can be used in combination with Oracle RMAN.

    What is Tablespace Encryption ?

    TDE Key Management architectureNew in Oracle Database 11g, the Oracle Advanced Security now includes support for tablespace encryption.

    When a tablespace is created through Enterprise Manager or on the command line, an option now exists to specify that the file be encrypted on the file system. When new data is added to the new tablespace using the insert command or datapump, entire tables will be transparently encrypted. When the database reads data blocks from the encrypted tablespace it will transparently decrypt the data blocks.

    With this certification, Oracle E-Business Suite environments can be migrated to the latest 11gR2 version of encrypted tablespaces. For more information, see:

    This database option is certified for all EBS platforms on which Oracle Database 11.2.0.2 is certified.  You can refer to the Certifications system on My Oracle Support for details about certified EBS platforms for this database release.

    Related Articles



    Tuesday May 10, 2011

    Database 10.2.0.5 Certified with EBS on Nine Additional Platforms

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

    Release 11.5.10.2 + ATG RUP 6 and higher

    • HP-UX PA-RISC (64-bit) (11.11, 11.23, 11.31)
    • HP-UX Itanium (11.23, 11.31)1
    • IBM: Linux on System z (RHEL 4 and 5, SLES 9 and 10)1
    Release 12 (12.0)
    • HP-UX PA-RISC (64-bit) (11.11, 11.23, 11.31)
    • IBM: Linux on System z (RHEL 4 and 5, SLES 9 and 10)1
    Release 12 (12.1)
    • HP-UX PA-RISC (64-bit) (11.23, 11.31)
    • IBM: Linux on System z (RHEL 5, SLES 9 and 10)
    1: This is a database tier only (or split tier) configuration where the application tier must reside on a different fully certified E-Business Suite platform

    This announcement includes:
    • Oracle Database Vault
    • Transparent Data Encryption (Column Encryption)
    • Advanced Security Option (ASO)/Advanced Networking Option (ANO)
    • Export/Import Process for Oracle E-Business Suite Release 11i and Release 12 Database Instances
    EBS 12 References
    EBS 11i References

    Related Articles

    Monday May 09, 2011

    Oracle Database 11gR2 11.2.0.2 Certified with EBS on Microsoft Windows

    As a follow-on to our 11.2.0.2 certification announcement late last year, Oracle Database 11g Release 2 (11.2.0.2) is now certified with Oracle E-Business Suite Release 12 and 11i on the following Microsoft Windows platforms:

    Release 12.1.1 and higher
    • Microsoft Windows Server (32-bit) (2003, 2008)
    • Microsoft Windows x64 (64-bit) (20031, 20081, 2008 R22)
    Release 12.0.4 and higher
    • Microsoft Windows Server (32-bit) (2003)
    • Microsoft Windows x64 (64-bit) (2003, 2008, 2008 R2)1
    Release 11.5.10.2 + ATG PF.H RUP 6 and higher
    • Microsoft Windows Server (32-bit) (2003)
    • Microsoft Windows x64 (64-bit) (2003, 2008)1
    1: This OS is a 'database tier only' or 'split tier configuration' platform where the application tier must be on a fully certified E-Business Suite platform.
    2: This OS is a 'database tier only' platform for Release 12.0. For 12.1.1 or higher, it is also supported on the application tier via the migration process outlined in My Oracle Support Document 1188535.1.

    This announcement for Oracle E-Business Suite R12 and 11i includes:
    • Oracle Database Vault
    • Transparent Data Encryption (Column Encryption)
    • Advanced Security Option (ASO)/Advanced Networking Option (ANO)
    • Export/Import Process for Oracle E-Business Suite Release 11i and Release 12 Database Instances
    EBS 11i References
    EBS 12 References
    Related Articles

    Tuesday Jan 25, 2011

    Database 10gR2 10.2.0.5 Certified with EBS on 14 Additional Platforms

    Somehow this certification that was completed last year missed out as a blog article (though it was updated at the time in our official Certifications matrix on My Oracle Support). 

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

    Platforms certified for 11i (11.5.10 CU2+ATG_PF.H.delta.6 (RUP 6) and higher)

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

    Platforms certified for R12 (12.0.4 and higher) and 12.1 (12.1.1 and higher):

    • HP-UX Itanium (11.23, 11.31)
    • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
    • Oracle Solaris on SPARC (64-bit) (8, 9, 10)
    • Oracle Solaris on x86-64 (64-bit) (10) (See Note 1)

    Screencap of download screen for 10 2 0 5 database patchset page 10205-download.png


    Notes

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

    Certified Database Options

    This database patchset certification also includes the following 10gR2 10.2.0.5 database options:

    • Real Application Clusters
    • Oracle Database Vault
    • TDE Column Encryption
    • Advanced Security Option/Advanced Networking Option (ANO/ASO) 
    Should You Upgrade to This Release?

    There are two important considerations if you're deciding whether to upgrade to this release.  The first:  Premier Support for 10gR2 ended in July 2010.  The second: Error Correction Support for 10.2.0.4 ends in April 2011 -- in three months.  For more details about what this means for E-Business Suite environments, and recommendations, see this article:
    EBS 12 References
    EBS 11i References
    Related Articles

    Friday Jan 21, 2011

    Upgrading EBS 12 to DB 11g with Physical Standby Enabled

    It's possible to use Oracle Data Guard to create physical standby databases for disaster recovery.  E-Business Suite users can configure their environments with the latest version of Oracle Data Guard 11g by following the documents linked in this article:
    When upgrading a database to a new release, you can upgrade the Data Guard Physical Standby database inline to minimize the downtime. To achieve this in an EBS 12 environment, additional manual configuration steps are needed on both the primary and standby systems.  These manual steps allow redo to be shipped from the primary and applied on the standby during the upgrade.

    Diagram showing synchronization of primary and data guard physical standby environments  dataguard2.JPG
    After the upgrade, the primary and physical standby will be in sync, and the physical standby should be reconfigured using AutoConfig.

    We have now published EBS 12-specific documentation covering this upgrade scenario for both 11gR1 and 11gR2 databases: Related Articles

    Thursday Jan 20, 2011

    Reminder: Error Correction Support for DB 10gR2 10.2.0.4 Ends April 30, 2011

    Experienced Apps DBAs know that they need to monitor database support windows for their E-Business Suite environments.  For an in-depth discussion about how database support policies affect E-Business Suite users, see:
    An important deadline is approaching if you're still running any E-Business Suite release on the 10gR2 10.2.0.4 database.  New 10gR2 patches produced after April 30, 2011 will require 10.2.0.5.  No new patches will be produced for 10.2.0.4 after that date. 

    This is covered, along with other useful topics, in the following 10gR2 Support FAQ from my colleagues in the Server Technologies division:

    Another important point from that FAQ:
    8. Will I get more time to install 10.2.0.5 if it is released on my platform close to April 30, 2011?

    Yes.  We will always support the previous patch set for at least 3 months, even if it is released after the one year to install the new patch set is up.  For example, patching for 10.2.0.4 generally expires on April 30, 2011.  If you are running 10.2.0.4 on the Commodore 64 platform and Oracle releases it after April 30, 2011, we will still patch 10.2.0.4 for you for 3 months following the 10.2.0.5 release on your platform.
    Advice for EBS sysadmins

    If you're still running your EBS environment on the 10.2.0.4 database, here are your options (in order of greatest bang-for-your-upgrade-buck):
    1. Upgrade to 11.2.0.2.  It's the latest 11gR2 database version certified with the E-Business Suite. Upgrading to this level will buy you the longest period before you're forced to do another database upgrade.
    2. Upgrade to 11.1.0.7.  It's the latest 11gR1 database version certified with the E-Business Suite.  Looking at this pragmatically, though, I don't see much value in upgrading to 11gR1.  If you're going to go to the trouble of upgrading from 10gR2 10.2.0.4 to a newer major database release, you might as well do it right and upgrade to 11.2.0.2.
    3. Upgrade to 10.2.0.5.  If you're planning on staying on 10gR2 for a while, you should be on a release for which you can get new patches and security fixes.
    Related Articles

    Wednesday Jan 19, 2011

    E-Business Suite Release 12 Certified With Microsoft Windows Server 2008 R2 (Windows x64)

    windows-logo.jpg
    I am pleased to announce that Oracle E-Business Suite Release 12 (12.1.1 or higher) is now certified with Microsoft Windows x64 (64-bit) on both the application and database tiers through a certified migration of an existing Release 12 installation. Microsoft Windows Server 2008 R2 is a Windows x64 (64-bit) only operating system and is the latest Windows server version.

    Support of the E-Business Suite on this platform is achieved by a two-step process of migrating the Oracle Database first (as documented in the 11gR2 Database Tier Only Platform note), and then migrating the application tier using the process documented in the R12 Rapid Clone note. These steps and all requirements are outlined in:
    The operating systems certified on this platform are:
    • Microsoft Windows Server 2008 R2 Standard
    • Microsoft Windows Server 2008 R2 Enterprise
    • Microsoft Windows Server 2008 R2 Datacenter
    • Microsoft Web Server 2008 R2
    Oracle E-Business Suite does not support Hyper-V and Server Core in Windows Server 2008 R2. Please review the documents below for all requirements and additional details on the use of EBS on this new platform.

    A number of external technology components are also certified with E-Business Suite R12 on this platform such as Oracle Internet Directory 11g, Oracle Discoverer 11g, Oracle Portal 11g, etc. Please review the Certifications tab on My Oracle Support for current information on platform support and certifications.

    References
    Related Articles

    Wednesday Jan 12, 2011

    Latest DSTv15 Timezone Patches Available for E-Business Suite

    Wooden_hourglass_small2.jpg
    If your E-Business Suite Release 11i or 12 environment is configured to support Daylight Saving Time (DST) or international time zones, it's important to keep your timezone definition files up-to-date. They were last changed in July 2010 and released as DSTv14. DSTv15 is now available and certified with Oracle E-Business Suite Release 11i and 12.

    Is Your Apps Environment Affected?

    When a country or region changes DST rules or their time zone definitions, your Oracle E-Business Suite environment will require patching if:
    • Your Oracle E-Business Suite environment is located in the affected country or region OR
    • Your Oracle E-Business Suite environment is located outside the affected country or region but you conduct business or have customers or suppliers in the affected country or region
    We last discussed the DSTv14 patches on this blog. The latest "DSTv15" timezone definition file is cumulative and includes all DST changes released in earlier time zone definition files. DSTv15 includes changes to the following timezones since the DSTv14 release:
    • Africa/Cairo 2010 2010
    • Egypt 2010 2010
    • America/Bahia_Banderas 2010 2010
    • Asia/Amman 2002
    • Asia/Gaza 2010 2010
    • Europe/Helsinki 1981 1982
    • Pacific/Fiji 2011
    • Pacific/Apia 2011
    • Hongkong 1977 1977
    • Asia/Hong_Kong 1977 1977
    • Europe/Mariehamn 1981 1982
    What Patches Are Required?

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

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

    Thursday Jan 06, 2011

    Offloading (Some) EBS 12 Reporting to Active Data Guard Instances

    For most Oracle Database users, Oracle Active Data Guard allows users to:
    1. Create a physical standby database for business continuity and disaster recovery
    2. Offload reporting from the production database to the read-only physical standby database
    E-Business Suite customers have been able to use Active Data Guard to create physical standby databases for their EBS environments since the feature was introduced with the 11g Database.  EBS sysadmins can use the generic Active Data Guard documentation to take advantage of the Active Data Guard standby database capabilities. 

    I am pleased to announce that it is now possible to offload a subset of some ReportWriter-based reports -- but not all -- from a production EBS environment to an Active Data Guard physical standby database.  But before I go into the details of this newly-certified configuration, it's necessary to understand some details about what happens whenever someone attempts to access the E-Business Suite.

    adg_diagram.png

    Behind the scenes: logging into the E-Business Suite

    Every E-Business Suite user is assigned one or more responsibilities.  These responsibilities govern the E-Business Suite applications (i.e. menu functions) and data that a given user can access.  For example, as a manager, I might be assigned responsibilities that allow me to review my employees' compensation and approve their expense reports.  I'm also an employee, which means that I can review my own payslips and file new expense reports.

    Every time anyone logs into a running E-Business Suite instance, the following things happen:

    1. Their authenticated credentials are checked against their assigned E-Business Suite responsibilities.
    2. A user session is created in the E-Business Suite database.
    3. All activities are logged for audit and tracking purposes, even queries against existing data.

    This level of security prevents E-Business Suite unauthorized users from, say, assigning stock options to themselves.  It also provides an audit trail in case someone abuses their position by attempting to cook the books in the midst of a financial industry meltdown.

    This also applies to the use of external reporting tools like Oracle Discoverer.  Discoverer users must log into the E-Business Suite instance, which checks their assigned responsibilities to prevent users from running reports against data that they're unauthorized to view.

    What does that mean?

    Putting this together: 

    • Active Data Guard makes a read-only replication of a given database. 
    • Even the simple act of logging into an E-Business Suite database requires write access.
    What's Changed in this new Active Data Guard certification?

    In this new certification, it is possible to run a subset of the standard Oracle Reports delivered with the E-Business Suite against the Active Data Guard instance.  In some cases, EBS reports also perform writes against the database; those reports will not run in this Active Data Guard configuration.

    We've made the following changes to support this new configuration:
    1. Created new Active Data Guard database triggers to redirect minimal required read/write activity back to the primary E-Business Suite database. 
    2. Introduced changes within the E-Business Suite's FND layer to support this new functionality.
    3. Developed Parallel Concurrent Processing configurations to manage the report executions against Active Data Guard.
    Technical Prerequisites

    This configuration requires the following prerequisites:
    • Oracle E-Business Suite Release 12.1.3 or later
    • Oracle Database 11.1.0.7 or 11.2.0.2 with the Active Data Guard database option
    Getting access to this new configuration

    Given the new state of this configuration, we'd like to stay very close to customers implementing this in their E-Business Suite environments.  Although the documentation is published externally, the required EBS patches are currently being distributed in a controlled availability release.  To get access to these patches, please log a formal Service Request with Oracle Support to request a password to access this patch.  While working with Oracle Support to obtain the password, you should also send an email to "ebs_adgrel_us at oracle.com" so that we can monitor your Service Request in Development.

    References
    Related Articles

    Wednesday Dec 29, 2010

    New Whitepaper: Oracle E-Business Suite on Exadata

    [Dec. 30, 2010 Update: Added link to Note 1133355.1]

    Our Maximum Availability Architecture (MAA) team has quietly been amassing a formidable set of whitepapers about the Oracle Exadata Database Machine.  They're available here:
    If you're one of the lucky ones with access to this hardware platform, you'll be pleased to hear that the MAA team has just published a new whitepaper with best practices for EBS environments:
    exadata_v2_feature_main.png
    This whitepaper covers the following topics:
    • Getting to Exadata -- a high level overview of fresh installation on, and migration to, Exadata Database Machine with pointers to more detailed documentation
    • High Availability and Disaster Recovery -- an overview of our MAA best practices with pointers to our detailed MAA Best Practices documentation
    • Performance and Scalability -- best practices for running Oracle E-Business Suite on Exadata Database Machine based on our internal testing
    As an added bonus, the whitepaper has details about the internal testbeds where this configuration was evaluated with Oracle's own 18 TB Global Single Instance.  The whitepaper's Appendix discusses Exada Smart Flash Cache results, Smart Scan, RAC, and RMAN backup performance.

    Need an Overview of Migration Options?

    Also useful:  A summary of the different technologies and techniques that you can use to migrate your E-Business Suite database to Exadata can be found here:
    That overview Note provides a short but precise analysis of physical migration techniques (e.g. Data Guard Physical Standby, Transportable Database, Transportable Tablespaces, Rapid Clone) vs. logical migration techniques (e.g. Oracle Data Pump).

    Related Articles


    Friday Dec 17, 2010

    Is RAC One Node Certified for E-Business Suite?

    Oracle Real Application Clusters (RAC) is a cluster database with a shared cache architecture that supports the transparent deployment of a single database across a pool of servers.  RAC is certified with both Oracle E-Business Suite Release 11i and 12.  We publish best-practices documentation for specific combinations of EBS + RAC versions.  For example, if you were planning on implementing RAC for EBS 12, you would use this documentation:
    Many of the largest E-Business Suite users in the world run RAC today, including Oracle; see this Oracle R12 case study for details.

    A number of customers have recently asked whether RAC One Node can be used with the E-Business Suite.  From the RAC website:
    Oracle RAC One Node is a new option available with Oracle Database 11g Release 2. Oracle RAC One Node is a single instance of an Oracle RAC-enabled database running on one node in a cluster.

    Diagram of RAC One Node database migration between nodes rac_one_node.png

    RAC ONE Node is supported as a cold failover solution for E-Business Suite environments.  We don't support live node migration; the E-Business Suite does not have code-level support for Fast Application Notification (FAN) events at present. 

    Is there RAC One Node documentation for EBS environments?


    No, we do not explicitly certify or document E-Business Suite configurations.  You can follow the generic RAC One Node documentation to implement this in E-Business Suite environments.  If you're interested in using this technology with the E-Business Suite, you're advised to run proof-of-concept tests prior to a production deployment to ensure that it meets your operational requirements.

    Related Articles


    Friday Dec 10, 2010

    E-Business Suite Certified with DB 11.2.0.2 on HP-UX Itanium and IBM AIX on Power

    As a follow-on to our previous certification announcement, Oracle Database 11g Release 2 (11.2.0.2) s now certified with Oracle E-Business Suite Release 12 (12.0.x and 12.1.x) and 11i (11.5.10.2 + ATG PF.H RUP 6 and higher) on the following additional platforms:

    Oracle E-Business Suite Release 12
    • HP-UX Itanium (11.31)
    • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
    Oracle E-Business Suite Release 11i
    • IBM AIX on Power Systems (64-bit) (5.3, 6.1)

    db_11202_screenshot.png

    This announcement for Oracle E-Business Suite R12 and 11i includes:
    Pending Certifications
    • Transparent Data Encryption (TDE) Tablespace Encryption
    • Other platform certifications are pending and awaiting the availability of this patchset on the platform, including:
      • HP-UX PA-RISC (64-bit)
      • Microsoft Windows Server (32-bit)
      • IBM: Linux on System z 
    • 'Split tier' or 'database tier only' certifications on:
      • AIX 7 (R12)
      • HP-UX Itanium 11.31 (11i)
      • Microsoft Windows x64 (64-bit) (R12)
    Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.   

    EBS 11i References
    EBS 12 References
    Related Articles

    Thursday Dec 02, 2010

    Maintaining Your EBS Environment for Maximum Performance

    I think that all E-Business Suite DBAs know that they need to apply a number of interoperability patches when upgrading from one database release to another.  These are documented in our Interoperability Upgrade Notes for a given EBS + database combination.  For example, if you're upgrading Oracle E-Business Suite Release 12 to the latest 11gR2 11.2.0.2 database, you'd apply the patches listed here:
    However, I don't think it's as widely-known that there are two other classes of patches that you might need to apply.  These are documented in the following two Notes:
    1. Oracle E-Business Suite Recommended Performance Patches (Note 244040.1)
    2. Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (Note 1147107.1)

    Performance benchmark graph for EBS 12 1 2 cpu_load.png


    What are E-Business Suite "recommended performance patches"?

    Oracle E-Business Suite Recommended Performance Patches (Note 244040.1) is written and maintained by our Applications Performance team.  I've covered this team's responsibilities previously, but to recap: this team is dedicated to optimizing the performance of the E-Business Suite.  They perform all of our E-Business Suite benchmarks and high-volume scalability testing, and they work intensively with our largest E-Business Suite customers in fine-tuning E-Business Suite configurations. 

    They've summarized all of their hard-won expertise about performance-related patches in a single document.  A major part of this document covers database patches, but that's not all.  It also covers performance-related patches for:
    • Client tools
    • Applications Technology products and components
    • Financials products
    • Manufacturing and Supply Chain products
    • Human Resources products
    • Sales & Marketing products
    This should be your first stop after upgrading your database or if you're trying to nail down a troublesome database performance-related issue.  I consider this mandatory reading for all E-Business Suite DBAs.

    Do you want to apply database Patch Set Updates?

    Our Server Technologies division began releasing quarterly database Patch Set Updates (PSU) in July 2009.   Patch Set Updates include:
    • Field-tested fixes for critical technical issues that may affect a large number of customers
    • Critical Patch Update fixes
    Database Patch Set Updates are optional for E-Business Suite users.  If you choose to use them, database Patch Set Updates may safely be applied to Oracle E-Business Suite Release 11i and 12 environments.  Patch Set Updates are fully compatible and supported for use with the E-Business Suite.  Depending upon the database version and Oracle E-Business Suite release, one or more overlay patches may be required to address conflicts with a specific Oracle Database Patch Set Update.

    Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (Note 1147107.1) summarizes the latest overlay patches required when applying Database Patch Set Updates to Oracle E-Business Suite environments running on the 10gR2, 11gR1, and 11gR2 databases.  If you use PSUs with your EBS database, you should review this Note on a regular basis.

    Related Articles

    Tuesday Nov 30, 2010

    EBS 11i Extended Support Starts December 2010 with Minimum Patching Baselines

    [Editor: This article was originally published in January 2010, and again in August 2010.  Reposting this article in its entirety with small modifications to emphasize the date.]

    Premier Support for Oracle E-Business Suite Release 11i ends today, November 30, 2010. Extended Support for EBS 11i begins tomorrow, December 1st, 2010.

    Extended Support comes at an additional cost, but these are waived for Oracle E-Business Suite Release 11i through November 2011. I'm in EBS Development and not sales, so you should contact your Oracle account manager with questions about Extended Support costs. 

    Here is a comparison of the different support levels:

    A new set of minimum technical requirements for Apps 11i goes into effect when Extended Support begins in December 2010.  These new minimum baseline patch requirements are listed in:
    What are the impacts of this new baseline?

    As always, Oracle Support will assist with diagnosis, triage, and debugging of any issues that you report for your E-Business Suite environment.  You will continue to have access to any existing online support tools, knowledge base documentation, and pre-existing fixes.

    If you report a new issue that requires a new bug fix, you should be aware that new patches will be released only for the new baseline patches listed in the Minimum Baseline Patch Requirements Note.  You should plan to apply the baseline patches (at minimum) listed in Note 883202.1 by November 2010 in order to receive any new bug fixes.

    Minimum Baseline Patch Requirements
    • Oracle E-Business Suite Release 11.5.10 Consolidated Update 2 plus additional patches listed in Note 883202.1
    • ATG Rollup Patchset 6 (11i.ATG_PF.H.delta.6, Patch 5903765)
    • 10.2.0.4 Database or 11.1.0.7 Database
    • Forms6i Patchset 19 (version 6.0.8.28, Patch 6194129)
    • Oracle HTTP Server MLR Patchset 4393827
    • Sun Java Runtime Engine (JRE) 1.6.0_03 or higher
    The baseline versions listed here (and in the Note) are current as of the document's release date but may change in the future.  Any changes will be communicated via Note 883202.1.  If you've found this article as the result of a web search, I would strongly encourage you to check the latest version of the Note for the current information.

    What EBS 11i products are affected by this new baseline?

    In addition to the major technology stack components shown above, Note 883202.1 contains additional minimum baseline requirements for:
    • Applications Technology
      • Common Applications Calendar
    • Contracts
      • Core Contracts
      • Procurement Contracts
      • Project Contracts
      • Sales Contracts
      • Service Contracts
    • Customer Data Management
      • Customers Online
      • Trading Community
    • Financials
      • Assets
      • iAssets
      • Advanced Collections
      • Bill Presentment Architecture
      • Cash Management
      • E-Business Tax
      • Financials for the Americas
      • Financials for Asia/Pacific
      • Financials Common Country
      • Financials for EMEA
      • Financials for India
      • Internet Expenses
      • Lease Management
      • Loans
      • Payables
      • Payments
      • Property Manager
      • Public Sector Budgeting
      • Public Sector Financials
      • Public Sector Financials (International)
      • Receivables
      • iReceivables
      • Treasury
      • U.S. Federal Financials
    • Human Resources
      • Advanced Benefits
      • Approvals Management
      • HR Intelligence
      • Human Resources
      • Labor Distribution
      • Learning Management
      • Payroll (All Localizations)
      • Payroll (International/Custom)
      • iRecruitment
      • Self-Service Human Resources
      • Time and Labor
      • US Federal Human Resources
    • Intelligence
      • Balanced Scorecard
      • E-Business Intelligence
    • Interaction Center
      • Customer Interaction History
    • Logistics
      • Inventory Management
      • Warehouse Management
    • Manufacturing
      • Cost Management
      • Quality
      • Supply Chain Globalization
      • Work in Process
    • Marketing and Sales
      • Incentive Compensation
      • Marketing
      • Partner Management
      • Quoting
      • Sales
      • Sales for Handheld
      • Sales Offline
      • Territory Management
      • Trade Management
    • Order Management
      • Advanced Pricing
      • Configurator
      • Order Capture
      • Order Management
    • Procurement
      • iProcurement
      • Purchasing
      • Sourcing
      • iSupplier Portal
      • Supplier Scheduling
    • Product Lifecycle Management
      • Advanced Product Catalog
      • Bills of Material
      • Document Management and Collaboration
      • Engineering
      • Item Master
    • Projects
      • Grants Accounting
      • Project Billing
      • Project Collaboration
      • Project Costing
      • Project Portfolio Analysis
      • Project Foundation
      • Project Resource Management
      • Projects
    • Service
      • Advanced Scheduler
      • Complex Maintenance, Repair & Overhaul
      • Customer Care
      • Depot Repair
      • Field Service
      • iSupport
      • Teleservice
    • Supply Chain Planning
      • Demand Planning
      • Production Scheduling
      • Strategic Network Optimization
    Related Articles

    Sunday Nov 28, 2010

    Using Two New Oracle Database 11gR2 Features With EBS

    ORACLE_DB11G_CLR.GIF

    With the recent announcement of Oracle Database 11gR2 (11.2.0.2) certification with Oracle E-Business Suite, we've also certified two new features with the E-Business Suite to make your life a little easier.

    These two new features are:

    1. The Single Client Access Name (SCAN) feature that was introduced with the Oracle Database 11g Release 2 Grid Infrastructure to simplify client access to database services.

    2. No need to disable Fast Validation before performing Applications maintenance or upgrade operations.

    Single Client Access Name support for EBS environments

    Single Client Access Name (SCAN) is an Oracle Real Application Clusters (RAC) 11gR2 feature that provides a single name for clients to access Oracle databases running in a cluster. This means that the client's connect information can remain the same if cluster nodes are added or removed.

    The SCAN feature is now certified for use with the EBS AutoConfig configuration management tool, and can be deployed with EBS by following the steps below.

    1. Meet the configuration prerequisites for using the SCAN listener, as per My Oracle Support Knowledge Document Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 12 (Doc ID  823587.1).

    2. Set the following AutoConfig parameters as shown below:
      • s_scan_name = <SCAN Name>
      • s_scan_port = <SCAN Port>
      • s_update_scan = <TRUE>
    3. Run AutoConfig on the EBS database tier to create SCAN configuration files on that tier.

    4. Run AutoConfig on the application tier to create SCAN configuration files on that tier.

    No Need to Disable Fast Validation

    With database versions prior to Oracle 11gR2 (11.2.0.2), you needed to disable Fast Validation in the database when performing Applications upgrades or maintenance operations.

    To disable Fast Validation, you needed to add the following parameter to the database initialization parameter file:

    _disable_fast_validate=TRUE

    Failing to set this in Oracle Database 11gR1 (11.1.0.7) or 11gR2 (11.2.0.1) could lead to invalid objects and forms or reports compilation failures, potentially causing problems with product functional flows.

    Starting with 11gR2 (11.2.0.2), this parameter no longer needs to be set for upgrade or maintenance operations (and then unset again for normal operations).  This is one less thing for you to have to remember.

    References

    Related Articles

    Monday Nov 15, 2010

    11gR2 11.2.0.2 Database Certified with E-Business Suite

    [Jan 20, 2011 Update: Removed erroneous Linux x86-64 SLES 9 database tier reference]

    [Nov 18, 2010 Update: Added HP-UX Itanium to the EBS 11i list of pending certifications]


    We certified the 11gR2 11.2.0.1 Database with E-Business Suite 11i and EBS 12 late in 2009.  It's taken a little longer than we had hoped to certify 11.2.0.2, the first patchset for the 11gR2 Database.  The reasons: the release cycle for 11.2.0.2 overlapped with our EBS 12.1.3 release cycle, and some of the ports for this patchset weren't released until just before Halloween.  Our Server Technologies team is as-yet working on other ports, too.

    I know that some of you have been eager to apply this latest patchset to your E-Business Suite databases, so I'm very pleased to announce that Oracle Database 11gR2 Patchset 1 Version 11.2.0.2 is now certified with the E-Business Suite. 

    Screenshot of 11-2-0-2 11gR2 database patchset 1 Patchset 10098816 download page db_11202_screenshot.png

    Oracle E-Business Suite Release 11i
    Prerequisites
    • Oracle E-Business Suite Release 11.5.10.2
    Certified Platforms
    • Linux x86 (Oracle Linux 4, 5)
    • Linux x86 (RHEL 4, 5)
    • Linux x86 (SLES 10)
    • Linux x86-64 (Oracle Linux 4, 5) -- Database-tier only
    • Linux x86-64 (RHEL 4, 5) -- Database-tier only
    • Linux x86-64 (SLES 10--Database-tier only)
    • Oracle Solaris on SPARC (64-bit) (10)
    • Oracle Solaris on x86-64 (64-bit) (10) -- Database-tier only
    Pending Platform Certifications
    • Microsoft Windows Server (32-bit)
    • Microsoft Windows Server (64-bit)
    • HP-UX PA-RISC (64-bit)
    • HP-UX Itanium
    • IBM: Linux on System z 
    • IBM AIX on Power Systems
    Oracle E-Business Suite Release 12
    Prerequisites
    • Oracle E-Business Suite Release 12.0.4 or later; or,
      Oracle E-Business Suite Release 12.1.1 or later
    Certified Platforms
    • Linux x86 (Oracle Linux 4, 5)
    • Linux x86 (RHEL 4, 5)
    • Linux x86 (SLES 10)
    • Linux x86-64 (Oracle Linux 4, 5)
    • Linux x86-64 (RHEL 4, 5)
    • Linux x86-64 (SLES 10)
    • Oracle Solaris on SPARC (64-bit) (10)
    • Oracle Solaris on x86-64 (64-bit) (10)  -- Database-tier only
    Pending Platform Certifications
    • Microsoft Windows Server (32-bit)
    • Microsoft Windows Server (64-bit)
    • HP-UX PA-RISC (64-bit)
    • IBM: Linux on System z
    • IBM AIX on Power Systems
    • HP-UX Itanium
    Database Feature and Option Certifications
    The following 11gR2 11.2.0.2 database options and features are supported for use:
    Certification of the following database options and features is still underway:
    • Transparent Data Encryption (TDE) Tablespace Encryption 11gR2 version 11.2.0.2
    About the pending certifications

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

    EBS 11i References
    EBS 12 References
    Related Articles
    The preceding is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.

    About

    Search

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