Oracle Applications 11.5.10 -Architecture and Tools Overview

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
• 10g database

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

9.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 11i applications
• 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
  vsql_plan
• CPU Costing new columns in a plan table
  (CPU_COST and IO_COST)
• Workload Statistics
• Bind variables values available in
  vsql_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
You
Sandra Vucinic
sandrav_at_vladgroup.com
[phone]
www.vladgroup.com