Wednesday Mar 05, 2014

Oracle Database 11.2.0.4 Certified with E-Business Suite 12.2

I'm very happy to announce the certification of Oracle Database 11.2.0.4 with Oracle E-Business Suite 12.2. 

To begin planning your database upgrade to 11.2.0.4, you should review our documentation in this order:

  1. Interoperability Notes: Oracle E-Business Suite 12.2 with Oracle Database 11g Release 2 (Note 1623879.1) 

  2. R12.2 Consolidated List of Patches and Technology Bug Fixes (Note 1594274.1) .  The interoperability note references this note.  It is crucial that you review all requirements in Section 2.2, "Database 11.2.0.4 Patches and Bug Numbers" of this note.

  3. Database Initialization Parameters for Oracle E-Business Suite Release 12 (Note 396009.1).  Make certain that you review Section 4, "Release-Specific Database Initialization Parameters For Oracle 11gR2" and Section 6, "Additional Database Initialization Parameters for Oracle E-Business Suite Release 12.2".

What does this mean if you are upgrading to R12.2?

  • This upgrade is highly recommended for all EBS 12.2 environments.

  • If you are just beginning your upgrade to R12.2 project, you should consider upgrading to Oracle Database 11.2.0.4 now. 

  • If your are currently in the midst of your R12.2 upgrade, you may continue as planned with Oracle Database 11.2.0.3 and upgrade to 11.2.0.4 as your R12.2 upgrade project and test plans permit.

  • If your go-live date is soon, you may choose to continue as planned with Oracle Database 11.2.0.3 and upgrade to 11.2.0.4 after you go-live with 12.2.

It may be useful to review the the Oracle Database 11gR2 support policies and dates as part of your decision-making process:

Prerequisites

  • 12.2.2 and higher
Certified Platforms
  • Linux x86-64 (Oracle Linux 5, 6)
  • Linux x86-64 (RH 5, 6)
  • Linux x86-64 (SLES 10, 11)
  • Oracle Solaris on SPARC (64-bit)  (10, 11)
  • Oracle Solaris on x86-64 (64-bit) (10, 11) -  Database tier only
  • IBM AIX on Power Systems (64-bit) (6.1, 7.1)
  • HP-UX Itanium (11.31)
Pending Platform Certifications
  • Microsoft Windows x64 (64-bit)
  • IBM: Linux on System z 
Database Feature and Option Certifications
The following database features and options are certified:

Pending Database Feature and Option Certifications

  • Database Vault

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.    

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.

Friday Sep 27, 2013

11.2.0.4 Database Certified with E-Business Suite

I’m pleased to announce that 11.2.0.4, the terminal patchset for the 11gR2 Database is now certified with Oracle E-Business Suite. Be sure to review the interoperability notes for R11i and R12 for the most up-to-date requirements for deployment.

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


Oracle E-Business Suite Release 11i

Prerequisites
  • 11.5.10.2 + ATG PF.H RUP 6 and higher
Certified Platforms
  • Linux x86 (Oracle Linux 4, 5)
  • Linux x86 (RHEL 4, 5)
  • Linux x86 (SLES 10)
  • Linux x86-64 (Oracle Linux 4, 5) -- Database-tier only
  • Linux x86-64 (RHEL 4, 5) -- Database-tier only
  • Linux x86-64 (SLES 10--Database-tier only)
Pending Platform Certifications
  • Oracle Solaris on SPARC
  • Oracle Solaris on x86-64 (64-bit)
  • IBM AIX on Power Systems
  • HP-UX Itanium
  • Microsoft Windows Server (32-bit)
  • Microsoft Windows x64 (64-bit)
  • HP-UX PA-RISC (64-bit)
  • IBM: Linux on System z 
Oracle E-Business Suite Release 12.0.4 and higher
Certified Platforms
  • Linux x86 (Oracle Linux 4, 5)
  • Linux x86 (RHEL 4, 5)
  • Linux x86 (SLES 10)
  • Linux x86-64 (Oracle Linux 4, 5)
  • Linux x86-64 (RHEL 4, 5)
  • Linux x86-64 (SLES 10)
Pending Certifications
  • Oracle Solaris on SPARC 
  • Oracle Solaris on x86-64
  • IBM AIX on Power Systems (64-bit)
  • HP-UX Itanium
  • Microsoft Windows Server (32-bit)
  • Microsoft Windows x64 (64-bit)
  • HP-UX PA-RISC (64-bit)
  • IBM: Linux on System z
Oracle E-Business Suite Release 12.1.1 and higher
Certified Platforms
  • Linux x86 (Oracle Linux 4, 5, 6)
  • Linux x86 (RHEL 4, 5, 6)
  • Linux x86 (SLES 10)
  • Linux x86-64 (Oracle Linux 4, 5, 6)
  • Linux x86-64 (RHEL 4, 5, 6)
  • Linux x86-64 (SLES 10, 11)
Pending Certifications
  • Oracle Solaris on SPARC 
  • Oracle Solaris on x86-64
  • IBM AIX on Power Systems (64-bit)
  • HP-UX Itanium
  • Microsoft Windows Server (32-bit)
  • Microsoft Windows x64 (64-bit)
  • HP-UX PA-RISC (64-bit)
  • IBM: Linux on System z
Database Feature and Option Certifications
The following database options and features are supported for use:
About the pending certifications

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

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

12.1.0.1 Database Certified with Oracle E-Business Suite

(Feb 19, 2014 Update: Article has been updated to correctly reflect Active Data Guard and Data Guard as pending certifications.)

I’m pleased to announce that 12.1.0.1, the base release for the 12c Database is now certified. Be sure to review the interoperability notes for R11i and R12 for the most up-to-date requirements for deployment.

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


Oracle E-Business Suite Release 11i

Prerequisites
  • 11.5.10.2 + ATG PF.H RUP 7 and higher
Certified Platforms
  • Linux x86-64 (Oracle Linux 5) -- Database-tier only
  • Linux x86-64 (RHEL 5) -- Database-tier only
  • Oracle Solaris on SPARC (64-bit) (10)
  • Oracle Solaris on x86-64 (64-bit) (10) -- Database-tier only
Pending Platform Certifications
  • Microsoft Windows x64 (64-bit)
  • IBM AIX on Power Systems (64-bit)
  • HP-UX Itanium
  • IBM: Linux on System z 
Oracle E-Business Suite Release 12.0.6 and higher
Certified Platforms
  • Linux x86-64 (Oracle Linux 5)
  • Linux x86-64 (RHEL 5)
  • Oracle Solaris on SPARC (64-bit) (10)
  • Oracle Solaris on x86-64 (64-bit) (10) -- Database-tier only
Pending Platform Certifications
  • Microsoft Windows x64 (64-bit)
  • IBM AIX on Power Systems (64-bit)
  • HP-UX Itanium
  • IBM: Linux on System z 
    Oracle E-Business Suite Release 12.1.3 and higher
    Certified Platforms
    • Linux x86-64 (Oracle Linux 5, 6)
    • Linux x86-64 (RHEL 5, 6)
    • Linux x86-64 (SLES 11)
    • Oracle Solaris on SPARC (64-bit) (10, 11)
    • Oracle Solaris on x86-64 (64-bit) (10, 11) -- Database-tier only
    Pending Platform Certifications
    • Microsoft Windows x64 (64-bit)
    • IBM AIX on Power Systems (64-bit)
    • HP-UX Itanium
    • IBM: Linux on System z 
    Database Feature and Option Certifications
    The following database options and features are supported for use:

    Pending Feature/Option Certifications

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

    About the pending certifications

    Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog for updates, which 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.

    Monday Nov 14, 2011

    11gR2 11.2.0.3 Database Certified with E-Business Suite

    [Nov 15, 2011 Update: Added TDE Tablespace and Column Encryption to the list of certified options]

    The 11gR2 11.2.0.2 Database was certified with E-Business Suite (EBS) 11i and EBS 12 almost one year ago today.  I’m pleased to announce that 11.2.0.3, the second patchset for the 11gR2 Database is now certified. Be sure to review the interoperability notes for R11i and R12 for the most up-to-date requirements for deployment.

    This certification announcement is important as you plan upgrades to the technology stack for your environment. For additional upgrade direction, please refer to the recently published EBS upgrade recommendations article. Database support implications may also be reviewed in the database patching and support article.


    Oracle E-Business Suite Release 11i

    Prerequisites
    • 11.5.10.2 + ATG PF.H RUP 6 and higher
    Certified Platforms
    • Linux x86 (Oracle Linux 4, 5)
    • Linux x86 (RHEL 4, 5)
    • Linux x86 (SLES 10)
    • Linux x86-64 (Oracle Linux 4, 5) -- Database-tier only
    • Linux x86-64 (RHEL 4, 5) -- Database-tier only
    • Linux x86-64 (SLES 10--Database-tier only)
    • Oracle Solaris on SPARC (64-bit) (10)
    • Oracle Solaris on x86-64 (64-bit) (10) -- Database-tier only
    Pending Platform Certifications
    • Microsoft Windows Server (32-bit)
    • Microsoft Windows Server (64-bit)
    • HP-UX PA-RISC (64-bit)
    • HP-UX Itanium
    • IBM: Linux on System z 
    • IBM AIX on Power Systems
    Oracle E-Business Suite Release 12
    Prerequisites
    • Oracle E-Business Suite Release 12.0.4 or later; or,
      Oracle E-Business Suite Release 12.1.1 or later
    Certified Platforms
    • Linux x86 (Oracle Linux 4, 5)
    • Linux x86 (RHEL 4, 5)
    • Linux x86 (SLES 10)
    • Linux x86-64 (Oracle Linux 4, 5)
    • Linux x86-64 (RHEL 4, 5)
    • Linux x86-64 (SLES 10)
    • Oracle Solaris on SPARC (64-bit) (10)
    • Oracle Solaris on x86-64 (64-bit) (10)  -- Database-tier only
    Pending Platform Certifications
    • Microsoft Windows Server (32-bit)
    • Microsoft Windows Server (64-bit)
    • HP-UX PA-RISC (64-bit)
    • IBM: Linux on System z
    • IBM AIX on Power Systems
    • HP-UX Itanium
    Database Feature and Option Certifications
    The following 11gR2 11.2.0.3 database options and features are supported for use:
    About the pending certifications

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

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

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

    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.

    Thursday Oct 01, 2009

    Database Vault 11.1.0.7 Certified for E-Business Suite on Windows Platforms

    Our Applications Platforms Group continues to round out our E-Business Suite certification matrix for Oracle Database Vault 11gR1.  Oracle DB Vault 11gR1 11.1.0.7 is now certified with E-Business Suite for the following Windows platforms:
    • Microsoft Windows Server (32-bit)
    • Microsoft Windows x64 (64-bit)
    DBVault11107-new.png
    Prerequisites
    • Oracle Database 11gR1 version 11.1.0.7
    • Oracle Database Vault 11gR1 version 11.1.0.7
    • Oracle E-Business Suite Release 11i version 11.5.10.2 or higher
    • Oracle E-Business Suite Release 12 version 12.0.4 or higher
    • Oracle E-Business Suite Release 12 version 12.1
    References
    Related Articles


    Thursday Jul 16, 2009

    Database Vault 11.1.0.7 Certified with Oracle E-Business Suite

    Oracle DB 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.  

    Database Vault 10gR2 was certified last year with Oracle E-Business Suite.  We're pleased to announce that the latest Database Vault 11gR1 Version 11.1.0.7 is now certified with E-Business Suite Release 11i and 12.

    You can now enable Database Vault 11gR1 on your existing E-Business Suite 11.1.0.7 Database instance.  If you already have DB Vault 10gR2 enabled in your E-Business Suite environment, you can now upgrade to the 11gR1 Database.  We also support EBS patching with Database Vault 11.1.0.7 enabled. Our DB Vault realm creation and grants-related scripts have been revised to reduce patching downtimes.

    Screenshot of database vault web page page showing Database Vault Feature Administration menu of security options

    Prerequisites

    • Oracle Database 11gR1 version 11.1.0.7
    • Oracle Database Vault 11gR1 version 11.1.0.7
    • Oracle E-Business Suite Release 11i version 11.5.10.2 or higher
    • Oracle E-Business Suite Release 12 version 12.0.4 or higher
    • Oracle E-Business Suite Release 12 version 12.1

    Certified Platforms

    • Linux x86
    • Linux x86-64 (64-bit)
    • Sun Solaris SPARC
    • IBM AIX
    • HP-UX PA-RISC
    • HP-UX Itanium

    Certifications for Microsoft Windows Server (32-bit) and Windows x64 (64-bit) are still underway.  I don't have firm schedules for these certifications yet, but you're welcome to monitor or subscribe to this blog for updates.  

    References

    Related Articles

    Thursday Sep 18, 2008

    Database Vault 10.2.0.4 Certified with EBS 11i and 12

    [Nov 24, 2008 Update: Added new R12 platform certifications for Microsoft Windows Server 2003, HP-UX PA-RISC, and HP-UX Itanium]. Added new 11i platform certifications for Windows 2000 Server, Windows Server 2003, HP-UX PA-RISC, OEL, RHEL, SUSE, HP-UX Itanium.]

    Our certification run-up to OpenWorld continues, and I'm pleased to announce that Database Vault 10.2.0.4 is now certified with E-Business Suite Release 11i and 12. For more details about Database Vault and how it works in E-Business Suite environments, see this article. This new certification brings improved performance and broader certification coverage for additional operating systems, too.

    [Read More]

    Thursday Feb 07, 2008

    Using Oracle Database Vault 10gR2 With Apps 11i

    [Editor Update May 21, 2008:  Nilesh has moved on to another team within Oracle and, sadly, is no longer an active contributor to this blog.  Feel free to direct any questions about his posted articles directly to Steven Chan, instead.]


    I'm very pleased to announce that Oracle Database Vault 10gR2 10.2.0.3 is certified with the E-Business Suite Release 11i.  I've been working on this certification for the last year. In this article I will give you some insight into how Oracle E-Business Suite Release 11i can be configured to use Oracle Database Vault features to protect sensitive transactional data from powerful users like Apps DBAs.

    What is Oracle Database Vault?

    A key challenge for security administrators is protecting enterprise data from insider attacks.  Oracle Database Vault is an optional database feature that can help you defend against that class of threats, as well as build internal controls to help meet regulatory requirements for privacy and segregation of duties.

    Oracle Database Vault can prevent highly privileged users, including powerful application DBAs and others, from accessing sensitive applications and data in Oracle databases outside their authorized responsibilities. You can use customizable Realms and rules to ensure that users, even administrators, have access only to what they need to do their job.

    Database Vault example: Diagram showing how Database Vault prevents a privileged DBA user from accessing application data, while allowing the authorized Realm owner to access the same data

    The figure above illustrates how Oracle Database Vault addresses the following database security concerns:
    • Administrative privileged account access to application data: In this case, Oracle Database Vault prevents the DBA from accessing the schemas that are protected by the FIN Realm. Although the DBA is the most powerful and trusted user, the DBA does not need access to application data residing within the database.
    • Separation of duties for application data access: In this case, the FIN Realm Owner, created in Oracle Database Vault, has access to the FIN Realm schemas.
    Protecting Database Objects With Realms and Rules

    Oracle Database Vault uses Realms to set up boundaries around set of objects in specific schemas; specific conditions must be met to access data protected by those boundaries. Realms specify a set of conditions that must be met before a given command can be executed on a set of database objects.

    This provides very granular control over what can be done to certain objects, and by whom. You can define rules to restrict access based on business-specific factors such as data access connections from particular database, from a particular machine, and from specific IP addresses.  You can also specify the time of day or authentication modes for data access.

    For details about various Oracle Database Vault Realms and customizable rules, see:
    Minimum Requirements
    Additional interoperability patches are also required. For complete details, see:
    Preseeded Realms for the E-Business Suite

    Oracle delivers a set of preseeded Database Vault Realms for your E-Business Suite Release 11i environment via the following patch:
    This patch contains the master fnddvebs.sql script. The fnddbvebs.sql script creates Realms around Oracle E-Business Suite 11i product schemas and gives authorization only to those users required to allow the Oracle E-Business Suite to function normally.

    The fnddvebs.sql script creates six Realms. Each realm protects different product schemas and has its own set of user authorizations.
    • EBS Realm
    • EBS Realm - Applsys Schema
    • EBS Realm - Applsyspub Schema
    • EBS Realm - Apps Schema
    • EBS Realm - MSC Schema
    • CTXSYS Data Dictionary
    Oracle Supplied Ebiz 11i Realms: Screenshot of Database Vault 10g 10.2.0.3 Realms definition screen, with pre-seeded Realms for the E-Business Suite Release 11i displayed

    Extending Oracle-Supplied Realms

    Oracle strongly recommends against modifying the preseeded Oracle-supplied Realms for the E-Business Suite. If you're familiar with the E-Business Suite data model, you can create your own realms and secure additional objects as needed. Improperly defined Realms can prevent the E-Business Suite from functioning normally, so careful testing of your custom Realms is advisable.

    Metalink Note 428503.1 has a detailed example of extending Oracle E-Business suite 11i realms.

    Key Considerations About Realms

    The preseeded Realms are not intended to provide:
    1. Protection from user logged into the SYSTEM schema
    2. Protection during Application mid tier patching
    Documentation
    Related Articles

    Wednesday May 10, 2006

    Statement of Direction: Oracle Database Vault and E-Business Suite Release 11i

    [Feb 8, 2008 Update: Database Vault 10g 10.2.0.3 has been certified with the E-Business Suite Release 11i. See this tag for all Database Vault related articles

    [Editor Oct 30 2007 Update:  This certification is still underway.  Customers interested in this certification are encouraged to monitor or subscribe to this website for updates, which will be posted as soon as this certification is completed.]

    [Editor May 2, 2007 Update:  As of today, the Database Vault certification for the E-Business Suite is still pending.  Our certification activities are underway, but there are no published schedules available yet.  We're working with the Database Vault team to obtain and certify some patches that are required for compatibility.]


    Oracle's recent announcement of the Oracle Database Vault for the 10gR2 Database has spurred a surge of questions about its use with E-Business Suite Release 11i.


    As a core database technology, it may generally be assumed to work with the E-Business Suite with no issues.  That said, the E-Business Suite covers a lot of territory, and Apps DBAs unfamiliar with its data model might need some guidance on how to set up Database Vault to meet their security requirements. 

    We have internal projects underway to develop some best practices around this for E-Business Suite environments.  Following that, we plan to publish some white papers summarizing those best practices and guidelines. 

    We don't have any firm schedules for these papers yet, but feel free to subscribe to this blog if you'd like to be notified when they're available.

    Related Articles:

    UPDATE (May 12, 2006): 

    Our Database Vault Product Management team is collecting names of customers who might be interested in using Database Vault with the E-Business Suite, PeopleSoft, JD Edwards, or Siebel applications.  Please feel free to add a comment to this post or send me a private email if you're interested in this configuration.

    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