Transcript Document 7121972

<Insert Picture Here>
Building Highly Available Infrastructure for
Oracle E-Business Suite
Deep Ram, Daniel Gonzalez, Venkat Bhagavatula
Oracle Consulting
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 Oracle’s
products remains at the sole discretion of Oracle.
Session Agenda
• Overview
• Ebusiness Architecture
• Critical Components
•
•
•
•
•
•
•
•
Application Server
Oracle Database
Real Application Cluster
Data Guard
SOA
Grid Control
Minimize downtime
Summary
<Insert Picture Here>
<Insert Picture Here>
Overview
Minimize outages
Increase Availability
Disaster Recovery
10g AS
10g RAC
Standby
Production
Recovery
Delayed and
Zero Loss Modes
Backup &
Recovery
Networking
Storage
+ Best Practices
Deliver Optimal Architecture
<Insert Picture Here>
EBusiness Suite
Ebusiness Technology Stack
Client
Application
Web Listener
HTTP / S
JSP
BC4J
JDBC/SQL Net
OC4J
Database
Global Single
Data Model
RAC & ASM
UIX
Partitioning
Reports
Forms
Data Guard
Integrated EBS Environment
<Insert Picture Here>
Oracle Application Server
Application Server
Oracle Application Server 10g
•
•
•
•
•
•
•
•
Firewall
External
Users
(via VPN)
Portal
Single Sign-On
Oracle Internet Directory
Directory Integration & Provisioning
Delegated Administration Services
Discoverer
OracleAS Certificate Authority
OracleAS 10g Metadata Repository
Application Server
Intranet
Firewall
Internal
Users
Application
Database
OracleAS 10g Integration
1.
2.
3.
4.
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
5. Analyse apps with Discoverer workbooks
6. Accelerate apps performance with WebCache
<Insert Picture Here>
Oracle 10g Database
Human Error Protection
System
Failures
Unplanned
Downtime
Data
Failures
Storage
Failures
Human
Errors
Data
Corruptions
Planned
Downtime
System
Changes
Data
Changes
Site Failures
Flashback
Technologies
Revolution in Recovery
• Flashback Revolutionizes Error Recovery
• Operates on just changed data
• Time to correct error equals time to make error
• Minutes instead of hours
Traditional
Recovery
80
60
40
20
0
Time
To
Recove
r
Correction Time = Error Time + f(DB_SIZE)
• Flashback is Easy
• Single command instead of complex procedure
• Very low performance overhead – less than 2%
• Great for testing also!
Error Correction with Flashback
Database
Customer
Order
• 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
Great for Testing Also
Best-of-Breed Data Corruption Protection
At Lowest Cost
System
Failures
Unplanned
Downtime
Data
Failures
Storage
Failures
Human
Errors
Data
Corruptions
Planned
Downtime
System
Changes
Data
Changes
Site Failures
Data Recovery
Advisor, RMAN,
Oracle Secure
Backup
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
Database
Area
Nightly Flash Recovery
Apply
Area
Validated
Incremental
Integrated storage tiering
within the database!
Weekly
Archive
To Tape
• Dramatically faster (20x)
• Blocks validated to prevent corruption of
backup copy
• Low cost ATA disks can be used for
recovery area
Oracle Secure Backup
Integrated 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-backup/index.html
<Insert Picture Here>
Oracle 10g RAC
Classic Active – Passive HA
Server 2
Server 1
Database
Database
‘A’
High Availability with 10g RAC
Database
‘A’
SERVER failure - your database remains available
Scalability with 10g RAC
Database
‘A’
Protect your investment - scale on demand
<Insert Picture Here>
Oracle Dataguard
Oracle10g Data Guard
Clients
Primary Site
Automatic Failover
Data Changes
Primary
Database
Standby Site
Clients
logical or physical
standby databases
Synchronous
Redo Shipping
Standby
Database
 Synchronous or asynchronous redo shipping
Corruptions don’t propagate
 Primary and standby databases can be single server Oracle or 10g RAC
 Up to nine standby databases supported in a single configuration
<Insert Picture Here>
EBusiness Target Architecture
E-business Suite Target MAA
Disaster Recovery Site
Primary Site
Application Tier
Database Tier
Oracle
RAC and
ASM
Oracle
RAC and
ASM
Oracle Data Guard
Oracle
Database
HA Storage
Oracle
Standby
Database
<Insert Picture Here>
Oracle SOA Suite
Conceptual SOA Model
Consumer
External
External Applications
Applications
Portal
Portal
Other internal apps
Perimeter
Security
Internet Firewall
SSL Encryption, NAT, Port Redirection
HTTP
Services
Oracle HTTP
Server
Application
Server
Control
Oracle HTTP Server
Canonical
Models
OracleAS Services
Web Services Manager
Gateway
ESB
singleton
adapters
ESB
Runtime
ESB Design
Time
Oracle Grid
Control
Service
Registry
Quest
Foglight
BPEL
OC4J
Data
Providers
Files
Meta data
Repository
E-Business
Suite
Queues
File System
SOA Data Tier
Apps Data Tier
MQ
System
Management
and
Monitoring
SOA
Logical
Architecture
Ascent
Logical SOA
Architecture UAT-1
Oracle HTTP Server
Oracle HTTP Canonical
Server
Models
WEB
PORTAL :80
Web Services
Manager
Gateway
HTTP 7779
oc4j_wsmg
opmn 6008
WSMG
ESB
Runtime
BPEL
Web
Services
Manager
Service
Registry
Application
Server
Control
ESB Design
Time
ESB
singleton
adapters
oc4j_soa
oc4j_wsm
oc4j_reg
oc4j_admin
oc4j_esbdt
oc4j_esbf
opmn 6006
opmn 6006
opmn 6006
opmn 6006
opmn 7010
opmn 6007
ESBDT
ESBF
SOA
E-Business
Suite
Meta data
Repository
Queues
Page 1
Files
<Insert Picture Here>
Oracle Grid Control
Enterprise Manager and E-Business
Suite
Database Deployment
RDBMS
DB Control
Application Server
Application
Server
AS
Control
Enterprise Manager:
Grid Control
Repository
Oracle
Management
Server
HTML
UI
E-Business Suite
Apps
Oracle
Applications
Manager
E-Business Suite Management Solution
OAM, Grid Control and EM Plug-in
Oracle
Applications
Manager
Simplified Administration
Grid Control
10gR2
Pro-active Monitoring
+
Plug-in for
Applications
Automated Maintenance
Diagnostics and Troubleshooting
Enterprise Views
Centralized Access
<Insert Picture Here>
Minimize Downtime
Minimize Downtime
•
•
•
•
•
•
•
•
•
Hot patch
Merge patches
Staged Appl_Top
Shared Appl_Top
Distributed AD
Archive/purge strategy
Selective Data Upgrades
Adpatch interactive=no options=no --Tuning upgrade performance
<Insert Picture Here>
Summary
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
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
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
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
• Don’t blame eratic Portal behavior on browser caching – Check the Web Cache
invalidation password and Load Balancer
For More Information
search.oracle.com
Consulting
or
oracle.com