Building Highly Available Infrastructure for Oracle E-Business Suite

1
(No Transcript)
2
Building Highly Available Infrastructure for
Oracle E-Business Suite
Deep Ram, Daniel Gonzalez, Venkat
Bhagavatula Oracle Consulting
3
The following 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
decisions.The development, release, and timing
of any features or functionality described for
Oracles products remains at the sole discretion
of Oracle.
4
Session Agenda
ltInsert Picture Heregt

• Overview
• Ebusiness Architecture
• Critical Components
• Application Server
• Oracle Database
• Real Application Cluster
• Data Guard
• SOA
• Grid Control
• Minimize downtime
• Summary

5
ltInsert Picture Heregt
Overview
6
Minimize outages
7
Increase Availability
10g AS
10g RAC
Disaster Recovery
Standby
Production
Recovery
Delayed andZero Loss Modes
Networking
Storage
Backup Recovery
Best Practices
8
Deliver Optimal Architecture
9
ltInsert Picture Heregt
EBusiness Suite
10
Ebusiness Technology Stack
Application
Database
Client
OC4J
Global Single Data Model
JSP
BC4J
RAC ASM
Web Listener
UIX
Partitioning
Reports
Forms
Data Guard
11
Integrated EBS Environment
12
ltInsert Picture Heregt
Oracle Application Server
13
Application Server

• Oracle Application Server 10g
• Portal
• Single Sign-On
• Oracle Internet Directory
• Directory Integration Provisioning
• Delegated Administration Services
• Discoverer
• OracleAS Certificate Authority
• OracleAS 10g Metadata Repository

Firewall
ExternalUsers(via VPN)
Application Server

• ApplicationDatabase

Intranet Firewall
InternalUsers
14
OracleAS 10g Integration

• Enable Single Sign-On for 11i/R12
• Manage users in Oracle Internet Directory
• Access Oracle app via custom Portals
• Integrate Oracle apps with third-party PKI, SSO
  LDAP directories, and legacy applications
• Analyse apps with Discoverer workbooks
• Accelerate apps performance with WebCache

15
ltInsert Picture Heregt
Oracle 10g Database
16
Human Error Protection
System Failures
Storage Failures
UnplannedDowntime
Flashback Technologies
Human Errors
Data Failures
Data Corruptions
System Changes
Site Failures
PlannedDowntime
Data Changes
17
Revolution in Recovery
Traditional Recovery

• Flashback Revolutionizes Error Recovery
• Operates on just changed data
• Time to correct error equals time to make error
• Minutes instead of hours
• Flashback is Easy
• Single command instead of complex procedure
• Very low performance overhead less than 2
• Great for testing also!

Correction Time Error Time f(DB_SIZE)
18
Error Correction with Flashback

• Correct errors at any level
• Flashback Database restore database to time
• Flashback Table restore contents of tables to
  time
• Flashback Transaction back out transaction and
  all subsequent conflicting transactions

Database
Customer
Order
Great for Testing Also
19
Best-of-Breed Data Corruption ProtectionAt
Lowest Cost
System Failures
Storage Failures
UnplannedDowntime
Human Errors
Data Failures
Data Recovery Advisor, RMAN, Oracle Secure Backup
Data Corruptions
System Changes
Site Failures
PlannedDowntime
Data Changes
20
Automated Disk Backups

• Fully automatic disk-based backup and recovery
• Set and Forget
• Nightly incremental backup rolls forward recovery
  area backup
• Changed blocks are tracked in production DB
• Full scan is never needed
• Dramatically faster (20x)
• Blocks validated to prevent corruption of backup
  copy
• Low cost ATA disks can be used for recovery area

Flash RecoveryArea
Nightly Apply Validated Incremental
DatabaseArea
Weekly Archive To Tape
Integrated storage tiering within the database!
21
Oracle Secure BackupIntegrated Tape Backup
Management

• Protects entire environment
• Oracle9i forward
• Application files
• Free Express edition bundled with the Oracle
  Database
• Low cost licensed edition
• Independent release schedule
• Available 10.1
• Upcoming 10.2
• Beta planned September, 07

http//www.oracle.com/technology/products/secure-b
ackup/index.html
22
ltInsert Picture Heregt
Oracle 10g RAC
23
Classic Active Passive HA
Server 2
Server 1
Database
Database A
24
High Availability with 10g RAC
Database A
SERVER failure - your database remains available
25
Scalability with 10g RAC
Database A
- scale on demand
Protect your investment
26
ltInsert Picture Heregt
Oracle Dataguard
27
Oracle10g Data Guard
Clients
Standby Site
Primary Site
Clients
logical or physical standby databases
Automatic Failover
Data Changes
Synchronous Redo Shipping
Primary Database
Standby Database

• Synchronous or asynchronous redo shipping
• Corruptions dont propagate
• Primary and standby databases can be single
  server Oracle or 10g RAC
• Up to nine standby databases supported in a
  single configuration

28
ltInsert Picture Heregt
EBusiness Target Architecture
29
E-business Suite Target MAA

30
ltInsert Picture Heregt
Oracle SOA Suite
31
Conceptual SOA Model
32
SOA Logical Architecture
33
ltInsert Picture Heregt
Oracle Grid Control
34
Enterprise Manager and E-Business Suite
35
E-Business Suite Management SolutionOAM, Grid
Control and EM Plug-in
Simplified Administration
Oracle Applications Manager Grid Control
10gR2 Plug-in for Applications
Automated Maintenance
Pro-active Monitoring
Diagnostics and Troubleshooting
Enterprise Views
Centralized Access
36
ltInsert Picture Heregt
Minimize Downtime
37
Minimize Downtime

• Hot patch
• Merge patches
• Staged Appl_Top
• Shared Appl_Top
• Distributed AD
• Archive/purge strategy
• Selective Data Upgrades
• Adpatch interactiveno optionsno ---
• Tuning upgrade performance

38
ltInsert Picture Heregt
Summary
39
Lessons Learnt

• Procure the hardware sooner
• Build more testing time into the project schedule
• Build a test lab with a full High Availability
  configuration
• Formalize the User Provisioning strategy earlier
  in the project lifecycle
• Build internal team skills earlier in the project

40
Lessons Learnt

• Architect with a focus on
• High availability
• Database resource utilization
• EBS integration with Oracle Application Server
• Identity Management
• Validate assumptions as soon as possible
• Did not always occur as soon as desired due to
  hardware availability
• Implement multiple times prior to production
• Builds eventually became routine
• Test performance and availability characteristics
• High availability testing was limited by data
  conversion and User Acceptance testing activities
• Deploy
• Keep Go-live in mind

41
Lessons Learnt

• Preparation and socialization of relevant
  architecture documents based on Oracle
  Application Implementation Methodology (AIM)
• TA30 Preliminary Conceptual Architecture
• TA70 Revised Conceptual Architecture
• TA80 Application Security Architecture
• TA90 Application and Database Server
  Architecture
• Document all installation and configuration
  activities to insure predictable outcomes
• Effective use of Oracle Consulting to supplement
  resources for key activities
• Solid testing strategy

42
Lessons Learnt

• Test load balancer configuration before testing
  EBS and OAS components
• Allow for multiple testing cycles focusing on
  different layers of the architecture such as
  network, software, and servers
• Plan for appropriate load testing based on
  expected workloads
• Test typical usage scenarios for expected
  behavior
• Test failure scenarios for proper failover of
  components
• Fail at least one server from every group of
  highly available components Do all dependent
  components continue to operate properly?
• Fail both servers from every group of highly
  available components Do all dependent
  components fail?
• Restore the original server from each group and
  leave the second server down Do all dependent
  components return to normal operation without
  manual intervention?
• Test batch and service oriented processing both
  with and without active workloads
• Dont blame eratic Portal behavior on browser
  caching Check the Web Cache invalidation
  password and Load Balancer

43
For More Information
search.oracle.com
Consulting
or oracle.com
44
Q

A
45
(No Transcript)