Oracle Applications 11.5.10 -Architecture and Tools Overview - PowerPoint PPT Presentation

Loading...

PPT – Oracle Applications 11.5.10 -Architecture and Tools Overview PowerPoint presentation | free to download - id: 407925-ZjAwZ



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Oracle Applications 11.5.10 -Architecture and Tools Overview

Description:

Oracle Applications 11.5.10 -Architecture and Tools Overview Sandra Vucinic VLAD Group, Inc. ... Discoverer 4i version 4.1.48 included Discoverer 10g ... – PowerPoint PPT presentation

Number of Views:94
Avg rating:3.0/5.0
Slides: 25
Provided by: Jonatha387
Learn more at: http://www.dbsig.com
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: 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
(630) 202-1248
www.vladgroup.com
About PowerShow.com