X

The Latest Technology Stack News Directly from EBS Development

Using Two New Oracle Database 11gR2 Features With EBS

Steven Chan
Senior Director

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