Oracle OATM

Oracle Applications has become a massive product that performs virtually every possible area of managing a business. When ERP products get huge, standardization becomes important, and the new Oracle Applications Tablespace Model (OATM) has a tablespace migration utility in R12 as well as instructions as noted in MOSC patch number 3942506. OATM does tablespace consolidation with an eye towards maintaining a uniform logical storage layer for the application: Move data files to from UNIX File System files (UFS) to raw devices to allow RAC to read the files. Standardizes tablespaces to allow for uniform file striping via ASM. Consolidates tablespaces from 382 tablespaces down to only 9 standard tablespaces. Creates only one locally managed tablespace for all transaction tables and another LMT for transaction indexes. OATM has these system management tablespaces: undo tablespace - Undo data temp tablespace - Temporary data. Global Temporary tables system tablespace - system tablespace. Holds data dictionary OATM also creates these new application tablespaces: apps_ts_tx_data tablespace – OATM tablespace for transaction tables apps_ts_tx_idx tablespace - OATM tablespace for transaction Indexes apps_ts_seed tablespace - OATM tablespace for FND objects (reference and setup data) plus indexes. apps_ts_interface tablespace - OATM tablespace for Interface and temporary objects (temp data and indexes). apps_ts_summary tablespace – OATM tablespace for “summary management” objects, a.k.a. materialized views. apps_ts_nologging tablespace – This OATM tablespace is reserved for materialized views that are dro[pped and re-created in nologging mode. apps_ts_queues tablespace - This is the OATM tablespace for advanced queuing objects apps_ts_media tablespace - Multimedia objects apps_ts_archive tablespace - Archive purge related objects In sum, OATM is a new unified way of managing the complexity of over 380 tablespaces by moving them into only 9 applications tablespaces, all utilizing identical features.

Oracle Advanced Security

http://gavinsoorma.com/2010/12/11g-tablespace-encryption/ Using TDE Tablespace Encryption with Oracle E-Business Suite Release 12 (Doc ID 828229.1) https://blogs.oracle.com/stevenChan/entry/tde_tablespace_encryption_11201_ebs11i https://blogs.oracle.com/stevenChan/entry/db11gr2_certified_ebs11i Using TDE Tablespace Encryption with Oracle E-Business Suite Release 11i (OracleMetalink Note 828223.1). Database Security - Transparent Data Encryption FAQ from OTN Oracle Advanced Security - Transparent Data Encryption Best Practices from OTN Oracle Database Advanced Security Administrator's Guide 10g Release 2 (10.2) (Part No. B14268-02), Chapter 3 Oracle Database Error Messages 10g Release 2 (10.2) (Part No. B14219-01) Oracle Database Advanced Security Administrator's Guide 11g Release 1 (11.1) (Part No. B28530-03), Chapter 3 Oracle Database Error Messages 11g Release 1 (11.1) (Part No. B28278-02) Oracle Database Advanced Security Administrator's Guide 11g Release 2 (11.2) (Part Number E10746-02), Chapter 3 Oracle Database Error Messages 11g Release 2 (11.2) (Part Number E10880-02) Using TDE Column Encryption with Oracle E-Business Suite Release 12. Oracle E-Business Suite Release 12.0 with Oracle Database 11g Release 1 (11.1.0) Interoperability Notes. Oracle E-Business Suite Release 12.1 with Oracle Database 11g Release 1 (11.1.0) Interoperability Notes. Oracle E-Business Suite Release 12 with Oracle Database 11g Release 2 (11.2.0) Interoperability Notes. Database Initialization Parameters (init.ora settings) in Oracle Applications Release 12 Oracle Database PL/SQL User's Guide and Reference 11g Release 1 (11.1) Oracle Database PL/SQL User's Guide and Reference 11g Release 2 (11.2) Oracle Database Utilities 11g Release 1 (11.1) Oracle Database Utilities 11g Release 2 (11.2) MOS Document 881505.1 - Interoperability Notes - Oracle E-Business Suite Release 11i with Oracle Database 11g Release 2 (11.2.0) MOS Document 946413.1 - Using Oracle E-Business Suite with a Split Configuration Database Tier on Oracle 11g Release 2 MOS Document 216205.1 - Database Initialization Parameters for Oracle Applications Release 11i MOS Document 823586.1 - Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 11i MOS Document 1091086.1 - Integrating Oracle E-Business Suite Release 11i with Oracle Database Vault 11gR2 MOS Document 403294.1 - Using TDE Column Encryption with Oracle E-Business Suite Release 11i MOS Document 828223.1 - Using TDE Tablespace Encryption with Oracle E-Business Suite Release 11i MOS Document 557738.1 - Export/Import Process for Oracle E-Business Suite Release 11i Database Instances Using Oracle Database 11g Release 1 or 2 MOS Document 729309.1 - Using Transportable Database to Migrate Oracle E-Business Suite Release 11i Using Oracle Database 10g Release 2 or 11g Enterprise Edition MOS Document 1366265.1 - Using Transportable Tablespaces to Migrate Oracle Applications Release 11i Using Oracle Database 11g Release 2 Enterprise Edition 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: Real Application Clusters (RAC) Advanced Security Option (ASO) / Advanced Networking Option (ANO) Advanced Compression Active Data Guard Database Partitioning Database Vault Data Guard Redo Apply with Physical Standby Databases Native PL/SQL compilation Oracle Label Security (OLS) Real Application Testing SecureFiles Transparent Data Encryption (TDE) Column Encryption Virtual Private Database (VPD)