1 / 24

Oracle Applications 11.5.10 -Architecture and Tools Overview

Oracle Applications 11.5.10 -Architecture and Tools Overview. Sandra Vucinic VLAD Group, Inc. Speaker Background. Sandra Vucinic Over 11 years of experience with Oracle database, applications, development and administration tools

trish
Download Presentation

Oracle Applications 11.5.10 -Architecture and Tools Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Applications 11.5.10 -Architecture and Tools Overview Sandra Vucinic VLAD Group, Inc.

  2. Speaker Background • Sandra Vucinic • Over 11 years of experience with Oracle database, applications, development and administration tools • Project roles: Architect, Oracle Apps DBA, Project Lead • Director, OAUG Database SIG Board • Director, OAUG SysAdmin SIG and Committee Chair, Oracle Tools and Utilities • Director, SROAUG Board • Presented at OAUG, NCOAUG, CSOAUG, SROAUG, Apps World and Open World conferences (30+ sessions) • Founded VLAD Group, Inc. in March, 2001

  3. Agenda • 11.5.10 Technology Stack Components • New Features in: • OAM (Oracle Applications Manager) • AD mini-pack I.1 • Oracle Applications Framework • Workflow • AOL (Application Object Library) • 9i database • 10gdatabase

  4. 9.2.0.5 Database 11i Architecture – Components Release 11.5.10 CD Release Client Tier Web HTTP Servers Application Technology Stack Middle Tier 9iAS ORACLE_HOME 8.0.6.3 ORACLE_HOME (1.0.2.2.2) Database Tier9.2.0.5 ORACLE_HOME JInitiator Admin Server Concurrent Processing Server Apache Discoverer Server Forms Server Reports Server

  5. 11.5.10 Technology Stack Components • Database Tier • Oracle 9i Enterprise Edition 9.2.0.5 • Middle Tier • Oracle 9i AS version 1.0.2.2.2 • Oracle HTTP Server – Rollup patch 4 (bug 3072811) • Forms and Reports – Developer 6i with Patch 15 - version 6.0.8.24 • JDK version 1.4.2 (both concurrent processing and web tier) • Oracle JSP Container version 1.1.3.4 • Client Tier • Oracle JInitiator version 1.3.1.16 on the PC

  6. 11.5.10 Technology Stack Components • 8i database is not certified to run with 11.5.10 (de-support 12/31/2004) • Discoverer 4i version 4.1.48 included • Discoverer 10g (9.0.4) certified in separate Oracle home • Oracle Application Server 10g(Oracle Internet Directory 9.0.4, Portal 9.0.4, Single Sign-On 9.0.4) certified on a stand-alone server

  7. Oracle Applications Manager • OAM – management html tool for 11iapplications • Included in version 11.5.7 or higher • Used primarily for: • examining system configuration • managing Oracle Workflow • administering services • measuring system usage • patch history “repository”

  8. New and Changed Features in OAM • Enhanced Web Server Monitoring • Provides a summary of running JServ instances , memory stats, database connection stats for each instance • Monitors AOL/J database connection pool within each instance • Oracle Forms Runaway Process Detection • Scans Forms server for runaway f60webmx processes • Support Cart enhancements • Captures system configuration, patch history, diagnostics results into single file • Extended Concurrent Processing Performance Charts • New charts and reports to monitor and analyze concurrent processing utilization and performance

  9. New and Changed Features in OAM • Enhanced Patch Impact Analysis • Downloads and analyzes patch data, recommends patches • Analyzes pre requisites and impact of patches • Provides an aggregate impact of patch combined with its prerequisites • Patch Advisor InfoBundle • Automatically downloads InfoBundle for Metalink • Downloads and merges patches directly from OAM • Patch database history enhancements • For merged patches search results show an individual patches

  10. New and Changed Features in OAM • Context Editor Enhancements • Supports variables that depend on the values of other variables • Allows to add custom variables • Database tier context can be edited from OAM • Monitoring Applications DBA Utilities from OAM • Allows you to monitor in-progress “adadmin” and “adpatch” • System Cloning • Manage overall cloning process directly from OAM • Pre-clone “interview” starts cloning process • OAM automates most steps and guides you through remaining steps • Cloning types supported: “single node to single node ”, “single node to multi node”, “multi node to multi node”

  11. New and Changed Features in OAM • Advanced Configuration Wizards • Automate configuration tasks such as: enabling load balancing, converting to SSL • Host Based Service Management • Allows to manage and monitor services by host • Security Page in Applications Dashboard • Allows to monitor failed login attempts, blocked user accounts, inactive user accounts • Restricted Mode Access • Allows access to limited set of features while the rest of apps are unavailable

  12. AD mini-pack I.1 - New Features • AD Controller (adctrl) runs in non-interactive mode • AD Merge Patch utility – merging zip files • Auto Patch automatically calls AutoConfig (including “test” mode) • ADX.E included in AD.I • Eliminated MRC schema overhead • reduces patch downtime

  13. AD mini-pack I.1 - New Features • Maintenance Mode feature • Used only during “adpatch” sessions • Shuts down Workflow Events System • Distributed AD • Allows to start AD workers on any node of “Shared APPL_TOP” • For more info review note id. 236469.1 • Use “parallel slaves” for creation of large indexes

  14. AD mini-pack I.1 - New Features • Patch history details written to “.lgi” file • Patch History for partially applied patches • ODF support for locally managed tablespaces • JSP compile improvements • adpatch runs JSP compile on “web server” node only • Increased help options for AD utilities

  15. OA Framework – New Features in 11.5.10 • First release of OA-Framework integrated development environment • Oracle JDeveloper OA Extension – wizards, property sheets for defining apps business logic • Personalization and Extensibility • Configurable Pages – designed with built-in layout personalization and content selection capabilities • Partial Page Rendering (PPR) enabled for more components (descriptive flexfields, subtabs and Gantt charts)

  16. Workflow • OWF mini-pack H (3258819) included in 11.5.10 release • New Features of OWF.H: • Self-Service Diagnostic Scripts • Workflow Purge Includes Messaging Content • E-mail Security Policy • Digital Signature for Notifications • Notification Mailer Enhancements • Stops mailer when a defined number of errors have been detected • Sends notifications in a summary form or in individual e-mails • Flags notification content as “secure”

  17. Application Object Library • Oracle Applications Tablespace Model (OATM) • Reduces number of tablespaces from 2 per product to 12 tablespaces (including 3 systems tablespaces: undo, system and temp) for all modules • Supports locally managed tablespaces • Database objects mapped to tablespaces bases on: object size, life span, access methods and locking granularity • Eases maintenance and reduces space usages • Supports RAC (Real Application Clusters)

  18. Application Object Library • Oracle Applications Tablespace Migration Utility • Interactive menu based PERL program • Series for sizing estimate reports for converting database schemas to OATM • Available for pre 11.5.10 customers as stand alone patch 3381489 • Customers must be on AD.H and on database version 9.2.0.4 or higher

  19. 9i database • 9.2 – terminal release of Oracle 9i • Recommended version – 9.2.0.5 – This version is only certified with apps 11.5.7 or higher • Release 9.0.1.x (9i ) de-supported as of 12/31/2003 • 8i support for 11i apps customers extended until July 31, 2005 • To upgrade to version 9.2.x use: "Interoperability Notes : Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)", (Doc ID: 216550.1)

  20. 10g database – New Features • Optimizer Enhancements • Runtime execution plans accessible in “v$sql_plan” • CPU Costing – new columns in a plan table (CPU_COST and IO_COST) • Workload Statistics • Bind variables values available in “v$sql_bind_capture” • Rule Based Optimizer (RBO) finally “retired”

  21. 10g database – New Features • Manageability • Automatic Database Diagnostic Monitor (ADDM) • Automatically diagnoses performance problems • Provides Root Cause Analysis; recommends solutions • Automatic Workload Repository (AWR) • Replacement for StatsPack • Takes periodic snapshots • Automatic SGA tuning (shared pool, buffer cache, log buffer, java pool)

  22. 10g database – New Features • PL/SQL Improvements • Global Optimizer • Computes certain operations during compilation rather then during execution • Reuses expression values • Improved Native Compilation • JDBC improvements • Improved connection cache • Bundled calls (single round trip per SQL call)

  23. Q & A

  24. Thank YouSandra Vucinicsandrav@vladgroup.com (630) 202-1248 www.vladgroup.com

More Related